spamassassin & clamav not working

  • Hello!


    I wanted to install spamassassin and clamav.


    First: SpamAssassin


    I have done this:


    aptitude update
    aptitude install spamassassin spamass-milter libmail-dkim-perl libnet-ident-perl libencode-detect-perl
    aptitude install pyzor razor


    then I installed the plugin. Then I've enabled in the config.php pyzor and razor. Then I clicked on "Update Plugins".


    Then I have sent from gmx.de an testmail with: XJS*C4JDBQADN1.NSBN3*2IDNEN*GTUBE-STANDARD-ANTI-UBE-TEST-EMAIL*C.34X


    The mail was normally delivered :(


    When I click in RoundCube on settings and then SPAM there comes an error:


    DATABASE ERROR: CONNECTION FAILED!
    Unable to connect to the database!
    Please contact your server-administrator.




    Second: ClamAV


    I have done:


    aptitude update
    aptitude install clamav clamav-base clamav-daemon clamav-freshclam clamav-milter
    service clamav-freshclam stop
    freshclam
    service clamav-freshclam start
    service clamav-daemon restart


    Then I have installed the plugin.


    Then I have sent from gmx.de an testmail with: X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*


    The mail was normally delivered :(



    I also tried to restart postfix. But spamassassin and clamav are not working.



    I hope someone can help me. Thanks in advance!! :)

    Files

    • Unbenannt.PNG

      (26.63 kB, downloaded 74 times, last: )
  • A first.. This EICAR signature will be filtered by gmx itself. So your test is not possible from GMX.
    At first check wheter the spamassasin table exist "imscp_spamassassin".
    Then check the config files of spamassasin

    Code
    1. /etc/spamassassin


    Take a look in the file "00_imscp.cf". You will find the database user and password

    Code
    1. bayes_sql_username sa_user
    2. bayes_sql_password


    Try to connect to the mysql server with this login credentials.


    I did installed the current version last week and all is working fine.
    Which i-MSCP version and which OS you are using?

  • Thanks for your answer.


    Good to know that gmx filters the EICAR signature.


    The table "imscp_spamassassin" is existing.


    With the login credentials from the 00_imscp.cf file I CAN'T login.


    What sould I do? Reinstall the Plugin, maybe?


    I'm using Debian 7 and i-MSCP 1.1.5

  • I have uninstalled the plugin and dropped the database. Then I have reinstalled the plugin. Same problem.



    I have done some tests ... now is all working. Here is my solution:


    The sa_user had as host the public IP address from my server (for example: 123.123.123.123). I have changed this to "localhost". Now I can login with the sa_user. I have sent an testmail from GMAIL with the EICAR signature. ClamAV is working and spamassassin, too.



    Thanks for your help! :)

  • Unfortunately I have to apply again .. not all is correctly working. :(


    I have looked into the mail.log file and I've found this:


    Code
    1. May 11 15:13:00 srv01 spamd[14783]: pyzor: check failed: internal error, python traceback seen in response


    Someone know how to solve this? In the config.php of the plugin I have enabled pyzor and razor and I have clicked on the "Update Plugins" button. Some things I have tested:


    Code
    1. pyzor pingpublic.pyzor.org:24441 (200, 'OK')


    Code
    1. pyzor discover
    2. downloading servers from http://pyzor.sourceforge.net/cgi-bin/inform-servers-0-3-x



    Thanks in advance! :)

  • Thanks for your answer!


    Here are the outputs:


    Code
    1. ls -la /var/lib/spamassassin/drwxr-xr-x 8 debian-spamd debian-spamd 4.0K May 11 12:41 .drwxr-xr-x 39 root root 4.0K May 11 12:53 ..drwxr-x--- 4 debian-spamd debian-spamd 4.0K May 11 12:21 3.003002drwxr-xr-x 3 debian-spamd debian-spamd 4.0K May 11 12:19 compileddrwx------ 2 debian-spamd debian-spamd 4.0K May 11 12:19 .pyzordrwxr-x--- 2 debian-spamd debian-spamd 4.0K May 12 13:40 .razordrwx------ 2 debian-spamd debian-spamd 4.0K May 11 12:19 sa-update-keysdrwx------ 3 debian-spamd debian-spamd 4.0K May 11 12:19 .spamassassin


    Code
    1. ls -la /var/lib/spamassassin/.pyzor/servers
    2. -rw------- 1 debian-spamd debian-spamd 23 May 12 13:39 /var/lib/spamassassin/.pyzor/servers


    Any ideas?


    Thanks in advance! :)

  • I know it's a very very bad question, but how can I see under which user spamassassin is running?


    I opened htop and looked on the running processes. I hope this is enough.


    On the picture the user spamass-m should be -> spamass-milter


    Thanks in advance! :)

    Files

    • htop.PNG

      (43.02 kB, downloaded 71 times, last: )
    • cat_etc_passwd.PNG

      (5.03 kB, downloaded 71 times, last: )