I have the same situation as above, there is not user or table called zimbra_logger. I tried to follow the steps in this thread below 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_logger MySQL schema not installed Code:
[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]$
Code:
[zimbra@mail root]$ zmcontrol -v
Release 4.5.11_GA_1751.RHEL5_20080128142638 CentOS5 FOSS edition
[zimbra@mail root]$
Bugzilla
Wiki
Source
zimbra_logger MySQL schema not installed 
Linear Mode
