0 Replies Latest reply on Aug 25, 2017 8:09 AM by Prem S

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

    Prem S

      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