搭建wiki(jira+confluence)环境
文章目录
1.环境准备
#1.需要java环境
[root@jiraconfluence ~]# yum install java -y
[root@jiraconfluence ~]# java -version
openjdk version "1.8.0_242"
OpenJDK Runtime Environment (build 1.8.0_242-b08)
OpenJDK 64-Bit Server VM (build 25.242-b08, mixed mode)
#注意:jira7.3以下版本不支持mysql5.7及以上版本数据库
#安装数据库5.6.35 https://blog.csdn.net/guolongpu/article/details/55001385
#上传mysql5.6.35数据包
[root@jirabackup ~]# ls
MySQL-5.6.35-1.linux_glibc2.5.x86_64.rpm-bundle.tar
[root@jirabackup ~]# tar xf MySQL-5.6.35-1.linux_glibc2.5.x86_64.rpm-bundle.tar
#卸载mariadb
[root@jirabackup ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64
[root@jirabackup ~]# yum remove mariadb-libs-5.5.60-1.el7_5.x86_64 -y
#安装
[root@jirabackup ~]# yum localinstall MySQL-server-5.6.35-1.linux_glibc2.5.x86_64.rpm -y
[root@jirabackup ~]# yum localinstall MySQL-client-5.6.35-1.linux_glibc2.5.x86_64.rpm -y
#初始密码
[root@jirabackup ~]# vim /root/.mysql_secret
[root@jirabackup ~]# systemctl enable mysql
[root@jirabackup ~]# systemctl start mysql
[root@jirabackup ~]# mysql -uroot -pfWeON6Od8QRx3pYL
mysql> SET PASSWORD = PASSWORD('123456'); #更改密码
mysql> Status;
#数据库安装完成
#创建jira库
mysql> create database jira default character set utf8 collate utf8_bin;
mysql> Grant ALL PRIVILEGES ON *.* TO 'jira'@'%' IDENTIFIED BY '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
#2.安装mysql5.7.26数据库
MySQL5.7.26下载地址
https://downloads.mysql.com/archives/community/
1.上传软件或下载软件至:/usr/local
[root@yearning local]# ls
bin games lib libexec sbin src
etc include lib64 mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz share
[root@yearning local]# tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz #解压软件包
[root@yearning local]# ln -s mysql-5.7.26-linux-glibc2.12-x86_64 mysql57 #做一个软连接
[root@yearning local]# mkdir -p /data/mysql/data_3306 #数据路径
[root@yearning local]# mkdir -p /data/mysql/binlog_3306 #日志路径
2.用户创建
[root@yearning ~]# useradd mysql #创建一个mysql用户
3.授权
[root@yearning ~]# chown -R mysql.mysql /usr/local/mysql57/ /data
4.环境变量
[root@yearning ~]# vim /etc/profile
#在文件最后添加一行环境变量
export PATH=/usr/local/mysql57/bin:$PATH
[root@yearning ~]# source /etc/profile #加载环境变量
5.残留处理
[root@yearning ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64
[root@yearning ~]# yum remove mariadb-libs -y #卸载残留
6.数据初始化(建系统库)
[root@yearning ~]# yum install libaio-devel -y #安装需要依赖
[root@yearning ~]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql57 --datadir=/data/mysql/data_3306 #初始化数据
7.准备配置文件
cat > /etc/my.cnf <<EOF
[mysqld]
user=mysql
port=3306
basedir=/usr/local/mysql57
datadir=/data/mysql/data_3306
server_id=6
socket=/tmp/mysql.sock
[mysql]
socket=/tmp/mysql.sock
EOF
8.准备启动脚本
[root@yearning ~]# cd /usr/local/mysql57/support-files
[root@yearning support-files]# cp mysql.server /etc/init.d/mysqld
[root@yearning support-files]# chkconfig --add mysqld
[root@yearning support-files]# systemctl start mysqld
[root@yearning support-files]# systemctl restart mysqld
[root@yearning support-files]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26 MySQL Community Server (GPL)
mysql>
#数据库就安装完毕
# mysqladmin -u root password +自己密码 #为数据库设置密码
[root@db01 ~]# mysql
#创建jira库
mysql> create database jira default character set utf8 collate utf8_bin;
mysql> Grant ALL PRIVILEGES ON *.* TO 'jira'@'%' IDENTIFIED BY '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
2.安装jira
#1.下载jira安装包
wget https://downloads.atlassian.com/software/jira/downloads/atlassian-jira-software-7.1.9-x64.bin
#2.给执行权限
[root@jiraconfluence opt]# chmod +x atlassian-jira-software-7.1.9-x64.bin
#3.开始安装
[root@jiraconfluence opt]# ./atlassian-jira-software-7.1.9-x64.bin
#因为8080端口比较常用,我们这里就把端口修改为8081
#1.先停止jira
[root@jiraconfluence bin]# cd /opt/atlassian/jira/bin
[root@jiraconfluence bin]# sh shutdown.sh
[root@jiraconfluence bin]# cd ../conf/
[root@jiraconfluence conf]# vim server.xml
<Service name="Catalina">
<Connector port="8081"
maxThreads="150"
minSpareThreads="25"
connectionTimeout="20000"
enableLookups="false"
maxHttpHeaderSize="8192"
protocol="HTTP/1.1"
useBodyEncodingForURI="true"
redirectPort="8443"
acceptCount="100"
disableUploadTimeout="true"/>
#2.下载 MYSQL 驱动包,文件名: mysql-connector-java-5.1.39-bin.jar
https://dev.mysql.com/downloads/connector/j/
mysql-connector-java-5.1.39-bin.jar (包名)
把驱动包放入以下目录中
/opt/atlassian/jira/lib
3.破解jira
#参考此文章:https://blog.csdn.net/lijunwyf/article/details/56011908
#3.破解
首先下载以下破解文件
文件名: atlassian-extras-3.2.jar 网盘: https://pan.baidu.com/s/1pKLMPmz 密码: RF0o
把破解文件放入以下目录替换原有文件
/opt/atlassian/jira/
[root@jirabackup lib]# cd /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/
[root@jirabackup lib]# mv atlassian-extras-3.1.2.jar atlassian-extras-3.1.2.jar.bak
[root@jirabackup lib]# ll mysql-connector-java-5.1.39-bin.jar atlassian-extras-3.2.jar
#4.启动jira
[root@jirabackup bin]# sh startup.sh
如上图:↑ 破解成功,到期时间2033年
设置中文
如果没有汉化,则上传jira-6.3.3-language-pack-zh_cn.jar汉化包
上传完成就OK
4.jira数据迁移
参考文章https://www.cnblogs.com/wei9593/p/10772611.html
5.安装confluence
#1.创建confluence库
mysql> create database confluence default character set utf8 collate utf8_bin;
mysql> Grant ALL PRIVILEGES ON *.* TO 'confluence'@'%' IDENTIFIED BY '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
#2.上传confluence
atlassian-confluence-5.9.6-x64.bin
[root@jirabackup opt]# chmod +x atlassian-confluence-5.9.6-x64.bin
[root@jirabackup opt]# ./atlassian-confluence-5.9.6-x64.bin
问题(数据库隔离级别)
#进入到数据库
mysql> SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
[root@jirabackup opt]# chmod 755 atlassian-confluence-5.9.6-x64.bin
[root@jirabackup opt]# ./atlassian-confluence-5.9.6-x64.bin
一路回车即可
访问:ip+端口
#停止confluence
[root@jirabackup opt]# cd /opt/atlassian/confluence/bin/
[root@jirabackup bin]# sh shutdown.sh
#上传数据库得连接插件
[root@jirabackup bin]# cd /opt/atlassian/confluence/confluence/WEB-INF/lib/
[root@jirabackup bin]# rz mysql-connector-java-5.1.29.jar
#启动
[root@jirabackup opt]# cd /opt/atlassian/confluence/bin/
[root@jirabackup bin]# sh startup.sh
#刷新页面
6.confluence汉化
上传中文包之后会自己汉化为中文
7.破解
#替换俩个文件,分别是(注意,两个文件位置不同)
/opt/atlassian/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.2.jar
/opt/atlassian/confluence/confluence/WEB-INF/atlassian-bundled-plugins/atlassian-universal-plugin-manager-plugin-2.22.jar
替换前必须做备份,方便回退。
[root@jirabackup atlassian-bundled-plugins]# /opt/atlassian/confluence/confluence/WEB-INF/atlassian-bundled-plugins
[root@jirabackup atlassian-bundled-plugins]# mv atlassian-universal-plugin-manager-plugin-2.20.jar atlassian-universal-plugin-manager-plugin-2.20.jar.bak
查看有没有被破解
下图是没有破解
8.解决中文乱码?
[root@conflce mysql]# vim /usr/share/mysql/my-default.cnf
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_bin
[root@conflce mysql]# systemctl restart mysql
下图是没有破解
8.解决中文乱码?
[root@conflce mysql]# vim /usr/share/mysql/my-default.cnf
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_bin
[root@conflce mysql]# systemctl restart mysql
数据库配置官方说明:https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html