[Ilugc] Urgent Help on Perl CGi
- From: lug@xxxxxxxxxxxxxxxxxx (Chandrashekar B.)
- Date: Sat Aug 21 17:02:10 2004
prakash wrote:
--------------apache error.log-------------------------------
failed: FATAL: IDENT authentication failed for user "user" at
/var/www/cgi-bin/select1.cgi line 6
Can't call method "prepare" on an undefined value at
/var/www/cgi-bin/select1.cgi line 8.
----------------------------------------------------------
It seems that your postgresql database is configured for IDENT
authentication scheme. In that case, the UNIX user-id of the executing
CGI script (apache webserver, apropriately) must be the same user as the
postgres database user. I believe that this is not the case (CGI scripts
normally run as user 'nobody' or 'apache' on most Linux distributions).
You might want to edit your pg_hba.conf file and change the
authentication scheme for 'user1' from 'ident' to 'password' or 'crypt'
scheme.
The URL
http://www.faqs.org/docs/ppbook/c15679.htm has some good ;
documentation on how to modify authentication scheme in your pg_hba.conf
file.
Cheers,
Chandrashekar Babu.
Other related posts:
