confluence安装记录

Confluence是世界上最好的wiki。

安装java

tar -zxvf openjdk-8u40-b25-linux-x64-10_feb_2015.tar.gz
sudo mkdir /usr/lib/jvm
sudo mv java-se-8u40-ri /usr/lib/jvm/java-8-oracle
sudo ln -sv /usr/lib/jvm/java-8-oracle/jre/bin/java /usr/bin/
java -version

安装confluence

chmod +x atlassian-confluence-7.4.6-x64.bin
sudo ./atlassian-confluence-7.4.6-x64.bin

授权

开启confluence服务，访问http://localhost:8090, 获取服务器ID

java -jar confluence_keygen.jar # BTZ0-2B66-GD4Y-BLLJ

sudo mv /opt/atlassian/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar atlassian-extras-2.4.jar

# 获取授权码后
sudo mv atlassian-extras-2.4.jar /opt/atlassian/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar
sudo service confluence restart
# 填写授权码
tar -zxvf mysql-connector-java-5.1.46.tar.gz
sudo mv ./mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar /opt/atlassian/confluence/confluence/WEB-INF/lib/mysql-connector-java-5.1.46-bin.jar
sudo service confluence restart

Mysql

confluence官方

sudo apt-get update
sudo apt-get install mysql-server

sudo cat /etc/mysql/debian.cnf
mysql -udebian-sys-maint -pxxx

# 修改密码 
show databases;
use mysql;
flush privileges;
UPDATE user SET authentication_string="" WHERE user="root";
flush privileges;
ALTER user 'root'@'localhost' IDENTIFIED BY 'Ycm@123nihao';
quit;

# 解决localhost root无法登陆的问题
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf # 加入skip-grant-tables
mysql -uroot -p
set host = '%' where user = 'root';
update user set host = '%' where user = 'root';


# 建表
mysql> 
CREATE DATABASE confluence CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
SET GLOBAL tx_isolation='READ-COMMITTED';
# mysql8.0创建用户必须分两步
create user 'confluence'@'%' identified by '123456';
grant all privileges on *.* to 'confluence'@'%' with grant option;
FLUSH PRIVILEGES;

# error ('mysql.infoschema'@'localhost') does not exist
mysql> 
DROP USER 'mysql.infoschema'@'localhost';
CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;