Daily mail report always reports "No messages found"

[mcevoys]

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

[brian]

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

[mcevoys]

Whoops..got it ..thanks

[cstolley]

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!

[gherndon]

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

[brian]

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

[gherndon]

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

[gherndon]

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

[McPringle]

Whats the command to rebuild the logger DB?

McPringle

[gherndon]

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

libexec/zmloggerinit