[isf-wifidog] install.php hang? (pg connect error)

listserv.traffic at sloop.net listserv.traffic at sloop.net
Jeu 12 Oct 17:20:49 EDT 2006

I hate to resend this, but I really need some help - even a few
pointers where to look for a problem.

(Not sure if the last post made it through - if this is a duplicate
please pardon my error! :) )

Ok, I'm back at things again, but I'm lost again.

Patel, I've reviewed the information in the archives for August on the
PHP hang thing, but that wasn't very enlightening. Perhaps I'm just
dumb, but that's where we are.

Here's what I've got.

I get this PHP error. (Follows the "Database access configuration"

Postgresql database connection :
Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "wifidog" in /var/www/html/wifidog/install.php on line 1062

Here's some additional information from postgres

wifidog-> \l
        List of databases
   Name    |  Owner   | Encoding
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
 wifidog   | wifidog  | UTF8
(4 rows)

wifidog-> \du
                               List of roles
 Role name | Superuser | Create role | Create DB | Connections | Member of
 postgres  | yes       | yes         | yes       | no limit    |
 wifidog   | no        | no          | no        | no limit    |
(2 rows)

Finally, I've edited the pg_hba.conf file, and all connections from (localhost) are trusted, thus we shouldn't need a password.

# "local" is for Unix domain socket connections only
#local   all         all                               ident sameuser
local   all         all                               trust
(Doesn't seem to matter though - either way I get the same error - no
matter if "trust" or "ident sameuser")

Am I missing something?

Again, running FC5.
The DB and ROLE in PGSQL were created after su'ing to the postgresql
user, since root can't create ROLE's or DB's.

If it makes anyone feel better, I'll be glad to write the docs on this
once I get it figured out.

-------------- next part --------------
WiFiDog mailing list
WiFiDog at listes.ilesansfil.org

Plus d'informations sur la liste de diffusion WiFiDog