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
[mysqld]
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:
127.0.0.1 localhost.localdomain localhost
192.168.31.1 mail.sathish.com mail # this was already there
$zmcontrol stop
$zmcontrol start
Now Everything is comes under my control…