<div>Hi Gerg</div>
<div> </div>
<div>I was strugling with the same problem.. Here is what I did hope it helps</div>
<div> </div>
<div>Turn on debugging option in Php.ini using vi /etc/php.ini</div>
<div>error_reporting = E_ALL</div>
<div>display_error = On</div>
<div> </div>
<div>Then to tail -f /var/lib/pgsql/data/pg_log/postgresql-<day of week>.log</div>
<div> </div>
<div>this should display php error messages.</div>
<div> </div>
<div>I fouund that I had problem in pg_hba.conf file just like you did and </div>
<div>added the followig entry</div>
<div>#TYPE DATABASE USER IP-ADDRESS SUBNET MASK METHOD</div>
<div>host wifidog wifidog <a href="http://192.168.0.203">192.168.0.203</a> <a href="http://255.255.255.0">255.255.255.0</a> md5</div>
<div> </div>
<div>where <a href="http://192.168.0.203">192.168.0.203</a> is the IP address of my authentication server for you it will be different.</div>
<div> </div>
<div> </div>
<div>Then ran install.php and it came connection to database success.</div>
<div> </div>
<div>I hope this helps greg.. It is helps create a documentation on this. It most common problem.</div>
<div> </div>
<div>Raj<br><br> </div>
<div><span class="gmail_quote">On 10/12/06, <b class="gmail_sendername"><a href="mailto:listserv.traffic@sloop.net">listserv.traffic@sloop.net</a></b> <<a href="mailto:listserv.traffic@sloop.net">listserv.traffic@sloop.net
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I hate to resend this, but I really need some help - even a few<br>pointers where to look for a problem.<br>
<br>---<br>(Not sure if the last post made it through - if this is a duplicate<br>please pardon my error! :) )<br><br>Ok, I'm back at things again, but I'm lost again.<br><br>Patel, I've reviewed the information in the archives for August on the
<br>PHP hang thing, but that wasn't very enlightening. Perhaps I'm just<br>dumb, but that's where we are.<br><br>Here's what I've got.<br><br>I get this PHP error. (Follows the "Database access configuration"<br>
page.)<br><br>---<br>Postgresql database connection :<br>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
<br>---<br><br>Here's some additional information from postgres<br><br>Databases<br>---<br>wifidog-> \l<br> List of databases<br> Name | Owner | Encoding<br>-----------+----------+----------<br>postgres | postgres | UTF8
<br>template0 | postgres | UTF8<br>template1 | postgres | UTF8<br>wifidog | wifidog | UTF8<br>(4 rows)<br><br>Users<br>---<br>wifidog-> \du<br> List of roles<br>Role name | Superuser | Create role | Create DB | Connections | Member of
<br>-----------+-----------+-------------+-----------+-------------+-----------<br>postgres | yes | yes | yes | no limit |<br>wifidog | no | no | no | no limit |<br>(2 rows)
<br><br>Finally, I've edited the pg_hba.conf file, and all connections from<br><a href="http://127.0.0.0">127.0.0.0</a> (localhost) are trusted, thus we shouldn't need a password.<br><br>---<br># "local" is for Unix domain socket connections only
<br>#local all all ident sameuser<br>local all all trust<br>---<br>(Doesn't seem to matter though - either way I get the same error - no<br>matter if "trust" or "ident sameuser")
<br><br>Am I missing something?<br><br>Again, running FC5.<br>The DB and ROLE in PGSQL were created after su'ing to the postgresql<br>user, since root can't create ROLE's or DB's.<br><br>If it makes anyone feel better, I'll be glad to write the docs on this
<br>once I get it figured out.<br><br>Thanks,<br>Greg<br><br><br>_______________________________________________<br>WiFiDog mailing list<br><a href="mailto:WiFiDog@listes.ilesansfil.org">WiFiDog@listes.ilesansfil.org</a><br>
<a href="http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog">http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog</a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Rajendra Jagad<br>954-239-2687