View Single Post
  #1  
Old 19th August 2009, 10:03
sergio.arnaldo sergio.arnaldo is offline
Junior Member
 
Join Date: Aug 2006
Posts: 28
Thanks: 0
Thanked 1 Time in 1 Post
Question MailScanner trouble with DBD-MYSQL

Dear all

I am recently installed MailScanner+MailWatch following the "The Perfect SpamSkane Ubuntu Jaunty Jackalope".
I notice in logs that MailScanner keeps restarting all the time.
I set debug = yes in MailScaner.conf and when I restart it the error I see is "Undefined subroutine &MailScanner::CustomConfig::SQLWhitelist called at /opt/MailScanner/lib/MailScanner/Config.pm line 171.

I have reinstalled MailScanner 3 times because I couldn't get rid of the above error.
I googled so many times because of it and it seems it is as issue with DBD-MySQL not being installed correctly. I tried to install is via apt-get but the error continues. I also tried to install it via CPAN but still I get errors.

Below is part of mail.log:
MailScanner E-Mail Virus Scanner version 4.75.11 starting...
Aug 19 06:26:24 spamsnake MailScanner[11277]: Read 855 hostnames from the phishing whitelist
Aug 19 06:26:24 spamsnake MailScanner[11277]: Read 5874 hostnames from the phishing blacklist
Aug 19 06:26:24 spamsnake MailScanner[11277]: Config: calling custom init function SQLBlacklist
Aug 19 06:26:24 spamsnake MailScanner[11277]: Config: calling custom init function MailWatchLogging
Aug 19 06:26:24 spamsnake MailScanner[11277]: Config: calling custom init function SQLWhitelist
Aug 19 06:26:24 spamsnake MailScanner[11277]: Using SpamAssassin results cache
Aug 19 06:26:24 spamsnake MailScanner[11277]: Connected to SpamAssassin cache database
Aug 19 06:26:24 spamsnake MailScanner[11277]: Enabling SpamAssassin auto-whitelist functionality...
Aug 19 06:26:29 spamsnake MailScanner[11279]: MailScanner E-Mail Virus Scanner version 4.75.11 starting...
Aug 19 06:26:29 spamsnake MailScanner[11279]: Read 855 hostnames from the phishing whitelist
Aug 19 06:26:29 spamsnake MailScanner[11279]: Read 5874 hostnames from the phishing blacklist
Aug 19 06:26:29 spamsnake MailScanner[11279]: Config: calling custom init function SQLBlacklist
Aug 19 06:26:29 spamsnake MailScanner[11279]: Config: calling custom init function MailWatchLogging
Aug 19 06:26:29 spamsnake MailScanner[11279]: Config: calling custom init function SQLWhitelist
Aug 19 06:26:29 spamsnake MailScanner[11279]: Using SpamAssassin results cache
Aug 19 06:26:29 spamsnake MailScanner[11279]: Connected to SpamAssassin cache database
Aug 19 06:26:29 spamsnake MailScanner[11279]: Enabling SpamAssassin auto-whitelist functionality...
Aug 19 06:26:29 spamsnake MailScanner[11277]: Connected to processing-messages database
Aug 19 06:26:29 spamsnake MailScanner[11277]: Found 377577 messages in the processing-messages database
Aug 19 06:26:29 spamsnake MailScanner[11277]: Using locktype = flock
Aug 19 06:26:30 spamsnake MailScanner[11277]: Making attempt 2 at processing message 57C52B1C475.99C72
Aug 19 06:26:30 spamsnake MailScanner[11277]: New Batch: Scanning 26 messages, 7565410 bytes
Aug 19 06:26:31 spamsnake MailScanner[11279]: Connected to processing-messages database
Aug 19 06:26:31 spamsnake MailScanner[11279]: Found 377602 messages in the processing-messages database
Aug 19 06:26:31 spamsnake MailScanner[11279]: Using locktype = flock
Aug 19 06:26:32 spamsnake MailScanner[11279]: New Batch: Scanning 26 messages, 7565410 bytes
Aug 19 06:26:34 spamsnake MailScanner[11283]: MailScanner E-Mail Virus Scanner version 4.75.11 starting...
Aug 19 06:26:34 spamsnake MailScanner[11283]: Read 855 hostnames from the phishing whitelist
Aug 19 06:26:34 spamsnake MailScanner[11283]: Read 5874 hostnames from the phishing blacklist
Aug 19 06:26:34 spamsnake MailScanner[11283]: Config: calling custom init function SQLBlacklist
Aug 19 06:26:34 spamsnake MailScanner[11283]: Config: calling custom init function MailWatchLogging
Aug 19 06:26:34 spamsnake MailScanner[11283]: Config: calling custom init function SQLWhitelist
Aug 19 06:26:34 spamsnake MailScanner[11283]: Using SpamAssassin results cache
Aug 19 06:26:34 spamsnake MailScanner[11283]: Connected to SpamAssassin cache database
Aug 19 06:26:34 spamsnake MailScanner[11283]: Enabling SpamAssassin auto-whitelist functionality...
Aug 19 06:26:36 spamsnake MailScanner[11283]: Connected to processing-messages database
Aug 19 06:26:36 spamsnake MailScanner[11283]: Found 377628 messages in the processing-messages database
Aug 19 06:26:36 spamsnake MailScanner[11283]: Using locktype = flock
Aug 19 06:26:37 spamsnake MailScanner[11283]: Making attempt 2 at processing message 86FD6B1C487.584DC
Aug 19 06:26:37 spamsnake MailScanner[11283]: New Batch: Scanning 26 messages, 7565410 bytes
Aug 19 06:26:39 spamsnake MailScanner[11286]: MailScanner E-Mail Virus Scanner version 4.75.11 starting...
Aug 19 06:26:39 spamsnake MailScanner[11286]: Read 855 hostnames from the phishing whitelist
Aug 19 06:26:39 spamsnake MailScanner[11286]: Read 5874 hostnames from the phishing blacklist
Aug 19 06:26:39 spamsnake MailScanner[11286]: Config: calling custom init function SQLBlacklist
Aug 19 06:26:39 spamsnake MailScanner[11286]: Config: calling custom init function MailWatchLogging
Aug 19 06:26:39 spamsnake MailScanner[11286]: Config: calling custom init function SQLWhitelist
Aug 19 06:26:39 spamsnake MailScanner[11286]: Using SpamAssassin results cache
Aug 19 06:26:39 spamsnake MailScanner[11286]: Connected to SpamAssassin cache database
Aug 19 06:26:39 spamsnake MailScanner[11286]: Enabling SpamAssassin auto-whitelist functionality...
Aug 19 06:26:41 spamsnake MailScanner[11286]: Connected to processing-messages database
Aug 19 06:26:41 spamsnake MailScanner[11286]: Found 377653 messages in the processing-messages database
Aug 19 06:26:41 spamsnake MailScanner[11286]: Using locktype = flock
Aug 19 06:26:42 spamsnake MailScanner[11286]: New Batch: Scanning 26 messages, 7565410 bytes
Aug 19 06:26:44 spamsnake MailScanner[11289]: MailScanner E-Mail Virus Scanner version 4.75.11 starting...
Aug 19 06:26:44 spamsnake MailScanner[11289]: Read 855 hostnames from the phishing whitelist
Aug 19 06:26:44 spamsnake MailScanner[11289]: Read 5874 hostnames from the phishing blacklist
Aug 19 06:26:44 spamsnake MailScanner[11289]: Config: calling custom init function SQLBlacklist
Aug 19 06:26:44 spamsnake MailScanner[11289]: Config: calling custom init function MailWatchLogging
Aug 19 06:26:44 spamsnake MailScanner[11289]: Config: calling custom init function SQLWhitelist
Aug 19 06:26:44 spamsnake MailScanner[11289]: Using SpamAssassin results cache

