Re: apache permission denied

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 denied
>
> An 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