启动zabbix错误问题

问题描述：

错误提示：Job for zabbix-server.service failed. See "systemctl status zabbix-server.service" and "journalctl -xe" for details.

状态：

● zabbix-server.service - Zabbix Server
   Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; vendor preset: disabled)
   Active: activating (start) since 三 2024-01-24 20:50:22 CST; 1ms ago
  Control: 27386 (zabbix_server)
   CGroup: /system.slice/zabbix-server.service
           └─27386 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf

第一步：

1、先排查防火墙是否关闭

sudo systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
已经关闭，问题继续排查

2、查看SELinux是否关闭

sudo vim /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three two values:
#     targeted - Targeted processes are protected,
#     minimum - Modification of targeted policy. Only selected processes are protected. 
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

已经关闭，问题继续排查

3、相关Server的配置文件，比如MySQL的Host，User，Password，全部确认无误，查看MySQL的初始化表格是否创建成功。

问题找到：yum下载的Zabbix默认给的是zabbix-server-mysql-5.0.40版本的SQL运行文件，而个人安装的版本是5.7.16，会出现路径找不着SQL文件执行不成功的问题。把SQL文件取出来，重新在Navicat执行一遍SQL文件即可解决。