Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix problem and few questions Gimly Installation/Configuration 12 7th July 2009 16:27
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 01:05
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 03:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.