一、本實(shí)驗(yàn)環(huán)境
Centos 6.8?
Confluence? ?5.4.4
MySQL 5.6
JDK??
二、需要的安裝包
1.?atlassian-confluence-6.15.9-x64.bin //官網(wǎng)下載
wget https://product-downloads.atlassian.com/software/confluence/downloads/atlassian-confluence-6.15.9-x64.bin?
2.?confluence5.1-crack.zip? ? //用來(lái)破解,下載鏈接:https://pan.baidu.com/s/1rTIEcwFrnnwG39KDpvRHjQ
三、升級(jí)步驟
1.執(zhí)行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? ? ?//不進(jìn)行Back up Confluence home
? ? Enter
? ? u? ? ?// Upgrade
? ? y? ? //Start Confluence now
? ?Finishing installation ...? ? //最后出現(xiàn)這個(gè)代表升級(jí)完成2.?confluence5.1-crack.zip? ? //用來(lái)破解
2.進(jìn)入到web界面報(bào)錯(cuò)
? ?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;? //解除外鍵約束
將以上查詢到的結(jié)果導(dǎo)出,然后使用? ?mysql? ?-uroot? -p confluence? < a.sql;? ?進(jìn)行修改表結(jié)構(gòu)。
報(bào)錯(cuò):LicenseException: Failed to verify the license
這個(gè)報(bào)錯(cuò)的原因是由于升級(jí)后需要重新破解軟件。
1.將文件/usr/local/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar拷貝到注冊(cè)機(jī)中并命名為atlassian-extras-2.4.jar,運(yùn)行confluence_keygen,輸入name,server-id,點(diǎn)擊.patch,成功后點(diǎn)擊.gen!生成license。
破解的atlassian-extras-2.4.jar已生成
進(jìn)入Web界面后,報(bào)錯(cuò)如下圖所示:

在my.cnf 中將innodb_log_file_size = 256M
重啟mysql,重啟confluence