Zabbixの構築手順の紹介！Almalinuxでサーバ構築

# getenforce

# vi /etc/selinux/config

SELINUX=disabled

# cat /etc/selinux/config

# shutdown -r now

# getenforce
Disabled

# dnf install -y mariadb-server

# mysql --versionmysql --version
mysql: unknown option '--versionmysql'
mysql Ver 15.1 Distrib 10.5.27-MariaDB, for Linux (x86_64) using EditLine wrapper

# systemctl restart mariadb

# systemctl enable mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.

# systemctl status mariadb
● mariadb.service - MariaDB 10.5 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Active: active (running) since Sat 2025-02-08 18:08:41 JST; 15s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 3148 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 17 (limit: 10727)
Memory: 76.6M
CPU: 727ms
CGroup: /system.slice/mariadb.service
mq3148 /usr/libexec/mariadbd --basedir=/usr

2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: The second is mysql@localhost, it has no password either, but
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: you need to be the system 'mysql' user to connect.
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: After connecting you can set the password, if you would need to be
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: able to connect as any of these users with a password and without sudo
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: See the MariaDB Knowledgebase at https://mariadb.com/kb
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: Please report any problems at https://mariadb.org/jira
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: The latest information about MariaDB is available at https://mariadb.org/.
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: Consider joining MariaDB's strong and vibrant community:
2月 08 18:08:41 Zabbix mariadb-prepare-db-dir[3103]: https://mariadb.org/get-involved/
2月 08 18:08:41 Zabbix systemd: Started MariaDB 10.5 database server.

# cp /etc/my.cnf.d/mariadb-server.cnf /etc/my.cnf.d/mariadb-server.cnf_orgcp

# vi /etc/my.cnf.d/mariadb-server.cnf
[mysqld]に以下の項目を追加する
character-set-server = utf8
collation-server = utf8_bin
skip-character-set-client-handshake

# systemctl restart mariadb

# systemctl status mariadb

# rpm -Uvh https://repo.zabbix.com/zabbix/7.0/alma/9/x86_64/zabbix-release-7.0-2.el9.noarch.rpm
https://repo.zabbix.com/zabbix/7.0/alma/9/x86_64/zabbix-release-7.0-2.el9.noarch.rpm を取得中
警告: /var/tmp/rpm-tmp.TQ9W25: ヘッダー V4 RSA/SHA512 Signature、鍵 ID b5333005: NOKEY
Verifying... ################################# [100%]
準備しています... ################################# [100%]
更新中 / インストール中...
1:zabbix-release-7.0-2.el9 ################################# [100%]

# dnf clean all
キャッシュのクリアをすることで、リポジトリが使えるようになる

# dnf -y install zabbix-web-japanese
日本語環境に必要なパッケージのインストールをする

# dnf -y update

# dnf -y install epel-release

# vi /etc/yum.repos.d/epel.repo
[epel]
name=Extra Packages for Enterprise Linux $releasever - $basearch
# It is much more secure to use the metalink, but if you wish to use a local mirror
# place its address here.
#baseurl=https://download.example/pub/epel/$releasever/Everything/$basearch/
metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-$releasever&arch=$basearch&infra=$infra&content=$contentdir
enabled=1
gpgcheck=1
countme=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-$releasever
excludepkgs=zabbix*

# dnf -y install zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent

# mysql -uroot -pmysql -uroot -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.27-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database [任意のデータベース名] character set utf8mb4 collate utf8mb4_bin;
Query OK, 1 row affected (0.004 sec)

MariaDB [(none)]> create user [任意のユーザ名]@localhost identified by '[任意のパスワード]';
Query OK, 0 rows affected (0.012 sec)

MariaDB [(none)]> grant all privileges on zabbix.* to zabbix@localhost;
Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> set global log_bin_trust_function_creators = 1;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit
Bye

# zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbixzcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -u[作成したユーザ] -p [作成したデータベース名]
Enter password: [先ほど設定したパスワード]

# mysql -uroot -p
MariaDB [(none)]> set global log_bin_trust_function_creators = 0;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit

# cp /etc/zabbix/zabbix_server.conf /etc/zabbix/zabbix_server.conf_org

# cat /etc/zabbix/zabbix_server.conf
以下のようになっているのを確認する
# DBPassword=

# vi /etc/zabbix/zabbix_server.conf
以下のように修正する
DBPassword=[パスワードを入力]

# systemctl restart zabbix-server zabbix-agent httpd php-fpm
# systemctl enable zabbix-server zabbix-agent httpd php-fpm
# systemctl status zabbix-server
# systemctl status zabbix-agent
# systemctl status httpd
# systemctl status php-fpm

# firewall-cmd --add-port=10051/tcp --zone=public --permanent
# firewall-cmd --add-port=80/tcp --zone=public --permanent
# firewall-cmd --reload