Spamsnake Wailwatch Problem

[dean_za]

I have followed this great guide , many thanks to the author , being a qmail admin for 8 years this is my first dab at postfix. I was really eager to use the mailwatch web page to manage things. Unfortunately something must be wrong and I am not to sure what to check. I can access the mailwatch page and I can see when messages are in the mailq. I can click on them and it shows the messages but does ot give me any options or actions.

Also none of the stats change on the right hand side and if I click messages I get o results from table. I am assuming that mailscanner is not interacting with mysql properly. The mail.log shows

Jun 30 20:17:24 oss01 MailScanner[32416]: MailScanner E-Mail Virus Scanner version 4.68.8 starting...
Jun 30 20:17:25 oss01 MailScanner[32416]: Read 817 hostnames from the phishing whitelist
Jun 30 20:17:25 oss01 MailScanner[32416]: Read 5141 hostnames from the phishing blacklist
Jun 30 20:17:25 oss01 MailScanner[32416]: Config: calling custom init function SQLBlacklist
Jun 30 20:17:25 oss01 MailScanner[32416]: Starting up SQL Blacklist
Jun 30 20:17:26 oss01 MailScanner[32416]: Read 0 blacklist entries
Jun 30 20:17:26 oss01 MailScanner[32416]: Config: calling custom init function SQLWhitelist
Jun 30 20:17:26 oss01 MailScanner[32416]: Starting up SQL Whitelist
Jun 30 20:17:26 oss01 MailScanner[32416]: Read 1 whitelist entries
Jun 30 20:17:27 oss01 MailScanner[32416]: SpamAssassin temporary working directory is /var/spool/MailScanner/incoming/SpamAssassin-Temp
Jun 30 20:17:27 oss01 MailScanner[32416]: Using SpamAssassin results cache
Jun 30 20:17:27 oss01 MailScanner[32416]: Connected to SpamAssassin cache database
Jun 30 20:17:28 oss01 MailScanner[32416]: Expired 3 records from the SpamAssassin cache
Jun 30 20:17:28 oss01 MailScanner[32416]: Enabling SpamAssassin auto-whitelist functionality...
Jun 30 20:17:36 oss01 MailScanner[32416]: ClamAV scanner using unrar command /usr/bin/unrar
Jun 30 20:17:36 oss01 MailScanner[32416]: Using locktype = flock

so I don't see any errors

Can anyone recommend what I need to check ?

Regards
Dean

[Rocky]

Dean,

Glad to hear that you've given the Spamsnake a shot. You must be having permission issues. I would redo the following and reboot your server.


chown -R postfix:www-data /var/spool/MailScanner
chown -R postfix:www-data /var/lib/MailScanner
chown -R postfix:www-data /var/run/MailScanner
chown -R postfix:www-data /var/lock/subsys/MailScanner
chown -R postfix:www-data /var/spool/postfix/hold
chmod -R ug+rwx /var/spool/postfix/hold
chmod -R u+rwx,g+rx /var/spool/MailScanner/quarantine


Let me know if that works for you.

Rocky

[dean_za]

chown -R postfix:www-data /var/run/MailScanner
chown: cannot access `/var/run/MailScanner': No such file or directory



ls -l /var/lock/subsys/
total 0
-rw-r--r-- 1 root root 0 2008-07-01 16:25 httpd.vmware
-rw-r--r-- 1 root root 0 2008-07-01 16:25 mailscanner
drwxr-xr-x 2 postfix www-data 60 2008-07-02 07:10 MailScanner
-rw-r--r-- 1 root root 0 2008-07-01 16:25 vmware

I do believe the system is working but it is not logging to the mysql database which is obviously where mailwatch(mailscaner webpage) is searching for info. If I "select * from maillog;" inside the mysql database I get no results , so that tells me nothing is going in. I do have data inside the geoip tables which tells me the database is setup and the usernames/passwordds are correct. So all I an assume is that mailscanner is not setup to log to the sql database . I have the sql settings in mailwatch.pm inside the CustomFunctions directory.

I am guessing the problem is in this area.

thanks for your help rocky.

regards
dean

[dean_za]

I was thingking , how can I enable more verbose logging so I can see what mailscanner is sending to the database ?

[dean_za]

Always Looked Up Last = &MailWatchLogging

so simple

Thanks again for a great setup