docker-compose jira、bugzilla

一、jira

同这篇文章：

linux docker 部署破解版本jira:8.4.0——测试体验(非商用)_jira docker-CSDN博客

直到构建完破解版本的镜像就可以了～

二、bugzilla

1. 拉取镜像：

官网镜像搜索bugzilla，第一个就是：

直接copy~

docker pull nasqueron/bugzilla

当然你会发现它只有这一个版本（有就不错了，0几年的问题管理平台有个镜像就庆幸口八～）

如果上述不可行，还是建议带上版本号，这里是latest，试试这个～

docker pull nasqueron/bugzilla:latest

好，拉取完毕，查看一哈：

2.localconfig文件配置

bugzilla的配置文件为：localconfig

在与jira同父级目录下，新建bugzilla目录，用来存放localconfig文件

mkdir -p bugzilla

cd bugzilla

vim localconfig

localconfig内容：

# Bugzilla 数据库配置
$db_type        = 'mysql';            # 数据库类型，这里假设是 MySQL
$db_host        = 'mysql_container';        # 数据库服务器地址: 服务名称
$db_port        = '3306';             # 数据库端口
$db_name        = 'bugzilla';         # 数据库名
$db_user        = 'bugzilla';         # 数据库用户名
$db_pass        = '123456'; # 数据库密码
# 邮件发送设置
$mail_program = '/usr/sbin/sendmail';
$bugzilla_from = 'xxx@ashes.vip';           # 通过这个邮箱发
$smtp_server    = 'smtp.qiye.aliyun.com';         # QQ邮箱的SMTP服务器地址
$smtp_port      = '465';                   # 邮箱SMTP端口，使用SSL加密通常为465，使用TLS加密为587
$smtp_username  = 'xxx@ashes.vip';  # 你的邮箱地址
$smtp_password  = 'xxxxxxxxx'; # 邮箱的密码
$smtp_use_tls   = 1;
$mail_delivery_method = 'SMTP';         # 指定邮件发送方式为SMTP

解释：方便好记所以数据库和用户名都为bugzilla，密码就是123456

对应的smtp_server自行百度找到合适的即可。

三、docker-compose.yml

这里的mysql服务的配置和这篇文章大同小异

linux docker 部署破解版本jira:8.4.0——测试体验(非商用)_jira docker-CSDN博客

mysqld.cnf和init.sql这两个文件有新增内容～

1. docker-compose.yml

version: '3.9'

services:
  mysql:
    image: mysql:5.7
    container_name: mysql_container
    ports:
      - "3306:3306"
#     restart: always
    environment:
      MYSQL_ROOT_PASSWORD: 123456
      MYSQL_DATABASE_jira: jira
      MYSQL_DATABASE_bugzilla: bugzilla
      MYSQL_USER_jira: jira
      MYSQL_PASSWORD_jira: 123456
      MYSQL_USER_bugzilla: bugzilla
      MYSQL_PASSWORD_bugzilla: 123456
    networks:
      - my-net
    volumes:
      - /home/IntegrationIssue/mysql:/var/lib/mysql
      - ./init.sql:/docker-entrypoint-initdb.d/init.sql
      - ./mysqld.cnf:/etc/mysql/conf.d/mysql.cnf
      - ./mysql_custom.cnf:/etc/mysql/mysql.conf.d/mysql_custom.cnf

  jira:
    image: jira:8.4.0
    container_name: jira_container
    ports:
      - "9000:8080"
    depends_on:
      - mysql
    environment:
      - MYSQL_HOST=mysql_container
      - MYSQL_PORT=3306
      - MYSQL_DATABASE=jira
      - MYSQL_USER=jira
      - MYSQL_PASSWORD=123456
    networks:
      - my-net
    volumes:
      - ./dbconfig.xml:/var/atlassian/application-data/jira/dbconfig.xml
      - ./lib/:/var/atlassian/application-data/jira/lib

  bugzilla:
    image: nasqueron/bugzilla
    container_name: bugzilla_container
    ports:
      - "9001:80"
    depends_on:
      - mysql
#     restart: always
    environment:
      - DB_HOST=mysql_container
      - MYSQL_PORT=3306
      - DB_DATABASE=bugzilla
      - DB_USER=bugzilla
      - DB_PASSWORD=123456
      - BUGZILLA_URL=https://bugzilla.example.com
    networks:
      - my-net
    volumes:
      - ../bugzilla/localconfig:/usr/share/webapps/bugzilla/localconfig
  
networks:
  my-net:
    driver: bridge

bugzilla默认的web端口是80，这里映射成9001或者其他没有用的端口即可。

这样就会 jira 和 bugzilla 各是各的数据库～

2. mysqld.cnf

分别对jira和bugzilla的数据库进行配置：

其实感觉在docker-compose.yml配置了之后这里貌似就不起作用了，因为这里的配置在docker-compose.yml就都已经配置过了～

[mysqld]
# 基本设置
user = root
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-host-cache
skip-name-resolve

# 安全设置
bind-address = 0.0.0.0

# 字符集设置
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

# Jira
[client_jira]
user = jira
password = 123456

[jira]
default-storage-engine=INNODB
character_set_server=utf8mb4
innodb_default_row_format=DYNAMIC
innodb_large_prefix=ON
innodb_file_format=Barracuda
innodb_log_file_size=2G

# Bugzilla 设置
[client_bugzilla]
user = bugzilla
password = 123456

[bugzilla]
default-storage-engine=INNODB
character_set_server=utf8mb4
innodb_default_row_format=DYNAMIC
innodb_large_prefix=ON
innodb_file_format=Barracuda
innodb_log_file_size=2G

# 日志设置
log_error = /var/log/mysql/error.log
log_queries_not_using_indexes = 1

# InnoDB 存储引擎设置
innodb_file_per_table = 1
innodb_buffer_pool_size = 128M
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 1

3. init.sql

也是新增了bugzilla的初始化数据库、用户、权限等操作：

CREATE DATABASE jira CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX ON jira.* TO 'jira'@'%' IDENTIFIED BY 'jira';
GRANT ALL PRIVILEGES ON jira.* TO 'jira'@'%' IDENTIFIED BY 'jira';
SET PASSWORD FOR 'jira'@'%' = PASSWORD('123456');
CREATE DATABASE bugzilla CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX ON bugzilla.* TO 'bugzilla'@'%' IDENTIFIED BY 'bugzilla';
GRANT ALL PRIVILEGES ON bugzilla.* TO 'bugzilla'@'%' IDENTIFIED BY 'bugzilla';
SET PASSWORD FOR 'bugzilla'@'%' = PASSWORD('123456');
FLUSH PRIVILEGES;