Problems with Openfire after upgrading 3.5.2 to 4.2.3

Openfire
1

Hello! Our enterprise has been using wildfire (v 3.1.1) almost for 10 years.
But now I’ve decided to update wildfire from current version (v 3.1.1) to latest (openserver 4.2.3). First of all I’ve been upgraded to openfire ver 3.5.2 successfully. But when I tried to update openfire from 3.5.2 to 4.2.3, I got loads of errors wich connected with version of database. (Also I’ve tried updating gradually, from 3.5.2 to 3.6.0/3.6.1, but eventually i got almost the same mistakes).
Error message from openfire window when i trying to start upgraded version of openfire:

Error message from openfire window

Found old database version 16 for openfire. Upgrading to version 26…
Database setup or configuratEirror on error: Please verifsytarting the server. Pleas echeck tehyoru log files for more information.
database settings and check the logs/error.log file for detailed error messages.
java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name ‘ofID’.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:820)

Caused by: java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
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.lang.AutoCloseable$$EnhancerByProxool$$7b535ee6.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:812)
… 16 more
Server halted

Error.log

2018.09.21 12:10:51 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1101)]
java.lang.IllegalArgumentException: No enum const class org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.null
at java.lang.Enum.valueOf(Unknown Source)
at org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.valueOf(Node.java:2178)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1092)
2018.09.21 12:10:51 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1101)]
java.lang.IllegalArgumentException: No enum const class org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.null
at java.lang.Enum.valueOf(Unknown Source)
at org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.valueOf(Node.java:2178)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1092)
2018.09.21 12:10:51 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersistenceManager.java:224)]
java.sql.SQLException: Violation of PRIMARY KEY constraint ‘PUBSUBNODE_PK’. Cannot insert duplicate key in object ‘dbo.PUBSUBNODE’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersistenceManager.java:218)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1693)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
2018.09.21 12:10:51 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSubPersistenceManager.java:771)]
java.sql.SQLException: Violation of PRIMARY KEY constraint ‘PUBSUBAFFIL_PK’. Cannot insert duplicate key in object ‘dbo.PUBSUBAFFILIATION’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSubPersistenceManager.java:758)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1698)
2018.09.21 12:12:51 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:14:51 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:16:51 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:18:51 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:20:51 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:27:39 [org.jivesoftware.wildfire.group.Group.getSharedGroupsNames(Group.java:83)]
java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1175)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:646)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:43:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:45:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:47:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:49:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:51:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:53:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:55:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:57:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 12:59:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:01:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:03:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:05:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:07:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:09:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:11:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:13:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:15:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:17:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:19:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:21:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:23:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:25:26 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:28:28 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1101)]
java.lang.IllegalArgumentException: No enum const class org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.null
at java.lang.Enum.valueOf(Unknown Source)
at org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.valueOf(Node.java:2178)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1092)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:326)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.09.21 13:28:28 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1101)]
java.lang.IllegalArgumentException: No enum const class org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.null
at java.lang.Enum.valueOf(Unknown Source)
at org.jivesoftware.wildfire.pubsub.Node$ItemReplyPolicy.valueOf(Node.java:2178)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1092)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:347)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.09.21 13:28:33 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersistenceManager.java:224)]
java.sql.SQLException: Violation of PRIMARY KEY constraint ‘PUBSUBNODE_PK’. Cannot insert duplicate key in object ‘dbo.PUBSUBNODE’. The duplicate key value is (pubsub, ).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersistenceManager.java:218)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1693)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.09.21 13:28:33 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSubPersistenceManager.java:771)]
java.sql.SQLException: Violation of PRIMARY KEY constraint ‘PUBSUBAFFIL_PK’. Cannot insert duplicate key in object ‘dbo.PUBSUBAFFILIATION’. The duplicate key value is (pubsub, , admin@kashtan).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSubPersistenceManager.java:758)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1698)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.09.21 13:30:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:32:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:34:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:36:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:38:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:40:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.09.21 13:42:28 [org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:332)] Internal server error
java.lang.NullPointerException
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.ensureMaxDays(AuditorImpl.java:245)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl.access$100(AuditorImpl.java:30)
at org.jivesoftware.wildfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:327)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2018.11.05 08:38:20 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:108)] Failed to create new connections on startup. Attempt 0 of 3
java.sql.SQLException: Unable to get information from SQL Server: srv03.
at net.sourceforge.jtds.jdbc.MSSqlServerInfo.(MSSqlServerInfo.java:91)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:263)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.ConnectionPool.createCon(ConnectionPool.java:437)
at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:85)
at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:83)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:441)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:74)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:269)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)
at org.jivesoftware.util.JiveProperties.(JiveProperties.java:49)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:43)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.wildfire.XMPPServer.initialize(XMPPServer.java:287)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:365)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:38:32 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:108)] Failed to create new connections on startup. Attempt 1 of 3
java.sql.SQLException: Unable to get information from SQL Server: srv03.
at net.sourceforge.jtds.jdbc.MSSqlServerInfo.(MSSqlServerInfo.java:91)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:263)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.ConnectionPool.createCon(ConnectionPool.java:437)
at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:85)
at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:83)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:441)
[org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnectionProvider.java:68)] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.
2018.11.05 08:45:04 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:92)] WARNING: ConnectionManager.getConnection() failed to obtain a connection.
2018.11.05 08:45:04 [org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:620)] Database could not be accessed
java.lang.NullPointerException
at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:610)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:369)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:45:04 [org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:405)]
java.lang.IllegalArgumentException: java.lang.NullPointerException
at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:621)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:369)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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.lang.NullPointerException
at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:610)
… 16 more
2018.11.05 08:53:57 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:204)]
java.sql.SQLException: There is already an object named ‘mucAffiliation’ in the database.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:332)
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:201)
at org.jivesoftware.database.SchemaManager.checkWildfireSchema(SchemaManager.java:66)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:449)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:74)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:269)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)
at org.jivesoftware.util.JiveProperties.(JiveProperties.java:49)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:43)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.wildfire.XMPPServer.initialize(XMPPServer.java:287)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:365)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1101)]
java.sql.SQLException: Invalid object name ‘pubsubDefaultConf’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1074)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:326)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfiguration(PubSubPersistenceManager.java:1151)]
java.sql.SQLException: Invalid object name ‘pubsubDefaultConf’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfiguration(PubSubPersistenceManager.java:1148)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:344)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1101)]
java.sql.SQLException: Invalid object name ‘pubsubDefaultConf’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfiguration(PubSubPersistenceManager.java:1074)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:347)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfiguration(PubSubPersistenceManager.java:1151)]
java.sql.SQLException: Invalid object name ‘pubsubDefaultConf’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfiguration(PubSubPersistenceManager.java:1148)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:365)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadNodes(PubSubPersistenceManager.java:515)]
java.sql.SQLException: Invalid object name ‘pubsubNode’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadNodes(PubSubPersistenceManager.java:452)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:370)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersistenceManager.java:224)]
java.sql.SQLException: Invalid object name ‘pubsubNode’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersistenceManager.java:218)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1693)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSubPersistenceManager.java:771)]
java.sql.SQLException: Invalid object name ‘pubsubAffiliation’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSubPersistenceManager.java:758)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1698)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveSubscription(PubSubPersistenceManager.java:891)]
java.sql.SQLException: Invalid object name ‘pubsubSubscription’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveSubscription(PubSubPersistenceManager.java:850)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1702)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:53:59 [org.jivesoftware.wildfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersistenceManager.java:570)]
java.sql.SQLException: Invalid object name ‘mucConversationLog’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.jivesoftware.wildfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersistenceManager.java:479)
at org.jivesoftware.wildfire.muc.spi.MultiUserChatServerImpl.start(MultiUserChatServerImpl.java:816)
at org.jivesoftware.wildfire.XMPPServer.startModules(XMPPServer.java:507)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:376)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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.wildfire.starter.ServerStarter.start(ServerStarter.java:93)
at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
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)
2018.11.05 08:54:34 [org.jivesoftware.wildfire.update.UpdateManager$1.run(UpdateManager.java:116)] Error checking for updates
java.net.UnknownHostException: www.jivesoftware.org
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:79)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:121)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at org.jivesoftware.wildfire.update.UpdateManager.checkForServerUpdate(UpdateManager.java:194)
at org.jivesoftware.wildfire.update.UpdateManager$1.run(UpdateManager.java:111)

