一、本实验环境
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界面后,报错如下图所示:
![](https://img.haomeiwen.com/i15648979/729bafcd6d0f87e2.png)
在my.cnf 中将innodb_log_file_size = 256M
重启mysql,重启confluence
网友评论