powered by Jive Software

Openfire cant connect to DB?

We recently switch boxes where openfire is/was running, copied over the files but openfire did not want to start. Changed setup to false, but still did not work. I’m getting the following in the error.log:

2009.08.11 19:50:42 [org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedCon nectionProvider.java:56)] EmbeddedConnectionProvider: Error while getting connection:
java.sql.SQLException: error in script file line: 2290 java.io.IOException: java.io.IOException: Unexpected end of command
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211 )
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConn ectionProvider.java:53)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:463)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:77)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:39)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
2009.08.11 19:50:42 [org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnecti onManager.java:470)]
java.lang.NullPointerException
at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:649)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:464)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:77)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:39)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
2009.08.11 19:50:43 [org.jivesoftware.util.log.util.CommonsLogFactory$1.error(CommonsLogFactory.jav a:91)] Prototype
java.sql.SQLException: error in script file line: 2290 java.io.IOException: java.io.IOException: Unexpected end of command
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)
2009.08.11 19:50:43 [org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedCon nectionProvider.java:56)] EmbeddedConnectionProvider: Error while getting connection:
java.sql.SQLException: error in script file line: 2290 java.io.IOException: java.io.IOException: Unexpected end of command
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211 )
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConn ectionProvider.java:53)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:92)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:39)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
2009.08.11 19:50:43 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManage r.java:95)] WARNING: ConnectionManager.getConnection() failed to obtain a connection.
2009.08.11 19:50:43 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:341)]
java.lang.NullPointerException
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:331)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:39)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
2009.08.11 19:50:43 [org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedCon nectionProvider.java:56)] EmbeddedConnectionProvider: Error while getting connection:
java.sql.SQLException: error in script file line: 2290 java.io.IOException: java.io.IOException: Unexpected end of command
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211 )
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConn ectionProvider.java:53)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:92)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:715)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:446)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
2009.08.11 19:50:43 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManage r.java:95)] WARNING: ConnectionManager.getConnection() failed to obtain a connection.
2009.08.11 19:50:43 [org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:726)] Database could not be accessed
java.lang.NullPointerException
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:716)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:446)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
2009.08.11 19:50:44 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:476)]
java.lang.IllegalArgumentException: java.lang.NullPointerException
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:727)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:446)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.install4j.runtime.Launcher.main(Unknown Source)
Caused by: java.lang.NullPointerException
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:716)
… 16 more

Found the issue, error in the DB files at line 2290. Removed the line and things worked fine.