Re: autentication problem

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