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 to server: Permission deniedAn strace of the program would probably give definite insight, but "Permission denied" sounds to me like a file system error message. Possibly, you don't have proper permissions (at least u+x) on the socket file (in (/tmp). But you would have to have done serious "customization" to get to that state. Mayb you have some fancy security configured around your Apache instance?
Thanks--SELinux was in fact enabled, and when I set it to permissive (i.e., audit only), httpd error_log now gives a login error:
DBI connect('dbname=db','',...) failed: FATAL: role "apache" is not permitted to log in at /home/www/cgi-bin/db.lib line 1635
The postgresql version is 8.1.11
