Broken CGI script since update

[wilfried]

I have a custom cgi script to upload HTML to a SQL database.
It has been working fine for 2 years.

Since the last update (Release) it is broken.
I get a Server Error 500 when I submit the HTML code via a form. If I remove the HTML and just enter a few letters of text it uploads just fine. So I am thinking it could be a security setting somewhere?

Any one can help?

[casey]

Maybe, did you recently add mod_security?

[lankyb]

Have you looked at the error log: /usr/local/apache/logs/error_log

It might give you a clearer indication why the script is not working.

[wilfried]

The full error is: Premature end of script headers: /path/to/script.cgi

[wilfried]

and in suexec_log I get "directory is writable by others" and "file has no execute permission"
All permission are set fine tho.
They haven't changed since it last worked
I did try to re-set them, and set the 777 files to 755 but it did not help.

[casey]

So you changed the permissions on the files, but did you also change the folder to 755?

[wilfried]

yup I did.... Changing permission just broke everything else.

I don't understand why a full html page won't upload thru the form but why a 4 letters word will....

[anup123]

I was in a similar situation after today's upcp and things wouldn't work under proxied mod_perl and even same script as plain cgi (giving same premature .... error).

http://forums.cpanel.net/showthread.php?t=41029

Just dowgrade and see if it resolves your problem... though it could be something else also.

Anup

[wilfried]

How do you downgrade DBD-mysql ?

I did downgrade cPanel at some point but it did not help either....

One thing I did the other day was to run /scripts/securetmp

But I don't see how that would affect it?

[anup123]

See if you have DBD-mysql-2.9008 in /home/.cpan/build

perl Makefile.PL
make
make install

if not then download from cpan

and do the above and see if it helps.

Anup

[wilfried]

Running the file from bash I get this:

Can't locate library/subs.cgi in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl
/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/pe
rl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/l
ib/perl5/5.8.0 .) at /home/path/to/script.cgi line 29.

[wilfried]

How do you download this from cpan? I have a newer version and it might be my problem...

[chirpy]

Anup has told you how to do it. Do a search Issues with DBD::mysql have been discussed at length on the forum in the last few days.

[gahelm]

I know DBD:mysql 3.000 has been discussed at length Chirpy, but has anyone fixed it? I've had my providers tech group on this to no avail. I've tried everything posted here and got no where. It's not causing me any real grief that I know of, but I hate to have errors showing up in the upcp log.

[anup123]

go to http://search.cpan.org

search DBD::Mysql

Navigate to the list
Download 2.9008
tar--zxvf DBD-mysql-2.9008.tar.gz
perl Makefile.PL
make
make install

Most of the tech groups round the world have been failing with this and you can't blame them, it takes time to get to the cause. It took me two Hrs to get my stuff back to working stage (after 3.0000 broke almost everything on db based scripts (cgi/perl)) and the reasons of that hapening has been explained by the author (whioch i have already posted for info) when i contacted with the bug report. As mentioned, he is going to come with a fixed version (which is not 3.0001) soon

Anup