[SOLVED] mysql.server is not running

[fogogg]

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:

zimbra@www:~/logger/db/data$ zmcontrol status
Host www.xxx.com
        antispam                Running
        antivirus               Running
        imapproxy               Running
        ldap                    Running
        logger                  Stopped
                logmysql.server is not running
                zmlogswatchctl is not running
        mailbox                 Stopped
                mysql.server is not running
        mta                     Running
        snmp                    Running
        spell                   Running
        stats                   Stopped

Attempting to manually start the server appears to work, but then connecting to it results in

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)
zimbra@www:~/logger/db/data$

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.

The error in /opt/zimbra/log/logger_mysql_error.log is

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

My /etc/hosts files looks like this

administrator@www:/opt/zimbra/log$ cat /etc/hosts
127.0.0.1 localhost.localdomain locahost
192.168.8.15 www.xxx.com www

MX and A records resolve properly, I can post logs of these as well if needed.


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.