June 2013 - spamikaze@kernelnewbies.org - Kernelnewbies Mailing Lists

the continuing saga
by Eric Henson July 1, 2013

July 1, 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

2 4

Qmail & Vpopmail Aliases
by 鱼 June 28, 2013

June 28, 2013

Hi, Had figured out how to get passivetrap.pl to work with qmail & vpopmail aliases. In the folder /home/vpopmail/domains/mydomain.com Create .qmail-first:lastname file. In the file, | /path/passivetrap.pl chown vpopmail:vchkpw .qmail-first:lastname If there is no lastname, just leave the lastname, including : out Regards nic

3 5

Install instructions
by Eric Henson June 28, 2013

June 28, 2013

Okay, the INSTALL file is fairly decent-a lot better than the online wiki. I now have apache up and serving pages, php+perl installed. There's a section on /etc/aliases, that refers to a "newaliases" command, which I don't seem to have. I'm running Centos 6.4 (minimal). Do I need to install Sendmail or something else? My primary mail infrastructure is Exchange 2010; I can set it to either send SMTP email to spamikaze, or drop the mail as files to a directory. -- ERIC HENSON Solutions Architect for Systems Organization PFSweb | www.pfsweb.com<http://www.pfsweb.com/> p: 972.881.2900 x3104 m: 972.948.3424

3 5

spamikaze installation
by Eric Henson June 27, 2013

June 27, 2013

I've started to do the install of Spamikaze, and the installation instructions are...lacking. The database file (spamikaze-mysql.sql) isn't formatted correctly for MySQL 5.x-I had to manually create the tables, columns, and indexes. Should I be using MySQL in the first place? I found an article that said that it will bog down very quickly and to use PostgreSQL instead. And, how do I do the actual install? I used git to clone the repository, do I need to "make install" or something at this point? I guess what I really want to ask is, is this project dead? Or just undocumented? -- ERIC HENSON Solutions Architect for Systems Organization PFSweb | www.pfsweb.com<http://www.pfsweb.com/> p: 972.881.2900 x3104 m: 972.948.3424

3 4

RE: spamikaze installation
by Eric Henson June 27, 2013

June 27, 2013

Major changes that I can see in my mysqldump are changing from TYPE=MyISAM to ENGINE=MyISAM, and adding a default charset. Should I attach the mysqldump to my next email? Should I zip it or anything? -- ERIC HENSON Solutions Architect for Systems Organization PFSweb | www.pfsweb.com p: 972.881.2900 x3104 m: 972.948.3424 -----Original Message----- From: Todd Lyons [mailto:tlyons@ivenue.com] Sent: Thursday, June 27, 2013 9:22 AM To: Eric Henson Cc: Rob Wise; spamikaze(a)kernelnewbies.org Subject: Re: spamikaze installation I would say to clone the repo from the spamikaze website, then create a project on github. Create branches and upload code. People can fork it and do similar and create pull requests for you, etc. On Thu, Jun 27, 2013 at 7:08 AM, Eric Henson <ehenson(a)pfsweb.com> wrote: > Should I use the 0.1 or 0.2 version? > > > > If I do a lot of work to get this thing running, can I upload the > fixed MySQL script and better installation instructions? > > > > -- > ERIC HENSON > Solutions Architect for Systems Organization > > PFSweb | www.pfsweb.com > p: 972.881.2900 x3104 > m: 972.948.3424 > > > > From: Rob Wise [mailto:rob@wonk.org] > Sent: Thursday, June 27, 2013 12:39 AM > To: Eric Henson > Cc: spamikaze(a)kernelnewbies.org > Subject: Re: spamikaze installation > > > > Hi Eric, > > > > I would classify the project as somewhere between dormant and dead. I > don't think there has been any significant work done since circa 2006. > > > > Having said that, when I last had the software running it was working > really well. If you can get it running in a current software > environment I'm sure it will get the job done for you. MySQL is > definitely the right DB, but as you noted the syntax of the schema file may be a little outdated now. > > > Cheers, > > > > Rob > > > > On Thu, Jun 27, 2013 at 8:19 AM, Eric Henson <ehenson(a)pfsweb.com> wrote: > > I’ve started to do the install of Spamikaze, and the installation > instructions are…lacking. > > > > The database file (spamikaze-mysql.sql) isn’t formatted correctly for > MySQL 5.x—I had to manually create the tables, columns, and indexes. > > > > Should I be using MySQL in the first place? I found an article that > said that it will bog down very quickly and to use PostgreSQL instead. > > > > And, how do I do the actual install? I used git to clone the > repository, do I need to “make install” or something at this point? > > > > I guess what I really want to ask is, is this project dead? Or just > undocumented? > > > > -- > ERIC HENSON > Solutions Architect for Systems Organization > > PFSweb | www.pfsweb.com > p: 972.881.2900 x3104 > m: 972.948.3424 > > > > > _______________________________________________ > Spamikaze mailing list > Spamikaze(a)kernelnewbies.org > http://lists.kernelnewbies.org/mailman/listinfo/spamikaze > > > > > ------------------------ > This email was scanned by BitDefender. > > > _______________________________________________ > Spamikaze mailing list > Spamikaze(a)kernelnewbies.org > http://lists.kernelnewbies.org/mailman/listinfo/spamikaze > -- The total budget at all receivers for solving senders' problems is $0. If you want them to accept your mail and manage it the way you want, send it the way the spec says to. --John Levine ------------------------ This email was scanned by BitDefender.

1 0