Re: autentication problem

http://www.postgresql.org/docs/7.4/interactive/client-
authentication.html#AUTH-PG-HBA-CONF

^^ should have everything you need to know :)

Gavin

On Oct 14, 2005, at 12:28 PM, JUAN ERNESTO FLORES BELTRAN wrote:

> 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
>>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

Gavin M. Roy
800 Pound Gorilla
gmr(at)ehpg(dot)net