Via CPAN I follow the steps:
perl -MCPAN -e shell
look DBD::mysql
perl Makefile.PL --testdb=test --testuser=root --testpassword=supersecret --testhost=localhost
make
make test
make install

But in make test there are errors like these:
t/40blobs.t 255 65280 ?? ?? ??
33 tests skipped.
Failed 1/35 test scripts. 0/6 subtests failed.
Files=35, Tests=6, 3 wallclock secs ( 1.93 cusr + 0.26 csys = 2.19 CPU)
Failed 1/35 test programs. 0/6 subtests failed.
make: *** [test_dynamic] Error 255

And If I insist on make install the output is following:
root@spamsnake:~/.cpan/build/DBD-mysql-4.012-aIxLSX# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib/perl/5.10.0/auto/DBD/mysql/mysql.so
Writing /usr/local/lib/perl/5.10.0/auto/DBD/mysql/.packlist
Appending installation info to /usr/local/lib/perl/5.10.0/perllocal.pod


It seems installation goes ok.... but I am not sure.
I still get the "Undefined subroutine &MailScanner::CustomConfig::SQLWhitelist called at /opt/MailScanner/lib/MailScanner/Config.pm line 171" whet I run MailScanner on debug mode.

Whould anyone please help me to correct this?
Reply With Quote
Sponsored Links