Project

General

Profile

Upgrade from 5.1 to 7.04 failed

Benno Benno
Added over 2 years ago

Hi,

I tried an upgrade from our old 5.1 tigase xmpp server to 7.04.

I did it this way:

unpack the archive with new version next to current one,

stop the old instance,

copy over configuration (etc/), certificates (certs/),

start new instance.

At tigase.log.0 I found the following errors:

2016-08-08 12:36:25.453 [main] DataRepositoryImpl.initRepository() SEVERE: null

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)

    at java.security.AccessController.doPrivileged(Native Method)

    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)

    at java.lang.ClassLoader.loadClass(ClassLoader.java:423)

    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)

    at java.lang.ClassLoader.loadClass(ClassLoader.java:356)

    at java.lang.Class.forName0(Native Method)

    at java.lang.Class.forName(Class.java:264)

    at tigase.db.jdbc.DataRepositoryImpl.initRepository(DataRepositoryImpl.java:262)

    at tigase.db.RepositoryFactory.getDataRepository(RepositoryFactory.java:458)

    at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:575)

    at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java:660)

    at tigase.server.sreceiver.StanzaReceiver.setProperties(StanzaReceiver.java:572)

    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:540)

    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:177)

    at tigase.conf.Configurator.componentAdded(Configurator.java:50)

    at tigase.conf.Configurator.componentAdded(Configurator.java:33)

    at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)

    at tigase.server.MessageRouter.addComponent(MessageRouter.java:108)

    at tigase.server.MessageRouter.addRouter(MessageRouter.java:145)

    at tigase.server.MessageRouter.setProperties(MessageRouter.java:704)

    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:540)

    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:177)

    at tigase.conf.Configurator.componentAdded(Configurator.java:50)

    at tigase.conf.Configurator.componentAdded(Configurator.java:33)

    at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)

    at tigase.server.MessageRouter.addRegistrator(MessageRouter.java:131)

    at tigase.server.MessageRouter.setConfig(MessageRouter.java:603)

    at tigase.server.XMPPServer.start(XMPPServer.java:142)

    at tigase.server.XMPPServer.main(XMPPServer.java:112)

2016-08-08 12:36:25.454 [main] DataRepositoryImpl.initRepository() INFO: Table schema found: tigase, database type: mysql, database driver: com.mysql.jdbc.Driver

2016-08-08 12:36:25.454 [main] StanzaReceiver.setProperties() SEVERE: Can't initialize repository:

tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:mysql://localhost/tigase?user=tigase&password=*****

    at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:612)

    at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java:660)

    at tigase.server.sreceiver.StanzaReceiver.setProperties(StanzaReceiver.java:572)

    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:540)

    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:177)

    at tigase.conf.Configurator.componentAdded(Configurator.java:50)

    at tigase.conf.Configurator.componentAdded(Configurator.java:33)

    at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)

    at tigase.server.MessageRouter.addComponent(MessageRouter.java:108)

    at tigase.server.MessageRouter.addRouter(MessageRouter.java:145)

    at tigase.server.MessageRouter.setProperties(MessageRouter.java:704)

    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:540)

    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:177)

    at tigase.conf.Configurator.componentAdded(Configurator.java:50)

    at tigase.conf.Configurator.componentAdded(Configurator.java:33)

    at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)

    at tigase.server.MessageRouter.addComponent(MessageRouter.java:108)

    at tigase.server.MessageRouter.addRouter(MessageRouter.java:145)

    at tigase.server.MessageRouter.setProperties(MessageRouter.java:704)

    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:540)

    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:177)

    at tigase.conf.Configurator.componentAdded(Configurator.java:50)

    at tigase.conf.Configurator.componentAdded(Configurator.java:33)

    at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)

    at tigase.server.MessageRouter.addRegistrator(MessageRouter.java:131)

    at tigase.server.MessageRouter.setConfig(MessageRouter.java:603)

    at tigase.server.XMPPServer.start(XMPPServer.java:142)

    at tigase.server.XMPPServer.main(XMPPServer.java:112)

Will I have to update the schema or something?


Replies (1)

Added by Daniel Wisnewski IoT 1 Cloud over 2 years ago

Hi Benno,

Your schemas should be fine as we did not change them until v7.1.0. It looks like Tigase does not have the right directory for the jdbc files. The libs directory was changed to jars, so adjust your init.properties to use that folder instead. Alternatively you could copy the contents of the jars folder to the libs folder, that should fix this error. Be sure to scour the logs file for any instances where you are using depreciated names for components and methods, there were a lot of changes between 5.1 and v7.

    (1-1/1)