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@xxxxxxxx>
To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof@xxxxxxxxxxx>
CC: operationsengineer1@xxxxxxxxx, pgsql-php@xxxxxxxxxxxxxx
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@xxxxxxxxx>
To: pgsql-php@xxxxxxxxxxxxxx
Subject: Re: [PHP] autentication problem
Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT)
--- JUAN ERNESTO FLORES BELTRAN
<juanernestof@xxxxxxxxxxx> 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@xxxxxxxx
---------------------------(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@xxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