Current database of openserver works on the Ms Sql Server 2008 (ver 10.0.5500.0).
Current openserver is located on Windows Server 2003 x64.

Can anybody help me to solve this problem with upgrade openfire to latest version?
Thank you in advance.

2

Error log still contains references to wildfire source code handles. You can try this guide http://download.igniterealtime.org/openfire/docs/latest/documentation/wildfire-openfire-upgrade.html
Or you may need to run every database upgrade sql script manually against your database one by one. Although i would still try to do incremental updates. Trying to upgrade to the latest version most probably will fail, even if you fix the current problem.

3

How are you upgrading. if you are just unzipping the binary zip files, then you will run into issues with old install artifacts still laying around in the runtime lib/ folders.

4

I’ve used this guide for updating. Also, I tried to update database by sql scripts (from folder with latest version) step by step, but it have not been applied by ms sql server 2008. I’ve found out one error: some queries can’t execute to database without parameter “set”.
Maybe this is due to problems with ms sql server 2003?

5

I’ve tried to upgrade openserver according to the instruction.

  1. First of all i’ve done backups (folder with openfire and sql base).
  2. I’ve installed openfire_4_2_3.exe in current openfire’s folder with version 3.5.2.
  3. When openfire had been installed, i started it and got loads of errors.
    Maybe i’ve done anything wrong?
