Postfix Mailscanner Issue

vikas027 · 10-16-2011, 05:26 AM

Hi All,

I have just installed postfix + spamassasin + mailscanner + clamav using this link on CentOS 5.7 on my test setup.

My MailScanner -lint shows

Code:

[root@box1 MailScanner]# MailScanner --lint
Trying to setlogsock(unix)

Reading configuration file /etc/MailScanner/MailScanner.conf
Reading configuration file /etc/MailScanner/conf.d/README
Read 867 hostnames from the phishing whitelist
Read 4252 hostnames from the phishing blacklists

Checking version numbers...
Version number in MailScanner.conf (4.84.3) is correct.

ERROR: The "envelope_sender_header" in your spam.assassin.prefs.conf
ERROR: is not correct, it should match X-HCL-MailScanner-From

MailScanner setting GID to  (89)
MailScanner setting UID to  (89)

Checking for SpamAssassin errors (if you use it)...
WARNING: You are trying to use the SpamAssassin cache but your DBI and/or DBD::SQLite Perl modules are not properly installed! at /usr/lib/MailScanner/MailScanner/SA.pm line 197
config: failed to parse line, skipping, in "/etc/mail/spamassassin/mailscanner.cf": use_auto_whitelist 0
SpamAssassin reported an error.
ERROR: Could not connect to SQLite database /var/spool/MailScanner/incoming/Processing.db, either I cannot write to that location or your SQLite installation is screwed. at /usr/sbin/MailScanner line 1763
Using locktype = posix
MailScanner.conf says "Virus Scanners = clamd"
Found these virus scanners installed: clamd
===========================================================================
Filename Checks: Windows/DOS Executable (1 eicar.com)
Other Checks: Found 1 problems
Virus and Content Scanning: Starting
Clamd::INFECTED::Eicar-Test-Signature :: ./1/
Clamd::INFECTED:: Eicar-Test-Signature :: ./1/eicar.com
Virus Scanning: Clamd found 2 infections
Infected message 1 came from 10.1.1.1
Virus Scanning: Found 2 viruses
===========================================================================
Virus Scanner test reports:
Clamd said "eicar.com was infected: Eicar-Test-Signature"

If any of your virus scanners (clamd)
are not listed there, you should check that they are installed correctly
and that MailScanner is finding them correctly via its virus.scanners.conf.
[root@box1 MailScanner]#

The above output gives this warning and error

Quote:

Checking for SpamAssassin errors (if you use it)...
WARNING: You are trying to use the SpamAssassin cache but your DBI and/or DBD::SQLite Perl modules are not properly installed!
ERROR: Could not connect to SQLite database /var/spool/MailScanner/incoming/Processing.db

I have installed perl-DBD-SQLite rpm from here.

Other installed versions are here.

Code:

[root@box1 ~]# yum list installed | egrep 'SQLite|mailscanner|spamassassin|clamav|clamd|perl-DBI|postfix'
clamav.x86_64                              0.97.2-1.el5.rf             installed
clamav-db.x86_64                           0.97.2-1.el5.rf             installed
clamd.x86_64                               0.97.2-1.el5.rf             installed
mailscanner.noarch                         4.84.3-1                    installed
perl-DBD-SQLite.x86_64                     1.29-2.el5.rfx              installed
perl-DBI.x86_64                            1.52-2.el5                  installed
postfix.x86_64                             2:2.3.3-2.3.el5_6           installed
spamassassin.x86_64                        3.3.1-2.el5                 installed

and /var/spool/MailScanner/incoming/Processing.db file is not present

Code:

[root@box1 ~]# ls -lrth /var/spool/MailScanner/incoming/Processing.db
ls: /var/spool/MailScanner/incoming/Processing.db: No such file or directory

Please suggest how to tackle this.

Also, MailScanner is not working as it should be. I tried blocking emails by size and password protected files, by below parameters, BUT it is not working. I am still getting emails.

Quote:

Maximum Attachment Size = 3000
Allow Password-Protected Archives = no

Please help.

lithos · 10-17-2011, 04:41 AM

look at here

thanhtd · 11-21-2011, 08:53 PM

I had the same problem with vikas027 and the link lithos provided does not help.

Anyway, I did solve the problem.
Here I post the reason that anyone have come through this can figure out faster.
Actually, this is the problem of package dependency. I tried to install perl-DBD-SQLite.x86_64 1.29-2.el5.rfx without concerning its dependency requirement (perl-DBI 1.57 or above).
Centos repo only provide perl-DBI 1.52 package for x86_64 machines (at the time I post this message).

So you only need to download perl-DBI 1.57 or above from any repo and install it(as my case, I got 1.616 from pkgs.repoforge.org/perl-DBI/).

Hope this help and sorry for my poor English.

vikas027 · 11-23-2011, 04:04 PM

Quote:

Originally Posted by thanhtd

I had the same problem with vikas027 and the link lithos provided does not help.

Anyway, I did solve the problem.
Here I post the reason that anyone have come through this can figure out faster.
Actually, this is the problem of package dependency. I tried to install perl-DBD-SQLite.x86_64 1.29-2.el5.rfx without concerning its dependency requirement (perl-DBI 1.57 or above).
Centos repo only provide perl-DBI 1.52 package for x86_64 machines (at the time I post this message).

So you only need to download perl-DBI 1.57 or above from any repo and install it(as my case, I got 1.616 from pkgs.repoforge.org/perl-DBI/).

Hope this help and sorry for my poor English.

Many thanks for posting this. I did installed all packages with all dependencies.

I will surely try this out when I will get time.