powered by Jive Software

Openfire Upgrade from 3.5.2. to 3.6 Fails

This is the Startup log:

Found old database version 16 for openfire. Upgrading to version 20…
SchemaManager: Failed to execute SQL:
CREATE TABLE mucService ( serviceID INT NOT NULL, subdomain NVARCHAR(255) NOT NULL, description NVARCHAR(255), CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
java.sql.SQLException: There is already an object named ‘mucService’ in the database.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
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$$d0d7356b.execute()
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:374 )
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)
at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:498)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:79)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:40)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
at org.jivesoftware.openfire.XMPPServer.(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)

java.sql.SQLException: Invalid object name ‘ofProperty’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
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.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery()
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:337)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:40)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
at org.jivesoftware.openfire.XMPPServer.(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)

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
Database could not be accessed
java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
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.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
at org.jivesoftware.openfire.XMPPServer.(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)

java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name ‘ofID’.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
at org.jivesoftware.openfire.XMPPServer.(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: java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
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.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
… 16 more
java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name ‘ofID’.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
at org.jivesoftware.openfire.XMPPServer.(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: java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
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.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
… 16 moEre

rror starting the server. Please check the log files for more information.
Server halted

Are you using LDAP? Even if you are not try this:

  • stop your server
  • edit your openfire.xml file setup tag to read false.
  • start server
  • go to admin page and step throught the config again.

I did try the setup. In fact we almost always run through the setup as part of an upgrade. This time it stops on the DB screen with an error of:

The Openfire database schema does not appear to be installed. Follow the installation guide to fix this error.

I have a same problem.

same here

I downgraded

dpkg -i openfire_3.5.2_all.deb

and everything works fine again.

Good lord, it sounds like there are some leftover tables hanging around that it’s conflicting with. You downgraded and it’s working fine? Did you restore your db from a previous version? I would think the db would be in a fairly confused state at the moment if you partially upgraded and then stopped.

So both of you are using the embedded db and seeing this?

Our database is runnoing on MSFT SQL

Im using ldap (readonly) for user authentification and the embedded DB from openfire. I just reinstalled the 3.5.2 version, no DB restoring.

greetings

kero

dthor wrote:

Our database is runnoing on MSFT SQL

What? =) What is that?

We use LDAP via Active Direcotyr… i just dropped back to 3.5.2 and used the DB backup and most everything seems fins. I ca’nt find the old version of rhte gateway .jar… the new one says it only works with 3.6

Hrm. I’ve attached a copy of the last released gateway.jar before this one.
gateway.jar (1188765 Bytes)

But what is MSFT SQL?

kero wrote:

Im using ldap (readonly) for user authentification and the embedded DB from openfire. I just reinstalled the 3.5.2 version, no DB restoring.

greetings

kero

Interesting. It sounds like the old tables are still present, or nothing got renamed, or something. scratch head

SQL Server… Microsoft SQL

dthor wrote:

SQL Server… Microsoft SQL

I’ve been told that there’s a bug in script 19 for SQL server:

In upgrade script 19
Line 60 - ofUserFlag should be ofRoster
Line 140 - mucRoom__pk should be mucRoom_pk

But it doesn’t help to problem with upgrade and error:

SchemaManager: Failed to execute SQL:
CREATE TABLE mucService ( serviceID INT NOT NULL, subdomain NVARCHAR(255) NOT NULL, description NVARCHAR(255), CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
java.sql.SQLException: There is already an object named ‘mucService’ in the database.

i’am using Widows version of OpenFire and MSSQL

Please help

Hrm. It looks like one of the upgrades partially succeeded and so now there are conflicting tables. Can you get a list of the tables in your db and paste them here (not the contents, just the table names)

yes, there is list of openfire database tables:

Name Owner Type Create Date
dtproperties dbo System 2006-07-26 10:42:23
jiveExtComponentConf dbo User 2006-07-25 17:45:33
jiveGroup dbo User 2006-07-25 17:45:33
jiveGroupProp dbo User 2006-07-25 17:45:33
jiveGroupUser dbo User 2006-07-25 17:45:33
jiveID dbo User 2006-07-25 17:45:33
jiveOffline dbo User 2006-07-25 17:45:33
jivePresence wildfire User 2007-02-13 18:36:55
jivePrivacyList dbo User 2006-07-25 17:45:33
jivePrivate dbo User 2006-07-25 17:45:33
jiveProperty dbo User 2006-07-25 17:45:33
jiveRemoteServerConf dbo User 2006-07-25 17:45:33
jiveRoster dbo User 2006-07-25 17:45:33
jiveRosterGroups dbo User 2006-07-25 17:45:33
jiveSASLAuthorized dbo User 2006-07-25 17:45:33
jiveSecurityAuditLog wildfire User 2008-04-23 17:32:33
jiveUser dbo User 2006-07-25 17:45:33
jiveUserFlag wildfire User 2008-04-23 17:32:33
jiveUserProp dbo User 2006-07-25 17:45:33
jiveVCard dbo User 2006-07-25 17:45:33
jiveVersion dbo User 2006-07-25 17:45:33
mucAffiliation dbo User 2006-07-25 17:45:33
mucConversationLog dbo User 2006-07-25 17:45:33
mucMember dbo User 2006-07-25 17:45:33
mucRoom dbo User 2006-07-25 17:45:33
mucRoomProp dbo User 2006-07-25 17:45:33
mucService wildfire User 2008-08-27 18:37:25
mucServiceProp wildfire User 2008-08-27 18:37:25
pubsubAffiliation dbo User 2006-07-25 17:45:33
pubsubDefaultConf dbo User 2006-07-25 17:45:33
pubsubItem dbo User 2006-07-25 17:45:33
pubsubNode dbo User 2006-07-25 17:45:33
pubsubNodeGroups dbo User 2006-07-25 17:45:33
pubsubNodeJIDs dbo User 2006-07-25 17:45:33
pubsubSubscription dbo User 2006-07-25 17:45:33
syscolumns dbo System 2000-08-06 01:29:12
syscomments dbo System 2000-08-06 01:29:12
sysdepends dbo System 2000-08-06 01:29:12
sysfilegroups dbo System 2000-08-06 01:29:12
sysfiles dbo System 2000-08-06 01:29:12
sysfiles1 dbo System 2000-08-06 01:29:12
sysforeignkeys dbo System 2000-08-06 01:29:12
sysfulltextcatalogs dbo System 2000-08-06 01:29:12
sysfulltextnotify dbo System 2000-08-06 01:29:12
sysindexes dbo System 2000-08-06 01:29:12
sysindexkeys dbo System 2000-08-06 01:29:12
sysmembers dbo System 2000-08-06 01:29:12
sysobjects dbo System 2000-08-06 01:29:12
syspermissions dbo System 2000-08-06 01:29:12
sysproperties dbo System 2000-08-06 01:29:12
sysprotects dbo System 2000-08-06 01:29:12
sysreferences dbo System 2000-08-06 01:29:12
systypes dbo System 2000-08-06 01:29:12
sysusers dbo System 2000-08-06 01:29:12