摘要：備份配置文件和數(shù)據(jù)庫(kù)導(dǎo)出原來(lái)的數(shù)據(jù)庫(kù)結(jié)構(gòu)和數(shù)據(jù)備份配置文件升級(jí)配置文件執(zhí)行配置文件當(dāng)出現(xiàn)如下畫(huà)面時(shí)配置文件以連接到數(shù)據(jù)庫(kù)。

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

導(dǎo)出原來(lái)的數(shù)據(jù)庫(kù)（結(jié)構(gòu)和數(shù)據(jù)）

備份配置文件

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

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

=============================================================================
    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ù)庫(kù)。

更新數(shù)據(jù)庫(kù)結(jié)構(gòu)
./scripts/tigase.sh upgrade-schema etc/tigase.conf
Mysql數(shù)據(jù)庫(kù)必須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

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

啟動(dòng)運(yùn)行

scripts/tigase.sh start etc/tigase.conf

遇到的問(wèn)題

升級(jí)后，新增了tig_user_credentials表，需要針對(duì)原來(lái)認(rèn)證方式存儲(chǔ)用戶密碼，sha1或者plain.，否則會(huì)出現(xiàn)無(wú)法登陸的問(wèn)題。

存儲(chǔ)聊天記錄遇到的問(wè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"
  }
  }

亂碼問(wèn)題，修改如下即可解決。

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

群消息無(wú)法推送，收到new room locked消息體，設(shè)置配置文件config.tdsl

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