zmloggerinit permissions

[rernst]

Hi,

I was running a successful zimbra install (and continue to do so). At some point (and unnecessarily so as it later turned out) I did an upgrade install. Unfortunately this destroyed my customized spam settings (I had razor and pyzor activated and essentially made most of the changes outlined in the improved zimbra filtering wiki, reducing my spam 99%). (Maybe in a future release an upgrade can leave the spam configuration files alone?)

However, the zimbra logger (statistics) broke somewhere along the way. So I am trying to run zmloggerinit again to recreate user, tables, etc.

I am receiving the following messages:

* 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 found the wiki about resetting the various zimbra mysql passwords but am quite confused what they should be set to.

How to I reinitialize this from scratch?

[phoenix]

Try the instructions in this post.