mysql not starting, sort of.

**lhutton** · 06-17-2009, 11:15 AM

I've got an odd problem with the mysql, according to zmcontrol status it's not running (neither is mailboxd but I assume that's because it depends on mysql). But when I try to run mysql.server start is says mysqld is running is safe mode. I also have this in the mysql error logs:

Code:

090616 17:35:43  mysqld started
090616 17:35:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090616 17:35:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090616 17:35:46  InnoDB: Started; log sequence number 0 43655
090616 17:35:46 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.67-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution

I'm running on CentOS 5.3

Thanks!

**phoenix** · 06-18-2009, 12:08 AM

What happens if you shutdown zimbra with:

Code:

zmcontrol stop

then kill any remaining zimbra porocesses and then restart zimbra? Are there any errors in the log files?

**lhutton** · 06-18-2009, 01:11 PM

Here are my /var/log/zimbra.log and /opt/zimbra/log, with some errors.

/var/log/zimbra.log

Code:

Jun 18 04:02:44 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gacf ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:45 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy URLs update. 
Jun 18 04:02:45 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:47 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy Backends update. 
Jun 18 04:02:47 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyBackends ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:49 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Memcached Servers update. 
Jun 18 04:02:49 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMemcachedServers ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:51 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All MTA Authentication Target URLs update. 
Jun 18 04:02:51 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMtaAuthURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:52 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Configuration for server webhost1.buttonhost.net update. 
Jun 18 04:02:52 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gs:webhost1.buttonhost.net ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:52 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Sleeping...Key lookup failed. 
Jun 18 04:02:59 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Global system configuration update. 
Jun 18 04:02:59 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gacf ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:02:59 webhost1 sendmail[32583]: n5I82gGn032583: from=root, size=549, class=0, nrcpts=1, msgid=<200906180802.n5I82gGn032583@webhost1.buttonhost.net>, relay=root@localhost
Jun 18 04:02:59 webhost1 sendmail[32583]: n5I82gGn032583: to=root, ctladdr=root (0/0), delay=00:00:17, xdelay=00:00:00, mailer=relay, pri=30549, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: Connection refused by [127.0.0.1]
Jun 18 04:03:00 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy URLs update. 
Jun 18 04:03:00 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:02 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy Backends update. 
Jun 18 04:03:02 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyBackends ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:03 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Memcached Servers update. 
Jun 18 04:03:03 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMemcachedServers ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:05 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All MTA Authentication Target URLs update. 
Jun 18 04:03:05 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMtaAuthURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:07 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Configuration for server webhost1.buttonhost.net update. 
Jun 18 04:03:07 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gs:webhost1.buttonhost.net ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:07 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Sleeping...Key lookup failed. 
Jun 18 04:03:14 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Global system configuration update. 
Jun 18 04:03:14 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gacf ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:15 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy URLs update. 
Jun 18 04:03:15 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:18 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy Backends update. 
Jun 18 04:03:18 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyBackends ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:20 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Memcached Servers update. 
Jun 18 04:03:20 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMemcachedServers ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:21 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All MTA Authentication Target URLs update. 
Jun 18 04:03:21 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMtaAuthURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:23 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Configuration for server webhost1.buttonhost.net update. 
Jun 18 04:03:23 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gs:webhost1.buttonhost.net ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:23 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Sleeping...Key lookup failed. 
Jun 18 04:03:30 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Global system configuration update. 
Jun 18 04:03:30 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gacf ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:31 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy URLs update. 
Jun 18 04:03:31 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:33 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy Backends update. 
Jun 18 04:03:33 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyBackends ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:35 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Memcached Servers update. 
Jun 18 04:03:35 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMemcachedServers ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:36 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All MTA Authentication Target URLs update. 
Jun 18 04:03:36 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMtaAuthURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:38 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Configuration for server webhost1.buttonhost.net update. 
Jun 18 04:03:38 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gs:webhost1.buttonhost.net ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:38 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Sleeping...Key lookup failed. 
Jun 18 04:03:45 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Global system configuration update. 
Jun 18 04:03:45 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gacf ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:46 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy URLs update. 
Jun 18 04:03:46 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:48 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy Backends update. 
Jun 18 04:03:48 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyBackends ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:50 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Memcached Servers update. 
Jun 18 04:03:50 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMemcachedServers ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:51 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All MTA Authentication Target URLs update. 
Jun 18 04:03:51 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllMtaAuthURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:53 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Configuration for server webhost1.buttonhost.net update. 
Jun 18 04:03:53 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gs:webhost1.buttonhost.net ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:03:53 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Sleeping...Key lookup failed. 
Jun 18 04:04:00 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping Global system configuration update. 
Jun 18 04:04:00 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: gacf ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:04:01 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy URLs update. 
Jun 18 04:04:01 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyURLs ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:04:02 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping All Reverse Proxy Backends update. 
Jun 18 04:04:02 webhost1 zimbramon[32574]: 32574:info: zmmtaconfig: Skipping getAllReverseProxyBackends ERROR: service.FAILURE (system failure: ZimbraLdapContext) (cause: javax.naming.CommunicationException webhost1.buttonhost.net:389)  
Jun 18 04:04:03 webhost1 zmmailboxdmgr[1574]: status requested

/opt/zimbra/log/spamtrain.log

Code:

20090610230002 Starting spam/ham extraction from system accounts.
Exception in thread "main" com.zimbra.common.service.ServiceException: system failure: admin auth failed url=https://webhost1.buttonhost.net:7071/service/admin/soap/
ExceptionId:main:1244689205816:9262a23cd813a1fa
Code:service.FAILURE
	at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253)
	at com.zimbra.cs.util.SpamExtract.getAdminAuthToken(SpamExtract.java:434)
	at com.zimbra.cs.util.SpamExtract.main(SpamExtract.java:187)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
	at java.net.Socket.connect(Socket.java:520)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:545)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.(SSLSocketImpl.java:389)
	at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:121)
	at com.zimbra.common.util.EasySSLProtocolSocketFactory.createSocket(EasySSLProtocolSocketFactory.java:124)
	at com.zimbra.common.util.EasySSLProtocolSocketFactory.createSocket(EasySSLProtocolSocketFactory.java:165)
	at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
	at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
	at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
	at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
	at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
	at com.zimbra.common.soap.SoapHttpTransport.invoke(SoapHttpTransport.java:258)
	at com.zimbra.common.soap.SoapHttpTransport.invoke(SoapHttpTransport.java:226)
	at com.zimbra.common.soap.SoapTransport.invoke(SoapTransport.java:315)
	at com.zimbra.common.soap.SoapTransport.invokeWithoutSession(SoapTransport.java:302)
	at com.zimbra.cs.util.SpamExtract.getAdminAuthToken(SpamExtract.java:429)
	... 1 more
