━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Docker Network構成のイメージ図 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 　172.18.0.2　　　 172.18.0.5 172.18.0.6 172.18.0.7 STEP2の手順 STEP2の手順 STEP5の手順 　　　STEP1の手順　 ┌─────┐　　┌─────┐　　　┌─────┐　　　┌──────┐ │ Nginx │　　│ GitLab　│　　　│ Zabbix │　　　│ MailServer │ └──┬──┘　　└──┬──┘　　　└──┬──┘ └──┬───┘ 　↑　│　　　　　　　　│　　　　　　　　　│ │ 　｜　└────────┴─────────┴─────────┴──────[ Docker Network] 　｜ 　｜┌──────────┐ 　└┤Windows(10.26.3.31) ｜ 　　└──────────┘ 前提確認作業(Windows/hostsの設定情報) ---------------------------------------------------------------------------------------------------------------------------- <接続先> STEP4の手順 /Container/gitlab https://git.sasio.jp STEP5の手順 /Container/jenkins https://jenkins.sasio.jp STEP6の手順 /var/lib/subako/zabbix https://zabbix.sasio.jp ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.ダウンロードのURLの一覧の資材の理解 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ https://www.jobarranger.info/jpn/download/index.html 接続先の新規コンテナ(jobarg)： 1-1.下記は今回のコンテナでの構築に必要であるため対象である ①Server →ジョブを実行させる機能そのものの「司令塔（土台）」 https://www.jobarranger.info/download/7.2.1//Server/jobarranger-server-7.2.1-1.el9.x86_64.rpm ②LinuxAgent →実際にコマンドを動かし、その結果（成功・失敗）をあなたに報告する「実務担当」 https://www.jobarranger.info/download/7.2.1//LinuxAgent/jobarranger-agentd-7.2.1-1.el9.x86_64.rpm ①Manager →ジョブを実行させる機能そのものの「司令塔（土台）」 https://www.jobarranger.info/download/7.2.1//Manager/jobarranger-manager-7.2.1-1.el9.x86_64.rpm 既存コンテナ(zabbix-web)： Other (jobarranger-7.2.1.tar.gz)：【必須】 →Zabbixの管理画面の中に「Jaz Manager」の画面を表示させるための本体だからです。 https://www.jobarranger.info/download/7.2.1//Other/jobarranger-7.2.1.tar.gz ──────────────────────────────────────────────────────── 2-2.そもそもクライアントでの作業になるのでサーバー構築では以下は完全対象外となる WindowsAgent https://www.jobarranger.info/download/7.2.1//WindowsAgent/Job_Arranger_Agent_x64.msi ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.運用監視サーバーへの接続 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ssh -p 10902 kbmnt@172.26.4.45 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.管理者権限に切り替える ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ su - ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.zabbix用のサーバー証明書の作成 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ [root@om01 cert]# ls -la /Container/cert 合計 32 drwxr-xr-x 2 root root 4096 6月 14 10:21 . drwxr-xr-x. 7 root root 4096 6月 13 07:44 .. -rw-r--r-- 1 root root 4812 6月 14 10:20 gitlab_cert.pem -rw------- 1 root root 227 6月 14 10:21 gitlab_privkey.pem -rw-r--r-- 1 root root 4808 6月 13 08:06 mail_cert.pem -rw------- 1 root root 227 6月 13 08:07 mail_privkey.pem [root@om01 cert]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 5.Job Arranger用のサーバー証明書の作成 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ sudo certbot certonly \ --manual \ --preferred-challenges=dns \ --email sasio-technologies@outlook.jp \ --agree-tos \ --no-eff-email \ -d jobarg.sasio.jp [root@om01 ~]# sudo certbot certonly \ > --manual \ > --preferred-challenges=dns \ > --email sasio-technologies@outlook.jp \ > --agree-tos \ > --no-eff-email \ > -d jobarg.sasio.jp Saving debug log to /var/log/letsencrypt/letsencrypt.log Requesting a certificate for gitlab.sasio.jp ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 6.Job Arranger用のサーバー証明書の作成 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ (1)zabbixのサーバー証明書をコピーする cp /etc/letsencrypt/live/zabbix.sasio.jp/fullchain.pem /Container/cert/zabbix_cert.pem cp /etc/letsencrypt/live/zabbix.sasio.jp/privkey.pem /Container/cert/zabbix_privkey.pem; (2)Job Arrangerのサーバー証明書をコピーする cp /etc/letsencrypt/live/jobarg.sasio.jp/fullchain.pem /Container/cert/jobarg_cert.pem cp /etc/letsencrypt/live/jobarg.sasio.jp/privkey.pem /Container/cert/jobarg_privkey.pem ---------------------------------------------------------------------------------------------------------------------------- (3)サーバ証明書の格納先にファイルが配置されていることを確認する [root@om01 cert]# ls -la /Container/cert 合計 56 drwxr-xr-x 2 root root 4096 6月 14 13:13 . drwxr-xr-x. 7 root root 4096 6月 13 07:44 .. -rw-r--r-- 1 root root 4812 6月 14 10:20 gitlab_cert.pem -rw------- 1 root root 227 6月 14 10:21 gitlab_privkey.pem -rw-r--r-- 1 root root 4812 6月 14 13:12 jobarg_cert.pem -rw------- 1 root root 227 6月 14 13:13 jobarg_privkey.pem -rw-r--r-- 1 root root 4808 6月 13 08:06 mail_cert.pem -rw------- 1 root root 227 6月 13 08:07 mail_privkey.pem -rw-r--r-- 1 root root 4817 6月 14 13:06 zabbix_cert.pem -rw------- 1 root root 227 6月 14 13:08 zabbix_privkey.pem [root@om01 cert]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 7. hostsの設定　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　★DNSに登録するまでは暫定で追加する ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ [root@om01 cert]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 172.26.4.45 om01.sasio.jp om01 172.26.4.45 jobarg.sasio.jp jobarg [root@om01 cert]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 8. Zabbixコンテナのコードの格納先の準備 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ (1)追加機能向けのディレクトリの一括作成 mkdir -p /Container/zabbix/jobarg-build ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 9.zabbix-webコンテナの追加機能の圧縮ファイルの展開(jobarranger)　　　　　　　　　　　　　　　 ★不要化はまだ不明 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ (3)不要の実行コマンド mkdir -p /Container/zabbix/web-modules chown -R root:root /Container/zabbix/web-modules chmod -R 755 /Container/zabbix/web-modules ---------------------------------------------------------------------------------------------------------------------------- tar --strip-components=1 \ -xzf /Container/zabbix/jobarg-build/jobarranger-7.2.1.tar.gz \ -C /Container/zabbix/web-modules [root@om01 jobarg-build]# ls -la /Container/zabbix/web-modules/ 合計 136 drwxr-xr-x 12 root root 4096 5月 6 09:36 . drwxr-xr-x 5 root root 4096 5月 5 20:05 .. -rwxrwxrwx 1 root root 32 1月 26 12:25 AUTHORS -rwxrwxrwx 1 root root 18332 1月 26 12:26 COPYING -rwxrwxrwx 1 root root 122 1月 26 12:26 ChangeLog -rwxrwxrwx 1 root root 19776 1月 26 12:26 Makefile.am -rwxrwxrwx 1 root root 53 1月 26 12:26 NEWS -rwxrwxrwx 1 root root 1124 1月 26 12:26 README.md drwxrwxrwx 4 root root 4096 1月 26 12:33 conf -rwxrwxrwx 1 root root 11136 1月 26 12:26 configure.ac drwxrwxrwx 5 root root 4096 1月 26 12:33 database drwxrwxrwx 3 root root 4096 1月 26 12:33 docker drwxrwxrwx 3 root root 4096 1月 26 12:33 frontend -rwxrwxrwx 1 root root 1249 1月 26 12:26 go.mod -rwxrwxrwx 1 root root 10156 1月 26 12:26 go.sum -rwxrwxrwx 1 root root 207 1月 26 12:26 install-gen.sh drwxrwxrwx 2 root root 4096 1月 26 12:33 man drwxrwxrwx 5 root root 4096 1月 26 12:33 misc drwxrwxrwx 5 root root 4096 1月 26 12:33 specs drwxrwxrwx 13 root root 4096 1月 26 12:33 src drwxrwxrwx 4 root root 4096 1月 26 12:33 tools drwxrwxrwx 4 root root 4096 1月 26 12:33 vendor ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 10. Nginxコンテナからzabbixへの接続の設定ファイルの作成 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ [root@om01 zabbix]# cat /Container/nginx/conf.d/zabbix.conf server { listen 443 ssl; server_name zabbix.sasio.jp; ssl_certificate /etc/nginx/cert/zabbix_cert.pem; ssl_certificate_key /etc/nginx/cert/zabbix_privkey.pem; # ★ Docker内部のDNSサーバー（名前解決の即死を防ぐ） resolver 127.0.0.11 valid=30s; # SSLの推奨設定（セキュリティ向上） ssl_protocols TLSv1.2 TLSv1.3; ssl_ciphers 'ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384'; # ========================================================================= # ★【最重要：新規追加】 # zabbix.sasio.jp/jobarranger 宛てのリダイレクトパケットが来たら、 # Zabbix側ではなく、JobArrangerの画面実体がある「jobargコンテナの80番」へバイパスします。 # ========================================================================= location /jobarranger { set $jobarg_endpoint http://jobarg:80; proxy_pass $jobarg_endpoint; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto https; # 中のApacheが「http://...」で返してきたリダイレクトURLを「https://...」に自動補正 proxy_redirect http:// https://; } # ========================================================================= # 通常のZabbixの通信（ルートパス）の処理 # Zabbix公式Webの仕様に合わせて、内部ポート「8080」へ正しく転送します（既存のまま） # ========================================================================= location / { set $upstream_endpoint http://zabbix-web:8080; proxy_pass $upstream_endpoint; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto https; } } [root@om01 zabbix]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 11.追加オプションの新規設定(Job Arranger) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ [root@om01 jobarg-build]# cat /Container/zabbix/jobarg-build/Dockerfile FROM almalinux:9 # 1. パッケージインストール RUN dnf install -y epel-release && \ dnf install -y https://dev.mysql.com/get/mysql80-community-release-el9-5.noarch.rpm && \ dnf install -y --allowerasing \ mariadb-connector-c \ net-snmp-libs \ curl \ libvterm \ mariadb \ mysql-community-libs \ httpd \ php \ php-mysqlnd \ php-gd \ php-xml \ php-mbstring \ php-ldap # 2. JobArranger RPMインストール RUN curl -L -O https://www.jobarranger.info/download/7.2.1/Server/jobarranger-server-7.2.1-1.el9.x86_64.rpm && \ curl -L -O https://www.jobarranger.info/download/7.2.1/LinuxAgent/jobarranger-agentd-7.2.1-1.el9.x86_64.rpm && \ curl -L -O https://www.jobarranger.info/download/7.2.1/Manager/jobarranger-manager-7.2.1-1.el9.x86_64.rpm && \ dnf localinstall -y jobarranger-*.rpm && \ rm -f jobarranger-*.rpm # 3. jobarg_server.conf の詳細設定修正 RUN sed -i -e '/^DBType=/d' \ -e '/^DBHost=/d' \ -e '/^DBName=/d' \ -e '/^DBUser=/d' \ -e '/^DBPassword=/d' \ -e '/^DBPort=/d' \ -e '/^DBPasswordExternal=/d' \ -e '/^JazDBHost=/d' \ -e '/^JazDBName=/d' \ -e '/^JazDBUser=/d' \ -e '/^JazDBPassword=/d' \ -e '/^JazDBPort=/d' \ -e '/^ListenIP=/d' \ -e '/^ListenPort=/d' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: DBType$/a DBType=mysql' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: DBHost$/a DBHost=zabbix-mysql' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: DBName$/a DBName=zabbix' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: DBUser$/a DBUser=zabbix' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: DBPassword$/a DBPassword=zabbixpass' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: DBPort$/a DBPort=3306' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: JazDBHost$/a JazDBHost=zabbix-mysql' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: JazDBName$/a JazDBName=zabbix' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: JazDBUser$/a JazDBUser=zabbix' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: JazDBPassword$/a JazDBPassword=zabbixpass' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: JazDBPort$/a JazDBPort=3306' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: ListenIP$/a ListenIP=0.0.0.0' /etc/jobarranger/jobarg_server.conf && \ sed -i '/### Option: ListenPort$/a ListenPort=10061' /etc/jobarranger/jobarg_server.conf # 4. Zabbixモジュールのコピー RUN mkdir -p /usr/share/zabbix/modules/ && \ cp -R /usr/share/jobarranger/modules/JazManager /usr/share/zabbix/modules/ # 5. Manager/API設定の修正 RUN CONFIG_PATH="/usr/share/jobarranger/api/app/config/jam.config.php" && \ if [ ! -f "$CONFIG_PATH" ]; then \ if [ -f "${CONFIG_PATH}.example" ]; then cp "${CONFIG_PATH}.example" "$CONFIG_PATH"; \ elif [ -f "${CONFIG_PATH}.dist" ]; then cp "${CONFIG_PATH}.dist" "$CONFIG_PATH"; \ else \ echo " "$CONFIG_PATH"; \ echo "define('DB_HOST' , 'localhost');" >> "$CONFIG_PATH"; \ echo "define('JA_DB_HOST' , 'localhost');" >> "$CONFIG_PATH"; \ echo "define('DB_NAME' , 'jobarranger');" >> "$CONFIG_PATH"; \ echo "define('JA_DB_NAME' , 'jobarranger');" >> "$CONFIG_PATH"; \ echo "define('DB_PASS' , 'zabbix');" >> "$CONFIG_PATH"; \ echo "define('JA_DB_PASS' , 'zabbix');" >> "$CONFIG_PATH"; \ echo "define('ZBX_API_ROOT', '');" >> "$CONFIG_PATH"; \ echo "define('ZBX_REDIRECT_URL', '');" >> "$CONFIG_PATH"; \ echo "define('ZBX_API_LOCAL', true);" >> "$CONFIG_PATH"; \ echo "define('SSL_VERIFICATION', 1);" >> "$CONFIG_PATH"; \ fi \ fi && \ sed -i "s/define('DB_HOST' , '.*');/define('DB_HOST' , 'zabbix-mysql');/" "$CONFIG_PATH" && \ sed -i "s/define('JA_DB_HOST' , '.*');/define('JA_DB_HOST' , 'zabbix-mysql');/" "$CONFIG_PATH" && \ sed -i "s/define('DB_NAME' , '.*');/define('DB_NAME' , 'zabbix');/" "$CONFIG_PATH" && \ sed -i "s/define('JA_DB_NAME' , '.*');/define('JA_DB_NAME' , 'zabbix');/" "$CONFIG_PATH" && \ sed -i "s/define('DB_PASS' , '.*');/define('DB_PASS' , 'zabbixpass');/" "$CONFIG_PATH" && \ sed -i "s/define('JA_DB_PASS' , '.*');/define('JA_DB_PASS' , 'zabbixpass');/" "$CONFIG_PATH" && \ sed -i "s|define('ZBX_API_ROOT', '.*');|define('ZBX_API_ROOT', 'http://zabbix-web:8080/');|g" "$CONFIG_PATH" && \ sed -i "s|define('ZBX_REDIRECT_URL', '.*');|define('ZBX_REDIRECT_URL', 'https://jobarg.sasio.jp');|g" "$CONFIG_PATH" && \ sed -i "s/define('ZBX_API_LOCAL', .*/define('ZBX_API_LOCAL', false);/" "$CONFIG_PATH" && \ sed -i "s/define('SSL_VERIFICATION', .*/define('SSL_VERIFICATION', 0);/" "$CONFIG_PATH" && \ echo 'if (isset($_SERVER["HTTP_X_FORWARDED_PROTO"]) && $_SERVER["HTTP_X_FORWARDED_PROTO"] === "https") { $_SERVER["HTTPS"] = "on"; }' >> "$CONFIG_PATH" # 6. Agent設定の修正 RUN sed -i -e '/^Server=/d' -e '/^Hostname=/d' /etc/jobarranger/jobarg_agentd.conf && \ sed -i '/### Option: Server$/a Server=127.0.0.1' /etc/jobarranger/jobarg_agentd.conf && \ sed -i '/### Option: Hostname$/a Hostname=jobarg-server' /etc/jobarranger/jobarg_agentd.conf # 7. Apache設定の修正 RUN rm -f /etc/httpd/conf.d/jobarranger.conf && \ echo 'Alias /jobarranger "/usr/share/jobarranger"' > /etc/httpd/conf.d/jobarranger.conf && \ echo '' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' DirectoryIndex index.html index.php' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' Options +FollowSymLinks' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' AllowOverride All' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' Require all granted' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' ' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' SetHandler "proxy:fcgi://127.0.0.1:9000"' >> /etc/httpd/conf.d/jobarranger.conf && \ echo ' ' >> /etc/httpd/conf.d/jobarranger.conf && \ echo '' >> /etc/httpd/conf.d/jobarranger.conf # PHP-FPMの設定修正 RUN sed -i 's|^listen = .*|listen = 127.0.0.1:9000|' /etc/php-fpm.d/www.conf || true # 8. API用の一時ディレクトリ準備 RUN mkdir -p /usr/share/jobarranger/api/app/tmp && \ chmod -R 777 /usr/share/jobarranger/api/app/tmp EXPOSE 80 10061 # 9. 実行設定 CMD echo 'Setting permissions...'; \ mkdir -p /usr/share/jobarranger/api/app/tmp /var/log/jobarranger/manager /run/php-fpm; \ chown -R apache:apache /usr/share/jobarranger /var/log/jobarranger /run/php-fpm; \ chmod -R 777 /usr/share/jobarranger/api/app/tmp /var/log/jobarranger/manager; \ chown -R zabbix:zabbix /var/log/jobarranger /usr/local/bin/jobarranger/server_socks; \ \ echo 'Waiting for MySQL connection...'; \ until mysqladmin ping -h zabbix-mysql -u zabbix -pzabbixpass --silent; do \ echo 'MySQL is unavailable - sleeping'; \ sleep 3; \ done; \ echo 'MySQL is up - executing SQL scripts...'; \ \ echo 'Updating Database...'; \ # ★修正箇所：不確実な検索処理を全削除し、先ほど存在を確認した本物のパスを直接指定して流し込みます。 mysql -h zabbix-mysql -u zabbix -pzabbixpass zabbix -f < /usr/share/doc/jobarranger-server/database/mysql/MySQL_JA_CREATE_TABLE.sql; \ mysql -h zabbix-mysql -u zabbix -pzabbixpass zabbix -f < /usr/share/doc/jobarranger-server/database/data/JA_2_INSERT_TABLE.sql; \ \ echo 'Starting Services...'; \ php-fpm; \ /usr/local/sbin/jobarg_agentd; \ /usr/local/sbin/jobarg_server -c /etc/jobarranger/jobarg_server.conf; \ \ NGINX_IP=$(getent hosts nginx | awk '{ print $1 }'); \ if [ -n "$NGINX_IP" ]; then \ hosts_content=$(cat /etc/hosts | sed '/zabbix.sasio.jp/d'); \ echo "$hosts_content" > /etc/hosts && echo "$NGINX_IP zabbix.sasio.jp" >> /etc/hosts; \ fi; \ \ /usr/sbin/httpd -D FOREGROUND [root@om01 jobarg-build]# ───────────────────────────────────────────────────────────── [root@om01 jobarg-build]# cat /Container/zabbix/jobarg-build/compose.yml services: job-arg-server: build: . image: local/jobarg-server:7.2.1 container_name: jobarg restart: always ports: - "10061:10061" environment: - TZ=Asia/Tokyo - MYSQL_ROOT_PASSWORD=zabbixroot - MYSQL_USER=zabbix - MYSQL_PASSWORD=zabbixpass - DB_SERVER_HOST=zabbix-mysql # --- ここを追加 --- extra_hosts: - "jobarg.sasio.jp:host-gateway" # ------------------ networks: - monitor_net networks: monitor_net: external: true [root@om01 jobarg-build]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.追加オプションの新規設定(Job Arranger) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ cd /Container/zabbix/jobarg-build;pwd docker build --network=host -t local/jobarg-server:7.2.1 . [root@om01 jobarg-build]# docker build --network=host -t local/jobarg-server:7.2.1 . [+] Building 2465.3s (13/13) FINISHED docker:default => [internal] load build definition from Dockerfile 0.1s => => transferring dockerfile: 8.07kB 0.0s => [internal] load metadata for docker.io/library/almalinux:9 3.4s => [internal] load .dockerignore 0.1s => => transferring context: 2B 0.0s => [1/9] FROM docker.io/library/almalinux:9@sha256:606be3c7b71a40dd3b024646e9b5a0b5023d0fdf111060f249b08f04cec0 54.2s => => resolve docker.io/library/almalinux:9@sha256:606be3c7b71a40dd3b024646e9b5a0b5023d0fdf111060f249b08f04cec0c 0.2s => => sha256:bf33987844e0293cd84c3d97bb714d6e871f8790237b923f70a2eb541b43d4df 71.28MB / 71.28MB 17.9s => => extracting sha256:bf33987844e0293cd84c3d97bb714d6e871f8790237b923f70a2eb541b43d4df 34.1s => [2/9] RUN dnf install -y epel-release && dnf install -y https://dev.mysql.com/get/mysql80-community-re 1555.8s => [3/9] RUN curl -L -O https://www.jobarranger.info/download/7.2.1/Server/jobarranger-server-7.2.1-1.el9.x86_6 97.9s => [4/9] RUN sed -i -e '/^DBType=/d' -e '/^DBHost=/d' -e '/^DBName=/d' -e '/^DB 5.3s => [5/9] RUN mkdir -p /usr/share/zabbix/modules/ && cp -R /usr/share/jobarranger/modules/JazManager /usr/sha 2.0s => [6/9] RUN CONFIG_PATH="/usr/share/jobarranger/api/app/config/jam.config.php" && if [ ! -f "$CONFIG_PATH" 2.6s => [7/9] RUN sed -i -e '/^Server=/d' -e '/^Hostname=/d' /etc/jobarranger/jobarg_agentd.conf && sed -i '/### 2.3s => [8/9] RUN rm -f /etc/httpd/conf.d/jobarranger.conf && echo 'Alias /jobarranger "/usr/share/jobarranger"' 1.4s => [9/9] RUN mkdir -p /usr/share/jobarranger/api/app/tmp && chmod -R 777 /usr/share/jobarranger/api/app/tmp 1.4s => exporting to image 726.3s => => exporting layers 296.9s => => exporting manifest sha256:7e05ce850e57d2fb2feb79a547d0e92bc9ee87672061f0f3fb3c34bbab751831 0.8s => => exporting config sha256:5c58022a0865ea4f3dea6d29fe6f56b9ec85dc5a71b8b2224352f96dc7d59504 1.1s => => exporting attestation manifest sha256:6847f25e1be96ae4bdc853f041f6caf8e6ca520cd3e08d9f07350bbaf31b5669 4.5s => => exporting manifest list sha256:9905a4f251f1c9e3500ecf5f9825613e3daad222616543727a6a81e7307c01ff 0.9s => => naming to docker.io/local/jobarg-server:7.2.1 0.7s => => unpacking to docker.io/local/jobarg-server:7.2.1 417.5s 1 warning found (use docker --debug to expand): - JSONArgsRecommended: JSON arguments recommended for CMD to prevent unintended behavior related to OS signals (line 111) [root@om01 jobarg-build]# ---------------------------------------------------------------------------------------------------------------------------- (1)新規コンテナの作成 # コンテナ起動（サービス名は job-arg-server） docker compose up -d [root@om01 jobarg-build]# docker compose up -d [+] up 1/1 ✔ Container jobarg Started 20.8s [root@om01 jobarg-build]# (3)テーブル数の確認 作成後にすぐできず502エラーはしばらく続くのでしばらく待機するため下記のコマンドで確認する watch -n 2 'docker exec -i jobarg mysql -h zabbix-mysql -u zabbix -pzabbixpass zabbix -e "SHOW TABLES;" | grep -v "Tables_in_zabbix" | wc -l' [実行結果] mysql: [Warning] Using a password on the command line interface can be insecure. 203 ---------------------------------------------------------------------------------------------------------------------------- (4)ブラウザでzabbixにログインする https://zabbix.sasio.jp ユーザ名：Admin パスワード：zabbix 画面の左下（メニューの一番下）にある 「User settings」（歯車マーク）をクリックします。 移動したページ内にある 「Language」 の項目を探します。 プルダウンメニューから 「Japanese (ja_JP)」 を選択します。 (5)下記の順に従ってモジュールの一覧へをアクセスする [Administration]―[General]―[Module] (6)モジュールの一覧の右上に表示されている[Scan Directory](紺色ボタン)を押す (7)JAZ Managerを無効から有効に切り替える (8)Jaz Managerをクリックする (6)初期設定 zabbix-mysql 3306 zabbix zabbix zabbixpass Zabbix URL https://zabbix.sasio.jp/ Zabbix Redirect URL https://zabbix.sasio.jp/ □Disable SSL Verification /var/log/jobarranger/manager jobarg_manager.log docker exec -it --user root jobarg sed -i "s|http://localhost/jobarranger|https://zabbix.sasio.jp/jobarranger|g" /usr/share/jobarranger/modules/JazManager/config/jam.module.config.php [root@om01 zabbix]# docker exec -it jobarg cat /usr/share/jobarranger/modules/JazManager/config/jam.module.config.php 10061/tcp, [::]:10061->10061/tcp jobarg [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -it jobarg rpm -qa | grep jobarranger jobarranger-agentd-7.2.1-1.el9.x86_64 jobarranger-server-7.2.1-1.el9.x86_64 jobarranger-manager-7.2.1-1.el9.x86_64 [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────── ③ ネットワーク待ち受け確認 ホストOSから 10061 ポートで接続を受け付ける準備ができているか確認します。 ss -nlt | grep 10061 [root@om01 jobarg-build]# ss -nlt | grep 10061 LISTEN 0 4096 0.0.0.0:10061 0.0.0.0:* LISTEN 0 4096 [::]:10061 [::]:* [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────── ① プロセス稼働確認 Server と Agent がコンテナ内で共存して動いているかを確認します。 docker exec -it jobarg-server ps aux | grep jobarg [root@om01 jobarg-build]# docker exec -it jobarg ps aux | grep jobarg zabbix 282 0.0 0.0 1671900 6648 ? Sl 13:20 0:00 jobarg_manage zabbix 283 0.0 0.0 1672156 8788 ? Sl 13:20 0:00 jobarg_server [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────── ② 接続ログの確認（最重要） 設定ファイル (jobarg_server.conf) の DBName 等の修正が正しく反映され、DB接続に成功しているかをログで確認します。 docker exec -it jobarg-server tail -n 50 /var/log/jobarranger/jobarg_server.log [root@om01 jobarg-build]# docker exec -it jobarg tail -n 50 /var/log/jobarranger/jobarg_server.log 278:20260808:132006.860 [INFO] [JASERVER000001] Starting Job Arranger Server. Job Arranger 7.2.1 (revision 3786). 278:20260808:132006.860 [INFO] [JASERVER000003] server #0 started [main process] 283:20260808:132006.861 [INFO] [JASERVER000004] server #0 started [jobarg_server_monitor #1] 287:20260808:132006.862 [INFO] [JASERVER000004] server #1 started [notification_manager #1] 318:20260808:132011.879 [INFO] [JASERVER000004] server #2 started [zabbix_link_manager #1] 509:20260808:132021.107 [INFO] [JASERVER000004] server #3 started [icon_result_manager #1] 519:20260808:132021.215 [INFO] [JASERVER000004] server #4 started [db_sync_manager #1] 526:20260808:132021.422 [INFO] [JASERVER000004] server #5 started [recovery_manager #1] 526:20260808:132022.275 [INFO] [JARECOVERYREEXEC000001 recoverymanager] In reExecute(), starting re-execution 526:20260808:132024.443 [INFO] [JARECOVERYREEXEC000009 recoverymanager] In reExecute(), move files from '/var/lib/jobarranger/server/recoverymanager/rerun/flow' to '/var/lib/jobarranger/server/flowmanager/in' for failover rerun 526:20260808:132024.443 [INFO] [JARECOVERYREEXEC000009 recoverymanager] In reExecute(), move files from '/var/lib/jobarranger/server/recoverymanager/rerun/flow' to '/var/lib/jobarranger/server/jobnetmanager/in' for failover rerun 526:20260808:132024.443 [INFO] [JARECOVERYREEXEC000010 recoverymanager] In reExecute(), created events [0]: 526:20260808:132024.444 [INFO] [JARECOVERYDELAY000001 recoverymanager] In recoverDelayedTransacFiles() start recovering delayed transaction files 537:20260808:132024.445 [INFO] [JASERVER000004] server #6 started [icon_execution_manager #1] 538:20260808:132024.445 [INFO] [JASERVER000004] server #7 started [flow_manager #1] 539:20260808:132024.445 [INFO] [JASERVER000004] server #8 started [jobnet_manager #1] 540:20260808:132024.445 [INFO] [JASERVER000004] server #9 started [timeout_manger #1] 541:20260808:132024.446 [INFO] [JASERVER000004] server #10 started [trapper_manager #1] 542:20260808:132024.446 [INFO] [JASERVER000004] server #11 started [housekeeper_manager #1] 278:20260808:132024.446 [INFO] [JASERVER000005] In SERVER_MAIN_ENTRY(), All processes started, now waiting for children [root@om01 jobarg-build]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 18.zabbix-serverからzabbix-mysqlへの接続確認 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ docker exec zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SELECT count(*) FROM information_schema.tables WHERE table_schema='zabbix';" [root@om01 jobarg-build]# docker exec zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SELECT count(*) FROM information_schema.tables WHERE table_schema='zabbix';" mysql: [Warning] Using a password on the command line interface can be insecure. count(*) 260 [root@om01 jobarg-build]# --------------------------------------------------------------------------------------------------------------------------- docker exec -it zabbix-server mysql -h mysql -uzabbix -pzabbixpass USE zabbix; SHOW TABLES LIKE 'config'; SELECT count(*) FROM information_schema.tables WHERE table_schema='zabbix'; [root@om01 jobarg-build]# docker exec -it zabbix-server mysql -h mysql -uzabbix -pzabbixpass mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9033 Server version: 8.0.46 MySQL Community Server - GPL Copyright (c) 2000, 2026, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> USE zabbix; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> mysql> SHOW TABLES LIKE 'config'; +---------------------------+ | Tables_in_zabbix (config) | +---------------------------+ | config | +---------------------------+ 1 row in set (0.05 sec) mysql> mysql> SELECT count(*) FROM information_schema.tables WHERE table_schema='zabbix'; +----------+ | count(*) | +----------+ | 260 | +----------+ 1 row in set (0.01 sec) mysql> mysql> exit Bye [root@om01 jobarg-build]# ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 19.zabbix-mysqlのレコード状態の確認(実行結果) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ [root@om01 jobarg-build]# docker exec -it zabbix-mysql mysql -u root -pzabbixroot -e "SHOW GRANTS FOR 'zabbix'@'%';" mysql: [Warning] Using a password on the command line interface can be insecure. +----------------------------------------------------+ | Grants for zabbix@% | +----------------------------------------------------+ | GRANT USAGE ON *.* TO `zabbix`@`%` | | GRANT ALL PRIVILEGES ON `zabbix`.* TO `zabbix`@`%` | +----------------------------------------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec zabbix-mysql mysql -uroot -pzabbixroot zabbix -t -e "SELECT host, port, base_dn, bind_dn FROM userdirectory_ldap WHERE userdirectoryid = 1;" mysql: [Warning] Using a password on the command line interface can be insecure. +-------------+------+----------------+------------------------------------------+ | host | port | base_dn | bind_dn | +-------------+------+----------------+------------------------------------------+ | 172.26.4.43 | 389 | DC=sasio,DC=jp | CN=Administrator,CN=Users,DC=sasio,DC=jp | +-------------+------+----------------+------------------------------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SELECT userdirectoryid, name, provision_status FROM userdirectory WHERE userdirectoryid = 1;" mysql: [Warning] Using a password on the command line interface can be insecure. userdirectoryid name provision_status 1 SASIO-AD 1 [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -it zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SELECT userdirectoryid, name FROM userdirectory;" mysql: [Warning] Using a password on the command line interface can be insecure. +-----------------+----------+ | userdirectoryid | name | +-----------------+----------+ | 1 | SASIO-AD | +-----------------+----------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SELECT host, port, base_dn, bind_dn FROM userdirectory_ldap WHERE userdirectoryid = 1;" mysql: [Warning] Using a password on the command line interface can be insecure. host port base_dn bind_dn 172.26.4.43 389 DC=sasio,DC=jp CN=Administrator,CN=Users,DC=sasio,DC=jp [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -it zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SELECT name, host, bind_password FROM userdirectory JOIN userdirectory_ldap USING(userdirectoryid);" mysql: [Warning] Using a password on the command line interface can be insecure. +----------+-------------+----------------------+ | name | host | bind_password | +----------+-------------+----------------------+ | SASIO-AD | 172.26.4.43 | get04F15fr34!x07r008 | +----------+-------------+----------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -t zabbix-mysql mysql -uzabbix -pzabbixpass zabbix -e "SELECT roleid, name FROM role;" mysql: [Warning] Using a password on the command line interface can be insecure. +--------+------------------+ | roleid | name | +--------+------------------+ | 2 | Admin role | | 4 | Guest role | | 3 | Super admin role | | 1 | User role | +--------+------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# [root@om01 jobarg-build]# docker exec -t zabbix-mysql mysql -uzabbix -pzabbixpass zabbix -e "SELECT usrgrpid, name FROM usrgrp;" mysql: [Warning] Using a password on the command line interface can be insecure. +----------+---------------------------+ | usrgrpid | name | +----------+---------------------------+ | 9 | Disabled | | 11 | Enabled debug mode | | 8 | Guests | | 13 | Internal | | 12 | No access to the frontend | | 7 | Zabbix administrators | +----------+---------------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -t zabbix-mysql mysql -uroot -pzabbixroot zabbix -e " > SELECT '--- [userdirectory] ---' AS table_name; > SELECT userdirectoryid, name, idp_type FROM userdirectory; > SELECT '--- [userdirectory_ldap] ---' AS table_name; > SELECT host, port, base_dn, search_attribute FROM userdirectory_ldap; > SELECT '--- [config (Auth Status)] ---' AS table_name; > SELECT authentication_type, ldap_auth_enabled, ldap_userdirectoryid, saml_auth_enabled FROM config; > " mysql: [Warning] Using a password on the command line interface can be insecure. +-------------------------+ | table_name | +-------------------------+ | --- [userdirectory] --- | +-------------------------+ +-----------------+----------+----------+ | userdirectoryid | name | idp_type | +-----------------+----------+----------+ | 1 | SASIO-AD | 1 | +-----------------+----------+----------+ +------------------------------+ | table_name | +------------------------------+ | --- [userdirectory_ldap] --- | +------------------------------+ +-------------+------+----------------+------------------+ | host | port | base_dn | search_attribute | +-------------+------+----------------+------------------+ | 172.26.4.43 | 389 | DC=sasio,DC=jp | sAMAccountName | +-------------+------+----------------+------------------+ +--------------------------------+ | table_name | +--------------------------------+ | --- [config (Auth Status)] --- | +--------------------------------+ +---------------------+-------------------+----------------------+-------------------+ | authentication_type | ldap_auth_enabled | ldap_userdirectoryid | saml_auth_enabled | +---------------------+-------------------+----------------------+-------------------+ | 1 | 1 | 1 | 0 | +---------------------+-------------------+----------------------+-------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -t zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "SHOW TABLES LIKE 'config%';" mysql: [Warning] Using a password on the command line interface can be insecure. +----------------------------+ | Tables_in_zabbix (config%) | +----------------------------+ | config | | config_autoreg_tls | +----------------------------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -t zabbix-mysql mysql -uroot -pzabbixroot zabbix -e "DESC config;" mysql: [Warning] Using a password on the command line interface can be insecure. +------------------------------+-----------------+------+-----+------------------------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+-----------------+------+-----+------------------------------------+-------+ | configid | bigint unsigned | NO | PRI | NULL | | | work_period | varchar(255) | NO | | 1-5,09:00-18:00 | | | alert_usrgrpid | bigint unsigned | YES | MUL | NULL | | | default_theme | varchar(128) | NO | | blue-theme | | | authentication_type | int | NO | | 0 | | | discovery_groupid | bigint unsigned | YES | MUL | NULL | | | max_in_table | int | NO | | 50 | | | search_limit | int | NO | | 1000 | | | severity_color_0 | varchar(6) | NO | | 97AAB3 | | | severity_color_1 | varchar(6) | NO | | 7499FF | | | severity_color_2 | varchar(6) | NO | | FFC859 | | | severity_color_3 | varchar(6) | NO | | FFA059 | | | severity_color_4 | varchar(6) | NO | | E97659 | | | severity_color_5 | varchar(6) | NO | | E45959 | | | severity_name_0 | varchar(32) | NO | | Not classified | | | severity_name_1 | varchar(32) | NO | | Information | | | severity_name_2 | varchar(32) | NO | | Warning | | | severity_name_3 | varchar(32) | NO | | Average | | | severity_name_4 | varchar(32) | NO | | High | | | severity_name_5 | varchar(32) | NO | | Disaster | | | ok_period | varchar(32) | NO | | 5m | | | blink_period | varchar(32) | NO | | 2m | | | problem_unack_color | varchar(6) | NO | | CC0000 | | | problem_ack_color | varchar(6) | NO | | CC0000 | | | ok_unack_color | varchar(6) | NO | | 009900 | | | ok_ack_color | varchar(6) | NO | | 009900 | | | problem_unack_style | int | NO | | 1 | | | problem_ack_style | int | NO | | 1 | | | ok_unack_style | int | NO | | 1 | | | ok_ack_style | int | NO | | 1 | | | snmptrap_logging | int | NO | | 1 | | | server_check_interval | int | NO | | 10 | | | hk_events_mode | int | NO | | 1 | | | hk_events_trigger | varchar(32) | NO | | 365d | | | hk_events_internal | varchar(32) | NO | | 1d | | | hk_events_discovery | varchar(32) | NO | | 1d | | | hk_events_autoreg | varchar(32) | NO | | 1d | | | hk_services_mode | int | NO | | 1 | | | hk_services | varchar(32) | NO | | 365d | | | hk_audit_mode | int | NO | | 1 | | | hk_audit | varchar(32) | NO | | 31d | | | hk_sessions_mode | int | NO | | 1 | | | hk_sessions | varchar(32) | NO | | 365d | | | hk_history_mode | int | NO | | 1 | | | hk_history_global | int | NO | | 0 | | | hk_history | varchar(32) | NO | | 31d | | | hk_trends_mode | int | NO | | 1 | | | hk_trends_global | int | NO | | 0 | | | hk_trends | varchar(32) | NO | | 365d | | | default_inventory_mode | int | NO | | -1 | | | custom_color | int | NO | | 0 | | | http_auth_enabled | int | NO | | 0 | | | http_login_form | int | NO | | 0 | | | http_strip_domains | varchar(2048) | NO | | | | | http_case_sensitive | int | NO | | 1 | | | ldap_auth_enabled | int | NO | | 0 | | | ldap_case_sensitive | int | NO | | 1 | | | db_extension | varchar(32) | NO | | | | | autoreg_tls_accept | int | NO | | 1 | | | compression_status | int | NO | | 0 | | | compress_older | varchar(32) | NO | | 7d | | | instanceid | varchar(32) | NO | | | | | saml_auth_enabled | int | NO | | 0 | | | saml_case_sensitive | int | NO | | 0 | | | default_lang | varchar(5) | NO | | en_US | | | default_timezone | varchar(50) | NO | | system | | | login_attempts | int | NO | | 5 | | | login_block | varchar(32) | NO | | 30s | | | show_technical_errors | int | NO | | 0 | | | validate_uri_schemes | int | NO | | 1 | | | uri_valid_schemes | varchar(255) | NO | | http,https,ftp,file,mailto,tel,ssh | | | x_frame_options | varchar(255) | NO | | SAMEORIGIN | | | iframe_sandboxing_enabled | int | NO | | 1 | | | iframe_sandboxing_exceptions | varchar(255) | NO | | | | | max_overview_table_size | int | NO | | 50 | | | history_period | varchar(32) | NO | | 24h | | | period_default | varchar(32) | NO | | 1h | | | max_period | varchar(32) | NO | | 2y | | | socket_timeout | varchar(32) | NO | | 3s | | | connect_timeout | varchar(32) | NO | | 3s | | | media_type_test_timeout | varchar(32) | NO | | 65s | | | script_timeout | varchar(32) | NO | | 60s | | | item_test_timeout | varchar(32) | NO | | 60s | | | session_key | varchar(32) | NO | | | | | url | varchar(2048) | NO | | | | | report_test_timeout | varchar(32) | NO | | 60s | | | dbversion_status | text | NO | | NULL | | | hk_events_service | varchar(32) | NO | | 1d | | | passwd_min_length | int | NO | | 8 | | | passwd_check_rules | int | NO | | 8 | | | auditlog_enabled | int | NO | | 1 | | | ha_failover_delay | varchar(32) | NO | | 1m | | | geomaps_tile_provider | varchar(255) | NO | | | | | geomaps_tile_url | varchar(2048) | NO | | | | | geomaps_max_zoom | int | NO | | 0 | | | geomaps_attribution | varchar(1024) | NO | | | | | vault_provider | int | NO | | 0 | | | ldap_userdirectoryid | bigint unsigned | YES | MUL | NULL | | | server_status | text | NO | | NULL | | | jit_provision_interval | varchar(32) | NO | | 1h | | | saml_jit_status | int | NO | | 0 | | | ldap_jit_status | int | NO | | 0 | | | disabled_usrgrpid | bigint unsigned | YES | MUL | NULL | | | timeout_zabbix_agent | varchar(255) | NO | | 3s | | | timeout_simple_check | varchar(255) | NO | | 3s | | | timeout_snmp_agent | varchar(255) | NO | | 3s | | | timeout_external_check | varchar(255) | NO | | 3s | | | timeout_db_monitor | varchar(255) | NO | | 3s | | | timeout_http_agent | varchar(255) | NO | | 3s | | | timeout_ssh_agent | varchar(255) | NO | | 3s | | | timeout_telnet_agent | varchar(255) | NO | | 3s | | | timeout_script | varchar(255) | NO | | 3s | | | auditlog_mode | int | NO | | 1 | | | mfa_status | int | NO | | 0 | | | mfaid | bigint unsigned | YES | MUL | NULL | | | software_update_checkid | varchar(32) | NO | | | | | software_update_check_data | text | NO | | NULL | | | timeout_browser | varchar(255) | NO | | 60s | | +------------------------------+-----------------+------+-----+------------------------------------+-------+ [root@om01 jobarg-build]# ──────────────────────────────────────────────────────────────────────────────────────── [root@om01 jobarg-build]# docker exec -t zabbix-mysql mysql -uzabbix -pzabbixpass zabbix -e " > SELECT > uig.name AS pattern, > r.name AS role, > ug.name AS zabbix_group > FROM userdirectory_idpgroup uig > JOIN role r ON uig.roleid = r.roleid > JOIN userdirectory_usrgrp uug ON uig.userdirectory_idpgroupid = uug.userdirectory_idpgroupid > JOIN usrgrp ug ON uug.usrgrpid = ug.usrgrpid;" mysql: [Warning] Using a password on the command line interface can be insecure. +---------+------------------+-----------------------+ | pattern | role | zabbix_group | +---------+------------------+-----------------------+ | * | Super admin role | Zabbix administrators | +---------+------------------+-----------------------+ [root@om01 jobarg-build]#