Docker部署JiraConfluence--基于Mysql数据库
服务规划
服务名称数据⽬录访问端⼝/数据端⼝客户端访问地址mysql/data/atlassian/mysql8306  3.1.101.36:8306 jira/data/atlassian/jira8080  3.1.101.36:8080 confluence/data/atlassian/confluence8090/8091  3.1.101.36:8090基础环境配置
创建应⽤数据⽬录
mkdir -pv /data/atlassian/mysql/{data,mysql-files,conf,logs}
mkdir -pv /data/atlassian/confluence/{data,logs}
mkdir -pv /data/atlassian/jira/{data,logs}
chown999.999 /data/atlassian/mysql -R
chown2002.2002 /data/atlassian/confluence -R
chown2001.2001 /data/atlassian/jira/{data,logs} -R
创建docker-compose配置⽂件⽬录
mkdir -pv /data/docker-compose/atlassian/{mysql,jira,confluence}
Mysql部署
myf配置⽂件
cat> /data/atlassian/mysql/conf/myf <<'EOF'
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set = utf8mb4
[mysql]
prompt="\u@mysqldb \R:\m:\s [\d]> "
no-auto-rehash
default-character-set = utf8mb4
[mysqld]
user = mysql
port = 3306
skip-name-resolve
# for confluence
character-set-server = utf8mb4
collation-server = utf8mb4_bin
transaction-isolation = READ-COMMITTED
max_connections      = 1024
max_connect_errors    = 100
wait_timeout          = 100
max_allowed_packet    = 128M
table_open_cache      = 2048
back_log              = 600
default-storage-engine = innodb
log_bin_trust_function_creators = 1
# Log
general_log=off
general_log_file =  /data/mysql/logs/mysql.log
log-error = /data/mysql/logs/error.log
#slowlog慢查询⽇志
slow_query_log = 1
slow_query_log_file = /data/mysql/logs/slow.log
long_query_time = 2
log_output = FILE
log_queries_not_using_indexes = 0
#global_buffers
innodb_buffer_pool_size = 2G
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 2
key_buffer_size = 64M
innodb_log_file_size = 512M
innodb_log_file_size = 2G
innodb_log_files_in_group = 2
mysql下载jar包innodb_data_file_path = ibdata1:20M:autoextend
secure_file_priv = /var/lib/mysql
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION [mysqldump]
quick
max_allowed_packet = 32M
EOF
chown999.999 /data/atlassian/mysql/conf/myf
Mysql参数:
报错: Confluence 不⽀持数据库排序规则 “utf8mb4_0900_ai_ci"，您需要使⽤ “utf8mb4_bin"
解决⽅法:
加⼊参数: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin
报错: 您的数据库必须使⽤'READ-COMMITTED'作为默认隔离级别
解决⽅法:
加⼊参数: --transaction-isolation=READ-COMMITTED
docker-compose配置
cat > /data/docker-compose/atlassian/l << EOF version:"3"
services:
atlassian_db:
container_name: atlassian_db
image: mysql:8.0
ports:
- 5306:3306
restart: always
# docker安全验证
security_opt:
- seccomp:unconfined
volumes:
- /etc/localtime:/etc/localtime
- /data/atlassian/mysql/data:/var/lib/mysql
-
/data/atlassian/mysql/mysql-files:/var/lib/mysql-files/
- /data/atlassian/mysql/logs/:/data/mysql/logs/
- /data/atlassian/mysql/conf/myf:/etc/mysql/myf
environment:
MYSQL_ROOT_PASSWORD: a123456
command:--default-authentication-plugin=mysql_native_password --skip-name-resolve networks:
- atlassian
networks:
atlassian:
EOF
启动mysql
docker-compose up -d
创建数据库并授权
# 进⼊容器
docker-compose exec atlassian_db /bin/bash
# 登录数据库
mysql -uroot -pa123456
# 为jira创建数据库并授权
create database jira;
create user "jira"@"%" identified by "jira";
grant all privileges on jira.* to "jira"@"%";
flush privileges;
# 为confluence创建数据库并授权
create database confluence;
create user "confluence"@"%" identified by "confluence";
grant all privileges on confluence.* to "confluence"@"%";
flush privileges;
Jira部署
docker-compose配置
cat > /data/docker-compose/atlassian/l << EOF
version:"3"
services:
jira:
container_name: jira
image: atlassian/jira-software:8.14
restart: always
ports:
- 8080:8080
volumes:
- /etc/localtime:/etc/localtime
- /data/atlassian/jira/data:/var/atlassian/application-data/jira
- /data/atlassian/jira/logs:/opt/atlassian/jira/logs
environment:
JVM_MINIMUM_MEMORY: 1024m
JVM_MAXIMUM_MEMORY: 2048m
JVM_RESERVED_CODE_CACHE_SIZE: 512m
deploy:
resources:
limits:
memory: 4G
reservations:
memory: 1G
networks:
- atlassian
networks:
atlassian:
EOF
启动JIRA
docker-compose up -d
上传Mysql驱动
wget sql/get/Downloads/Connector-J/mysql-connector-java-8.0.
tar -zxf mysql-connector-java-8.0.
docker cp mysql-connector-java-8.0.25/mysql-connector-java-8.0.25.jar jira:/opt/atlassian/jira/atlassian-jira/WEB-INF/lib/ docker exec jira chmod +r /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/mysql-connector-java-8.0.25.jar
免费(PJ)⽅法
1. PJ包下载
提取码：txpp
2. 破解包上传
docker cp atlassian-extras-3.2.jar jira:/opt/atlassian/jira/atlassian-jira/WEB-INF/lib/atlassian-extras-3.2.jar
docker exec jira chmod +r /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/atlassian-extras-3.2.jar
docker exec jira ls /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/atlassian-extras-3.2.jar -l
安装JIRA
重启容器，⽣效所有导⼊jar包
docker-compose restart jira
访问地址：
3.1.101.36:8080
语⾔选择->中⽂
数据库信息：
连接数据库：其他数据库
数据库类型：mysql8.0
主机：3.1.101.36
端⼝：5306
数据库：jira
⽤户名：jira
密码：jira
根据提⽰进⾏安装即可，安装后应⽤程序中查看是否有29天限制，如果没有，即PJ成功
Confluence部署
docker-compose配置
cat > /data/docker-compose/atlassian/l << EOF
version:"3"
services:
confluence:
container_name: confluence
image: atlassian/confluence-server:7.13.0-m03
restart: always
ports:
- 8090:8090
- 8091:8091
volumes:
-
/etc/localtime:/etc/localtime
- /data/atlassian/confluence/data:/var/atlassian/application-data/confluence
- /data/atlassian/confluence/logs:/opt/atlassian/confluence/logs
environment:
JVM_MINIMUM_MEMORY: 1024m
JVM_MAXIMUM_MEMORY: 2048m
JVM_RESERVED_CODE_CACHE_SIZE: 512m
deploy:
resources:
limits:
memory: 4G
reservations:
memory: 1G
networks:
- atlassian
networks:
atlassian:
EOF
启动confluence
docker-compose up -d
上传Mysql驱动
wget sql/get/Downloads/Connector-J/mysql-connector-java-8.0.
tar -zxf mysql-connector-java-8.0.
docker cp mysql-connector-java-8.0.25/mysql-connector-java-8.0.25.jar confluence:/opt/atlassian/confluence/confluence/WEB-INF/lib/ docker exec confluence chmod +r /opt/atlassian/confluence/confluence/WEB-INF/lib/mysql-connector-java-8.0.25.jar
免费(PJ)⽅法
访问地址: 3.1.101.36:8090
到输⼊授权码页⾯进⾏如下操作

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。