RE: the continuing saga

June 29, 2013

      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@pfsweb.com] 
Sent: Saturday, 29 June, 2013 11:49 PM
To: 鱼; spamikaze@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  |   <http://www.pfsweb.com/> www.pfsweb.com
p:  972.881.2900  x3104
m: 972.948.3424

From: 鱼 [mailto:nicholas@10122112.com] 
Sent: Saturday, June 29, 2013 3:15 AM
To: Eric Henson; spamikaze@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@kernelnewbies.org
[mailto:spamikaze-bounces@kernelnewbies.org] On Behalf Of Eric Henson
Sent: Saturday, 29 June, 2013 3:28 AM
To: spamikaze@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  |   <http://www.pfsweb.com/> www.pfsweb.com
p:  972.881.2900  x3104
m: 972.948.3424

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