Re: authentication failed
От | Chris Travers |
---|---|
Тема | Re: authentication failed |
Дата | |
Msg-id | 022001c3c941$87fa7060$52285e3d@winxp обсуждение исходный текст |
Ответ на | authentication failed (roboccc@t-online.de (Bogdan Chytrek)) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: