mailboxd cant connect to mysql database, zimbra dead
hi all,
i am upgraded zimbra 6.0.15 to zimbra 7.1.4p1 running on Ubuntu 10.04 today.
After the upgrade the mailboxd cant connect to the database.
in the mailboxd.log i get:
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Caused by: java.net.ConnectException: Connection refused
then i checked, the database is running on port 7306.
then i found in localconfig.xml there are some entries missing
<key name="mysql_socket">
<value>${zimbra_db_directory}/mysql.sock</value>
</key>
<key name="mysql_mycnf">
<value>${zimbra_home}/conf/my.cnf</value>
</key>
<key name="mysql_data_directory">
<value>${zimbra_db_directory}/data</value>
</key>
<key name="zimbra_mysql_user">
<value>zimbra</value>
</key>
but zmmailboxd still cant connect to the database.
But trying
mysql -u root -h localhost -p is able to connect to the database.
migrate20100913-Mysql51.pl did also run fine.
any ideas?
thomas
zmcontrol -v
1x Release 6.0.10_GA_2692.UBUNTU8_64 NETWORK edition.
1x Release 6.0.14_GA_2928.UBUNTU8_64 NETWORK edition
2x Release 7.1.3_GA_3346.UBUNTU10_64 NETWORK edition, Patch 7.1.3_P1
1x Release 8.0.2.GA.5569.UBUNTU12.64 NETWORK edition
2x Release 6.0.10_GA_2692.UBUNTU8_64 FOSS edition
2x Release 7.2.2_GA_2852.UBUNTU10_64 FOSS edition
1x Release 7.1.4_GA_2555.UBUNTU10_64 FOSS
1x Release 8.0.3.GA.5664.UBUNTU12.64 FOSS edition