Project

General

Profile

the --cm-see-other-host use of

Moffitt tig
Added over 2 years ago

hi !

Use tigase7.1 version ,Add in the init.properties is as follows:

--cm-see-other-host=tigase.server.xmppclient.SeeOtherHostDB

Start the tigase Abnormal as follows:

2016-09-29 19:12:41.874 [main]             SeeOtherHostDB.setProperties()     SEVERE:   Cannot initialize connection to database: 
java.sql.SQLException: Can't create table `tigasedb710`.`tig_see_other_hosts` (errno: 150 "Foreign key constraint is incorrectly formed")
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)
    at tigase.db.jdbc.DataRepositoryImpl.checkTable(DataRepositoryImpl.java:144)
    at tigase.db.DataRepositoryPool.checkTable(DataRepositoryPool.java:113)
    at tigase.server.xmppclient.SeeOtherHostDB.checkDB(SeeOtherHostDB.java:205)
    at tigase.server.xmppclient.SeeOtherHostDB.initRepository(SeeOtherHostDB.java:180)
    at tigase.server.xmppclient.SeeOtherHostDB.setProperties(SeeOtherHostDB.java:167)
    at tigase.server.xmppclient.ClientConnectionManager.setProperties(ClientConnectionManager.java:621)
    at tigase.server.websocket.WebSocketClientConnectionManager.setProperties(WebSocketClientConnectionManager.java:83)
    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:543)
    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:179)
    at tigase.conf.Configurator.componentAdded(Configurator.java:50)
    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:1)
    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:698)
    at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:543)
    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:179)
    at tigase.conf.Configurator.componentAdded(Configurator.java:50)
    at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:1)
    at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)
    at tigase.server.MessageRouter.addRegistrator(MessageRouter.java:131)
    at tigase.server.MessageRouter.setConfig(MessageRouter.java:597)
    at tigase.server.XMPPServer.start(XMPPServer.java:142)
    at tigase.server.XMPPServer.main(XMPPServer.java:112)
Loading component: ws2s :: componentInfo{Class=tigase.cluster.WebSocketClientConnectionClustered}

This is why?

--cm-see-other-host What is the role of?

Thank you in advance!


Replies (1)

Added by Wojciech Kapcia TigaseTeam over 2 years ago

Moffitt tig wrote:

hi !

Use tigase7.1 version ,Add in the init.properties is as follows:

--cm-see-other-host=tigase.server.xmppclient.SeeOtherHostDB

Start the tigase Abnormal as follows:

[...]

This is why?

Thank you for the report - I've corrected the error and pushed the change to the repository.

--cm-see-other-host What is the role of?

Thank you in advance!

Please familiarize yourself with the documentation:

    (1-1/1)