Project

General

Profile

schema version is not loaded in the database or it is old!

wang xiaohui
Added 8 months ago

i install 8.0 with some error

=============================================================================
ERROR! Component server (JDBCRepository) schema version is not loaded in the database or it is old!
Required version: 0.0.0
Please upgrade the installation by running:
$ ./scripts/tigase.sh upgrade-schema etc/tigase.conf
=============================================================================


Replies (21)

Added by Chirs Chan 8 months ago

I also encountered this problem today. I haven’t found a solution for a long time. (┬_┬)

Added by Andrzej Wójcik IoT 1 CloudTigaseTeam 8 months ago

What steps did you follow during installation of Tigase XMPP Server? Were you using web installer? or you were installing it in some other way?

Added by Chirs Chan 8 months ago

I installed it with the latest version of Windows, it automatically created a database, and then I started through the source code, and copy the configuration content of the init.properties in windows to the source code of init-mysql.properties.

Is it caused by the inconsistency between the windows version and the source version? I have no idea...

this is my console information:

D:\MyDevelop\JDK8\jre\bin\java -Dfile.encoding=UTF-8 -Dsun.jnu.encoding=UTF-8 -Djdbc.drivers=com.mysql.jdbc.Driverrg.postgresql.Driverrg.apache.derby.jdbc.EmbeddedDriver -server -Xms100M -Xmx200M -XX:MaxDirectMemorySize=128m "-javaagent:D:\IDE\IntelliJ IDEA 2017.3.3\lib\idea_rt.jar=53905:D:\IDE\IntelliJ IDEA 2017.3.3\bin" -classpath D:\MyDevelop\JDK8\jre\lib\charsets.jar;D:\MyDevelop\JDK8\jre\lib\deploy.jar;D:\MyDevelop\JDK8\jre\lib\ext\access-bridge-64.jar;D:\MyDevelop\JDK8\jre\lib\ext\cldrdata.jar;D:\MyDevelop\JDK8\jre\lib\ext\dnsns.jar;D:\MyDevelop\JDK8\jre\lib\ext\jaccess.jar;D:\MyDevelop\JDK8\jre\lib\ext\jfxrt.jar;D:\MyDevelop\JDK8\jre\lib\ext\localedata.jar;D:\MyDevelop\JDK8\jre\lib\ext\nashorn.jar;D:\MyDevelop\JDK8\jre\lib\ext\sunec.jar;D:\MyDevelop\JDK8\jre\lib\ext\sunjce_provider.jar;D:\MyDevelop\JDK8\jre\lib\ext\sunmscapi.jar;D:\MyDevelop\JDK8\jre\lib\ext\sunpkcs11.jar;D:\MyDevelop\JDK8\jre\lib\ext\zipfs.jar;D:\MyDevelop\JDK8\jre\lib\javaws.jar;D:\MyDevelop\JDK8\jre\lib\jce.jar;D:\MyDevelop\JDK8\jre\lib\jfr.jar;D:\MyDevelop\JDK8\jre\lib\jfxswt.jar;D:\MyDevelop\JDK8\jre\lib\jsse.jar;D:\MyDevelop\JDK8\jre\lib\management-agent.jar;D:\MyDevelop\JDK8\jre\lib\mysql-connector-java-5.1.46-bin.jar;D:\MyDevelop\JDK8\jre\lib\mysql-connector-java-5.1.46.jar;D:\MyDevelop\JDK8\jre\lib\mysql-connector-java.jar;D:\MyDevelop\JDK8\jre\lib\plugin.jar;D:\MyDevelop\JDK8\jre\lib\resources.jar;D:\MyDevelop\JDK8\jre\lib\rt.jar;D:\IDE\IdeaWorkSpace\startByResource\tigase-server-master\server\target\classes;C:\Users\chent.m2\repository\tigase\tigase-utils\4.0.0-SNAPSHOT\tigase-utils-4.0.0-20180327.024755-107.jar;C:\Users\chent.m2\repository\tigase\tigase-xmltools\4.0.0-SNAPSHOT\tigase-xmltools-4.0.0-20180327.024708-163.jar tigase.server.XMPPServer --property-file server/etc/init-mysql.properties
componentInfo{Title=Tigase XML Tools, Version=4.0.0-SNAPSHOT-b262/92c6bcf6(2018-03-27/02:46:40), Class=tigase.xml.XMLUtils}
componentInfo{Title=Tigase Utils, Version=4.0.0-SNAPSHOT-b367/4ca7dd6c(2018-03-27/02:47:28), Class=tigase.util.ClassUtil}
componentInfo{Class=tigase.server.XMPPServer}
三月 28, 2018 5:54:11 下午 tigase.conf.ConfiguratorAbstract parseArgs
配置: Setting defaults: --property-file = server/etc/init-mysql.properties
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Loading initial properties from property file: server\etc\init-mysql.properties
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--cluster-mode=true)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (config-type=--gen-config-def)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--debug=server,xmpp.impl,db)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--user-db=mysql)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--admins=admin@DESKTOP-EKRRI4F,admin@192.168.30.46)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--user-db-uri=jdbc:mysql://localhost/tigasedb?user=tigase&password=tigase12&autoReconnect=true&useUnicode=true&characterEncoding=utf8&mysqlEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--virt-hosts=DESKTOP-EKRRI4F)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-name-4=message-archive)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-class-4=tigase.archive.MessageArchiveComponent)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-name-3=proxy)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-class-3=tigase.socks5.Socks5ProxyComponent)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-name-2=pubsub)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-class-2=tigase.pubsub.PubSubComponent)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-class-1=tigase.muc.MUCComponent)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--comp-name-1=muc)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
配置: Added default config parameter: (--sm-plugins=+message-archive-xep-0136,+jabber:iq:auth,+urn:ietf:params:xml:ns:xmpp-sasl,+urn:ietf:params:xml:ns:xmpp-bind,+urn:ietf:params:xml:ns:xmpp-session,+jabber:iq:register,+jabber:iq:roster,+presence,+jabber:iq:privacy,+jabber:iq:version,+http://jabber.org/protocol/stats,+starttls,+msgoffline,+vcard-temp,+http://jabber.org/protocol/commands,+jabber:iq:private,+urn:xmpp:ping,+basic-filter,+domain-filter,+pep,-zlib)
三月 28, 2018 5:54:12 下午 tigase.conf.ConfiguratorAbstract loadFromPropertiesFiles
警告: Tigase cache turned off
三月 28, 2018 5:54:14 下午 tigase.util.dns.DNSResolverDefault
警告: Resolving default host name: desktop-ekrri4f took: 10
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder lambda$convertFromOldFormat$43
警告: could not find class for processor message-archive-xep-0136
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder lambda$convertFromOldFormat$43
警告: could not find class for processor presence
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder lambda$convertFromOldFormat$43
警告: could not find class for processor basic-filter
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder lambda$convertFromOldFormat$43
警告: could not find class for processor pep
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder logOutput
配置: Existing DSL config file server\etc\config.tdsl was renamed to server\etc\config.tdsl.old as conversion from property files was started.
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder logOutput
配置: Configuration files server\etc\init-mysql.properties were updated to DSL configuration format and saved as server\etc\config.tdsl.
三月 28, 2018 5:54:14 下午 tigase.conf.OldConfigHolder logOutput
配置: Old configuration file server\etc\init-mysql.properties was renamed to server\etc\init-mysql.properties.old.
三月 28, 2018 5:54:14 下午 tigase.conf.ConfigHolder loadFromDSLFiles
配置: Loading configuration from file: server\etc\config.tdsl
三月 28, 2018 5:54:14 下午 tigase.vhosts.VHostItem initFromPropertyString
详细: Initialized from property string: Domain: desktop-ekrri4f, enabled: true, anonym: true, register: true, maxusers: 0, tls: false, s2sSecret: 8879a27e-1af9-48f5-8ede-5319a55b1bb9, domainFilter: ALL, domainFilterDomains: null, c2sPortsAllowed: null, saslAllowedMechanisms: null
三月 28, 2018 5:54:14 下午 tigase.vhosts.VHostItem initFromPropertyString
详细: Initialized from property string: Domain: 192.168.30.46, enabled: true, anonym: true, register: true, maxusers: 0, tls: false, s2sSecret: 27217e96-467b-4f44-96a4-3f26854e4a48, domainFilter: ALL, domainFilterDomains: null, c2sPortsAllowed: null, saslAllowedMechanisms: null
三月 28, 2018 5:54:14 下午 tigase.conf.ConfigHolder loadConfiguration
配置: Configuration file server\etc\config.tdsl was updated to match current format. Previous version of configuration file was saved as server\etc\config.tdsl.old.1
三月 28, 2018 5:54:14 下午 tigase.conf.ConfigHolder loadConfiguration
配置: Loaded configuration:
admins = [ 'admin@DESKTOP-EKRRI4F', 'admin@192.168.30.46' ]
'cluster-mode' = true
'config-type' = 'default'
debug = [ 'server', 'xmpp.impl', 'db' ]
dataSource {
default () {
uri = 'jdbc:mysql://localhost/tigasedb?user=tigase&password=tigase12&autoReconnect=true&useUnicode=true&characterEncoding=utf8&mysqlEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false'
}
}
userRepository {
default () {}
}
authRepository {
default () {}
}
'message-archive' (class: tigase.archive.MessageArchiveComponent) {}
muc (class: tigase.muc.MUCComponent) {}
proxy (class: tigase.socks5.Socks5ProxyComponent) {}
pubsub (class: tigase.pubsub.PubSubComponent) {}
'sess-man' () {
'basic-filter' () {}
'domain-filter' () {}
'http:' {}
'jabber:iq:auth' () {}
'jabber:iq:privacy' () {}
'jabber:iq:private' () {}
'jabber:iq:register' () {}
'jabber:iq:roster' () {}
'jabber:iq:version' () {}
'message-archive-xep-0136' () {}
msgoffline () {}
pep () {}
presence () {}
starttls () {}
'urn:ietf:params:xml:ns:xmpp-bind' () {}
'urn:ietf:params:xml:ns:xmpp-sasl' () {}
'urn:ietf:params:xml:ns:xmpp-session' () {}
'urn:xmpp:ping' () {}
'vcard-temp' () {}
zlib (active: false) {}
}
'virtual-hosts' {
'192.168.30.46' {
anonymous = true
'domain-filter' = ALL
enabled = true
'max-users' = 0L
register = true
's2s-secret' = '27217e96-467b-4f44-96a4-3f26854e4a48'
}
'desktop-ekrri4f' {
anonymous = true
'domain-filter' = ALL
enabled = true
'max-users' = 0L
register = true
's2s-secret' = '8879a27e-1af9-48f5-8ede-5319a55b1bb9'
}
}

2018-03-28 17:54:14.874 [main] Bootstrap.start() WARNING: Tigase cache turned off

=============================================================================
ERROR! Component server (JDBCRepository) schema version is not loaded in the database or it is old!
Required version: 0.0.0
Please upgrade the installation by running:
$ ./scripts/tigase.sh upgrade-schema etc/tigase.conf
=============================================================================

ShutdownThread started... 2018-03-28T17:54:17.775

Total number of threads: 12
No locked threads.

Save thread-dump to file: logs/thread-dump.log, size: 5621
ShutdownThread finished...

Process finished with exit code 1

Added by Andrzej Wójcik IoT 1 CloudTigaseTeam 8 months ago

From what I can see, the latest version of Tigase XMPP Server installer for windows is for version 7.1.4, while you are trying to run version 8.0.0. If you tried to "install" Tigase XMPP Server 8.0.0 using Tigase XMPP Server 7.1.4 installation package and replacing files then you failed because you tried to do something that is not supported. If you installed version 7.1.4 with windows installer then you need to follow upgrade procedure for Tigase XMPP Server 8.0.0 which is described in Tigase XMPP Server documentation at http://docs.tigase.org/ (look for Tigase XMPP Server and SNAPSHOT as a version).

As of version 8.0.0 we will no longer provide an installer for Windows. Instead, our documentation provides you with detailed description of installation procedure on Windows, see http://docs.tigase.org/tigase-server/snapshot/Administration_Guide/html/#windowsInstallation

Added by Chirs Chan 8 months ago

First of all thank you for your answer!I really did not realize this problem. I am directly cloning a project from git above. And I found through your answers that this is probably the cause of the problem. I will now go and see what is happening.

Forgive my poor English,Thank you very much!

Added by wang xiaohui 8 months ago

probbly it is the error with datebase create

i create datebase from mysql use the sql
////////////////////////////

drop database if exists tigasedb8;

create database if not exists tigasedb8;

GRANT ALL ON tigasedb8.* TO root@'%' IDENTIFIED BY 'root';

GRANT ALL ON tigasedb8.* TO root@'localhost' IDENTIFIED BY 'wang6727';

GRANT ALL ON tigasedb8.* TO root IDENTIFIED BY 'wang6727';

GRANT SELECT, INSERT, UPDATE ON mysql.proc TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE ON mysql.proc TO 'root'@'%';

GRANT SELECT, INSERT, UPDATE ON mysql.proc TO 'root';
FLUSH PRIVILEGES;

use tigasedb8;

source database\mysql-server-8.0.0.sql;

//////////////

then i find the table of datebase lost

Added by Wojciech Kapcia TigaseTeam 8 months ago

To install schema please use internal Tiagse utility described in:
http://docs.tigase.org/tigase-server/snapshot/Administration_Guide/html_chunk/databasePreperation.html#dbSchemaLoader

In principle you should call:

./scripts/tigase.sh install-schema etc/tigase.conf [options]

Added by Chirs Chan 8 months ago

I upgraded the database on liunx. I think it should be successful. You can look at the screenshots. Then I copied the configuration file to the local source etc, and tried to start the source code.Connect to this upgraded database. However, it still reports an error. The error is the same as before. This confused me.What should I do?

Added by Chirs Chan 8 months ago

Although I got an error, I could run it. However, after successfully registering with smack, the user found that there was no user data in the database, and therefore he could not log in. Where can I get the v7.1.3 source code?

Added by wang xiaohui 8 months ago

install-schema error

123.png (46.7 KB) 123.png

Added by Wojciech Kapcia TigaseTeam 8 months ago

Chirs Chan wrote:

I upgraded the database on liunx. I think it should be successful. You can look at the screenshots. Then I copied the configuration file to the local source etc, and tried to start the source code.Connect to this upgraded database. However, it still reports an error. The error is the same as before. This confused me.What should I do?

Please don't post images with the log entries as they make it more difficult to process the information.

After looking at the error it looks like the upgrade was correct, but because you are running your own build the required version reported by the application is not identified correctly ("Required version: 0.0.0") which causes the problem.

I would recommend running the server from the provided binaries, and if you wan't do develop with Tigase you can build the server binary, deploy it and then connect the debugger remotely.

Chirs Chan wrote:

Although I got an error, I could run it. However, after successfully registering with smack, the user found that there was no user data in the database, and therefore he could not log in. Where can I get the v7.1.3 source code?

The sources are in the same repository in the stable branch: $ git checkout stable.

wang xiaohui wrote:

install-schema error

This issue is separate - it's usually better submit separate forum thread.

As for the issue - please read the documentation and please use provided binaries. It looks like you are mixing a lot of things and you don't have all binaries available. You should also use ./scripts.sh install-schema etc/tigase.org to install schema -- please refer to the documentation for more information or use provided web-based installer.

Added by w xy 3 months ago

I did that: git clone sources, removed src exclude java , for using mongodb database, i make a file named 'init.properties', the content like this:


config-type=--gen-config-def
--admins=10005@192.168.0.31
--virt-hosts =192.168.0.31
#,114.119.6.150,www.youjob.co
--debug= net

jars D:\Workspace\git\net_tigase-server\jars

##客户端连接时的端口号
##--c2s-ports=5222,5223
##服务器连接时的端口号(集群时)
##--s2s-ports=5224,5225

##mongodb://[username:password@]host1[:port1][,host2[:port2],
##...[,hostN[:portN]]][/[database][?options]]
--user-db=tigase.mongodb.MongoRepository
--auth-db=tigase.mongodb.MongoRepository
#--user-db-uri=mongodb://192.168.0.199:27017/tigase
--user-db-uri=mongodb://192.168.97.132:27017/tigase

#imapi数据库配置
##刷新用户在线状态 1:true else :false
--refresh-user-status=1
##关键词过滤功能 1:打开 0:关闭
--confirm-open-keyword=0
##imapi 的数据库链接 修改用户在线状态是用到
##mongodb://sysop:moon@localhost
#--api-db-uri=mongodb://192.168.0.199:27017/imapi
--api-db-uri=mongodb://192.168.97.132:27017/imapi
#--api-db-port=27017
#--api-db-port=imapi

--sm-plugins=-starttls,shiku-auto-reply,shiku-offline-msg,shiku-message-archive-plugin,jabber:iq:register

amp组件配置

#amp/amp-repo-uri=mongodb://192.168.0.199:27017/tigase
amp/amp-repo-uri=mongodb://192.168.97.132:27017/tigase
amp/amp-repo-class=tigase.mongodb.MongoMsgRepository

amp插件配置

#sess-man/plugins-conf/amp/amp-repo-uri=mongodb://192.168.0.199:27017/tigase
sess-man/plugins-conf/amp/amp-repo-uri=mongodb://192.168.97.132:27017/tigase
sess-man/plugins-conf/amp/amp-repo-class=tigase.mongodb.MongoMsgRepository

#--monitoring=jmx:9050

群聊组件

--comp-name-2=muc
--comp-class-2=tigase.muc.MUCComponent
muc/history-db=tigase.mongodb.muc.MongoHistoryProvider
#muc/history-db-uri=mongodb://192.168.0.199:27017/tigase
muc/history-db-uri=mongodb://192.168.97.132:27017/tigase
muc/shiku-room-db=tigase.shiku.db.MongoShikuMucRoomRepository
#muc/shiku-room-db-uri=mongodb://192.168.0.199:27017/imRoom
muc/shiku-room-db-uri=mongodb://192.168.97.132:27017/imRoom

--comp-name-3=shiku-message-archive
--comp-class-3=tigase.shiku.ShikuMessageArchiveComponent

客户端每隔一段时间(大概几十秒,每种客户端不一样)就会向服务器发tcp层保活包(带一个字节的数据)

##是否 开启根据 客户端发送的心跳包 检测 自动离线 0 关闭 1 开启
--xmpp-ping-open=0
##系统账号最大值 属于系统账号的 不需要 根据 心跳包关闭链接
--max-system-user=100200

遍历所有的连接,检查它们是否都真正的活着 间隔时间 毫秒 30000 即 30秒

--watchdog_delay=30000
--watchdog_ping_type=xmpp

毫秒 如果 客户端 超出该时间 未与服务端链接 50 秒 没有接收到心疼包 即 离线

--watchdog_timeout=50000
#shiku-message-archive/archive-repo-uri=mongodb://192.168.0.199:27017/tigase
shiku-message-archive/archive-repo-uri=mongodb://192.168.97.132:27017/tigase
shiku-message-archive/archive-repo-class=tigase.shiku.db.MongoShikuMessageArchiveRepository
shiku-message-archive/muc-msgs-split-method=year/month/day
shiku-message-archive/msgs-split-method=year/month/day

#插件参数配置
#消息存储
sess-man/plugins-conf/shiku-message-archive-plugin/component-jid=shiku-message-archive@192.168.0.31
#离线通知

sess-man/plugins-conf/shiku-offline-msg/shiku_PushUrl=http://192.168.0.31:8092/tigase/notify

and then I start with a method of main in the class of tigase.server.XMPPServer, the error has occured:

Connected to the target VM, address: '127.0.0.1:62948', transport: 'socket'
componentInfo{Title=Tigase XML Tools, Version=4.0.0-SNAPSHOT-b263/94f8b8cd(2018-08-15/02:47:07), Class=tigase.xml.XMLUtils}
componentInfo{Title=Tigase Utils, Version=4.0.0-SNAPSHOT-b374/1c509527(2018-08-07/08:44:49), Class=tigase.util.ClassUtil}
componentInfo{Class=tigase.server.XMPPServer}
Aug 16, 2018 10:24:42 PM tigase.conf.OldConfigHolder detectPathAndFormat
FINEST: No property file not specified! Using default one etc/init.properties
Aug 16, 2018 10:24:42 PM tigase.conf.OldConfigHolder detectPathAndFormat
FINEST: Provided property file /Users/wenxuyang/java-space/2018/tigase-server/server/etc/init.properties does NOT EXISTS! Trying to use default one etc/init.properties
Aug 16, 2018 10:24:42 PM tigase.conf.ConfigHolder loadFromDSLFiles
CONFIG: Loading configuration from file: etc/config.tdsl
Aug 16, 2018 10:24:42 PM tigase.conf.ConfigHolder loadConfiguration
CONFIG: Loaded configuration:
--api-db-uri = 'mongodb://192.168.97.132:27017/imapi'
--confirm-open-keyword = 0
--max-system-user = 100200
--refresh-user-status = 1
--xmpp-ping-open = 0
admins = [ '10005@192.168.0.31' ]
'config-type' = 'default'
debug = [ 'tigase' ]
'default-virtual-host' = '192.168.0.31'
'watchdog-ping-type' = 'xmpp'
'watchdog-timeout' = 30000
dataSource {
default () {
uri = 'mongodb://192.168.97.132:27017/tigase'
}
}
userRepository {
default () {
cls = 'tigase.mongodb.MongoRepository'
}
}
authRepository {
default () {
cls = 'tigase.mongodb.MongoRepository'
}
}
amp {
'amp-repo-class' = 'tigase.mongodb.MongoMsgRepository'
'amp-repo-uri' = 'mongodb://192.168.97.132:27017/tigase'
}
muc (class: tigase.muc.MUCComponent) {
'history-db' = 'tigase.mongodb.muc.MongoHistoryProvider'
'history-db-uri' = 'mongodb://192.168.97.132:27017/tigase'
'shiku-room-db' = 'tigase.shiku.db.MongoShikuMucRoomRepository'
'shiku-room-db-uri' = 'mongodb://192.168.97.132:27017/imRoom'
}
'sess-man' () {
amp {
'amp-repo-class' = 'tigase.mongodb.MongoMsgRepository'
'amp-repo-uri' = 'mongodb://192.168.97.132:27017/tigase'
}
'jabber:iq:register' () {}
'shiku-auto-reply' () {}
'shiku-message-archive-plugin' () {
'component-jid' = 'shiku-message-archive@192.168.0.31'
}
'shiku-offline-msg' () {
shiku_PushUrl = 'http://192.168.0.31:8092/tigase/notify'
}
starttls (active: false) {}
}
'shiku-message-archive' (class: tigase.shiku.ShikuMessageArchiveComponent) {
'archive-repo-class' = 'tigase.shiku.db.MongoShikuMessageArchiveRepository'
'archive-repo-uri' = 'mongodb://192.168.97.132:27017/tigase'
'msgs-split-method' = 'year/month/day'
'muc-msgs-split-method' = 'year/month/day'
}

Class name: org.groovy.debug.hotswap.ResetAgent$TimestampFieldRemover
java.lang.LinkageError: loader (instance of sun/misc/Launcher$AppClassLoader): attempted duplicate class definition for name: "org/groovy/debug/hotswap/ResetAgent$TimestampFieldRemover"
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at tigase.util.ClassUtil.getClassesFromNames(ClassUtil.java:176)
at tigase.util.ClassUtil.getClassesFromClassPath(ClassUtil.java:133)
at tigase.util.reflection.ClassUtilBean.initialize(ClassUtilBean.java:92)
at tigase.server.Bootstrap.start(Bootstrap.java:129)
at tigase.server.XMPPServer.start(XMPPServer.java:185)
at tigase.server.XMPPServer.main(XMPPServer.java:139)
2018-08-16 22:24:47.324 [main] DNSResolverDefault.() WARNING: Resolving default host name: wenxuyangs-macbook-pro.local took: 3

=============================================================================
ERROR! Component server-user (MongoRepository) schema version is not loaded in the database or it is old!
Required version: 0.0.0
Please upgrade the installation by running:
$ ./scripts/tigase.sh upgrade-schema etc/tigase.conf
=============================================================================

However, i exec the command of './scripts/tigase.sh upgrade-schema etc/tigase.conf', another error has occured:

TIGASE_HOME is not set or main binary (jars/tigase-server*.jar) was missing in ..... location

Please set it to correct value before starting the sever.

and then, i put the jar of tigase-server*.jar into the folder of jars, other error has occured:


Error: A JNI error has occurred, please check your installation and try again
Exception in thread "main" java.lang.NoClassDefFoundError: tigase/util/ui/console/CommandlineParameter
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Class.java:2701)
at java.lang.Class.privateGetMethodRecursive(Class.java:3048)
at java.lang.Class.getMethod0(Class.java:3018)
at java.lang.Class.getMethod(Class.java:1784)
at sun.launcher.LauncherHelper.validateMainClass(LauncherHelper.java:544)
at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:526)
Caused by: java.lang.ClassNotFoundException: tigase.util.ui.console.CommandlineParameter
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 7 more

