[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