Re: [GENERAL] apache permission denied

2008-07-10 Thread Chris Cosner
ALTER ROLE apache LOGIN It now works! Thank you Devrim and Peter for your help. Devrim GÜNDÜZ wrote: On Thu, 2008-07-10 at 11:49 -0700, Chris Cosner wrote: DBI connect('dbname=db','',...) failed: FATAL: role "apache" is not permitted to log in at /home/www/cgi-bin/db.lib line 1635 What abo

Re: [GENERAL] apache permission denied

2008-07-10 Thread Devrim GÜNDÜZ
On Thu, 2008-07-10 at 11:49 -0700, Chris Cosner wrote: > DBI connect('dbname=db','',...) failed: FATAL: role "apache" is not > permitted to log in at /home/www/cgi-bin/db.lib line 1635 What about: ALTER ROLE apache LOGIN; -HTH. -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim

Re: [GENERAL] apache permission denied

2008-07-10 Thread Chris Cosner
Peter Eisentraut wrote: Am Donnerstag, 10. Juli 2008 schrieb Chris Cosner: Using RHEL 5, with Postgresql 8.1, Apache, mod_perl, mod_auth_pgsql, DBI, DBD::Pg Perl cgi scripts that access the database get the following in httpd error_log: DBI connect('dbname=db','',...) failed: could not connect

Re: [GENERAL] apache permission denied

2008-07-10 Thread Peter Eisentraut
Am Donnerstag, 10. Juli 2008 schrieb Chris Cosner: > Using RHEL 5, with Postgresql 8.1, Apache, mod_perl, mod_auth_pgsql, > DBI, DBD::Pg > > Perl cgi scripts that access the database get the following in httpd > error_log: > DBI connect('dbname=db','',...) failed: could not connect to server: > Per