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

[Rajendra Jagad]

Hi Gerg

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
METHOD
host          wifidog           wifidog         192.168.0.203
255.255.255.0             md5

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
common problem.

Raj


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"
> page.)
>
> ---
> 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
>
> Databases
> ---
> wifidog-> \l
>        List of databases
>   Name    |  Owner   | Encoding
> -----------+----------+----------
> postgres  | postgres | UTF8
> template0 | postgres | UTF8
> template1 | postgres | UTF8
> wifidog   | wifidog  | UTF8
> (4 rows)
>
> Users
> ---
> 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.
>
> Thanks,
> Greg
>
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>
>
>


-- 
Rajendra Jagad
954-239-2687
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20061012/2d5912b2/attachment.htm