AnsweredAssumed Answered

upgrade from 3.6.3 on Windows to 4.1.5 on Linux - Oracle DB

Question asked by Prem S on Aug 24, 2017

how do I go about upgrading openfire from 3..6.3 instance on windows to  4.1.5 Linux

 

0. exported data from current DB to new Oracle DB server/instance

1.  installed a fresh copy of openfire 4.1.5 on Linux,

2. setup Linux to connect to new DB instance/server, authenticate to LDAP, matching my 3.6.3 server

3. confirmed that the schema got updated to the latest 25 version

 

restarted server and it fails with a DB error

 

2017.08.24 16:02:31 org.jivesoftware.openfire.muc.spi.MUCPersistenceManager - A database error prevented MUC rooms to be loaded from the database.

java.sql.SQLRecoverableException: Closed Connection: next

        at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:547)

        at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadHistory(MUCPersiste nceManager.java:591)

        at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPers istenceManager.java:471)

        at org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl.start(MultiUserChatS erviceImpl.java:1287)

        at org.jivesoftware.openfire.component.InternalComponentManager.addComponent(Inter nalComponentManager.java:159)

        at org.jivesoftware.openfire.muc.MultiUserChatManager.registerMultiUserChatService (MultiUserChatManager.java:161)

        at org.jivesoftware.openfire.muc.MultiUserChatManager.start(MultiUserChatManager.j ava:112)

        at org.jivesoftware.openfire.XMPPServer.startModules(XMPPServer.java:561)

        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:430)

        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:163)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessor Impl.java:62)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

        at java.lang.Class.newInstance(Class.java:442)

        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)

        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)

        at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:60)

:                                                                                               472,2

Outcomes