Results 1 to 7 of 7

Thread: mailbox mysql error after O/S updates

  1. #1
    Join Date
    Dec 2005
    Location
    Southern California
    Posts
    22
    Rep Power
    10

    Default mailbox mysql error after O/S updates

    I ran Ubuntu updates this morning, mysql got updated along with php.

    Now zimbra mailbox will not run.

    I'm including some of the error information from mailbox.log Even though this looks like a java error I believe it to really be a mysql problem. Please correct me if i'm wrong.



    ** BEGIN NESTED EXCEPTION **

    java.net.SocketException
    MESSAGE: java.net.ConnectException: Connection refused

    STACKTRACE:

    java.net.SocketException: java.net.ConnectException: Connection refused
    at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:156)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2769)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1 531)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
    at java.sql.DriverManager.getConnection(DriverManager .java:525)
    at java.sql.DriverManager.getConnection(DriverManager .java:140)
    at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnection(DriverManagerConnectionFacto ry.java:97)
    at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:300)
    at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject(GenericObjectPool.java:816)
    at org.apache.commons.dbcp.PoolingDataSource.getConne ction(PoolingDataSource.java:140)
    at com.zimbra.cs.db.DbPool.getConnection(DbPool.java: 279)
    at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 68)
    at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 95)
    at com.zimbra.cs.db.DbStats.getStatus(DbStats.java:87 )
    at com.zimbra.cs.db.DbStats.getStatData(DbStats.java: 58)
    at com.zimbra.cs.stats.RealtimeStats.getData(Realtime Stats.java:73)
    at com.zimbra.cs.stats.ZimbraPerf$ZimbraStatsDumper.r un(ZimbraPerf.java:539)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)

  2. #2
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default connection error

    That's a connection error when the server tries to connect to MySQL. Is MySQL running?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  3. #3
    Join Date
    Dec 2005
    Location
    Southern California
    Posts
    22
    Rep Power
    10

    Default Yes, lot's and lot's of processes.

    root@phred:/opt/zimbra/bin# ps -ef | grep mysql
    root 5064 1 0 07:09 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
    mysql 5135 5064 0 07:09 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
    root 5136 5064 0 07:09 ? 00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
    root 10208 9849 0 07:30 pts/1 00:00:00 vi adodb-mysql.inc.php
    zimbra 15401 1 0 11:05 pts/2 00:00:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --ledir=/opt/zimbra/logger/mysql/libexec
    zimbra 15445 15401 0 11:05 pts/2 00:00:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock

  4. #4
    Join Date
    Nov 2005
    Posts
    477
    Rep Power
    10

    Default

    Quote Originally Posted by pksings View Post
    I ran Ubuntu updates this morning, mysql got updated along with php.

    Now zimbra mailbox will not run.

    I'm including some of the error information from mailbox.log Even though this looks like a java error I believe it to really be a mysql problem. Please correct me if i'm wrong.



    ** BEGIN NESTED EXCEPTION **

    java.net.SocketException
    MESSAGE: java.net.ConnectException: Connection refused

    STACKTRACE:

    java.net.SocketException: java.net.ConnectException: Connection refused
    at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:156)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2769)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1 531)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
    at java.sql.DriverManager.getConnection(DriverManager .java:525)
    at java.sql.DriverManager.getConnection(DriverManager .java:140)
    at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnection(DriverManagerConnectionFacto ry.java:97)
    at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:300)
    at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject(GenericObjectPool.java:816)
    at org.apache.commons.dbcp.PoolingDataSource.getConne ction(PoolingDataSource.java:140)
    at com.zimbra.cs.db.DbPool.getConnection(DbPool.java: 279)
    at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 68)
    at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 95)
    at com.zimbra.cs.db.DbStats.getStatus(DbStats.java:87 )
    at com.zimbra.cs.db.DbStats.getStatData(DbStats.java: 58)
    at com.zimbra.cs.stats.RealtimeStats.getData(Realtime Stats.java:73)
    at com.zimbra.cs.stats.ZimbraPerf$ZimbraStatsDumper.r un(ZimbraPerf.java:539)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)

    Are you using a firewall?

    Try this:
    telnet localhost 3306
    telnet [your server's public ip] 3306

    Do either of these return anything?

  5. #5
    Join Date
    Dec 2005
    Location
    Southern California
    Posts
    22
    Rep Power
    10

    Default Nope, no software firewall or blocked ports.

    Nope, no firewall loaded. The last part of the post was cut off but I did try to telnet to it and this is what I got..

    root@phred:~# su - zimbra
    zimbra@phred:~$ telnet localhost 3306
    Trying 127.0.0.1...
    Connected to localhost.pksings.com.
    Escape character is '^]'.
    M
    5.0.22-Debian_0ubuntu6.06.2-log
    >~!&:1&j,d9,qux{!-^uO
    Connection closed by foreign host.

    I also logged into mysql and did a status

    mysql> status
    --------------
    /opt/zimbra/mysql/bin/mysql Ver 14.12 Distrib 5.0.26, for pc-linux-gnu (i686) using readline 5.0

    Connection id: 3
    Current database: mysql
    Current user: zimbra@localhost
    SSL: Not in use
    Current pager: stdout
    Using outfile: ''
    Using delimiter: ;
    Server version: 5.0.26-log
    Protocol version: 10
    Connection: Localhost via UNIX socket
    Server characterset: latin1
    Db characterset: latin1
    Client characterset: latin1
    Conn. characterset: latin1
    UNIX socket: /opt/zimbra/db/mysql.sock
    Uptime: 1 min 12 sec

    Threads: 1 Questions: 24 Slow queries: 2 Opens: 22 Flush tables: 1 Open tables: 17 Queries per second avg: 0.333
    Last edited by pksings; 02-22-2007 at 04:35 PM.

  6. #6
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    What does your hosts file look like?

    -john

  7. #7
    Join Date
    Dec 2005
    Location
    Southern California
    Posts
    22
    Rep Power
    10

    Default hosts file

    paul@phred:~$ cat /etc/hosts
    127.0.0.1 localhost.localdomain localhost
    192.168.1.5 phred.pksings.com www.pksings.com phred

Similar Threads

  1. Replies: 210
    Last Post: 01-17-2012, 01:19 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. mailbox not running - tomcat fails to login to mysql
    By milprog in forum Installation
    Replies: 6
    Last Post: 08-02-2006, 09:44 AM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 07:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •