View Single Post
  #5 (permalink)  
Old 01-31-2009, 11:09 PM
maumar maumar is offline
Elite Member
 
Posts: 286
Default

Quote:
Originally Posted by jholder View Post
Hey maumar,
We've determined that this issue is likely unique to you. The logger db schema has been at version 5 for quite a while. We're not sure how yours got to zero. Have you been having issues with the logger?

in any case, please reinitialize your logger by running:
Code:
su - zimbra
rm -rf /opt/zimbra/logger/db/*
cd /opt/zimbra/libexec
./zmloggerinit
Then rerun the upgrade.
i am getting the same issu, now, migrating from 5.0.11 to 5.0.12; issuing what you suggested i get:
Code:
[07:21:15 zimbra@zimbra ~/logger/db ]$ rm -rf *
[07:21:22 zimbra@zimbra ~/logger/db ]$ ls -la
total 8
drwxr-xr-x 2 zimbra zimbra 4096 Feb  1 07:21 .
drwxrwxr-x 4 zimbra zimbra 4096 Feb  1 03:32 ..
[07:21:25 zimbra@zimbra ~/logger/db ]$ cd /opt/zimbra/libexec
[07:21:39 zimbra@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 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
* 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: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!
* Changing mysql zimbra user password
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
**** PASSWORD CHANGE FAILED
what you suggest?
Reply With Quote