[SOLVED] zmmailboxd "connection refused" after restoring a backup

[sgnaus]

hi there,

i must restore a backup of my actually running mail server into a virtual machine for doing some tests.

i use this procedure to make backups of my mta.

So i restored the bck doing this (on the virtual machine):

mv /opt/zimbra /opt/zimbra.old
mkdir /opt/zimbra; cd /opt/zimbra
dar -x path/to/darfiles
/opt/zimbra/libexec/zmfixperms -v -e

but when i restart the services zmmailboxd goes down and into the logs i see that:

** BEGIN NESTED EXCEPTION ** 

java.net.ConnectException
MESSAGE: Connection refused

STACKTRACE:

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:525)
        at java.net.Socket.connect(Socket.java:475)
        at java.net.Socket.<init>(Socket.java:372)
        at java.net.Socket.<init>(Socket.java:215)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2921)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)
        at com.zimbra.cs.db.DbPool$ZimbraConnectionFactory.createConnection(DbPool.java:239)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
        at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:308)
        at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:292)
        at com.zimbra.cs.db.DbPool.waitForDatabase(DbPool.java:198)
        at com.zimbra.cs.db.DbPool.startup(DbPool.java:189)
        at com.zimbra.cs.servlet.FirstServlet.init(FirstServlet.java:95)
        at javax.servlet.GenericServlet.init(GenericServlet.java:241)
        at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:431)
        at org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:263)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
        at org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:667)
        at org.mortbay.jetty.servlet.Context.startContext(Context.java:140)
        at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1239)
        at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
        at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:466)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
        at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
        at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
        at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
        at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
        at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
        at org.mortbay.jetty.Server.doStart(Server.java:222)
        at org.mortbay.setuid.SetUIDServer.doStart(SetUIDServer.java:138)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
        at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:985)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.mortbay.start.Main.invokeMain(Main.java:194)
        at org.mortbay.start.Main.start(Main.java:523)
        at org.mortbay.start.Main.main(Main.java:119)


** END NESTED EXCEPTION **

i've installed a local bind service to let zimbra resolve hostname correctly:

:~$ host -nt mx ubiquity.it
ubiquity.it mail is handled by 100 subsonica.ubiquity.it.

:~$ host subsonica.ubiquity.it
subsonica.ubiquity.it has address 192.168.0.208

zimbra@subsonica:~$ host `hostname`
subsonica.ubiquity.it has address 192.168.0.208

:~$ cat /etc/resolv.conf 
search ubiquity.it
nameserver 127.0.0.1

:~$ cat /etc/hosts
127.0.0.1	localhost
192.168.0.208	subsonica.ubiquity.it subsonica

i can't figure out that exception, any suggest?

there's no other mysql running on the machine, i've also tried to run the install script (zcs ose 6.0.1) without success

[sgnaus]

solved, was innodb trying to locate 5gb of memory while the VM has only 3gb
decreasing the innodb buffer from my.cnf solved my problem.