Hi Bogdan;
This is a typical problem when you install PosgreSQL via the Red Hat CD's.
You need to edit the pg_hba.conf and change the authentication type to more
appropriate settings. If your PHP app connects using a host field in the
connection string, it will be using a network socket. Otherwise, it will be
a local socket.
I usually set my servers to use md5 authentication for all network
connections and trust for local connections, allowing the admin to connect
locally as any user, but this assumes a level of security and architecture
you may not wish to assume. md5 authentication on both local and network
sockets will force password authentication for all connections via a
zero-knowledge md5-sum authentication method.
Best Wishes,
Chris Travers
----- Original Message -----
From: "Bogdan Chytrek" <roboccc@t-online.de>
To: <pgsql-general@postgresql.org>
Sent: Thursday, December 18, 2003 6:26 PM
Subject: [GENERAL] authentication failed
Why happens this?
Warning: pg_connect() unable to connect to PostgreSQL server: FATAL:
IDENT authentication failed for user "bchytrek" in
/var/www/html/physio2/test.php on line 19
The php-statement is :
$conn = pg_connect("dbname=testdb user=bchytrek");
the owner of that testdb is bchytrek and he does not have a password, he
is in the users-list as superuser, an may cerate dbs.
So why does the authentication fail?
Helpless
Bogdan
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
