123

配置镜像

sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json <<-'EOF'
{
"registry-mirrors": ["https://tqkz2w1o.mirror.aliyuncs.com"]
}
EOF
sudo systemctl daemon-reload
sudo systemctl restart docker

创建mysql-server:5.7的镜像
docker run
-d
--name mysqlserver
-e MYSQL_ROOT_PASSWORD=faw-vwzhijie123
-e TZ=Asia/Shanghai
-p 3307:3307
mysql/mysql-server:5.7
docker run --name mysqlserver4 -e MYSQL_ROOT_PASSWORD=fawvwzhijie123 -p 3309:3306 -d mysql/mysql-server:5.7

创建项目管理

删除文件夹
rm -rf /usr/local/docker/confluence7/

docker run
-d
--name confluence
--restart=always
--privileged=true
-e TZ=Asia/Shanghai
-p 9999:8090
-p 8091:8091
-v /usr/local/docker/confluence7:/var/atlassian/application-data/confluence
atlassian/confluence-server:7.15.1

docker cp /home/d/mysql-connector-java-5.1.49-bin.jar 1195ef11d768:/opt/atlassian/confluence/confluence/WEB-INF/lib/mysql-connector-java-5.1.49-bin.jar

docker cp 1195ef11d768:/opt/atlassian/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar /home/d/atlassian-extras-decoder-v2-3.4.1.jar

docker cp /home/d/atlassian-extras-decoder-v2-3.4.1.jar 1195ef11d768:/opt/atlassian/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar

confluence
atlassian-extras-decoder-v2-3.4.1.jar

atlassian-extras-2.4.jar

docker restart 1195ef11d768

docker exec -it c99f52ab43a3 bash
mysql -u root -p
use mysql;
select host,user from user;
update user set host='%' where user ='root';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON . TO 'root'@'%'WITH GRANT OPTION;

ALTER DATABASE confluence COLLATE utf8_bin;
ALTER DATABASE confluence COLLATE utf8mb4_bin;
FLUSH PRIVILEGES;
SELECT @@character_set_database, @@collation_database;

设置mysql数据库隔离
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
SELECT @@global.tx_isolation;