[GENERAL] apache permission denied

2008-07-10 Thread 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: Permission denied A direct test with a simple SQL command in

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','',...) faile

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/c