[thelist] perl DBD::mysql issues
Darren Beale
bealers_lists at exponetic.com
Thu Apr 15 05:22:37 CDT 2004
Hi
I've got a perl app that works fine in dev but doesn't when uploaded to
production and I wonder if someone could sanity check what I've tried as
whatever I do I get a 500 when running it.
1) Permissions on script are 0755
2) httpd.conf contains
<Directory /dir/admin>
Options +ExecCGI
</Directory>
and
AddHandler cgi-script .cgi .sh .pl
3) @INC contains:
/usr/local/lib/perl/5.6.1
/usr/local/share/perl/5.6.1
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.6.1
/usr/share/perl/5.6.1
/usr/local/lib/site_perl
4) ls -al /usr/local/lib/perl/5.6.1/
drwxrwsr-x 3 root staff 4096 Apr 15 10:44 Bundle
drwxrwsr-x 3 root staff 4096 Apr 15 10:44 DBD
drwxrwsr-x 6 root staff 4096 Apr 15 10:31 DBI
-r--r--r-- 1 root staff 252259 Mar 11 13:45 DBI.pm
drwxrwsr-x 2 root staff 4096 Apr 15 10:44 Mysql
-r-xr-xr-x 1 root staff 23888 Oct 17 18:20 Mysql.pm
-r--r--r-- 1 root staff 34769 Mar 21 02:43 Storable.pm
drwxrwsr-x 2 root staff 4096 Apr 15 10:31 Win32
drwxrwsr-x 6 root staff 4096 Apr 15 10:44 auto
-rw-rw-r-- 1 root staff 1372 Apr 15 10:44 perllocal.pod
5) which perl
/usr/bin/perl
5) I've created a test version of the script, leaving out *everything*
just the first few lines, and adding some output but I still get the
same deal, works on dev but now on production (both are debian woody fwiw)
-----8<-----
#!/usr/bin/perl -w
BEGIN { unshift(@INC,'/usr/local/lib/perl/5.6.1/DBD'); }
use Mysql;
print <<"EOF";
Content-type: text/html
<html>
<body>
Foo
</body>
</html>
EOF
----->8-----
6) All attempts lead to the same pearls of wisdom from the logs:
[Thu Apr 15 11:16:55 2004] [error] (13)Permission denied: exec of
/dir/admin/script.cgi failed
[Thu Apr 15 11:16:55 2004] [error] [client 82.68.149.225] Premature end
of script headers: /dir/admin/script.cgi
7) Bundle::DBI and Bundle:DBD:mysql were installed using the perl CPAN
installer
I'm really stuck, what can I have missed?
Thanks
Darren
More information about the thelist
mailing list