Results 1 to 8 of 8

Thread: zmlogproccess error

  1. #1
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default zmlogprocess error

    Hello,

    sorry if this has been posted before, couldn't find any similar problems.

    The 'server status' in admin control panel shows only 'Server status data is not available. To see the server status, logger service must be installed'

    zimbra@mail:~/libexec$ zmcontrol status
    Host mail.izvedba.si
    antispam Running
    antivirus Running
    imapproxy Running
    ldap Running
    logger Running
    mailbox Running
    mta Running
    snmp Running
    spell Running
    zimbra@mail:~/libexec$
    The "zmlogproccess" command, as suggested in another similar thread produces logs but fails on this error:
    DBD::mysql::st execute failed: Column 'host' cannot be null at ./zmlogprocess line 1020.
    Error executing insert into amavis_aggregate (period_start, period_end, host, period, msg_count, spam_count, virus_count) values (?,?,?,?,?,?,?) with 2007-02-21 07:00:00 2007-02-21 08:00:00 hour 2 0 0
    Column 'host' cannot be null
    Column 'host' cannot be null at ./zmlogprocess line 1021.
    Same for table 'mta_aggregate'.


    Using OCS zimbra 4.5.2 on Ubuntu Dapper.

    Thanks for quick response and support, being very professional as always.

    regards
    primski
    Last edited by preem; 02-26-2007 at 04:12 AM.

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

    Default

    Hi-
    Sorry it took so long.

    Can you please file a bug in our bugzilla so that our devs can look at it?
    Thanks
    john

  3. #3
    brian is offline Project Contributor
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    this is already fixed and should be in the next release.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  4. #4
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default

    Great, thanks very much.

    I forgot to mention though, this problem has been going on more that just with the 4.5.2 release, i've had it for a few months now, since 4.5. BETA. Has this been taken into consideration?

  5. #5
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default

    Hello, the problem about 'host' column beeing null went away, great job on fixing that bug.

    However, i still have a lot of problems getting logger to work. Now, its giving me the wrong password error:

    zimbra@mail:~$ ./zmlogprocess
    DBI connect('database=zimbra_logger;mysql_read_default _file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock','zimbra',...) failed: Access denied for user 'zimbra'@'localhost' (using password: YES) at ./zmlogprocess line 64
    DB: Can't connect to dbi:mysql:database=zimbra_logger;mysql_read_defaul t_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock: Access denied for user 'zimbra'@'localhost' (using password: YES)
    I followed the wiki instructions how to change the root and zimbra passwords for the logger database. I changed the root password without any problems, but the zmmylogpasswd utility for changing user zimbra's pass gives same error:
    >zmmylogpasswd newpasswd

    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    **** PASSWORD CHANGE FAILED
    I tried rebuilding logger database with zmloggerinit util but exits with same error.

    Any ideas greaty appreciated.

    greetz,
    primski

  6. #6
    brian is offline Project Contributor
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    You can following the steps in this post to reset your logger data.

    Daily mail report always reports "No messages found"

    Basic process is, stop logger, remove the db files and rerun zmloggerinit.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  7. #7
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default

    Code:
    % su - zimbra
    % rm -rf logger/db
    % zmloggerinit
    great, that did the trick. I didn't dare to manually remove the db folder my self

    The logger service is started again and runs without problems. The graphs showed up in the admin GUI, but still no server status data. Eh i guess its not vital for operations but would still be nice too see it there.

  8. #8
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default

    Hm,

    i was able to find out, that the 'service_status' table in the logger database doesn't get populated.

    I tried manually adding a few lines in there, just to see if it will show up in the admin GUI and it did.

    zmlogprocess script produces no errors, i tried even putting a simple
    Code:
    print "populating database now";
    just under the 'insert into service_status' statement. Didn't even show up, so my guess would be the one of the 'if' statements doesn't return true and it doesn't even come to begin populating db.

    Since i don't know Jack Schitt about perl i'm not sure what to do next.

    Any thoughts anyone?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM
  4. Replies: 14
    Last Post: 12-22-2005, 04:59 PM
  5. Building native libraries on MacOS X
    By ajmas in forum Developers
    Replies: 3
    Last Post: 10-14-2005, 11:00 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
  •