Re^3: 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
[download]

Any idea why could this happen What is Dynaloader.pm

Comment on Re^3: CGI problem Download Code

Replies are listed 'Best First'.
Re^4: CGI problem by Corion (Patriarch) on Nov 07, 2011 at 09:46 UTC
`Can't load 'C:/perl/perl/site/lib/auto/DBD/mysql/mysql.dll'` [download] 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.	[reply] [d/l] [select]
Re^5: CGI problem by Anonymous Monk on Nov 09, 2011 at 16:57 UTC
your fourth point did the trick. I started apache from command line and then all works fine. Thankyou very much.	[reply]


Clear questions and runnable code get the best and fastest answer
	PerlMonks