[SOLVED] Migrated from 32 to 64 bit - logger won't start

[blueflametuna]

After following the wiki guide for migrating from 32 to 64 bit,
logmysql.server is not running

We are getting the following when trying to connect to the logger database:

ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

Can't seem to find the missing piece. Any clues?

[phoenix]

Did you set the passwords to be the same as those on the old server?

[blueflametuna]

Yes, all 12. Including mysql_logger_root_password, which wasn't in the list.

[blueflametuna]

However, I did notice that the localconfig.xml on the new server is much smaller than the old one. Some items not included are:

[root@old conf]# grep logger localconfig.xml
<key name="logger_mysql_mycnf">
<value>${zimbra_home}/conf/my.logger.cnf</value>
<value>${zimbra_home}/logger/db/work</value>
<key name="logger_mysql_pidfile">
<value>${zimbra_home}/logger/db/mysql.pid</value>
<key name="logger_mysql_directory">
<value>${zimbra_home}/logger/mysql</value>
<key name="logger_mysql_data_directory">
<value>${zimbra_home}/logger/db/data</value>
<key name="logger_mysql_port">
<key name="logger_mysql_socket">
<value>${zimbra_home}/logger/db/mysql.sock</value>
<key name="logger_mysql_bind_address">

The file my.logger.cnf is there...

And I could find nothing in the log files, errors or otherwise.

[blueflametuna]

Uninstalled and reinstalled again. Same thing.

$ logmysql zimbra_logger
ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

I've searched but only found some older posts recommending zmloggerinit, or by changing passwords (which requires mysqld to be running, which it is not.)

It is now nearly 3 AM. Been at this all night. Any help would be most appreciated.

[blueflametuna]

I was able to get some sleep, but so far, no resolution.

Still getting:

$ logmysql zimbra_logger
ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

[blueflametuna]

Thanks Phoenix,

I searched again and found that this does work:

Issues with mysql and logmysql passwords - Zimbra :: Wiki