the continuing saga

June 28, 2013

      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

the continuing saga

Eric Henson