Hi Gurus: Moving my application from development to production server. For some reason, I can't seem to execute my application when using mod_perl in production. I keep getting this permission error: [Mon Mar 10 13:47:33 2008] [error] Can't call method "prepare" on an undefined value at /var/www/:app/index.pl line 26.\n DBI connect('testdb','dbusr',...) failed: Couldn't connect to /tmp/.s.PGSQL.5432: connect: Permission denied at /usr/lib/perl5/site_perl/5.8.5/DBD/PgPP.pm line 124 at /var/www/app/index.pl line 24 [Mon Mar 10 18:49:19 2008] [error] Can't call method "prepare" on an undefined value at /var/www/app/index.pl line 26.\n DBI connect('testdb','dbusr',...) failed: Couldn't connect to /tmp/.s.PGSQL.5432: connect: Permission denied at /usr/lib/perl5/site_perl/5.8.5/DBD/PgPP.pm line 124 at /var/www/app/index.pl line 24 [Mon Mar 10 20:05:36 2008] [error] Can't call method "prepare" on an undefined value at /var/www/app/index.pl line 26.\n
I am able to connect to my database using, psql -U dbusr testdb without any problems. I actually gave my user and database full DB access. When I run the program via CLI, it works. just not working thru mod_perl. Any suggestions? TIA