Results 1 to 9 of 9

Thread: av/ spam graph stopped in admin console

  1. #1
    Join Date
    Jul 2006
    Location
    ireland
    Posts
    388
    Rep Power
    9

    Default av/ spam graph stopped in admin console

    Hi All,
    has any body has an issues with the av/ spam graph stopped in admin console

    it was workin' fine for a couple of days after the initial install, and then stopped. The logger is
    running.
    i updated:
    Kill percent: 66
    Tag percent: 20
    because the spam volume was so large the spam filter is working well
    but no graph
    thanks for any replies

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    By stopped do you mean that the service stopped, or that the graphs stopped,
    ergo-is the service running?

  3. #3
    Join Date
    Jul 2006
    Location
    ireland
    Posts
    388
    Rep Power
    9

    Default

    Hi, The logger service is running ( it did stop at one stage due to the 2.30am issue see:
    http://www.zimbra.com/forums/showthr...?t=3569&page=2)
    and all other graphs are fine apart from the as/av which seems to be updating with blank data?

  4. #4
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    8

    Default

    Hi, I have the same issue where all the services are running, and spam and av is working fine, but the graphs in the admin interface show no data after about a month of use.

    Anyone know where to start looking for the cause of this problem?

    Cheers.

  5. #5
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    take a look at the logger db file
    /opt/zimbra/logger/db/data/hostname.err

  6. #6
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    8

    Default

    Thanks.. after a bit of poking and proding i discovered I had a corrupt table in zimbra_logger.

    After running the following command it started to work again.

    /opt/zimbra/logger/mysql/bin/mysqlcheck --socket=/opt/zimbra/logger/db/mysql.sock -p -uroot zimbra_logger --repair


    You can get the root mysql password for the logger using this command:
    zmlocalconfig -s | grep mysql_logger

  7. #7
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    8

    Default

    Im now not sure this was my only problem.
    After re enabling a filter in the postfix master.cf, the logs stopped working again.

    If i have:
    465 inet n - n - - smtpd
    -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
    -o content_filter=dfilt:


    the AV/AS graphs stop working.. they display, but no data.

    If i remove the -o content_filter=dfilt: it starts working again.
    "dfilt" just adds a Privacy Statement to the end of outgoing emails.

    Any ideas why it stops it working?

    Thanks.

  8. #8
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    8

    Thumbs up

    OK, I found the cause of my problem.

    Altering master.cf was a bad move. I found I can only have 1 content filter per server. When i removed the last content_filter=dfilt i noticed the zimbra config setting returned. content_filter=smtp-amavis:[127.0.0.1]:10024

    The graphs now work.

  9. #9
    Join Date
    Aug 2007
    Posts
    103
    Rep Power
    8

    Default

    I had this problem too. The error I get from the logprocess.out is
    Code:
    Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    I repair the table it it works again. For a while at least. It seems like everytime the database stops and starts that table needs to be repaired again.
    Anyone know why?
    I could start a new thread if this isnt related

Similar Threads

  1. centos 5 zimbra 4.5.6 no statistics
    By rutman286 in forum Installation
    Replies: 9
    Last Post: 08-14-2007, 10:30 AM
  2. [SOLVED] admin console disk stats graph
    By padraig in forum Administrators
    Replies: 7
    Last Post: 07-17-2007, 07:29 AM
  3. Admin console not connecting to remote server
    By f2uk in forum Administrators
    Replies: 8
    Last Post: 05-22-2007, 02:00 AM
  4. Stats don't update
    By Doug_M in forum Administrators
    Replies: 33
    Last Post: 05-05-2007, 09:17 PM
  5. Replies: 14
    Last Post: 03-06-2006, 04:27 PM

Posting Permissions

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