Recently my zimbra server machine  was restarted and there i found that zimbra mysql didn’t start its shows failed running mysql in zimbra.

Tried zmcontrol stop and start – didn’t change

Checked logfile and saw:
[zimbra@mail log]$ more mysqld.log
061227 11:17:19 mysqld started
061227 11:17:20 [ERROR] Can’t start server: cannot resolve hostname!: Success
061227 11:17:20 mysqld ended
Checked /opt/zimbra/conf/my.cnf file – saw


basedir = /opt/zimbra/mysql
datadir = /opt/zimbra/db/data
socket = /opt/zimbra/db/mysql.sock
pid-file = /opt/zimbra/db/mysql.pid
bind-address = localhost
port = 7306
user = zmbra

But localhost wasn’t listed in /etc/hosts – must have been removed prior.

Added this to /etc/hosts: localhost.localdomain localhost mail.sathish.com mail # this was already there

$zmcontrol stop
$zmcontrol start

Now Everything is comes under my control…