Hi, I ran into some errors this morning when running this procedure and I am hoping you can help me with them. The Zimbra mail is running, it looks like the logger never came back.
Here is what I did and the errors I was encountering:
When I ran the ./zmloggerinit command I received the following output.
paul@mydomain.com:/opt/zimbra/libexec$ sudo ./zmloggerinit
* 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 continued with the rest of the steps in the script.
After restarting Zimbra I got these messages
zmcontrol start
Host mydomain.com.
Starting ldap...Done.
Starting logger...Done.
Starting mailbox...Done.
Starting antispam...Done.
Starting antivirus...FAILED
Starting zmmtaconfig...zmmtaconfig is already running.
Starting amavisd...amavisd is already running.
Starting clamd...failed.
Starting snmp...Done.
Starting spell...Done.
Starting mta...Done.
Starting stats...Done.
I stopped Zimbra and started it again to the same set of errors.
I stopped Zimbra and rebooted my server hoping that would clean things up.
That fixed the clamd failed
When I ran a zmcontrol status I got this.
zmcontrol status
Host mydomain.com.
antispam Running
antivirus Stopped
zmclamdctl is not running
ldap Running
logger Stopped
logmysql.server is not running
zmlogswatchctl is not running
mailbox Running
mta Running
snmp Running
spell Running
stats Running
I logged into the admin console and received this error message box:
Zimbra Administration
Server error encountered.
And in the server status screen this error was showing:
Server status data is not available. To see the server status, logger service must be installed.
I checked around and mail did seam to be working.
I went back to the unix level and thinking that the logger did not start I ran the following command
logmysql.server start
and I got this response.
mysqld_safe already running with pid 6455
I looked to see what this was and got this:
paul@mydomain.com:~$ ps -ef | grep mysqld_safe
zimbra 6343 1 0 06:18 ? 00:00:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --external-locking --log-error=/opt/zimbra/log/logger_mysql_error.log --ledir=/opt/zimbra/logger/mysql/libexec
zimbra 6486 1 0 06:18 ? 00:00:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --external-locking --log-error=/opt/zimbra/log/mysql_error.log --ledir=/opt/zimbra/mysql/libexec
paul 29699 28959 0 06:48 pts/1 00:00:00 grep mysqld_safe
Since the mail appears to be running I decided that I didn’t want to go any further without checking with some experts. Any thoughts on how to proceed?