zimbra_logger MySQL schema not installed

[tfpk3]

I have been attempting to do a fresh install of zcs-4.0.5_GA_518.FC4 on a clean install of FC 4 guested on a VMware ESX virtual machine. The install seemed to go well with no critical error messages and I was able to login to the web admin interface. However, when I do login I get a message that logger was not installed so no monitoring was being done. According to the install logs, logger was installed, but using the command-line tools (zmloggerctl or zmlogswatchctl) also shows that logger wasn't available. The logs show that zimbra_logger was not able to log into the MySQL database.

After exploring the forums, I found the threads about passwords not being in sync. After unsuccessfully trying zmmylogpasswd, I restarted the logger instance of MySQL without the grant permissions (i.e., --skip-grant-tables flag) and logged into that instance only to find no "zimbra_logger" database established and no "zimbra_logger" user in the mysql user table. It looked like a fresh MySQL install with only the "mysql" and "test" databases.

Everything else in the install looks okay. Is there a mysql schema file around that I could use to establish the database and tables? Something else I should do (other than install again, which I've done three times now).

Thanks

[phoenix]

Welcome to the forums.

You need zmloggerinit, do a search of the forums for details of the resolution.

[tfpk3]

Bill -

Thanks for the pointer. However, zmloggerinit failed to properly set up the database stuff. What it did do, however, was let me see where the schema files were kept so that I could successfully do a manual install of the database and, after a bit of password adjusting, got things running acceptably.

Thanks again - Tom K.

[phoenix]

Glad you've got it working. Happy New Year.

[newmember]

I have the same situation as above, there is not user or table called zimbra_logger. I tried to follow the steps above but I do not know how to fix the permission to complete the user and table install.
Here is my error when I run zmloggerinit.
How do set up permissions to make zmloggerinit successful?

[zimbra@mail root]$ /opt/zimbra/libexec/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
[zimbra@mail root]$

[zimbra@mail root]$ zmcontrol -v


Release 4.5.11_GA_1751.RHEL5_20080128142638 CentOS5 FOSS edition

[zimbra@mail root]$