Results 1 to 4 of 4

Thread: [SOLVED] Get amavis_msg_count/amavis_spam_count

  1. #1
    jor-el is offline Junior Member
    Join Date
    Jul 2009
    Posts
    5
    Rep Power
    6

    Question [SOLVED] Get amavis_msg_count/amavis_spam_count

    Hi, we are looking to customize our spam filters(adding SPF, tuning spamassassin configuration files, etc.), but we need to see if what we're doing is actually working, we need to see the numbers, not just the graphics, is there any way to get the amavis_msg_count and amavis_spam_count from the CLI(or any other way but to get the real number)?.

    Thanks!

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Postfix and Amavis Log Reporters

    You will need to increase log_level to 2 in /opt/zimbra/conf/amavisd.conf.in and then run
    Code:
    su - zimbra
    zmamavisdctl stop ; zmamavisdctl start

  3. #3
    jor-el is offline Junior Member
    Join Date
    Jul 2009
    Posts
    5
    Rep Power
    6

    Default

    Hello uxbod, that is just the tool i needed, even whit the log level set to 1 it parses the info I needed, of course there's no detailed information, so it's not that usefull for identifing patterns or anything, but to get a summary from the data that we already have still works, I already increased the log level to make amavis-logwatch reports more rich.

    Thank you very much!

    Best Regards

  4. #4
    jor-el is offline Junior Member
    Join Date
    Jul 2009
    Posts
    5
    Rep Power
    6

    Default

    Just in case anyone reads this in the future(this can be helpfull), there is also a way to see simple information in the mysql database:

    as zimbra user(su - zimbra) run logmysl - D zimbra_logger (the -D parameter is optional just to avoid having to change databases inside the DBMS).

    Under the table amavis_aggregate you have the sumary of the message count, the spam count, and the virus count, by hour, or by day.

    If you are interested in more detailed information you can query the amavis table. There are other tables such as config, mta or mta_aggregate that may interest you, but, be carefull whit this.

    Regards,

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •