Spamsnake Wailwatch Problem

Discussion in 'HOWTO-Related Questions' started by dean_za, Jun 30, 2008.

  1. dean_za

    dean_za New Member

    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
     
  2. Rocky

    Rocky New Member

    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.

    Code:
     
    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
     
  3. dean_za

    dean_za New Member

    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
     
  4. dean_za

    dean_za New Member

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

    dean_za New Member

    Fixed

    Always Looked Up Last = &MailWatchLogging

    so simple

    Thanks again for a great setup
     

Share This Page