at the last, i change the type of config-type in the config.tdsl into 'setup', so these is no error, like this:

Class name: org.groovy.debug.hotswap.ResetAgent$TimestampFieldRemover
2018-08-16 22:59:34.541 [main] AbstractBeanConfigurator.registerBeans() WARNING: unknown class null for bean sess-man, skipping registration of a bean
2018-08-16 22:59:34.587 [main] DNSResolverDefault.() WARNING: Resolving default host name: wenxuyangs-macbook-pro.local took: 8
Loading component: message-router :: componentInfo{Class=tigase.server.MessageRouter}
2018-08-16 22:59:34.708 [main] DSLBeanConfigurator.dumpConfiguration() WARNING: Dumping full server configuration to: etc/config-dump.properties

== 2018-08-16 22:59:34.937 Please setup server at http://localhost:8080/

but , the url of 'http://localhost:8080/' cannot be accessed . the error that these is a string of 'dial tcp 127.0.0.1:8080: connect: connection refused' has occured on the page.

Added by w xy 3 months ago

I solved this problem by adding the filed of 'schema-management' in the config.tdsl. like this :

dataSource {
    default () {
        uri = 'mongodb://192.168.97.132:27017/tigase'
        'schema-management' = false
    }
}

the Solution link is [[[https://docs.tigase.org/tigase-server/snapshot/Administration_Guide/html/#_using_modified_database_schema]]]

Added by Wojciech Kapcia TigaseTeam 3 months ago

Couple of general guidelines:

  • in version 8.0.0 you should use config.tdsl instead of init.properties
  • it's recommended to use our distribution builds
    • if you want to build your own binaries, please make user you clone/checkout the latest sources from matching branches!
  • for MongoDB there is no need to run upgrade-schema per se.

Added by Bill Lei 3 months ago

你好,可以交流tigase project技术开发吗。
我的QQ:9311914
谢谢。

Added by Wojciech Kapcia TigaseTeam 3 months ago

Bill Lei wrote:

你好,可以交流tigase project技术开发吗。

To allow the most people participate in conversation please do use English language.

Added by yong li 11 days ago

Wojciech Kapcia wrote:

Couple of general guidelines:

  • in version 8.0.0 you should use config.tdsl instead of init.properties
  • it's recommended to use our distribution builds
    • if you want to build your own binaries, please make user you clone/checkout the latest sources from matching branches!
  • for MongoDB there is no need to run upgrade-schema per se.

config.tdsl How do I use documents?

Added by Wojciech Kapcia TigaseTeam 11 days ago

I'm sorry I don't understand the question.
The documentation is available here: https://docs.tigase.net/tigase-server/snapshot/Administration_Guide/html/

Added by yong li 10 days ago

Wojciech Kapcia wrote:

Is the driver name of post-mysql 8.0 version changed from "com.mysql.jdbc.Driver" to "com.mysql.cj.jdbc.Driver" tigase considered supporting post-mysql 8.0 version?

Added by Wojciech Kapcia TigaseTeam 7 days ago

No, driver name hasn't hanged. And you don't have to specify driver name now.

    (1-21/21)