Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 43

Thread: Daily mail report always reports "No messages found"

  1. #21
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    Thanks for the tips...still having a challenge.

    I did the rm -rf logger/db
    zmloggerinit gave me some challenges. Perhaps you have a solution:
    ________

    ./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

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

    Default

    You'll have to manually kill the existing mysql logger daemons as well.

  3. #23
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    Whoops..got it ..thanks

  4. #24
    cstolley is offline New Member
    Join Date
    Aug 2006
    Posts
    3
    Rep Power
    9

    Default

    I'm running 4.0.3 on a mac with the logger running and my reports still contain only the two lines that this thread originially complained of.

    Furrthermore, zmlogprocess produces no errors. Does anyone know why this might be? Here's how the zmlogprocess output starts out:

    Processing mta entries from 88886
    Found 0 messages
    Deleting processed postfix logs from raw_logs...Done
    Processing clamd entries from 1439
    Found 0 entries
    Deleting processed clamd logs from raw_logs...Done
    Processing amavis entries from 0
    Found 0 entries
    Deleting processed amavis logs from raw_logs...Done
    Processing sendmail entries from 0
    Found 0 entries
    Deleting processed sendmail logs from raw_logs...Done
    Processing zimbramon entries from 88909
    Found 0 entries
    Deleting processed zimbramon logs from raw_logs...Done
    Aggregating hour mta from 2006-09-03 21:00:00 to 2006-09-03 22:00:00
    ...[snip]...
    Aggregating hour disk from 2006-11-06 21:00:00 to 2006-11-06 22:00:00
    Aggregating day disk from 2006-11-05 00:00:00 to 2006-11-06 00:00:00
    RAW: 31
    SUM: 730
    Pruning raw mta logs from 2006-10-06 00:00:00
    Pruning raw amavis logs from 2006-10-06 00:00:00
    Pruning raw disk logs from 2006-10-06 00:00:00
    Pruning summary mta logs from 2004-11-06 00:00:00
    Pruning summary amavis logs from 2004-11-06 00:00:00
    Pruning summary disk logs from 2004-11-06 00:00:00
    Pruning other raw logs from 2006-10-06 00:00:00

    Does anyone have any ideas?

    Thanks for your help!

  5. #25
    gherndon is offline Intermediate Member
    Join Date
    Sep 2006
    Posts
    18
    Rep Power
    8

    Default zmdailyreport - no messages 4.0.3 on osx server 10.4.8

    i too am having trouble with my zmdailyreport output. after initial upgrade to 4.0.3 i did not have this problem. my last good zmdailyreport was on 10/27.
    since then, i'm getting "no message" as the output of the overnite cron task.

    taking a hint from the previous post, i ran zmlogprocess. here's the output:

    libexec/zmlogprocess

    myhost maps to fqdn -- host info removed

    Processing mta entries from 7153711
    DBD::mysql::st execute failed: Can't open file: 'raw_logs.MYI' (errno: 145) at libexec/zmlogprocess line 989.
    Error executing select distinct(postfix_qid) from raw_logs where postfix_qid is not null and app like 'postfix%' and id > '7153711' with
    Can't open file: 'raw_logs.MYI' (errno: 145)
    Can't open file: 'raw_logs.MYI' (errno: 145) at libexec/zmlogprocess line 990.

    Can't call method "fetchall_arrayref" on an undefined value at libexec/zmlogprocess line 744.

    my logger process is running and i'm getting output to /opt/zimbra/log/zimbra.log and /var/log/zimbra.log

    any help is appreciated

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

    Default

    Your logger db is corrupted. you can follow the guidance in the previous messages of this post to recover.

  7. #27
    gherndon is offline Intermediate Member
    Join Date
    Sep 2006
    Posts
    18
    Rep Power
    8

    Default

    following this thread:

    Logger service issues


    the problem i was having is i wasn't detailed enough in my ps -aux search for mysql. i needed ps auxww | grep mysql to be able to kill all lingering logger db threads

    thanks brian, et al

    i will hopefully accumulate entries in the zmlogger db and then get a good report in the next day or so
    Last edited by gherndon; 11-07-2006 at 01:51 PM. Reason: resolved

  8. #28
    gherndon is offline Intermediate Member
    Join Date
    Sep 2006
    Posts
    18
    Rep Power
    8

    Default

    i'm happy to say that rebuilding the logger db worked. i was greeted this a.m. with a complete zmdailyreport

    thanks again for all the help

  9. #29
    McPringle's Avatar
    McPringle is offline Active Member
    Join Date
    Apr 2006
    Location
    Switzerland
    Posts
    46
    Rep Power
    9

    Default

    Whats the command to rebuild the logger DB?

    McPringle

  10. #30
    gherndon is offline Intermediate Member
    Join Date
    Sep 2006
    Posts
    18
    Rep Power
    8

    Default

    stop any processes...
    then rebuild the Logger DB, Directory, and info with this command:

    libexec/zmloggerinit

Page 3 of 5 FirstFirst 12345 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problems with port 25
    By yogiman in forum Installation
    Replies: 57
    Last Post: 06-13-2011, 01:55 PM
  2. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  3. fresh install down may be due to tomcat
    By gon in forum Installation
    Replies: 10
    Last Post: 07-25-2007, 08:09 AM
  4. DynDNS and Zimbra
    By afterwego in forum Installation
    Replies: 30
    Last Post: 04-01-2007, 03:34 PM
  5. receiveing mail
    By maybethistime in forum Administrators
    Replies: 15
    Last Post: 12-09-2005, 04:55 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
  •