Zabbix 6 基于 OB 4.2 MySQL 部署实践

rpm -Uvh https://repo.zabbix.com/zabbix/6.0/rhel/8/x86_64/zabbix-release-6.0-4.el8.noarch.rpm
dnf clean all

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

zcat usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql -h10.0.0.63 -uzabbix@obmysql#obv4 -P2883 -pzab@BIX#123 -c -A zabbix6

 vim etc/zabbix/zabbix_server.conf


DBHost=10.0.0.63
DBName=zabbix6
DBUser=zabbix@obmysql#obv4
DBPassword=zab@BIX#123
DBPort=2883
AllowUnsupportedDBVersions=1

vim etc/nginx/conf.d/zabbix.conf
listen          8080;
server_name     server070;

systemctl restart zabbix-server zabbix-agent nginx php-fpm
systemctl enable zabbix-server zabbix-agent nginx php-fpm
systemctl status zabbix-server zabbix-agent nginx php-fpm

May 11 10:05:32 server070 zabbix_server[29247]: usr/sbin/zabbix_server: symbol lookup error: usr/sbin/zabbix_server: undefined symbol: usmAES192PrivProtocol                                                                            
May 11 10:05:32 server070 systemd[1]: zabbix-server.service: Control process exited, code=exited status=127
May 11 10:05:32 server070 systemd[1]: zabbix-server.service: Failed with result 'exit-code'.
May 11 10:05:32 server070 systemd[1]: Failed to start Zabbix Server.

dnf -y install net-snmp.x86_64

tail -n 50 /var/log/zabbix/zabbix_server.log -f

  7704:20240511:121338.429 using configuration file: etc/zabbix/zabbix_server.conf
  7704:20240511:121338.432 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to MySQL server on '10.0.0.63' (13)                                                                                                       
  7704:20240511:121338.432 database is down: reconnecting in 10 seconds

[root@server070 ~]# getenforce
Enforcing
[root@server070 ~]# setenforce 0

  8083:20240511:122233.607 Zabbix supports only "utf8_bin,utf8mb3_bin,utf8mb4_bin" collation(s). Database "zabbix" has default collation "utf8mb4_general_ci"
  8083:20240511:122233.615 character set name or collation name that is not supported by Zabbix found in 480 column(s) of database "zabbix"
  8083:20240511:122233.615 only character set(s) "utf8,utf8mb3,utf8mb4" and corresponding collation(s) "utf8_bin,utf8mb3_bin,utf8mb4_bin" should be used in database
  8083:20240511:122233.620 Unsupported DB! MySQL version 50625 is older than minimum required 50728
  8083:20240511:122233.620  
  8083:20240511:122233.620 Unable to start Zabbix server due to unsupported MySQL database version (5.06.25).
  8083:20240511:122233.620 Must be at least (8.00.0).
  8083:20240511:122233.620 Use of supported database version is highly recommended.
  8083:20240511:122233.620  

[root@server063 ~]# mysql -h10.0.0.63 -uroot@proxysys -P2883 -paaAA11__ -c -A
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 96129
Server version: 5.6.25


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


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


(root@proxysys@10.0.0.63:2883) [(none)]> alter proxyconfig set mysql_version='8.0.26';
Query OK, 0 rows affected (0.06 sec)


(root@proxysys@10.0.0.63:2883) [(none)]> show proxyconfig like '%mysql_version%';
+---------------+--------+--------------------------------------------------------------------------------------------------------------------------+-------------+---------------+
| name          | value  | info                                                                                                                     | need_reboot | visible_level |
+---------------+--------+--------------------------------------------------------------------------------------------------------------------------+-------------+---------------+
| mysql_version | 8.0.26 | returned version for mysql mode, default value is 5.6.25. If set, proxy will send new version when user connect to proxy | false       | USER          |
+---------------+--------+--------------------------------------------------------------------------------------------------------------------------+-------------+---------------+
1 row in set (0.00 sec)

dnf install -y glibc-langpack-zh

http://10.0.0.70:8080/setup.php

drop database zabbix6;
create database zabbix6 character set utf8mb4 collate utf8mb4_bin;
grant all privileges on zabbix6.* to zabbix;

zcat usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql -h10.0.0.63 -uzabbix@obmysql#obv4 -P2883 -pzab@BIX#123 -c -A zabbix6

SELECT column_type,count(*) FROM information_schema.columns WHERE table_schema='zabbix6' 
GROUP BY column_type WITH ROLLUP  ORDER BY column_type;

CREATE TRIGGER hosts_name_upper_insert BEFORE INSERT ON hosts FOR EACH ROW trigger hosts_name_upper_insert
before insert on hosts for each row
set new.name_upper=upper(new.name);


CREATE TRIGGER hosts_name_upper_update BEFORE UPDATE ON hosts FOR EACH ROW trigger hosts_name_upper_update
before update on hosts for each row
begin
if new.name<>old.name
then
set new.name_upper=upper(new.name);
end if;
end;


CREATE TRIGGER items_name_upper_insert BEFORE INSERT ON items FOR EACH ROW trigger items_name_upper_insert
before insert on items for each row
set new.name_upper=upper(new.name);


CREATE TRIGGER items_name_upper_update BEFORE UPDATE ON items FOR EACH ROW trigger items_name_upper_update
before update on items for each row
begin
if new.name<>old.name
then
set new.name_upper=upper(new.name);
end if;
end;

DELETE FROM history_uint WHERE  itemid = ?  AND clock < ?