Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: spam graph

  1. #1
    padraig's Avatar
    padraig is offline Elite Member
    Join Date
    Jul 2006
    Location
    ireland
    Posts
    388
    Rep Power
    9

    Unhappy spam graph

    hi all,

    my admin console spam graph is blank.
    it has data for feb 07, but the i updated my Spam checking Settings to:
    Kill percent: 66
    Tag percent: 20

    (defaults are 75/33)
    not sure if this upset the graph any suggestions would be appreciated e.g.
    Attached Images Attached Images
    Last edited by padraig; 05-31-2007 at 02:17 AM. Reason: defaults are 75/33

  2. #2
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    What version of ZCS are you using? Is your logger running? Have you had to reinit it, or reinstall?

    There is a known bug: http://bugzilla.zimbra.com/show_bug.cgi?id=14809
    Which was recently reopened.

    john

  3. #3
    scalper is offline Partner (VAR/HSP)
    Join Date
    Jul 2006
    Location
    KL, Malaysia
    Posts
    123
    Rep Power
    9

    Default

    I have encountered this before..

    My loggerdb went corrupt of somewhat reasons..

    What's the output of zmlogprocess and zmgengraphs commands? any errors in /tmp/logprocess.out and /tmp/logswatch.out

    I have trouble running zmlogprocess.. it claimed my db got errors

    So, if the db is the problem.. you just reinit the db back again..

    % su - zimbra
    % rm -rf logger/db
    % zmloggerinit

    Hope that helps.
    Last edited by scalper; 04-23-2007 at 11:52 PM. Reason: add stuff

  4. #4
    padraig's Avatar
    padraig is offline Elite Member
    Join Date
    Jul 2006
    Location
    ireland
    Posts
    388
    Rep Power
    9

    Default did vmware test

    What version of ZCS are you using? 4.5.1
    Is your logger running? yes
    Have you had to reinit it, or reinstall? no

    As a test did a full reinstall of 4.5.1 on a vmware system changed spam settings same result

  5. #5
    padraig's Avatar
    padraig is offline Elite Member
    Join Date
    Jul 2006
    Location
    ireland
    Posts
    388
    Rep Power
    9

    Default

    Quote Originally Posted by scalper View Post
    I have encountered this before..
    My loggerdb went corrupt of somewhat reasons..
    What's the output of zmlogprocess and zmgengraphs commands? any errors in /tmp/logprocess.out and /tmp/logswatch.out
    I have trouble running zmlogprocess.. it claimed my db got errors
    So, if the db is the problem.. you just reinit the db back again..
    % su - zimbra
    % rm -rf logger/db
    % zmloggerinit
    Hope that helps.
    thanks for the reply,
    no errors in /tmp/logprocess.out
    /tmp/logswatch.out contains
    Code:
    *** logswatch version 3.1.1 (pid:4218) started at Wed Apr 18 13:24:03 IST 2007
    Caught a SIGHUP -- sending a TERM signal to 4309
    *** logswatch version 3.1.1 (pid:4218) started at Thu Apr 19 04:03:19 IST 2007
    Caught a SIGHUP -- sending a TERM signal to 16583
    *** logswatch version 3.1.1 (pid:4218) started at Fri Apr 20 04:03:20 IST 2007
    Caught a SIGHUP -- sending a TERM signal to 917
    *** logswatch version 3.1.1 (pid:4218) started at Sat Apr 21 04:03:12 IST 2007
    Caught a SIGHUP -- sending a TERM signal to 27380
    *** logswatch version 3.1.1 (pid:4218) started at Sun Apr 22 04:03:12 IST 2007
    Caught a SIGHUP -- sending a TERM signal to 4643
    *** logswatch version 3.1.1 (pid:4218) started at Mon Apr 23 04:02:46 IST 2007
    will try the zmloggerinit on a vmware test server
    is it possible to init just the spam graph

    thanks again.
    p.

  6. #6
    Cryophallion is offline Senior Member
    Join Date
    Mar 2007
    Location
    New England
    Posts
    55
    Rep Power
    8

    Default

    So, I am trying to run the commands here... and bash won't seem to let me.

    It is giving me the errors:

    -bash: zmloggerinit :command not found
    Even if I am in the right directory, and can see the command file, I still can't run it. Any ideas?

  7. #7
    Cryophallion is offline Senior Member
    Join Date
    Mar 2007
    Location
    New England
    Posts
    55
    Rep Power
    8

    Default

    Quote Originally Posted by Cryophallion View Post
    So, I am trying to run the commands here... and bash won't seem to let me.

    It is giving me the errors:

    -bash: zmloggerinit :command not found
    Even if I am in the right directory, and can see the command file, I still can't run it. Any ideas?
    So, I am an idiot. ./zmloggerinit did the trick.

    However, I am getting errors running this:


    * Creating required directories
    * Creating database in /opt/zimbra/logger/db/data
    * Starting logger_mysql server
    * Loading schema /opt/zimbra/db/loggerdb.sql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    * Setting random password for mysql root user in zimbra local config
    * Setting random password for mysql zimbra user in zimbra local config
    * Changing mysql root user password
    /opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    * Changing mysql zimbra user password
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    **** PASSWORD CHANGE FAILED

    I have run this as root and as zimbra. Is there a different way I should be doing this?

    Thanks

  8. #8
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,583
    Rep Power
    57

    Default

    Quote Originally Posted by Cryophallion View Post
    I have run this as root and as zimbra. Is there a different way I should be doing this?

    Thanks
    A quick search would have found this thread.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  9. #9
    kplau is offline Junior Member
    Join Date
    Apr 2007
    Posts
    6
    Rep Power
    8

    Default

    I used to have errors just like the first post of this thread.

    Followed everything to the letter. Executed those commands as zimbra user, found zmloggerinit under libexec.. ran that. Before that I cleaned up all traces of hanged zimbra.. restarted the entire thing, graphs are generated but there's like zero data.. its like its not receiving any information at all? (and oh server status does not properly show unless i restarted everything..heh)

    logprocess files and all looks fine.. no errors. Any ideas where I ought to start looking ?

    edit : and oh yeah zmcontrol status shows everything as running. running latest zcs
    Last edited by kplau; 05-02-2007 at 08:59 PM. Reason: forgot to add a few things

  10. #10
    Cryophallion is offline Senior Member
    Join Date
    Mar 2007
    Location
    New England
    Posts
    55
    Rep Power
    8

    Default

    I did search, just obviously not for the right terms.

    So, the problems continue. I tried several options:

    zimbra@mail:~$ zmcontrol status
    Host mail.majortheatre.com
    antispam Running
    antivirus Running
    ldap Running
    logger Stopped
    logmysql.server is not running
    zmlogswatchctl is not running
    mailbox Running
    mta Running
    snmp Running
    spell Running
    zimbra@mail:~$ zmlogswatchctl start
    zimbra@mail:~$ logmysql.server start
    /opt/zimbra/bin/logmysql.server: line 89: syntax error: unexpected end of file
    zimbra@mail:~$ cd libexec
    zimbra@mail:~/libexec$ ./zmloggerinit
    * Creating required directories
    * Creating database in /opt/zimbra/logger/db/data
    * Starting logger_mysql server
    * Loading schema /opt/zimbra/db/loggerdb.sql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    * Setting random password for mysql root user in zimbra local config
    * Setting random password for mysql zimbra user in zimbra local config
    * Changing mysql root user password
    /opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!
    * Changing mysql zimbra user password
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    **** PASSWORD CHANGE FAILED
    zimbra@mail:~/libexec$

    However, mysql.sock does exist.
    I saw in another thread here that I should delete the mysql.sock file.

    So I tried:
    zimbra@mail:~/libexec$ cd /opt/zimbra/logger/db/
    zimbra@mail:~/logger/db$ locate mysql.sock
    /opt/zimbra/db/mysql.sock
    /backup/opt/zimbra/db/mysql.sock
    /backup/opt/zimbra/logger/db/mysql.sock
    zimbra@mail:~/logger/db$ rm mysql.sock
    rm: cannot lstat `mysql.sock': No such file or directory

    So, it thinks it exists, but it doesn't. How do I create a new one?


    Mysql in general works, as the mailbox is still working.

    Edit: I forgot to mention I tried changing the password also, but that would fail too. Let me know if you would like me to post that session also.
    Last edited by Cryophallion; 05-03-2007 at 05:24 AM. Reason: added info

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to understand Zimbra's anti-spam system
    By TaskMaster in forum Users
    Replies: 11
    Last Post: 01-25-2008, 09:59 AM
  2. av/ spam graph stopped in admin console
    By padraig in forum Administrators
    Replies: 8
    Last Post: 12-04-2007, 06:48 AM
  3. centos 5 zimbra 4.5.6 no statistics
    By rutman286 in forum Installation
    Replies: 9
    Last Post: 08-14-2007, 09:30 AM
  4. Stats don't update
    By Doug_M in forum Administrators
    Replies: 33
    Last Post: 05-05-2007, 08:17 PM
  5. Training spam and ham
    By Justin in forum Developers
    Replies: 2
    Last Post: 10-31-2006, 03:39 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
  •