报错如题所示，更详细的内容如下：
在ZABBIX的日志文件【/etc/zabbix/zabbix_server.conf，可以找到配置的日志文件的位置】中，你可以看到很多类似标题所示的报错
28106:20170227:112642.572 database is down: reconnecting in 10 seconds 28106:20170227:112652.572 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 28106:20170227:112652.572 database is down: reconnecting in 10 seconds 28106:20170227:112702.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 28106:20170227:112702.573 database is down: reconnecting in 10 seconds 28106:20170227:112712.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 28106:20170227:112712.573 database is down: reconnecting in 10 seconds
该报错的原因很简单，因为启用的MySQL的SOCKET不在默认的路径下，而ZABBIX，默认只会去默认的路径【/var/lib/mysql】找socket，当然找不到了，于是就报错了。
首先，看看我的socket的真实位置：
[root@zabbix-me backup]# cat /etc/my.cnf # # The Percona Server 5.7 configuration file. # # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # Please make any edits and changes to the appropriate sectional files # included below. # !includedir /etc/my.cnf.d/ !includedir /etc/percona-server.conf.d/ [client] socket=/data/database/percona_data/mysql.sock #mysql.default_socket = /data/database/percona_data/mysql.sock [root@zabbix-me backup]# [root@zabbix-me backup]# cat /etc/percona-server.conf.d/mysqld.cnf | grep -v '#' | strings [mysqld] datadir=/data/database/percona_data/db_data socket=/data/database/percona_data/mysql.sock log-bin=/data/database/percona_data/binlog_data/percona-binlog server-id=1 bind-address = 127.0.0.1 local-infile = 0 symbolic-links=0 log-error=/var/log/mysqld-error.log pid-file=/var/run/mysqld/mysqld.pid [client] socket=/data/database/percona_data/mysql.sock [root@zabbix-me backup]# [root@zabbix-me backup]# ls -ltr /data/database/percona_data/ | grep --color sock -rw------- 1 mysql mysql 6 Feb 27 11:01 mysql.sock.lock srwxrwxrwx 1 mysql mysql 0 Feb 27 11:01 mysql.sock [root@zabbix-me backup]#
对ZABBIX的配置文件作出更改：
[root@zabbix-me backup]# cat /etc/zabbix/zabbix_server.conf LogFile=/var/log/zabbix/zabbix_server.log LogFileSize=0 PidFile=/var/run/zabbix/zabbix_server.pid DBHost=localhost DBSocket=/data/database/percona_data/mysql.sock DBName=zabbix DBUser=zabbix DBPassword=Abcd1@34 #DBPassword= SNMPTrapperFile=/var/log/snmptrap/snmptrap.log Timeout=4 AlertScriptsPath=/usr/lib/zabbix/alertscripts ExternalScripts=/usr/lib/zabbix/externalscripts LogSlowQueries=3000 [root@zabbix-me backup]# [root@zabbix-me backup]# cat /etc/zabbix/zabbix_server.conf | grep DBSocket DBSocket=/data/database/percona_data/mysql.sock [root@zabbix-me backup]#
然后，重启zabbix服务就好了：
[root@zabbix-me backup]# systemctl status zabbix-server
● zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2017-02-27 11:28:03 CST; 8min ago
Process: 28253 ExecStop=/bin/kill -SIGTERM $MAINPID (code=exited, status=0/SUCCESS)
Process: 28255 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 28257 (zabbix_server)
CGroup: /system.slice/zabbix-server.service
├─28257 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
├─28258 /usr/sbin/zabbix_server: configuration syncer [synced configuration in 0.008348 sec, idle 60 sec]
├─28259 /usr/sbin/zabbix_server: db watchdog [synced alerts config in 0.001918 sec, idle 60 sec]
├─28260 /usr/sbin/zabbix_server: poller #1 [got 0 values in 0.000004 sec, idle 5 sec]
├─28261 /usr/sbin/zabbix_server: poller #2 [got 0 values in 0.000004 sec, idle 5 sec]
├─28262 /usr/sbin/zabbix_server: poller #3 [got 1 values in 0.000085 sec, idle 5 sec]
├─28263 /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000004 sec, idle 5 sec]
├─28264 /usr/sbin/zabbix_server: poller #5 [got 0 values in 0.000004 sec, idle 5 sec]
├─28265 /usr/sbin/zabbix_server: unreachable poller #1 [got 0 values in 0.000008 sec, idle 5 sec]
├─28266 /usr/sbin/zabbix_server: trapper #1 [processed data in 0.000000 sec, waiting for connection]
├─28267 /usr/sbin/zabbix_server: trapper #2 [processed data in 0.000014 sec, waiting for connection]
├─28268 /usr/sbin/zabbix_server: trapper #3 [processed data in 0.000000 sec, waiting for connection]
├─28269 /usr/sbin/zabbix_server: trapper #4 [processed data in 0.000000 sec, waiting for connection]
├─28270 /usr/sbin/zabbix_server: trapper #5 [processed data in 0.000000 sec, waiting for connection]
├─28271 /usr/sbin/zabbix_server: icmp pinger #1 [got 0 values in 0.000005 sec, idle 5 sec]
├─28272 /usr/sbin/zabbix_server: alerter [sent alerts: 0 success, 0 fail in 0.000949 sec, idle 30 sec]
├─28273 /usr/sbin/zabbix_server: housekeeper [startup idle for 30 minutes]
├─28274 /usr/sbin/zabbix_server: timer #1 [processed 1 triggers, 0 events in 0.000385 sec, 0 maintenances in 0.001080 sec, idle 30 sec]
├─28275 /usr/sbin/zabbix_server: http poller #1 [got 0 values in 0.000890 sec, idle 5 sec]
├─28276 /usr/sbin/zabbix_server: discoverer #1 [processed 0 rules in 0.001038 sec, idle 60 sec]
├─28277 /usr/sbin/zabbix_server: history syncer #1 [synced 0 items in 0.000002 sec, idle 1 sec]
├─28278 /usr/sbin/zabbix_server: history syncer #2 [synced 0 items in 0.000002 sec, idle 1 sec]
├─28279 /usr/sbin/zabbix_server: history syncer #3 [synced 0 items in 0.000002 sec, idle 1 sec]
├─28280 /usr/sbin/zabbix_server: history syncer #4 [synced 0 items in 0.000003 sec, idle 1 sec]
├─28281 /usr/sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.001093 sec, idle 3 sec]
├─28282 /usr/sbin/zabbix_server: proxy poller #1 [exchanged data with 0 proxies in 0.000005 sec, idle 5 sec]
├─28283 /usr/sbin/zabbix_server: self-monitoring [processed data in 0.000005 sec, idle 1 sec]
└─28284 /usr/sbin/zabbix_server: task manager [processed 0 task(s) in 0.000544 sec, idle 5 sec]
Feb 27 11:28:03 zabbix-me systemd[1]: zabbix-server.service: main process exited, code=exited, status=1/FAILURE
Feb 27 11:28:03 zabbix-me systemd[1]: Unit zabbix-server.service entered failed state.
Feb 27 11:28:03 zabbix-me systemd[1]: zabbix-server.service failed.
Feb 27 11:28:03 zabbix-me systemd[1]: Starting Zabbix Server...
Feb 27 11:28:03 zabbix-me systemd[1]: PID file /run/zabbix/zabbix_server.pid not readable (yet?) after start.
Feb 27 11:28:03 zabbix-me systemd[1]: Started Zabbix Server.
[root@zabbix-me backup]#
[root@zabbix-me backup]# systemctl stop zabbix-server
[root@zabbix-me backup]#
[root@zabbix-me backup]# systemctl start zabbix-server
[root@zabbix-me backup]#
[root@zabbix-me backup]# systemctl status zabbix-server
● zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2017-02-27 11:36:50 CST; 12s ago
Process: 28422 ExecStop=/bin/kill -SIGTERM $MAINPID (code=exited, status=0/SUCCESS)
Process: 28438 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 28440 (zabbix_server)
CGroup: /system.slice/zabbix-server.service
├─28440 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
├─28441 /usr/sbin/zabbix_server: configuration syncer [waiting 60 sec for processes]
├─28442 /usr/sbin/zabbix_server: db watchdog [synced alerts config in 0.055670 sec, idle 60 sec]
├─28443 /usr/sbin/zabbix_server: poller #1 [got 0 values in 0.000004 sec, idle 5 sec]
├─28444 /usr/sbin/zabbix_server: poller #2 [got 0 values in 0.000003 sec, idle 5 sec]
├─28445 /usr/sbin/zabbix_server: poller #3 [got 0 values in 0.000007 sec, idle 5 sec]
├─28446 /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000005 sec, idle 5 sec]
├─28447 /usr/sbin/zabbix_server: poller #5 [got 0 values in 0.000004 sec, idle 5 sec]
├─28448 /usr/sbin/zabbix_server: unreachable poller #1 [got 0 values in 0.000006 sec, idle 5 sec]
├─28449 /usr/sbin/zabbix_server: trapper #1 [processed data in 0.000000 sec, waiting for connection]
├─28450 /usr/sbin/zabbix_server: trapper #2 [processed data in 0.000000 sec, waiting for connection]
├─28451 /usr/sbin/zabbix_server: trapper #3 [processed data in 0.000000 sec, waiting for connection]
├─28452 /usr/sbin/zabbix_server: trapper #4 [processed data in 0.000024 sec, waiting for connection]
├─28453 /usr/sbin/zabbix_server: trapper #5 [processed data in 0.000000 sec, waiting for connection]
├─28454 /usr/sbin/zabbix_server: icmp pinger #1 [got 0 values in 0.000006 sec, idle 5 sec]
├─28455 /usr/sbin/zabbix_server: alerter [sent alerts: 0 success, 0 fail in 0.001411 sec, idle 30 sec]
├─28456 /usr/sbin/zabbix_server: housekeeper [startup idle for 30 minutes]
├─28457 /usr/sbin/zabbix_server: timer #1 [processed 1 triggers, 1 events in 0.129951 sec, 0 maintenances in 0.001293 sec, idle 29 sec]
├─28458 /usr/sbin/zabbix_server: http poller #1 [got 0 values in 0.000535 sec, idle 5 sec]
├─28459 /usr/sbin/zabbix_server: discoverer #1 [processed 0 rules in 0.000806 sec, idle 60 sec]
├─28460 /usr/sbin/zabbix_server: history syncer #1 [synced 0 items in 0.000003 sec, idle 1 sec]
├─28461 /usr/sbin/zabbix_server: history syncer #2 [synced 0 items in 0.000001 sec, idle 1 sec]
├─28462 /usr/sbin/zabbix_server: history syncer #3 [synced 0 items in 0.000003 sec, idle 1 sec]
├─28463 /usr/sbin/zabbix_server: history syncer #4 [synced 0 items in 0.000001 sec, idle 1 sec]
├─28464 /usr/sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000955 sec, idle 3 sec]
├─28465 /usr/sbin/zabbix_server: proxy poller #1 [exchanged data with 0 proxies in 0.000004 sec, idle 5 sec]
├─28466 /usr/sbin/zabbix_server: self-monitoring [processed data in 0.000005 sec, idle 1 sec]
└─28467 /usr/sbin/zabbix_server: task manager [processed 0 task(s) in 0.000476 sec, idle 5 sec]
Feb 27 11:36:50 zabbix-me systemd[1]: Starting Zabbix Server...
Feb 27 11:36:50 zabbix-me systemd[1]: PID file /run/zabbix/zabbix_server.pid not readable (yet?) after start.
Feb 27 11:36:50 zabbix-me systemd[1]: Started Zabbix Server.
[root@zabbix-me backup]#
[root@zabbix-me backup]#
这个过程中的日志：
------------------------------------------ 28257:20170227:113633.890 Got signal [signal:15(SIGTERM),sender_pid:28422,sender_uid:0,reason:0]. Exiting ... 28257:20170227:113635.891 syncing history data... 28257:20170227:113635.935 syncing history data done 28257:20170227:113635.935 syncing trend data... 28257:20170227:113636.061 syncing trend data done 28257:20170227:113636.062 Zabbix Server stopped. Zabbix 3.2.3 (revision 64610). --------------------------------------------- 28440:20170227:113650.836 Starting Zabbix Server. Zabbix 3.2.3 (revision 64610). 28440:20170227:113650.836 ****** Enabled features ****** 28440:20170227:113650.836 SNMP monitoring: YES 28440:20170227:113650.836 IPMI monitoring: YES 28440:20170227:113650.836 Web monitoring: YES 28440:20170227:113650.836 VMware monitoring: YES 28440:20170227:113650.836 SMTP authentication: YES 28440:20170227:113650.836 Jabber notifications: YES 28440:20170227:113650.836 Ez Texting notifications: YES 28440:20170227:113650.836 ODBC: YES 28440:20170227:113650.836 SSH2 support: YES 28440:20170227:113650.836 IPv6 support: YES 28440:20170227:113650.836 TLS support: YES 28440:20170227:113650.836 ****************************** 28440:20170227:113650.836 using configuration file: /etc/zabbix/zabbix_server.conf 28440:20170227:113650.852 current database version (mandatory/optional): 03020000/03020000 28440:20170227:113650.852 required mandatory version: 03020000 28440:20170227:113650.863 server #0 started [main process] 28452:20170227:113650.879 server #12 started [trapper #4] 28454:20170227:113650.883 server #14 started [icmp pinger #1] 28455:20170227:113650.883 server #15 started [alerter #1] 28457:20170227:113650.884 server #17 started [timer #1] 28453:20170227:113650.885 server #13 started [trapper #5] 28449:20170227:113650.888 server #9 started [trapper #1] 28444:20170227:113650.891 server #4 started [poller #2] 28445:20170227:113650.902 server #5 started [poller #3] 28441:20170227:113650.914 server #1 started [configuration syncer #1] 28442:20170227:113650.914 server #2 started [db watchdog #1] 28446:20170227:113650.915 server #6 started [poller #4] 28447:20170227:113650.926 server #7 started [poller #5] 28448:20170227:113650.937 server #8 started [unreachable poller #1] 28451:20170227:113650.948 server #11 started [trapper #3] 28456:20170227:113650.952 server #16 started [housekeeper #1] 28443:20170227:113650.952 server #3 started [poller #1] 28450:20170227:113650.963 server #10 started [trapper #2] 28458:20170227:113650.967 server #18 started [http poller #1] 28462:20170227:113650.974 server #22 started [history syncer #3] 28465:20170227:113650.975 server #25 started [proxy poller #1] 28466:20170227:113650.978 server #26 started [self-monitoring #1] 28464:20170227:113650.978 server #24 started [escalator #1] 28467:20170227:113650.981 server #27 started [task manager #1] 28459:20170227:113650.982 server #19 started [discoverer #1] 28460:20170227:113650.992 server #20 started [history syncer #1] 28463:20170227:113650.993 server #23 started [history syncer #4] 28461:20170227:113650.993 server #21 started [history syncer #2] -------------------------------------------------
——————————————————————————
Done。