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
