spamassassin cp bug ?

Hi,

There could be a issue on CentOS 5 / iworx 3.0.3, because i’ve two server with the same simptoums …

Checking CP, On “SpamAssassin Options” … it’s disabled and could not be enabled (CP).

If we check command line, “service spamassassin status” … it looks that is running …

Please confirm this issue and how to solve it …

Regards

PS: “SMTP Virus Scanning” is also “disabled” (on CP) and i does not turn “enabled” :-S

PS2: A ticket has been updated with this issue

Have you by chance updated to mysql5 lately?

I had the same problem, which didn’t surface until after a reboot for some reason.

Check your error log

[SIZE=2][root@iworx log]# tail /var/log/maillog
Oct 23 21:27:56 iworx spamd[5332]: Can’t load ‘/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so’ for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
Oct 23 21:27:56 iworx spamd[5332]: at (eval 195) line 3
Oct 23 21:27:56 iworx spamd[5332]: Can’t load ‘/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so’ for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
Oct 23 21:27:56 iworx spamd[5332]: at (eval 195) line 3
Oct 23 21:27:56 iworx spamd[5332]: Compilation failed in require at (eval 195) line 3.
Oct 23 21:27:56 iworx spamd[5332]: install_driver(mysql) failed: Can’t load ‘/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so’ for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
Oct 23 21:27:56 iworx spamd[5332]: at (eval 195) line 3
Oct 23 21:27:56 iworx spamd[5332]: Compilation failed in require at (eval 195) line 3.
Oct 23 21:27:56 iworx spamd[5332]: Perhaps a required shared library or dll isn’t installed where expected
Oct 23 21:27:56 iworx spamd[5332]: at /usr/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesStore/SQL.pm line 1656
[root@iworx log]#[/SIZE]
The fix was to update the package

perl-DBD-MySQL for php5/mysql5 support

EDIT: Whoops! Didn’t see you had opened a ticket, but here’s the info if anyone else needs it.

Hi Tim,

I did need to update any package and there where no error on the logs.

I did reboot the server and the problem is solved :wink:

Thank’s for the hint …

EDIT: Whoops! Didn’t see you had opened a ticket, but here’s the info if anyone else needs it.

I didn’t had an answer to that ticket :frowning:

Regards

Paulo

Hi…

Talked to soon … solved on the i386 platform, but not on the x64 …

maillog:
[…]
Oct 26 10:42:08 gomo spamd[10096]: Use of uninitialized value in numeric eq (==) at /usr/lib/perl5/site_perl/5.8.8/Mail/SpamAssassin/SpamdForkScaling.pm line 689
[…]

Still can’t update the spamassassin and clam to “enable” :frowning:

Any ideas ?

Regards

Paulo

Paul wrote

Try this two commands and see if it fixes it. I suspect the /var/qmail/control/simcontrol file is missing for some reason - it gets created during the “goiworx” install step, but it seems like on some unknown scenario, it doesn’t get created or disappears.

Try this:

echo “:clam=no,spam=no,trophie=no,spam_hits=95” > /var/qmail/control/simcontrol

chown iworx /var/qmail/control/simcontrol

rebooted and the problem is solved …

Thank you

Hi,

Just for your knowledge, we have a machine running:

Centos 5.1 64 bits
Interworx 3.0.3

and we had the same problem.

It solved with the two commands mentioned above.

i opened a ticket due today to SA not accepting values for smtp threshold scanning and a couple of other issues. nodeworx accepts the smtp scan value, and i restart SA, but /var/log/maillog still shows 5 as the value for scanning, even after i set it to 30 in nodeworx. perms on /var/qmail/control/simcontrol are showing as iworx:root and perms on simcontrol.cdb are showing as root:root. here is my ls of /var/qmail/control dir:

