docker部署jira with mysql or postgresql

参考链接1：docker搭建jira-7.11.1 + 破解 - Fithon - 博客园

参考链接2：https://www.cnblogs.com/ilanni/p/6200875.html

参考链接3：Postgresql默认用户名与密码_postgresql 精简版 用户名密码-CSDN博客

参考链接4：GitHub - sameersbn/docker-postgresql: Dockerfile to build a PostgreSQL container image which can be linked to other containers.

https://www.cnblogs.com/panlifeng/p/17723201.html

jira with mysql

1.pull docker 镜像： jira:7.11.1(目前的最新版本) mysql:5.7
docker pull cptactionhank/atlassian-jira-software
docker pull mysql:5.7

2.启动mysql docker实例
docker run --name atlassian-mysql --restart always -p 3306:3306 -v /opt/mysql_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 #记得修改passwd

3.连接mysql
docker run -it --link atlassian-mysql:mysql --rm mysql:5.7 sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'

4.创建jira数据库,并添加jira用户 【mysql操作台执行】
create database jira default character set utf8 collate utf8_bin;
CREATE USER `jira`@`%` IDENTIFIED BY 'jira';GRANT ALL ON *.* TO `jira`@`%` WITH GRANT OPTION;
alter user 'jira'@'%' identified with mysql_native_password by 'jira';

5.修改mysql事物隔离级别 【mysql操作台执行】
set global transaction isolation level read committed;
set session transaction isolation level read committed;

6.启动jira实例
docker run --detach --restart always -v /data/atlassian/confluence:/home --publish 8080:8080 cptactionhank/atlassian-jira-software

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

jira with postgresql

1. 
docker pull sameersbn/postgresql:10

2.启动postgresql docker实例
//docker run --name postgresql -itd --restart always --publish 8854:5432 --volume /opt/postgresql_data:/var/lib/postgresql  sameersbn/postgresql:10

docker run --name postgresql -itd --restart always --env 'DB_USER=root' --env 'DB_PASS=123456' --env 'DB_NAME=jira' --publish 8854:5432 --volume /opt/postgresql_data:/var/lib/postgresql sameersbn/postgresql:10

进入容器修改超级账户密码

(运行实例是自动创建默认的超级账户postgres账户,同时postgresql会在linux端创建一个系统用户，名为postgres，无需密码登陆)

docker exec -it 容器短id bash

~# sudo su postgres
~# psql postgres

postgres=#  alter user postgres password '123456';
postgres=# 此时进行相关对  root用户鉴权等操作，或者直接弃用root账户，使用postgres账户

3.连接postgresql
docker run -it --link postgresql --rm sameersbn/postgresql:10 sh -c 'exec psql -h '192.168.1.9' -p '8854' -d jira -U root --password'

4. 在postgresql 控制台设置

相对于 mysql，步骤 3~4可以省略

5.
docker run --detach --restart always -v /data/atlassian/confluence:/home --publish 8080:8080 cptactionhank/atlassian-jira-software

6.破解jira
docker exec --user root 88e317beb644 mv /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/atlassian-extras-3.2.jar /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/atlassian-extras-3.2.jar_bak

docker cp atlassian-extras-3.1.2.jar 88e317beb644:/opt/atlassian/jira/atlassian-jira/WEB-INF/lib/

docker restart 88e317beb644     #97为jira容器短id