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

[Rajendra Jagad]

Can somebody please remove my email address from block list, I cannot send
email to group because I had a jpg image attached
instead of link to jpg file. Now I cannot send email to group but only
reply...??

Thanks for help

Raj



On 10/12/06, Rajendra Jagad <rjagad at gmail.com> wrote:
>
> 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




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