wilfried

Active Member
Aug 23, 2003
33
0
156
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?
 

lankyb

Well-Known Member
Sep 21, 2004
99
0
166
Peterborough, UK
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

Active Member
Aug 23, 2003
33
0
156
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

Well-Known Member
Jan 17, 2003
2,288
0
191
So you changed the permissions on the files, but did you also change the folder to 755?
 

wilfried

Active Member
Aug 23, 2003
33
0
156
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....

:(
 

wilfried

Active Member
Aug 23, 2003
33
0
156
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

Well-Known Member
Mar 29, 2004
889
1
168
This Planet
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

Active Member
Aug 23, 2003
33
0
156
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

Active Member
Aug 23, 2003
33
0
156
How do you download this from cpan? I have a newer version and it might be my problem...
 

chirpy

Well-Known Member
Verifed Vendor
Jun 15, 2002
13,437
31
473
Go on, have a guess
Anup has told you how to do it. Do a search :rolleyes: Issues with DBD::mysql have been discussed at length on the forum in the last few days.
 

gahelm

Active Member
Jun 21, 2003
37
0
156
Florida
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

Well-Known Member
Mar 29, 2004
889
1
168
This Planet
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
 

baidarkabob

Well-Known Member
Jan 12, 2003
105
0
166
Alaska
Hello Anup, fellow gmail user here.

I appreciate you posting instructions but I am so inexperienced I fear there is a step left out.

YOu say to download the older version of the tar but do not say where to upload it too? I can run pico OK as long as I know where the file is supposed to be placed.

Please help.

bob
 

gahelm

Active Member
Jun 21, 2003
37
0
156
Florida
baidarkabob,

You need to download it to a directory on your server. Then;

tar--zxvf DBD-mysql-2.9008.tar.gz
perl Makefile.PL
make
make install

UPCP will still show errors in the morning because it will try to update again.....
 

anup123

Well-Known Member
Mar 29, 2004
889
1
168
This Planet
Oh it's never safe to really have upcp set in auto mode. I switched it to manual right in the initial days when one such thing broke quite a few things.

As for downloads, I have all my downloads in downloads directory ... easier to have all things organized in one directory :)

Anup
 
Last edited:

wilfried

Active Member
Aug 23, 2003
33
0
156
Anup

Thanks a lot, this fixed my problem too....

Will it be fixed so we can re-upgrade at some point?