升级confluence5.4.4为confluence6.15.9

一、本实验环境
Centos 6.8 
Confluence   5.4.4
MySQL 5.6
JDK  

二、需要的安装包
1. atlassian-confluence-6.15.9-x64.bin //官网下载

wget https://product-downloads.atlassian.com/software/confluence/downloads/atlassian-confluence-6.15.9-x64.bin 

2. confluence5.1-crack.zip    //用来破解，下载链接：https://pan.baidu.com/s/1rTIEcwFrnnwG39KDpvRHjQ

三、升级步骤
1.执行atlassian-confluence-6.15.9-x64.bin
    ./atlassian-confluence-6.15.9-x64.bin
    依次输入
    o     // install Confluence 6.15.9
    3    // Upgrade an existing Confluence installation
    /usr/local/confluence     //installation directory
    n     //不进行Back up Confluence home
    Enter
    u     // Upgrade
    y    //Start Confluence now
   Finishing installation ...    //最后出现这个代表升级完成2. confluence5.1-crack.zip    //用来破解

2.进入到web界面报错
   Detected tables with non-default collation.
  解决方法：

SELECT CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` ', DATA_TYPE, '(', CHARACTER_MAXIMUM_LENGTH, ') CHARACTER SET UTF8 COLLATE utf8_bin', (CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE '' END), ';')FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'confluence'AND DATA_TYPE = 'varchar'AND( CHARACTER_SET_NAME != 'utf8' OR COLLATION_NAME != 'utf8_bin');

SELECT CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` ', DATA_TYPE, ' CHARACTER SET UTF8 COLLATE utf8_bin', (CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE '' END), ';')FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'confluence'AND DATA_TYPE != 'varchar'AND( CHARACTER_SET_NAME != 'utf8' OR COLLATION_NAME != 'utf8_bin');

SELECT CONCAT('ALTER TABLE ', table_name, ' CHARACTER SET utf8 COLLATE utf8_bin;')FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS CWHERE C.collation_name = T.table_collationAND T.table_schema = 'confluence'AND( C.CHARACTER_SET_NAME != 'utf8' OR C.COLLATION_NAME != 'utf8_bin');

SET FOREIGN_KEY_CHECKS=0;  //解除外键约束

将以上查询到的结果导出,然后使用   mysql   -uroot  -p confluence  < a.sql;   进行修改表结构。

报错：LicenseException: Failed to verify the license
这个报错的原因是由于升级后需要重新破解软件。

1.将文件/usr/local/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar拷贝到注册机中并命名为atlassian-extras-2.4.jar,运行confluence_keygen，输入name,server-id,点击.patch,成功后点击.gen!生成license。
破解的atlassian-extras-2.4.jar已生成

进入Web界面后，报错如下图所示：

在my.cnf 中将innodb_log_file_size = 256M
重启mysql，重启confluence