Page 4 of 5

Error install on Mac OS X

Posted: Mon Nov 21, 2005 12:41 pm
by 939pcoleman
Not at the system right now will check when I get home.

Thanks.

Error install on Mac OS X

Posted: Mon Nov 21, 2005 4:50 pm
by 939pcoleman
Well I tried again and tomcat just doesn't start.

This is what I get in /opt/zimbra/log/zimbra.log when I tried

tomcat start
2005-11-21 17:41:45,446 INFO [main] [] soap - Servlet SoapServlet starting up

2005-11-21 17:41:45,635 INFO [main] [] soap - Adding service AccountService to SoapServlet

2005-11-21 17:41:45,941 INFO [main] [] soap - Adding service MailService to SoapServlet

2005-11-21 17:41:46,474 INFO [main] [] misc - version=3.0.0_M2_747 release=20051118121136 builddate=20051118-1211 buildhost=xserve1.liquidsys.com

2005-11-21 17:41:46,678 INFO [main] [] DbPool - Setting mysql connector property: maxActive=10

2005-11-21 17:41:46,680 INFO [main] [] misc - Setting mysql connection pool size to 10

2005-11-21 17:42:01,871 FATAL [main] [] system - Config initialization failed

com.zimbra.cs.service.ServiceException: system failure: getting database connection

at com.zimbra.cs.service.ServiceException.FAILURE(ServiceException.java:99)

at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:279)

at com.zimbra.cs.util.Config.init(Config.java:69)

at com.zimbra.cs.util.Config.initConfig(Config.java:96)

at com.zimbra.cs.util.Config.getString(Config.java:108)

at com.zimbra.cs.db.Versions.checkDBVersion(Versions.java:87)

at com.zimbra.cs.db.Versions.checkVersions(Versions.java:82)

at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:88)

at com.zimbra.soap.SoapServlet.init(SoapServlet.java:118)

at javax.servlet.GenericServlet.init(GenericServlet.java:211)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:800)

at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:695)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)

at org.apache.catalina.core.StandardService.start(StandardService.java:450)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)

at org.apache.catalina.startup.Catalina.start(Catalina.java:537)

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:585)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)

Caused by: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectExce

ption: Connection refused'.
** 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(StandardSocketFactory.java:156)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)

at com.mysql.jdbc.Connection.(Connection.java:1474)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)

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.PoolingDriver.connect(PoolingDriver.java:171)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:193)

at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:270)

at com.zimbra.cs.util.Config.init(Config.java:69)

at com.zimbra.cs.util.Config.initConfig(Config.java:96)

at com.zimbra.cs.util.Config.getString(Config.java:108)

at com.zimbra.cs.db.Versions.checkDBVersion(Versions.java:87)

at com.zimbra.cs.db.Versions.checkVersions(Versions.java:82)

at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:88)

at com.zimbra.soap.SoapServlet.init(SoapServlet.java:118)

at javax.servlet.GenericServlet.init(GenericServlet.java:211)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:800)

at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:695)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)

at org.apache.catalina.core.StandardService.start(StandardService.java:450)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)

at org.apache.catalina.startup.Catalina.start(Catalina.java:537)

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:585)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2734)

at com.mysql.jdbc.Connection.(Connection.java:1474)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)

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.PoolingDriver.connect(PoolingDriver.java:171)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:193)

at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:270)

... 34 more

patrick-colemans-powerbook:/opt/zimbra/log root#

Error install on Mac OS X

Posted: Mon Nov 21, 2005 4:51 pm
by marcmac
tomcat can't contact mysql for it's config - is mysql running?

Error install on Mac OS X

Posted: Mon Nov 21, 2005 5:01 pm
by 939pcoleman
Looks like it...

1068 p1 S 0:00.12 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --ledir=/opt/zimbra/logger/mysql/
1101 p1 R 0:05.96 /opt/zimbra/logger/mysql/bin/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/


and the mysql error log file has this at the end
/opt/zimbra/logger/mysql/bin/mysqld: ready for connections.

Version: '4.1.14-standard-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 MySQL Community Edition - Standard (GPL)

Error install on Mac OS X

Posted: Mon Nov 21, 2005 5:02 pm
by marcmac
That's the wrong mysql instance.
su - zimbra

mysql.server start

tomcat start

Error install on Mac OS X

Posted: Mon Nov 21, 2005 5:16 pm
by 939pcoleman
ok then why would that instance be started?
I tried
zimbra$ mysql.server start

patrick-colemans-powerbook:~ zimbra$ chown: /opt/zimbra/log/mysqld.log: Operation not permitted

Starting mysqld daemon with databases from /opt/zimbra/db/data

STOPPING server from pid file /opt/zimbra/db/mysql.pid

051121 18:14:35 mysqld ended

Error install on Mac OS X

Posted: Mon Nov 21, 2005 5:23 pm
by marcmac
The logger instance is used for stats gathering and server status.
zimbra$ mysql.server start

patrick-colemans-powerbook:~ zimbra$ chown: /opt/zimbra/log/mysqld.log: Operation not permitted

Starting mysqld daemon with databases from /opt/zimbra/db/data

STOPPING server from pid file /opt/zimbra/db/mysql.pid

051121 18:14:35 mysqld ended


You've got permissions problems.
Are all of these owned by zimbra:

/opt/zimbra/log/mysqld.log

/opt/zimbra/log

/opt/zimbra/db

Error install on Mac OS X

Posted: Mon Nov 21, 2005 7:09 pm
by 939pcoleman
Just about everything from /opt down is owner/group zimbra

except for /opt/zimbra/bin which is root/wheel

Error install on Mac OS X

Posted: Mon Nov 21, 2005 8:03 pm
by marcmac
You're running the script as the zimbra user, right?

Error install on Mac OS X

Posted: Mon Nov 21, 2005 8:05 pm
by fozzy
I have a different error related to DB in /opt/zimbra/log/zimbra.log:
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)

Caused by: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'zimbra'@'localhost' (using password: YES)'.
So this seems a little easier to fix except how do I reset the password or add an account on the zimbra mysql instance?

Thanks.