the continuing saga

[Eric Henson]

Okay, the database updated successfully, but apache is returning an internal server error.

Here are the apache errors:

[Mon Jul 01 14:50:12 2013] [error] [client 10.100.211.50] DBD::mysql::st execute failed: Out of range value for column 'octa' at row 1 at /var/www/cgi-bin/remove.cgi line 160., referer: http://prodantispam01.pfsweb.com/remove.html

[Mon Jul 01 14:50:12 2013] [error] [client 10.100.211.50] DBD::mysql::st execute failed: Out of range value for column 'octa' at row 1 at /var/www/cgi-bin/remove.cgi line 160., referer: http://prodantispam01.pfsweb.com/remove.html

[Mon Jul 01 14:50:12 2013] [error] [client 10.100.211.50] Premature end of script headers: remove.cgi, referer: http://prodantispam01.pfsweb.com/remove.html

Here’s that line of the remove.cgi file:
    $sthi->execute($epoch, $octa, $octb, $octc, $octd);

--
ERIC HENSON
Solutions Architect for Systems Organization
PFSweb  |  www.pfsweb.com<http://www.pfsweb.com/>
p:  972.881.2900  x3104
m: 972.948.3424

From: 鱼 [mailto:nicholas at 10122112.com]
Sent: Saturday, June 29, 2013 11:37 AM
To: Eric Henson; spamikaze at kernelnewbies.org
Subject: RE: the continuing saga

httpd.x86_64                                                                                  2.2.15-28.el6.centos                                                                           @updates
httpd-tools.x86_64                                                                            2.2.15-28.el6.centos                                                                           @updates
Available Packages
httpd-devel.i686                                                                              2.2.15-28.el6.centos                                                                           updates
httpd-devel.x86_64                                                                            2.2.15-28.el6.centos                                                                           updates
httpd-itk.x86_64                                                                              2.2.22-6.el6                                                                                   epel
httpd-manual.noarch                                                                           2.2.15-28.el6.centos                                                                           updates

As for perl I have over 100 packages which I don’t think it is nice to list here.

Regards
nic

From: Eric Henson [mailto:ehenson at pfsweb.com]
Sent: Saturday, 29 June, 2013 11:49 PM
To: 鱼; spamikaze at kernelnewbies.org<mailto:spamikaze at kernelnewbies.org>
Subject: RE: the continuing saga

Can you tell me what perl and httpd packages you have installed?

--
ERIC HENSON
Solutions Architect for Systems Organization
PFSweb  |  www.pfsweb.com<http://www.pfsweb.com/>
p:  972.881.2900  x3104
m: 972.948.3424

From: 鱼 [mailto:nicholas at 10122112.com]
Sent: Saturday, June 29, 2013 3:15 AM
To: Eric Henson; spamikaze at kernelnewbies.org<mailto:spamikaze at kernelnewbies.org>
Subject: RE: the continuing saga

I do not have such error. I am running on CentOS 6.4 with perl-5.10.1-131.el6_4.x86_64

Removal Results
IP address 78.129.223.91 has been removed from the database. It should be gone from the DNSBL list psbl.sorbl.com after the next zone file rebuild, in a couple of minutes.
Note that it will be added back in the next time it sends email to one of our spam traps, so please minimise any abusive behaviour by 78.129.223.91



From: spamikaze-bounces at kernelnewbies.org<mailto:spamikaze-bounces at kernelnewbies.org> [mailto:spamikaze-bounces at kernelnewbies.org] On Behalf Of Eric Henson
Sent: Saturday, 29 June, 2013 3:28 AM
To: spamikaze at kernelnewbies.org<mailto:spamikaze at kernelnewbies.org>
Subject: the continuing saga

Mysql: installed and working
Sendmail: installed and working
Passive.pl: working
remove.cgi: getting this error:

DBD::mysql::st execute failed: Out of range value for column 'octa' at row 1 at /var/www/cgi-bin/remove.cgi line 160., referer: http://prodantispam01.pfsweb.com/remove.html

My guess is that the remove.cgi isn’t updating the database correctly.

Here it parses the IP:

if ($ip =~ /^(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})$/) {
                                $octa = $1;
                                $octb = $2;
                                $octc = $3;
                                $octd = $4;

Here it writes to the database:

    my $dbh;


                # DBI connect params.
                $dbh = Spamikaze::DBConnect();

                my $sql = "UPDATE ipnumbers SET visible = 0 WHERE
                                                octa = ? AND
                                                octb = ? AND
                                                octc = ? AND
                                                octd = ? AND
                                                visible = 1";

--
ERIC HENSON
Solutions Architect for Systems Organization
PFSweb  |  www.pfsweb.com<http://www.pfsweb.com/>
p:  972.881.2900  x3104
m: 972.948.3424


------------------------
This email was scanned by BitDefender.

------------------------
This email was scanned by BitDefender.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kernelnewbies.org/pipermail/spamikaze/attachments/20130701/ac005b00/attachment-0001.html