Kontalk JDBC Error while starting the server

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!

From what I can see in tigase.db.DBInitException: Problem initializing jdbc connection:, I would guess your database simply isn’t running.

On that note, you just leaked the IP, port, database username and database password. You probably want to change that.

I believe you didn’t run (or there was a problem when tried to run) the Tigase script for creating the database objects. Please refer to this page: there is a link pointing to Tigase docs for running their scripts, then you have to import the four SQL scripts for Kontalk objects.

I know that this procedure is a bit unclear because of discrepancies between our docs and Tigase docs. I’ll update our documentation to include the actual commands (they’ll be pretty much a copy of the commands executed here).

I’ve just added those commands in the local server howto. Check them out! :slight_smile: