プロジェクト

全般

プロフィール

ダウンロード (75.9 KB)

その他問い合わせ #3810 » JobArranger_var1.0.txt

JobArrangerの構築手順書 - 匿名ユーザー, 2026/08/08 14:07

 
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
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 "<?php " > "$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 '<Directory "/usr/share/jobarranger">' >> /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 ' <FilesMatch \.php$>' >> /etc/httpd/conf.d/jobarranger.conf && \
echo ' SetHandler "proxy:fcgi://127.0.0.1:9000"' >> /etc/httpd/conf.d/jobarranger.conf && \
echo ' </FilesMatch>' >> /etc/httpd/conf.d/jobarranger.conf && \
echo '</Directory>' >> /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
<?php
//Jobarranger Manager Path
define('JAM_URL' , 'https://zabbix.sasio.jp/jobarranger');
[root@om01 zabbix]#



━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
15.標準機能のZabbixテーブルの一覧の確認
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
★ノウハウ
時間経過

[root@om01 jobarg-build]# docker exec -it jobarg mysql -h zabbix-mysql -u zabbix -pzabbixpass zabbix -e "SHOW TABLES;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------------------------------+
| Tables_in_zabbix |
+-----------------------------------+
| acknowledges |
| actions |
| alerts |
| auditlog |
| autoreg_host |
| changelog |
| conditions |
| config |
| config_autoreg_tls |
| connector |
| connector_tag |
| corr_condition |
| corr_condition_group |
| corr_condition_tag |
| corr_condition_tagpair |
| corr_condition_tagvalue |
| corr_operation |
| correlation |
| dashboard |
| dashboard_page |
| dashboard_user |
| dashboard_usrgrp |
| dbversion |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| event_recovery |
| event_suppress |
| event_symptom |
| event_tag |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| group_discovery |
| group_prototype |
| ha_node |
| hgset |
| hgset_group |
| history |
| history_bin |
| history_log |
| history_str |
| history_text |
| history_uint |
| host_discovery |
| host_hgset |
| host_inventory |
| host_proxy |
| host_rtdata |
| host_tag |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| hstgrp |
| httpstep |
| httpstep_field |
| httpstepitem |
| httptest |
| httptest_field |
| httptest_tag |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| interface_discovery |
| interface_snmp |
| item_condition |
| item_discovery |
| item_parameter |
| item_preproc |
| item_rtdata |
| item_rtname |
| item_tag |
| items |
| ja_2_calendar_control_table |
| ja_2_calendar_detail_table |
| ja_2_define_extjob_table |
| ja_2_define_run_log_message_table |
| ja_2_define_value_jobcon_table |
| ja_2_filter_control_table |
| ja_2_flow_control_table |
| ja_2_host_lock_table |
| ja_2_icon_agentless_table |
| ja_2_icon_calc_table |
| ja_2_icon_end_table |
| ja_2_icon_extjob_table |
| ja_2_icon_fcopy_table |
| ja_2_icon_fwait_table |
| ja_2_icon_if_table |
| ja_2_icon_info_table |
| ja_2_icon_job_table |
| ja_2_icon_jobnet_table |
| ja_2_icon_reboot_table |
| ja_2_icon_release_table |
| ja_2_icon_task_table |
| ja_2_icon_value_table |
| ja_2_icon_zabbix_link_table |
| ja_2_index_table |
| ja_2_job_command_table |
| ja_2_job_control_table |
| ja_2_jobnet_control_table |
| ja_2_object_lock_table |
| ja_2_parameter_table |
| ja_2_ran_flow_table |
| ja_2_ran_job_table |
| ja_2_ran_job_variable_table |
| ja_2_ran_jobnet_summary_table |
| ja_2_ran_jobnet_table |
| ja_2_ran_jobnet_variable_table |
| ja_2_ran_log_table |
| ja_2_ran_value_job_table |
| ja_2_ran_value_jobcon_table |
| ja_2_run_action_table |
| ja_2_run_flow_table |
| ja_2_run_job_table |
| ja_2_run_job_variable_table |
| ja_2_run_jobnet_summary_table |
| ja_2_run_jobnet_table |
| ja_2_run_jobnet_variable_table |
| ja_2_run_log_table |
| ja_2_run_timeout_table |
| ja_2_run_value_job_table |
| ja_2_run_value_jobcon_table |
| ja_2_schedule_control_table |
| ja_2_schedule_detail_table |
| ja_2_schedule_jobnet_table |
| ja_2_send_message_table |
| ja_2_session_table |
| ja_2_value_job_table |
| ja_2_value_jobcon_table |
| ja_2_zbx_hosts_table |
| lld_macro_path |
| lld_override |
| lld_override_condition |
| lld_override_opdiscover |
| lld_override_operation |
| lld_override_ophistory |
| lld_override_opinventory |
| lld_override_opperiod |
| lld_override_opseverity |
| lld_override_opstatus |
| lld_override_optag |
| lld_override_optemplate |
| lld_override_optrends |
| maintenance_tag |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| media |
| media_type |
| media_type_message |
| media_type_param |
| mfa |
| mfa_totp_secret |
| module |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opinventory |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| optag |
| optemplate |
| permission |
| problem |
| problem_tag |
| profiles |
| proxy |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_group |
| proxy_group_rtdata |
| proxy_history |
| proxy_rtdata |
| regexps |
| report |
| report_param |
| report_user |
| report_usrgrp |
| rights |
| role |
| role_rule |
| scim_group |
| script_param |
| scripts |
| service_alarms |
| service_problem |
| service_problem_tag |
| service_status_rule |
| service_tag |
| services |
| services_links |
| sessions |
| sla |
| sla_excluded_downtime |
| sla_schedule |
| sla_service_tag |
| sysmap_element_trigger |
| sysmap_element_url |
| sysmap_shape |
| sysmap_url |
| sysmap_user |
| sysmap_usrgrp |
| sysmaps |
| sysmaps_element_tag |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| tag_filter |
| task |
| task_acknowledge |
| task_check_now |
| task_close_problem |
| task_data |
| task_remote_command |
| task_remote_command_result |
| task_result |
| timeperiods |
| token |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| trigger_queue |
| trigger_tag |
| triggers |
| ugset |
| ugset_group |
| user_scim_group |
| user_ugset |
| userdirectory |
| userdirectory_idpgroup |
| userdirectory_ldap |
| userdirectory_media |
| userdirectory_saml |
| userdirectory_usrgrp |
| users |
| users_groups |
| usrgrp |
| valuemap |
| valuemap_mapping |
| widget |
| widget_field |
+-----------------------------------+
[root@om01 jobarg-build]#

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
16.追加オプションの設定ファイルの確認(Job Arranger)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

[root@om01 jobarg-build]# docker exec -it jobarg mysql -h zabbix-mysql -u zabbix -pzabbixpass zabbix -e "SELECT * FROM ja_2_index_table;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+----------+---------------------+
| count_id | nextid |
+----------+---------------------+
| 1 | 1 |
| 2 | 1500000000000000000 |
| 3 | 1600000000000000000 |
| 20 | 1 |
| 30 | 1 |
| 40 | 1 |
| 100 | 1 |
| 101 | 1 |
| 102 | 1 |
| 103 | 1 |
+----------+---------------------+
[root@om01 jobarg-build]#

----------------------------------------------------------------------------------------------------------------------------

[root@om01 jobarg-build]# docker exec -it jobarg ps aux | grep -E "httpd|php-fpm|jobarg"
root 255 0.0 0.1 182020 11648 ? Ss 13:20 0:00 php-fpm: mast
apache 256 0.0 0.1 184268 13328 ? S 13:20 0:00 php-fpm: pool
apache 257 0.0 0.1 184268 13328 ? S 13:20 0:00 php-fpm: pool
apache 258 0.0 0.1 184268 13328 ? S 13:20 0:00 php-fpm: pool
apache 259 0.0 0.1 184268 13328 ? S 13:20 0:00 php-fpm: pool
apache 260 0.0 0.1 184268 13332 ? S 13:20 0:00 php-fpm: pool
zabbix 282 0.0 0.0 1671900 6648 ? Sl 13:20 0:00 jobarg_manage
zabbix 283 0.0 0.0 1672156 8784 ? Sl 13:20 0:00 jobarg_server
[root@om01 jobarg-build]#

----------------------------------------------------------------------------------------------------------------------------

[root@om01 jobarg-build]# docker exec -it jobarg cat /usr/share/jobarranger/api/app/config/jam.config.php
<?php
// Zabbix Database params
define('DATA_SOURCE_NAME' , 'mysql'); //mysql=MySQL,pgsql=PostgreSQL
define('DB_HOST' , 'zabbix-mysql');
define('DB_USER' , 'zabbix');
define('DB_PASS' , 'zabbixpass');
define('DB_NAME' , 'zabbix');
define('DB_PORT' , '3306');

// Job Arranger Database params
define('JA_DB_HOST' , 'zabbix-mysql');
define('JA_DB_USER' , 'zabbix');
define('JA_DB_PASS' , 'zabbixpass');
define('JA_DB_NAME' , 'zabbix');
define('JA_DB_PORT' , '3306');


// Used for Zabbix Database TLS connection.
define('DB_ENCRYPTION', 0);
define('DB_CA_FILE', '');
define('DB_KEY_FILE', '');
define('DB_CERT_FILE', '');
define('DB_VERIFY_HOST', 0);
define('DB_CIPHER_LIST', '');

// Used for Job Arranger Database TLS connection.
define('JA_DB_ENCRYPTION', 0);
define('JA_DB_CA_FILE', '');
define('JA_DB_KEY_FILE', '');
define('JA_DB_CERT_FILE', '');
define('JA_DB_VERIFY_HOST', 1);
define('JA_DB_CIPHER_LIST', '');

//ZABBIX API URL
define('ZBX_API_ROOT', 'http://zabbix-web:8080/');
define('ZBX_REDIRECT_URL', 'https://jobarg.sasio.jp');

//SSL VERIFICATION 0=No 1=Yes
define('SSL_VERIFICATION', 0);

//Application Log Path (Dynamic links)
define('APPLICATION_LOG_PATH', '/var/log/jobarranger/manager/jobarg_manager.log');

//Application Log Level (Dynamic)
define('APPLICATION_LOG_LEVEL', 'INFO');

//Permission To access SETUP screen 0=No 1=Yes
define('CONFIG_CREATION_PERMISSION',1);
if (isset($_SERVER["HTTP_X_FORWARDED_PROTO"]) && $_SERVER["HTTP_X_FORWARDED_PROTO"] === "https") { $_SERVER["HTTPS"] = "on"; }
[root@om01 jobarg-build]#

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
17.新規コンテナ構築の起動確認と設定確認(Job Arranger)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

# 状態確認
docker ps -f name=jobarg

[root@om01 jobarg-build]# docker ps -f name=jobarg
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
53c5a9ee3ef2 local/jobarg-server:7.2.1 "/bin/sh -c 'echo 'S…" 7 minutes ago Up 7 minutes 80/tcp, 0.0.0.0:10061->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]#
(19-19/19)