[root@srv spamassassin]# cd /var/qmail/control/
[root@srv control]# ls -al
total 276
drwxr-xr-x 2 root qmail 4096 Aug 21 02:05 .
drwxr-xr-x 12 root qmail 4096 Oct 31 2007 …
-rw-r–r-- 1 root qmail 24 Sep 20 2007 badloadertypes
-rw-r–r-- 1 root root 2164 Oct 31 2007 badloadertypes.cdb
-rw-r–r-- 1 root qmail 25 May 4 13:25 badmailfrom
-rw-r–r-- 1 root qmail 25 May 3 22:01 .badmailfrom
-rw-r–r-- 1 root qmail 0 Sep 20 2007 badmailto
-rw-r–r-- 1 root qmail 326 Sep 20 2007 badmimetypes
-rw-r–r-- 1 root root 2609 Oct 31 2007 badmimetypes.cdb
-rw-r–r-- 1 root qmail 37 May 4 13:25 blacklists
-rw-r–r-- 1 root qmail 37 May 4 13:23 .blacklists
-rw-r–r-- 1 root qmail 4 Sep 20 2007 bouncemaxbytes
lrwxrwxrwx 1 root qmail 14 Oct 31 2007 clientcert.pem -> servercert.pem
-rw-r–r-- 1 root qmail 3 Sep 20 2007 concurrencyincoming
-rw-r–r-- 1 root qmail 4 Sep 20 2007 concurrencyremote
-rw-r–r-- 1 root qmail 9 Feb 5 2008 databytes
-rw-r–r-- 1 root qmail 11 Sep 20 2007 defaultdelivery
-rw-r–r-- 1 root qmail 19 Nov 4 2007 defaultdomain
-rw-r–r-- 1 root qmail 245 Aug 21 01:01 dh1024.pem
-rw-r–r-- 1 root qmail 156 Aug 21 01:01 dh512.pem
-rw-r–r-- 1 root root 58 Jul 24 22:17 locals
-rw------- 1 root root 0 Jul 24 22:17 locals.lock
-rw-r–r-- 1 root qmail 24 Nov 4 2007 me
-rw-r–r-- 1 root qmail 2 Sep 20 2007 mfcheck
-rw-r–r-- 1 root qmail 19 Nov 4 2007 plusdomain
-rw-r–r-- 1 root root 496 Jul 24 22:17 rcpthosts
-rw------- 1 root root 0 Jul 24 22:17 rcpthosts.lock
-rw-r–r-- 1 root qmail 497 Aug 21 01:01 rsa512.pem
-rw-r–r-- 1 root qmail 1693 Sep 20 2007 servercert.pem
-rw-r–r-- 1 iworx root 43 Aug 21 02:05 simcontrol
-rw-r–r-- 1 root root 2113 Aug 21 02:05 simcontrol.cdb
-rw-r–r-- 1 root qmail 24 Nov 5 2007 smtpgreeting
-rw-r–r-- 1 root qmail 36 Nov 5 2007 .smtpgreeting
-rw-r–r-- 1 root qmail 0 Nov 17 2007 smtproutes
-rw-r–r-- 1 root qmail 44 Nov 17 2007 .smtproutes
-rw-r–r-- 1 root qmail 27 Sep 20 2007 spamt
-rw-r–r-- 1 root root 2096 Oct 31 2007 spamt.cdb
-rw-r–r-- 1 root qmail 2 Sep 20 2007 spfbehavior
-rw-r----- 1 root vchkpw 102 Nov 1 2007 sql
-rw-r–r-- 1 root qmail 4 Sep 20 2007 timeoutremote
lrwxrwxrwx 1 root root 35 Oct 31 2007 tlsclientciphers -> /var/qmail/control/tlsserverciphers
-rw-r–r-- 1 root qmail 704 Oct 31 2007 tlsserverciphers
-rw-r–r-- 1 root root 896 Jul 24 22:17 virtualdomains
-rw------- 1 root root 0 Jul 24 22:17 virtualdomains.lock

Hi,

What value is set on /var/qmail/control/simcontrol file ?

my permissons on simcontrol file:
-rw-r–r-- 1 iworx root 41 Aug 14 14:55 /var/qmail/control/simcontrol

Regards

the file /var/qmail/control/simcontrol contains the following:

clam=yes,spam=yes,trophie=no,spam_hits=30

iworx Paul did come back on the ticket and cleared up a common point of confusion. he wrote:

The “SMTP SPAM Score Threshold:” is not the same as the “required_score” SpamAssassin setting, this is where the confusion lies.

The “SMTP SPAM Score Threshold:” is the Spam Score at which mail will be rejected at the SMTP level.

The spamassassin required_score setting is what you’re editing in the local.cf - and it determines at what point SpamAssassin will tag a message as spam. There’s no explicit setting for this option in the NodeWorx Spam Filtering section, but you can set it in the “Advanced SpamAssassin Custom Options” section.

silly me… i thought required_score (which is NOT set in nodeworx, but only in /etc/mail/spamassassin/local.cf) was the same as SMTP SPAM Score Threshold. The latter, whose value is set in nodeworx, specifies spam email that is rejected at the server level and never delivered…if i’m understanding what Paul wrote. so, for SA i guess everyone still needs to set a required_score value in local.cf.

j