Re: autentication problem

Sorry for the english message, i will translate it as follows:

"Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL:
autentification has failed for postgres user in
/srv/www/htdocs/Prototipo/opciones.php on line 51"

any other suggesttion?
what shoudl i modify to pg_hba.conf?

regards

>From: "Gavin M. Roy" <gmr(at)ehpg(dot)net>
>To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof(at)hotmail(dot)com>
>CC: operationsengineer1(at)yahoo(dot)com, pgsql-php(at)postgresql(dot)org
>Subject: Re: [PHP] autentication problem
>Date: Fri, 14 Oct 2005 12:16:42 -0700
>
>I would guess your pg_hba.conf is not configured correctly. It appears to
>be an ident matching issue (best I can tell from the spanish error
>messages, sorry).
>
>Gavin
>
>On Oct 14, 2005, at 12:06 PM, JUAN ERNESTO FLORES BELTRAN wrote:
>
>>Information contained on page 51:
>>
>>pg_connect(host=localhost port=5432 dbname=prototipo user=postgres
>>password=13177337)
>>
>>this is the route i used on windows to run queries on postgre trough php.
>>This does not work on linux, and result in an autentication error
>>
>>What the problem could be?
>>thanks for your answers in advance..
>>
>>
>>>From: <operationsengineer1(at)yahoo(dot)com>
>>>To: pgsql-php(at)postgresql(dot)org
>>>Subject: Re: [PHP] autentication problem
>>>Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT)
>>>
>>>--- JUAN ERNESTO FLORES BELTRAN
>>><juanernestof(at)hotmail(dot)com> wrote:
>>>
>>> > Hi everyone
>>> >
>>> > i am working on php and posgresql, i designed a
>>> > database system web oriented
>>> > on windows at first on template1 default database.
>>>
>>>did you copy template1 and then create your db from
>>>the template? i always understood that template1
>>>itself was to be left alone and left as template.
>>>
>>> > I
>>> > used a password and a
>>> > loggin
>>> > loggin=postgres
>>> > password=13177337
>>> > this info is requested when installing postgresql on
>>> > windows.
>>> > Know i trying to migrate to suse linux...i moved my
>>> > scripts to
>>> > srv/www/htdocs/prototipo as root. I installed
>>> > apache2 server, and i
>>> > configured both apache and posgtresql to start
>>> > running when starting the
>>> > computer.
>>> >
>>> > The problem is, i have not been able tu run properly
>>> > the system on linux...i
>>> > receive the following message when conecting to
>>> > postgresql:
>>> >
>>> > "Warning: pg_connect(): Unable to connect to
>>> > PostgreSQL server: FATAL: la
>>> > autentificación Ident falló para el usuario
>>> > «jufl» in
>>> > /srv/www/htdocs/Prototipo/opciones.php on line 51"
>>>
>>>i've never administered pgsql on linux before, so i
>>>don't have direct experience. what does opciones.php
>>>line 51 say? is tcp/ip enabled? are you using the
>>>same username and password?
>>>
>>> > I didnt create any user when installing postgres, it
>>> > didnt request during
>>> > installation...so i wonder....how can i manage this?
>>> > the extrange thing is
>>> > that i can modify tables from console as follows;
>>> >
>>> >
>>>.....................................................................
>>>.....................................................................
>>>.....................
>>> > su root
>>> > enter password
>>> > su postgres
>>> > psql prototipo
>>> > Bienvenido a psql 8.0.3, el terminal interactivo de
>>> > PostgreSQL.
>>> >
>>> > Digite: \copyright para ver los términos de
>>> > distribución
>>> > \h para obtener ayuda sobre comandos SQL
>>> > \? para obtener ayuda sobre comandos
>>> > internos
>>> > \g o punto y coma (;) para ejecutar
>>> > consulta
>>> > \q para salir
>>> >
>>> > prototipo=#
>>> >
>>> >
>>>.....................................................................
>>>.....................................................................
>>>...........................................
>>> >
>>> >
>>> > so i dont understand what the problem is.....
>>> >
>>> > Thaks for your help...
>>>
>>>not sure i can help, but if you post line 51 it will
>>>likely help those who can help.
>>>
>>>best of luck.
>>>
>>>ps - a guy on the pgsql novice mailint list was
>>>recently asking how to install pgsql onto suse. if
>>>you had any instructions or could point to a tutorial
>>>that you used, he would like appreciate it.
>>>
>>>
>>>
>>>
>>>__________________________________
>>>Yahoo! Mail - PC Magazine Editors' Choice 2005
>>>http://mail.yahoo.com
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 5: don't forget to increase your free space map settings
>>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>
>Gavin M. Roy
>800 Pound Gorilla
>gmr(at)ehpg(dot)net
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match