As the title suggests, my mysql.server is not running when start the Zimbra server. This is a production 5.0.10 server which has been running flawlessly for several months now. It is running on Ubuntu 6.06 LTS x64 with 4gb of memory.
I installed a new certificate and after running zmcontrol stop and zmcontrol start the status looked like this:
Attempting to manually start the server appears to work, but then connecting to it results in
zimbra@www:~/logger/db/data$ zmcontrol status
logmysql.server is not running
zmlogswatchctl is not running
mysql.server is not running
I have spent some hours trying everything I could find in the wikis and on the forums and have had no luck. I even reinstalled the server and ran the zmfixperms script.
zimbra@www:~/logger/db/data$ mysql mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
The error in /opt/zimbra/log/logger_mysql_error.log is
My /etc/hosts files looks like this
090105 09:42:17 mysqld started
090105 9:42:17 [ERROR] Can't start server: cannot resolve hostname!: Connection timed out
090105 09:42:17 mysqld ended
MX and A records resolve properly, I can post logs of these as well if needed.
administrator@www:/opt/zimbra/log$ cat /etc/hosts
127.0.0.1 localhost.localdomain locahost
192.168.8.15 www.xxx.com www
If any more info is needed I will be glad to provide anything to help troubleshoot this.
EDIT: Restarting the server for a fourth time has resulted in things sorting out and everything is up and running again. I have marked this solved but not sure why it is now solved. I made no system changes between this restart and the two previous failed restarts.