[isf-wifidog] install.php hang? (pg connect error)
rjagad at gmail.com
Jeu 12 Oct 17:55:29 EDT 2006
I was strugling with the same problem.. Here is what I did hope it helps
Turn on debugging option in Php.ini using vi /etc/php.ini
error_reporting = E_ALL
display_error = On
Then to tail -f /var/lib/pgsql/data/pg_log/postgresql-<day of week>.log
this should display php error messages.
I fouund that I had problem in pg_hba.conf file just like you did and
added the followig entry
#TYPE DATABASE USER IP-ADDRESS SUBNET MASK
host wifidog wifidog 192.168.0.203
where 192.168.0.203 is the IP address of my authentication server for you it
will be different.
Then ran install.php and it came connection to database success.
I hope this helps greg.. It is helps create a documentation on this. It most
On 10/12/06, listserv.traffic at sloop.net <listserv.traffic at sloop.net> wrote:
> 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
> 127.0.0.0 (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.
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
-------------- next part --------------
An HTML attachment was scrubbed...
Plus d'informations sur la liste de diffusion WiFiDog