6

I don’t know much about databases. Hard to tell, but i think Openfire should be backwards compatible and MS SQL 2008 is not that old. But maybe database driver has been updated a few times during those years and it can’t talk to your old database for some reason. Anyway, as i have suggested, i would try to do incremental updates. Try updating 3.5.2 to 3.6.0 and provide error.log after this operation. You said it was similar, but maybe there will be some clues.

7

As i said before, I have allready tried to update openserver step by step…And update from 3.5.2 to 3.6.0 has returned me similar errors. No matter which update i have to use, because i have old database (16 version), and all next updates (starting with 3.6.0) can’t update database to 17v or highter, because queries from openfire_sqlserver.sql applies with mistakes.
In addition to this, I’ve allready tried to fix this openfire_sqlserver.sql, but it seems to me this is not a good idea in this case.
Do u have any other ideas?

8

That is really the only way around this; examine the file, run each command manually one at a time in SQL Server Management Studio (remembering that some may have already run successfully) and correct any errors. When you’ve got the last line running successfully, (“UPDATE jiveVersion set version=17 where name = ‘openfire’”), you should be able to try again. People here should be able to help with any specific errors you can’t resolve.

Greg

1 Like
9

PS. Just to clarify, it the server won’t upgrade to schema version 17, then the file with problems is database/17/openfire_sqlserver.sql

Greg

10

Hello Greg! First of all thank you, but you are talking about elementary things. Of course I also have allready tried to fix “openfire_sqlserver.sql” , but i wasn’t able to fix ALL mistakes. I came across queries which try to change nonexistent tables and indexes. Eventually i had done my best, but it didn’t help me to upgrade openfire from 3.7.0 to 3.8.0. I’m sure, this is not correct decision to fix “openfire_sqlserver.sql” for each version of database (17,18,19 and etc). Openfire developers must have had prepared solution for case like mine, and I still have been waiting for akrherz’s answer. It seems to me he has allready come across case like this.
Thanks.

11

Hi,

Firstly, I wouldn’t expect to much help to cover your explicit problem re. upgrading to DB version 17 and beyond; version 17 dates from 2008, so any experience in this has problem been lost to the mists of time.

Secondly, if the script is referring to tables no longer present then something more significant than simple syntax errors has occurred, 3.5.2. certainly had tables referenced by the 17 upgrade script - they were not renamed until DB version 19 / Openfire 3.6.0. You may have to restore from backup and try again.

