摘要：備份配置文件和數(shù)據(jù)庫導出原來的數(shù)據(jù)庫結構和數(shù)據(jù)備份配置文件升級配置文件執(zhí)行配置文件當出現(xiàn)如下畫面時配置文件以連接到數(shù)據(jù)庫。

備份配置文件和數(shù)據(jù)庫

導出原來的數(shù)據(jù)庫（結構和數(shù)據(jù)）

備份配置文件

cp ../tigase-server7.02/etc/tigase.conf etc/
cp ../tigase-server7.02/etc/init.properties etc/

升級配置文件
執(zhí)行配置文件./scripts/tigase.sh upgrade-config etc/tigase.conf
當出現(xiàn)如下畫面時

=============================================================================
    Configuration file etc/init.properties was converted to DSL format.
    Previous version of a configuration file was saved at etc/init.properties.old
=============================================================================

配置文件config.tdsl以連接到數(shù)據(jù)庫。

更新數(shù)據(jù)庫結構
./scripts/tigase.sh upgrade-schema etc/tigase.conf
Mysql數(shù)據(jù)庫必須5.7以上版本
成功之后，看到如下界面：

=============================================================================
    Schema upgrade finished

      Data source: default with uri
    jdbc:mysql://HOST/DATABASE?user=USERNAME&password=PASSWORD
    Checking connection to database ok
    Checking if database exists     ok
    Loading schema: Tigase XMPP Server (Core), version: 8.0.0       ok
    Loading schema: Tigase Message Archiving Component, version: 1.3.0      ok
    Loading schema: Tigase MUC Component, version: 2.5.0    ok
    Loading schema: Tigase PubSub Component, version: 3.3.0 ok
    Adding XMPP admin accounts      warning
            Message: Error: No admin users entered
    Post installation action        ok

=============================================================================

啟動運行

scripts/tigase.sh start etc/tigase.conf

遇到的問題

升級后，新增了tig_user_credentials表，需要針對原來認證方式存儲用戶密碼，sha1或者plain.，否則會出現(xiàn)無法登陸的問題。

存儲聊天記錄遇到的問題

先配置聊天記錄

message-archive {
  archive-repo-uri = "jdbc:mysql://localhost/tigasedb7?user=root&password=root",
  tags-support = true
  }
  sess-man {
  message-archive {
     default-store-method = "message",
     required-store-method = "body"
  }
  }

亂碼問題，修改如下即可解決。

   message-archive {
   archive-repo-uri = "jdbc:mysql://localhost/tigasedb7?user=root&password=root&useUnicode=true&characterEncoding=UTF-8",
   tags-support = true
  }

群消息無法推送，收到new room locked消息體，設置配置文件config.tdsl

  muc {
      "muc-lock-new-room" = false
  }