Exception in thread "main" com.zimbra.common.service.ServiceException: system failure: admin auth failed url=https://webhost1.buttonhost.net:7071/service/admin/soap/
ExceptionId:main:1244689209052:0ad91da3de007150
Code:service.FAILURE
	at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253)
	at com.zimbra.cs.util.SpamExtract.getAdminAuthToken(SpamExtract.java:434)
	at com.zimbra.cs.util.SpamExtract.main(SpamExtract.java:187)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
	at java.net.Socket.connect(Socket.java:520)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:545)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.(SSLSocketImpl.java:389)
	at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:121)
	at com.zimbra.common.util.EasySSLProtocolSocketFactory.createSocket(EasySSLProtocolSocketFactory.java:124)
	at com.zimbra.common.util.EasySSLProtocolSocketFactory.createSocket(EasySSLProtocolSocketFactory.java:165)
	at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
	at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
	at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
	at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
	at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
	at com.zimbra.common.soap.SoapHttpTransport.invoke(SoapHttpTransport.java:258)
	at com.zimbra.common.soap.SoapHttpTransport.invoke(SoapHttpTransport.java:226)
	at com.zimbra.common.soap.SoapTransport.invoke(SoapTransport.java:315)
	at com.zimbra.common.soap.SoapTransport.invokeWithoutSession(SoapTransport.java:302)
	at com.zimbra.cs.util.SpamExtract.getAdminAuthToken(SpamExtract.java:429)
	... 1 more
20090610230009 Finished extracting spam/ham from system accounts.
20090610230009 Starting spamassassin training.
netset: cannot include 127.0.0.0/8 as it has already been included
Learned tokens from 0 message(s) (0 message(s) examined)
netset: cannot include 127.0.0.0/8 as it has already been included
Learned tokens from 0 message(s) (0 message(s) examined)
netset: cannot include 127.0.0.0/8 as it has already been included
bayes: synced databases from journal in 0 seconds: 16 unique entries (269 total entries)
20090610230016 Finished spamassassin training.
20090610234502 Starting spam/ham cleanup

**phoenix** · 06-18-2009, 11:22 PM

Is this a new install or an upgrade? Have you disabled SElinux and the firewall on your CentOS server? Please post the output of the following commands (run on your zimbra server):

Code:

cat /etc/hosts
cat /etc/resolv.conf
dig yourdomain.com any
dig yourdomain.com mx
host `hostname`  <-- type that exact command and use backticks not single quotes

**lhutton** · 06-19-2009, 09:01 AM

/etc/hosts:

Code:

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1		localhost.localdomain localhost
::1		localhost6.localdomain6 localhost6
74.81.191.68		webhost1.buttonhost.net webhost1

/etc/resolv.conf

Code:

search buttonhost.net
nameserver 208.67.222.222
nameserver 208.67.220.220

