Daily mail report always reports "No messages found"

[padraig]

using zcs 4.5.1_NE RHEL_64 i get this each morning:

/etc/cron.daily/prelink: line 47: 1951 Aborted
/usr/sbin/prelink -av $PRELINK_OPTS >>/var/log/prelink.log 2>&1

the av/as graph is blank could this be the cause

[phoenix]

Originally Posted by padraig

the av/as graph is blank could this be the cause

No, that's not the cause. The prelink is just a job to prelink modules for faster loading. Have you looked at some of the threads about debugging the av/as graphs? Has it always been blank or has it just happened?

[padraig]

Hi Bill,

it has data for feb 07, but the i updated my Spam checking Settings to:
Kill percent: 66
Tag percent: 20

not sure if this upset the graph

is it possible to zmloggerinit the spam graph only?
/tmp/ out files look ok

[Franck]

I found that to repair bad mysql tables:

su -zimbra 
zmloggerctl stop
su - root
cd /opt/zimbra/logger/db/data/zimbra_logger
../../../mysql/bin/myisamchk -r *.MYI
su - zimbra
zmloggerctl start

[dljordaneku]

Originally Posted by gherndon

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

libexec/zmloggerinit

When I ran this it told me that the passwords for the sql were incorrect and now my mysql won't start back. HELP

dj

[dljordaneku]

Here is the output when I ran the libexec/loggerinit

* 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

[dljordaneku]

Also, another quick question. The only service not running is the logger. Is it bad to run without it until I can get it fixed?

dj

[dljordaneku]

Ok. I just want to say first that Zimbra employees rock. Mike answered a question for me, I will just say outside the forum Which helps me for now but I still need to get the logger running. Is there something I need to do to get the passwords in sync? Will upgrading to latest version fix this?

dj

[mmorse]

For the collective knowledge:
Q: Can I run without logger?
A: Yes, but you should actually disable it & not leave it in a broken state.

To fix, the commands I had him run were:
su - zimbra
logmysql.server stop
exit/su - root/sudo -i (switch back to root however)
ps aux | grep logger (kill -9 any remaining)

Note:
-The below will remove all currently recorded data.
-Make sure you use the word 'logger' where given below, else you'll wipe your data db if you use the wrong path!

rm -rf /opt/zimbra/logger/db/data/*
chown zimbra:zimbra /opt/zimbra/logger/db/data
chmod 775 /opt/zimbra/logger/db/data
su - zimbra
cd /opt/zimbra/libexec
./zmloggerinit
logmysql.server start (or zmcontrol stop/start)
cd /opt/zimbra/libexec
./zmgengraphs
(And ./zmdailyreport as wanted, but it will proably be empty the first time.)

Originally Posted by dljordaneku

Just wanted to let you know that I got a good daily report this morning. Thanks.

[dljordaneku]

Just wanted to say thanks again to Mike for helping me out.

dj