Hello,
When I start the kontalk server I am getting JDBC Error. Here is the complete log as follows:
STARTED Tigase Fri Mar 31 22:49:54 MST 2017
OpenJDK 64-Bit Server VM warning: ignoring option PermSize=32m; support was removed in 8.0
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.xml.XMLUtils}
componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.util.ClassUtil}
componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.server.XMPPServer}
2017-03-31 22:49:54.396 [main] ConfiguratorAbstract.parseArgs() CONFIG: Setting defaults: --property-file = etc/init.properties
2017-03-31 22:49:54.415 [main] ConfiguratorAbstract.parseArgs() CONFIG: Loading initial properties from property file: etc/init.properties
2017-03-31 22:49:54.416 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--s2s-ports=5269)
2017-03-31 22:49:54.417 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--vhost-anonymous-enabled=false)
2017-03-31 22:49:54.417 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-5=org.kontalk.xmppserver.KontalkLegacyPushComponent)
2017-03-31 22:49:54.417 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-4=org.kontalk.xmppserver.ExtendedAddressing)
2017-03-31 22:49:54.417 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-3=tigase.server.ext.ComponentProtocol)
2017-03-31 22:49:54.418 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-2=org.kontalk.xmppserver.probe.ProbeComponent)
2017-03-31 22:49:54.418 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-1=org.kontalk.xmppserver.NetworkComponent)
2017-03-31 22:49:54.418 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (config-type=--gen-config-def)
2017-03-31 22:49:54.418 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--external=media.prime.kontalk.net:secret:listen:5270)
2017-03-31 22:49:54.418 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--user-db-uri=jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false)
2017-03-31 22:49:54.419 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--c2s-ports=5999,5222,5223,8443)
2017-03-31 22:49:54.419 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--virt-hosts=greatdiscountsavings.com)
2017-03-31 22:49:54.419 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-4=multicast)
2017-03-31 22:49:54.419 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-3=ext)
2017-03-31 22:49:54.419 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-2=probe)
2017-03-31 22:49:54.420 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--hardened-mode=true)
2017-03-31 22:49:54.420 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-1=network)
2017-03-31 22:49:54.420 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--debug-packages=org.kontalk)
2017-03-31 22:49:54.420 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--user-db=mysql)
2017-03-31 22:49:54.420 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--sm-plugins=-amp,-message-carbons,-jabber:iq:auth,-jabber:iq:register,-jabber:iq:privacy,-jabber:iq:last,-msgoffline,-urn:xmpp:blocking,-urn:xmpp:csi:0,+message,+msgoffline2,+presence:urn:xmpp:pubkey:2,+kontalk:push:legacy,+kontalk:jabber:iq:roster,+urn:xmpp:pubkey:2,+kontalk:urn:xmpp:blocking,+kontalk:urn:xmpp:csi:0,+kontalk:jabber:iq:last)
2017-03-31 22:49:54.421 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--admins=admin@greatdiscountsavings.com)
2017-03-31 22:49:54.421 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--debug=server,xmpp.impl)
2017-03-31 22:49:54.421 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--vhost-tls-required=false)
2017-03-31 22:49:54.429 [main] DNSResolverDefault.<init>() WARNING: Resolving default host name: cweb01.nityainc.com took: 3
2017-03-31 22:49:54.446 [main] AbstractMessageReceiver.setMaxQueueSize() FINEST: message-router maxQueueSize: 466, maxInQueueSize: 28, maxOutQueueSize: 932
2017-03-31 22:49:54.449 [main] MessageRouter.addRegistrator() INFO: Adding registrator: Configurator
2017-03-31 22:49:54.449 [main] MessageRouter.addComponent() INFO: Adding component:
2017-03-31 22:49:54.449 [main] ConfiguratorAbstract.componentAdded() CONFIG: component: basic-conf
2017-03-31 22:49:54.449 [main] ConfiguratorAbstract.setup() CONFIG: Setting up component: basic-conf
2017-03-31 22:49:55.905 [main] ConfiguratorAbstract.setup() CONFIG: Component basic-conf defaults: {component-id=basic-conf@cweb01.nityainc.com, def-hostname=cweb01.nityainc.com, admins=[Ljava.lang.String;@3b24087d, scripts-dir=scripts/admin, command/ALL=ADMIN, logging/.level=CONFIG, logging/handlers=java.util.logging.ConsoleHandler java.util.logging.FileHandler, logging/java.util.logging.ConsoleHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.ConsoleHandler.level=WARNING, logging/java.util.logging.FileHandler.append=true, logging/java.util.logging.FileHandler.count=5, logging/java.util.logging.FileHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.FileHandler.limit=10000000, logging/java.util.logging.FileHandler.pattern=logs/tigase.log, logging/tigase.useParentHandlers=true, logging/java.util.logging.FileHandler.level=ALL, logging/tigase.server.level=ALL, logging/tigase.xmpp.impl.level=ALL, logging/org.kontalk.level=ALL, user-domain-repo-pool=tigase.db.UserRepositoryMDImpl, auth-domain-repo-pool=tigase.db.AuthRepositoryMDImpl, user-repo-pool-size=32, data-repo-pool-size=32, user-repo-class=mysql, user-repo-url=jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false, auth-repo-class=tigase.db.jdbc.TigaseCustomAuth, auth-repo-url=jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false, ssl-container-class=tigase.io.jdk18.SNISSLContextContainer, ssl-certs-location=certs/, ssl-def-cert-domain=default, config-dump-file=etc/config-dump.properties}
2017-03-31 22:49:55.906 [main] ConfiguratorAbstract.setup() CONFIG: Component basic-conf configuration: {auth-repo-params/sasl-mechs=EXTERNAL, component-id=basic-conf@cweb01.nityainc.com, def-hostname=cweb01.nityainc.com, admins=[Ljava.lang.String;@3b24087d, scripts-dir=scripts/admin, command/ALL=ADMIN, logging/.level=CONFIG, logging/handlers=java.util.logging.ConsoleHandler java.util.logging.FileHandler, logging/java.util.logging.ConsoleHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.ConsoleHandler.level=WARNING, logging/java.util.logging.FileHandler.append=true, logging/java.util.logging.FileHandler.count=5, logging/java.util.logging.FileHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.FileHandler.limit=10000000, logging/java.util.logging.FileHandler.pattern=logs/tigase.log, logging/tigase.useParentHandlers=true, logging/java.util.logging.FileHandler.level=ALL, logging/tigase.server.level=ALL, logging/tigase.xmpp.impl.level=ALL, logging/org.kontalk.level=ALL, user-domain-repo-pool=tigase.db.UserRepositoryMDImpl, auth-domain-repo-pool=tigase.db.AuthRepositoryMDImpl, user-repo-pool-size=32, data-repo-pool-size=32, user-repo-class=mysql, user-repo-url=jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false, auth-repo-class=tigase.db.jdbc.TigaseCustomAuth, auth-repo-url=jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false, ssl-container-class=tigase.io.jdk18.SNISSLContextContainer, ssl-certs-location=certs/, ssl-def-cert-domain=default, config-dump-file=etc/config-dump.properties}
2017-03-31 22:49:55.906 [main] ConfiguratorAbstract.itemUpdated() INFO: Updating configuration item: basic-conf/auth-repo-params/sasl-mechs=EXTERNAL
2017-03-31 22:49:55.906 [main] ConfiguratorAbstract.setProperties() INFO: Propeties size is 1, and here are all propeties: {auth-repo-params/sasl-mechs=EXTERNAL}
2017-03-31 22:49:56.395 [main] ConfiguratorAbstract.setProperties() SEVERE: Can't initialize user default repository:
tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:627)
at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java:672)
at tigase.conf.ConfiguratorAbstract.addUserRepo(ConfiguratorAbstract.java:888)
at tigase.conf.ConfiguratorAbstract.setProperties(ConfiguratorAbstract.java:817)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:138)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:644)
at tigase.server.XMPPServer.start(XMPPServer.java:142)
at tigase.server.XMPPServer.main(XMPPServer.java:112)
Caused by: java.sql.SQLSyntaxErrorException: FUNCTION greatdis_tigase.TigGetDBProperty does not exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java:1060)
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:591)
at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java:672)
at tigase.conf.ConfiguratorAbstract.addUserRepo(ConfiguratorAbstract.java:888)
at tigase.conf.ConfiguratorAbstract.setProperties(ConfiguratorAbstract.java:817)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:138)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:644)
at tigase.server.XMPPServer.start(XMPPServer.java:142)
at tigase.server.XMPPServer.main(XMPPServer.java:112)
2017-03-31 22:49:56.910 [main] UserRepositoryMDImpl.userExists() WARNING: Couldn't obtain user repository for domain: vhost-manager, not even default one!
2017-03-31 22:49:56.910 [main] UserRepositoryMDImpl.addUser() WARNING: Couldn't obtain user repository for domain: vhost-manager, not even default one!
2017-03-31 22:49:56.911 [main] UserRepositoryMDImpl.addUser() WARNING: Couldn't obtain user repository for domain: vhost-manager, not even default one!
2017-03-31 22:49:56.911 [main] UserRepositoryMDImpl.getData() WARNING: Couldn't obtain user repository for domain: vhost-manager, not even default one!
2017-03-31 22:49:56.911 [main] VHostManager.setProperties() WARNING: {greatdiscountsavings.com=Domain: greatdiscountsavings.com, enabled: true, anonym: false, register: true, maxusers: 0, tls: false, s2sSecret: 60c2f581-f69a-42ba-a1fa-7f8e7c45d09f, domainFilter: ALL, domainFilterDomains: null, c2sPortsAllowed: null, saslAllowedMechanisms: null}
2017-03-31 22:49:56.911 [main] UserRepositoryMDImpl.getData() WARNING: Couldn't obtain user repository for domain: vhost-manager, not even default one!
2017-03-31 22:49:56.973 [main] ConnectionManager.setProperties() WARNING: c2s last_minute_packets_limit = 2500
2017-03-31 22:49:56.973 [main] ConnectionManager.setProperties() WARNING: c2s total_packets_limit = 0
2017-03-31 22:49:56.973 [main] ConnectionManager.setProperties() WARNING: c2s last_minute_bin_limit = 20971520
2017-03-31 22:49:56.973 [main] ConnectionManager.setProperties() WARNING: c2s total_bin_limit = 0
Loading component: c2s :: componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.server.xmppclient.ClientConnectionManager}
Loading component: eventbus :: componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.disteventbus.component.EventBusComponent}
2017-03-31 22:49:57.020 [main] ConnectionManager.setProperties() WARNING: ext last_minute_packets_limit = 26214400
2017-03-31 22:49:57.020 [main] ConnectionManager.setProperties() WARNING: ext total_packets_limit = 0
2017-03-31 22:49:57.020 [main] ConnectionManager.setProperties() WARNING: ext last_minute_bin_limit = 20971520000
2017-03-31 22:49:57.020 [main] ConnectionManager.setProperties() WARNING: ext total_bin_limit = 0
2017-03-31 22:49:57.021 [main] UserRepositoryMDImpl.userExists() WARNING: Couldn't obtain user repository for domain: ext-comp-manager, not even default one!
2017-03-31 22:49:57.021 [main] UserRepositoryMDImpl.addUser() WARNING: Couldn't obtain user repository for domain: ext-comp-manager, not even default one!
2017-03-31 22:49:57.021 [main] UserRepositoryMDImpl.addUser() WARNING: Couldn't obtain user repository for domain: ext-comp-manager, not even default one!
2017-03-31 22:49:57.021 [main] UserRepositoryMDImpl.getData() WARNING: Couldn't obtain user repository for domain: ext-comp-manager, not even default one!
Loading component: ext :: componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.server.ext.ComponentProtocol}
2017-03-31 22:49:57.040 [main] ConfigRepository.setProperties() WARNING: Items list is not set in the configuration file!!
2017-03-31 22:49:57.040 [main] UserRepositoryMDImpl.userExists() WARNING: Couldn't obtain user repository for domain: tigase-monitor, not even default one!
2017-03-31 22:49:57.040 [main] UserRepositoryMDImpl.addUser() WARNING: Couldn't obtain user repository for domain: tigase-monitor, not even default one!
2017-03-31 22:49:57.040 [main] UserRepositoryMDImpl.addUser() WARNING: Couldn't obtain user repository for domain: tigase-monitor, not even default one!
2017-03-31 22:49:57.041 [main] UserRepositoryMDImpl.getData() WARNING: Couldn't obtain user repository for domain: tigase-monitor, not even default one!
2017-03-31 22:49:57.041 [main] MonitorComponent.setProperties() WARNING: Monitoring Tasks: {} with items: {}
2017-03-31 22:49:57.041 [main] UserRepositoryMDImpl.getData() WARNING: Couldn't obtain user repository for domain: tigase-monitor, not even default one!
Loading component: monitor :: componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.monitor.MonitorComponent}
Loading component: multicast :: componentInfo{Class=org.kontalk.xmppserver.ExtendedAddressing}
Loading component: network :: componentInfo{Class=org.kontalk.xmppserver.NetworkComponent}
2017-03-31 22:49:57.163 [main] MessageRouter.setProperties() WARNING: configuration of component probe failed - disabling component, error: unable to initialize user data repository
2017-03-31 22:49:59.284 [main] ConnectionManager.setProperties() WARNING: s2s last_minute_packets_limit = 15360
2017-03-31 22:49:59.284 [main] ConnectionManager.setProperties() WARNING: s2s total_packets_limit = 0
2017-03-31 22:49:59.284 [main] ConnectionManager.setProperties() WARNING: s2s last_minute_bin_limit = 125829120
2017-03-31 22:49:59.284 [main] ConnectionManager.setProperties() WARNING: s2s total_bin_limit = 0
Loading component: s2s :: componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.server.xmppserver.S2SConnectionManager}
2017-03-31 22:49:59.391 [main] DNSResolver.<clinit>() WARNING: Resolving default host name: cweb01.nityainc.com took: 1
Loading plugin: session-close=32:145 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: session-open=16:291 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: default-handler=32:145 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: urn:ietf:params:xml:ns:xmpp-sasl=32:145 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: urn:ietf:params:xml:ns:xmpp-bind=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: urn:ietf:params:xml:ns:xmpp-session=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: jabber:iq:roster=32:145 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: jabber:iq:version=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: http://jabber.org/protocol/stats=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: starttls=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: vcard-temp=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: http://jabber.org/protocol/commands=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: jabber:iq:private=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: urn:xmpp:ping=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: presence-state=32:145 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: presence-subscription=32:145 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: disco=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: zlib=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: vcard-xep-0292=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: urn:xmpp:time=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: message=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: msgoffline2=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
2017-03-31 22:50:00.053 [main] JDBCMsgRepository.initRepository() WARNING: Error initializing message repository
java.sql.SQLException: Can't create table 'greatdis_tigase.messages' (errno: 150)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1603)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2632)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1529)
at tigase.db.jdbc.DataRepositoryImpl.checkTable(DataRepositoryImpl.java:146)
at tigase.db.DataRepositoryPool.checkTable(DataRepositoryPool.java:114)
at org.kontalk.xmppserver.messages.JDBCMsgRepository.checkDB(JDBCMsgRepository.java:202)
at org.kontalk.xmppserver.messages.JDBCMsgRepository.initRepository(JDBCMsgRepository.java:185)
at org.kontalk.xmppserver.messages.OfflineMessages.init(OfflineMessages.java:98)
at tigase.server.xmppsession.SessionManager.setProperties(SessionManager.java:929)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:115)
at tigase.server.MessageRouter.addRouter(MessageRouter.java:152)
at tigase.server.MessageRouter.setProperties(MessageRouter.java:745)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:138)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:644)
at tigase.server.XMPPServer.start(XMPPServer.java:142)
at tigase.server.XMPPServer.main(XMPPServer.java:112)
Loading plugin: kontalk:jabber:iq:roster=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: urn:xmpp:pubkey:2=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: kontalk:urn:xmpp:blocking=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: kontalk:urn:xmpp:csi:0=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
Loading plugin: kontalk:jabber:iq:last=8:582 ... , version: 7.1.0-b/48c47302 (2017-03-31/09:06:00)
2017-03-31 22:50:00.074 [main] SessionManager.setProperties() SEVERE: Problem initializing plugin: kontalk:jabber:iq:last
tigase.db.TigaseDBException: error initializing presence repository
at org.kontalk.xmppserver.presence.LastActivity.init(LastActivity.java:65)
at tigase.server.xmppsession.SessionManager.setProperties(SessionManager.java:929)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:115)
at tigase.server.MessageRouter.addRouter(MessageRouter.java:152)
at tigase.server.MessageRouter.setProperties(MessageRouter.java:745)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:138)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:644)
at tigase.server.XMPPServer.start(XMPPServer.java:142)
at tigase.server.XMPPServer.main(XMPPServer.java:112)
Caused by: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:mysql://66.226.73.49:3306/greatdis_tigase?user=greatdis_tigase&password=Tigase@123&useUnicode=true&characterEncoding=UTF-8&useSSL=false
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:627)
at org.kontalk.xmppserver.presence.JDBCPresenceRepository.initRepository(JDBCPresenceRepository.java:67)
at org.kontalk.xmppserver.presence.LastActivity.init(LastActivity.java:62)
at tigase.server.xmppsession.SessionManager.setProperties(SessionManager.java:929)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:115)
at tigase.server.MessageRouter.addRouter(MessageRouter.java:152)
at tigase.server.MessageRouter.setProperties(MessageRouter.java:745)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:138)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:644)
at tigase.server.XMPPServer.start(XMPPServer.java:142)
at tigase.server.XMPPServer.main(XMPPServer.java:112)
Caused by: java.sql.SQLSyntaxErrorException: FUNCTION greatdis_tigase.TigGetDBProperty does not exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java:1060)
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:591)
at org.kontalk.xmppserver.presence.JDBCPresenceRepository.initRepository(JDBCPresenceRepository.java:67)
at org.kontalk.xmppserver.presence.LastActivity.init(LastActivity.java:62)
at tigase.server.xmppsession.SessionManager.setProperties(SessionManager.java:929)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:115)
at tigase.server.MessageRouter.addRouter(MessageRouter.java:152)
at tigase.server.MessageRouter.setProperties(MessageRouter.java:745)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:519)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:152)
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:138)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:644)
at tigase.server.XMPPServer.start(XMPPServer.java:142)
at tigase.server.XMPPServer.main(XMPPServer.java:112)
Loading component: sess-man :: componentInfo{Title=Tigase XMPP Server, Version=7.1.0-b/48c47302 (2017-03-31/09:06:00), Class=tigase.server.xmppsession.SessionManager}
2017-03-31 22:50:00.128 [main] ConfigurationCache.store() WARNING: Dumping server configuration to: etc/config-dump.properties
== Fri Mar 31 22:50:00 MST 2017 Server finished starting up and (if there wasn't any error) is ready to use
2017-03-31 22:50:01.911 [hostnames] UserRepositoryMDImpl.getData() WARNING: Couldn't obtain user repository for domain: vhost-manager, not even default one!
