mysql.server is not running

[M.K.Z.R]

Hi,

I re-installed zimbra. But it seems that this time mysql.server is not working.

[zimbra@zimbra root]$ zmcontrol start
Host xxxx.xxxx.xx
Starting logger...Done.
Starting mailbox...Done.
Starting memcached...Done.
Starting imapproxy...Done.
Starting antispam...Done.
Starting antivirus...Done.
Starting snmp...Done.
Starting spell...Done.
Starting mta...Done.
Starting stats...Done.

[zimbra@zimbra root]$ zmcontrol status
Host zimbra.amnesty.nl
antispam Running
antivirus Running
imapproxy Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running.
memcached Running
mta Running
snmp Running
spell Running
stats Stopped

[zimbra@zimbra root]$ mysql.server start
Starting mysqld...done.

[zimbra@zimbra root]$ mysql.server status
mysql is not running

[zimbra@zimbra root]$ mysql mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

[zimbra@zimbra root]$ zmmysqlstatus
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
Error while running 'mysql --user=zimbra --password=zimbra --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 248.

How can I fix this problem?

[uxbod]

Why did you re-install when you had it working ? How did you clean up the old install ?

[M.K.Z.R]

Originally Posted by uxbod

Why did you re-install when you had it working ? How did you clean up the old install ?

I re-installed my whole linux machine first i removed zimbra with the command sh install.sh -u and: rm -rf zimbraserver

[uxbod]

cat /etc/hosts
cat /etc/resolv.conf
dig yourdomain mx
dig yourdomain any
host `hostname` <- note backticks and not single quotes

Did you also disable SELinux and IPTables ?

[dalmate]

can you ping localhost or 127.0.0.1?
If you can't ping that, mysql can't start

[M.K.Z.R]

# Do not remove the following line, or various programs
# that require network functionality will fail.
XXX.XXX.X.X XXXX.XXXX.com XXXX
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6


nameserver XX.XX.XX.XX
nameserver XX.XX.XX.XX


[zimbra@zimbra root]$ dig yourdomain mx

; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain mx
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 31279
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

;; QUESTION SECTION:
;yourdomain. IN MX

;; AUTHORITY SECTION:
. 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

;; Query time: 34 msec
;; SERVER: XX.XX.XX.XX#53(XX.XX.XX.XX)
;; WHEN: Fri Mar 26 09:53:10 2010
;; MSG SIZE rcvd: 103

[zimbra@zimbra root]$ dig yourdomain any

; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain any
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 61384
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

;; QUESTION SECTION:
;yourdomain. IN ANY

;; AUTHORITY SECTION:
. 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

;; Query time: 35 msec
;; SERVER: XX.XX.XX.XX#53(XX.XX.XX.XX)
;; WHEN: Fri Mar 26 09:53:25 2010
;; MSG SIZE rcvd: 103


[zimbra@zimbra root]$ 'hostname'
XXX.XXX.com

[uxbod]

Well that tells us nothing as you have removed all the necessary detail; plus you need to execute

host `hostname`

and not just

`hostname`

[M.K.Z.R]

# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.8.6 zimbra.xxxx.com zimbra
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6


nameserver 194.109.6.66
nameserver 194.109.9.99


[zimbra@zimbra root]$ dig yourdomain mx

; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain mx
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 31279
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

;; QUESTION SECTION:
;yourdomain. IN MX

;; AUTHORITY SECTION:
. 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

;; Query time: 34 msec
;; SERVER: 194.109.6.66#53(194.109.6.66)
;; WHEN: Fri Mar 26 09:53:10 2010
;; MSG SIZE rcvd: 103

[zimbra@zimbra root]$ dig yourdomain any

; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain any
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 61384
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

;; QUESTION SECTION:
;yourdomain. IN ANY

;; AUTHORITY SECTION:
. 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

;; Query time: 35 msec
;; SERVER: 194.109.6.66#53(194.109.6.66)
;; WHEN: Fri Mar 26 09:53:25 2010
;; MSG SIZE rcvd: 103

[zimbra@zimbra root]$ host 'hostname'
Host hostname not found: 3(NXDOMAIN)

[M.K.Z.R]

[zimbra@zimbra root]$ host `hostname`
zimbra.xxxx.com has address 194.109.106.6

[uxbod]

Your DNS A record for the Zimbra server does not match /etc/hosts.