AnsweredAssumed Answered

Upgrade problem

Question asked by msanders on Aug 7, 2009
Latest reply on Aug 10, 2009 by msanders

I'm attempting to upgrade an installation from Openfire 3.3.2 to 3.6.4. The data is held in a MySQL database. When attempting to start I get the messages:

 

.........
Found old database version 10 for openfire. Upgrading to version 20...
Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
java.lang.IllegalArgumentException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofid' doesn't exist
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    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:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    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.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofid' doesn't exist
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
    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 org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.Wrapper$$EnhancerByProxool$$518616e5.executeQuery(<generated>)
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    ... 16 more
Error starting the server. Please check the log files for more information.
Server halted

 

I thought that the database schema gets upgraded automatically...?

 

Here's a list of tables in my DB:

 

mysql> use openfire
Database changed
mysql> show tables;
+----------------------+
| Tables_in_openfire   |
+----------------------+
| jiveextcomponentconf |
| jivegroup            |
| jivegroupprop        |
| jivegroupuser        |
| jiveid               |
| jiveoffline          |
| jivepresence         |
| jiveprivacylist      |
| jiveprivate          |
| jiveproperty         |
| jiveremoteserverconf |
| jiveroster           |
| jiverostergroups     |
| jivesaslauthorized   |
| jiveuser             |
| jiveuserprop         |
| jivevcard            |
| jiveversion          |
| mucaffiliation       |
| mucconversationlog   |
| mucmember            |
| mucroom              |
| mucroomprop          |
| pubsubaffiliation    |
| pubsubdefaultconf    |
| pubsubitem           |
| pubsubnode           |
| pubsubnodegroups     |
| pubsubnodejids       |
| pubsubsubscription   |
+----------------------+
30 rows in set (0.02 sec)

 

Thanks,

Michael

Outcomes