dig butthost.net any

Code:

; <<>> DiG 9.3.4-P1 <<>> buttonhost.net any
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 42561
;; flags: qr rd ra; QUERY: 1, ANSWER: 3, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;buttonhost.net.			IN	ANY

;; ANSWER SECTION:
buttonhost.net.		172790	IN	NS	ns1.dn***it.com.
buttonhost.net.		172790	IN	NS	ns2.dn***it.com.
buttonhost.net.		172790	IN	NS	ns3.dn***it.com.

;; Query time: 21 msec
;; SERVER: 208.67.222.222#53(208.67.222.222)
;; WHEN: Fri Jun 19 11:59:02 2009

dig buttonhost.net mx

Code:

; <<>> DiG 9.3.4-P1 <<>> buttonhost.net mx
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 61213
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;buttonhost.net.			IN	MX

;; ANSWER SECTION:
buttonhost.net.		28800	IN	MX	0 mail.buttonhost.net.

;; Query time: 26 msec
;; SERVER: 208.67.222.222#53(208.67.222.222)
;; WHEN: Fri Jun 19 11:59:35 2009
;; MSG SIZE  rcvd: 53

host `hostname`

Code:

webhost1.buttonhost.net has address 208.69.32.132
Host webhost1.buttonhost.net not found: 3(NXDOMAIN)

**phoenix** · 06-19-2009, 09:28 AM

I seem to be getting a different response than you from those DNS servers that you've listed in your resolv.conf:

Code:

dig @208.67.222.222 buttonhost.net any

; <<>> DiG 9.5.0-P2 <<>> @208.67.222.222 buttonhost.net any
; (1 server found)                                         
;; global options:  printcmd                               
;; Got answer:                                             
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 27880  
;; flags: qr rd ra; QUERY: 1, ANSWER: 5, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;buttonhost.net.                        IN      ANY

;; ANSWER SECTION:
buttonhost.net.         28649   IN      A       74.81.191.68
buttonhost.net.         28649   IN      NS      ns4.dn***it.com.
buttonhost.net.         28649   IN      NS      ns1.dn***it.com.
buttonhost.net.         28649   IN      NS      ns2.dn***it.com.
buttonhost.net.         28649   IN      NS      ns3.dn***it.com.

;; Query time: 74 msec
;; SERVER: 208.67.222.222#53(208.67.222.222)
;; WHEN: Fri Jun 19 18:22:15 2009           
;; MSG SIZE  rcvd: 131

Code:

dig @208.67.222.222 buttonhost.net mx

; <<>> DiG 9.5.0-P2 <<>> @208.67.222.222 buttonhost.net mx
; (1 server found)
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 63114
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;buttonhost.net.                        IN      MX

;; ANSWER SECTION:
buttonhost.net.         28800   IN      MX      0 mail.buttonhost.net.

;; Query time: 217 msec
;; SERVER: 208.67.222.222#53(208.67.222.222)
;; WHEN: Fri Jun 19 18:22:29 2009
;; MSG SIZE  rcvd: 53

and your server seems to be called mail.buttonhost.net rather than webhost1.buttonhost.net, you should also note that the host `hostname` command returns the wrong IP address. If the reason for that is that you're behind a firewall or NAT router then you'll need to set-up a Split DNS

**lhutton** · 06-19-2009, 10:45 AM

webhost1 was just the localhost name assigned by CentOS setup, I didn't think anything really carded about that, just what the DNS records have. I'm not sure what that other address is from or what it points at, that's nothing I have. My zimbra install is not behind a NAT, it's a VM with a bridged interface on the host.

I change my localhost name to mail, and reran host `hostname`

Code:

mail.buttonhost.net has address 74.81.191.68

So that seems to be well with the world, although mysql still won't start in anything but safe mode:

/opt/zimbra/log/mysql_error.log

Code:

090619 12:51:30  mysqld started
090619 12:51:30 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090619 12:51:30 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090619 12:51:30  InnoDB: Started; log sequence number 0 43655
090619 12:51:30 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.67-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution

zmcontrol status

Code:

	antispam                Running
	antivirus               Running
	ldap                    Running
	logger                  Running
	mailbox                 Stopped
		mysql.server is not running.
		zmmailboxdctl is not running.
	mta                     Running
	snmp                    Running
	spell                   Running
	stats                   Stopped

Zimbra

Thread: mysql not starting, sort of.

LinkBack

Thread Tools

Search Thread

Display

mysql not starting, sort of.

Thread Information

Users Browsing this Thread

Similar Threads

Install zcs 6 beta1 / centos 5.3 - INSTALLING COMMON ZIMLETS HANG

Zimbra fails after working for 2 weeks

[SOLVED] Install Problem in Ubuntu 6.06 Server

DNS Questions and Trouble Installing

Zimbra on Debian?

Posting Permissions