Greg

12

Hi guys! Today I’ve decided to make an experiment.
I created empty database and installed openserver v.3.3.0 , after it i tried to apply update for this (from 3.3.0 to 3.6.0), but got almost similar mistake when tried update enterprise wildfire:

Error message from openfire window

Found old database version 11 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: 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(JtdsPreparedStatement.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(ProxyStatementE.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$f2737783.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
… 16 more
rror starting the server. Please check the log files for more information.
Server halted

error.log

2018.11.21 07:55:16 [org.jivesoftware.util.log.util.CommonsLogFactory$1.fatal(CommonsLogFactory.java:95)] The scratchDir you specified: C:\DOCUME~1\9335~1\LOCALS~1\Temp\Jetty_0_0_0_0_9090_webapp____-dnguxu\jsp is unusable.
2018.11.21 07:55:54 [org.jivesoftware.openfire.update.UpdateManager$1.run(UpdateManager.java:116)] Error checking for updates
java.net.UnknownHostException: www.igniterealtime.org
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:79)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:121)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at org.jivesoftware.openfire.update.UpdateManager.checkForServerUpdate(UpdateManager.java:194)
at org.jivesoftware.openfire.update.UpdateManager$1.run(UpdateManager.java:111)
2018.11.21 07:58:13 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:379)] SchemaManager: Failed to execute SQL:
ALTER TABLE mucRoom DROP CONSTRAINT mucRoom_pk;
2018.11.21 07:58:13 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:269)]
java.sql.SQLException: ‘mucRoom_pk’ is not a constraint.
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.GeneratedMethodAccessor5.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.Statement$$EnhancerByProxool$$6bb94837.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(DbConnectionManager.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)
2018.11.21 07:58:13 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)]
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(JtdsPreparedStatement.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$$f2737783.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)
2018.11.21 07:58:13 [org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:709)] 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(JtdsPreparedStatement.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$$f2737783.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)
2018.11.21 07:58:13 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:457)]
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(JtdsPreparedStatement.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$$f2737783.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
… 16 more

Current database of openserver works on the Ms Sql Server 2008 (ver 10.0.5500.0).
Current openserver is located on Windows Server 2003 x64.

Can anybody tell me from developers this software, why i catch these errors? which version MS SQL SERVER had been used when openserver was testing before release?

13

I don’t know of anybody actively testing / developing Openfire against MS SQL Server. We are all volunteers here and don’t have infinite bandwidth for testing. At any point, folks can offer to chip in with this regard.

14

Well, SQL Server is one of the configurations we use, but not even we use systems as old as 3.3; I think you’ve got two choices, really, given that this is a problem that only seems to affect you;

a) Fix it yourself
b) Pay someone to fix it

15

For what it’s worth i have just tried this:

Installed 3.3.0 with the Embedded database in Win7 x86 VM. Finished setup. Created user test and logged in with this user in Spark in the same VM.
Then installed 3.6.0 on top. Btw, i have ran into a known bug with old installers when it hanged while trying to uninstall old version. I had to kill the process and run the installer again and then it installed on top without trying to uninstall it (already removed). This bug has been fixed a few years ago. But it installed fine and 3.6.0 came up normally. It said database 11 was found and updated it to 20. Was able to login with the test user again.

So, maybe this is some problem with MS SQL in older Wildfire/Openfire versions. But there is nobody to dig that deep into old stuff. Unless you pay someone like @gdt says. I know that @speedy uses MS SQL (not sure about the version), but with the newest Openfire version of course.

16

Also, i have a third variant: do nothing.

17

I tried to transfer users from wildfire table (jiveUser) to openfire table ‘ofUser’ . I’ve transfered all successfully, but password for each transfered account is wrong, why? Can you help me with it?
All transfered accounts can work only if I change password via admin panel for these users.

18

It’s likely the password hashing algorithm has changed between Wildfire v. ancient and Openfire 4.2.x

19

I want to try this upgrade just for fun to see what happens. I might give it a go tonight after I get some others stuff done.