Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: CGI problem

by Anonymous Monk
on Nov 07, 2011 at 09:36 UTC ( #936452=note: print w/replies, xml ) Need Help??


in reply to Re^2: CGI problem
in thread CGI problem

Hey Thank you for the timely help. But now i have another problem. My script seems to run fine from command line. but if it gets invoked by the apache server it throws internal server error. When i look into the error log this is what i get.
[Mon Nov 07 14:59:57 2011] [error] [client 127.0.0.1] Premature end of + script headers: user_login.pl, referer: http://127.0.0.1/login.htm [Mon Nov 07 14:59:57 2011] [error] [client 127.0.0.1] install_driver(m +ysql) failed: Can't load 'C:/perl/perl/site/lib/auto/DBD/mysql/mysql. +dll' for module DBD::mysql: load_file:The specified module could not +be found at C:/perl/perl/lib/DynaLoader.pm line 200., referer: http:/ +/127.0.0.1/login.htm [Mon Nov 07 14:59:57 2011] [error] [client 127.0.0.1] at (eval 6) lin +e 3, referer: http://127.0.0.1/login.htm [Mon Nov 07 14:59:57 2011] [error] [client 127.0.0.1] Compilation fail +ed in require at (eval 6) line 3., referer: http://127.0.0.1/login.ht +m [Mon Nov 07 14:59:57 2011] [error] [client 127.0.0.1] Perhaps a requir +ed shared library or dll isn't installed where expected, referer: htt +p://127.0.0.1/login.htm [Mon Nov 07 14:59:57 2011] [error] [client 127.0.0.1] at C:/Program F +iles/Apache Software Foundation/Apache2.2/cgi-bin/user_login.pl line +57, referer: http://127.0.0.1/login.htm
Any idea why could this happen What is Dynaloader.pm

Replies are listed 'Best First'.
Re^4: CGI problem
by Corion (Pope) on Nov 07, 2011 at 09:46 UTC
    Can't load 'C:/perl/perl/site/lib/auto/DBD/mysql/mysql.dll'

    So:

    • Is DBD::mysql installed for the version of (mod_)Perl that Apache is running? You say the script works when you run it as another user, so make sure that both users see the same Perl and the same mod_perl.
    • Did it pass its test suite? If you installed the module via the CPAN tool, did it pass its test suite?
    • Is the file C:/perl/perl/site/lib/auto/DBD/mysql/mysql.dll there?
    • Does the Apache user have read/execute permissions for the file and all directories above it? You seem to be running Windows, so if the Apache user is running as a service, it may or may not have the appropriate permissions to load DLLs.
      your fourth point did the trick. I started apache from command line and then all works fine. Thankyou very much.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://936452]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2021-11-28 17:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?