Results 1 to 9 of 9

Thread: av/ spam graph stopped in admin console

  1. #1
    padraig's Avatar
    padraig is offline Elite Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

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

  3. #3
    padraig's Avatar
    padraig is offline Elite Member
    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:
    logger stopped by itself)
    and all other graphs are fine apart from the as/av which seems to be updating with blank data?

  4. #4
    styelz is offline Junior Member
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    7

    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

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

  6. #6
    styelz is offline Junior Member
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    7

    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
    styelz is offline Junior Member
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    7

    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
    styelz is offline Junior Member
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    7

    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
    mcesari is offline Special Member
    Join Date
    Aug 2007
    Posts
    103
    Rep Power
    7

    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

Thread Information

Users Browsing this Thread

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

Similar Threads

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