zabbix' failed: [1044] Access denied for user 'zab
环境：zabbix 3.4
Redhat 6.5 64
PHP 5.5
Mysql 5.6
Nginx1.6
现象：登录zabbix后，提示service is not runing ,zabbix状态显示如下截图
http://s1.运维网.com/images/20180627/1530082101167721.png
日志分析：
日志路径：/tmp/zabbix_server.log
26508:20180627:144257.934 Starting Zabbix Server. Zabbix 3.4.10 (revision 81503).
26508:20180627:144257.934 ****** Enabled features ******
26508:20180627:144257.934 SNMP monitoring: YES
26508:20180627:144257.934 IPMI monitoring: NO
26508:20180627:144257.934 Web monitoring: YES
26508:20180627:144257.934 VMware monitoring: NO
26508:20180627:144257.934 SMTP authentication: NO
26508:20180627:144257.934 Jabber notifications: NO
26508:20180627:144257.934 Ez Texting notifications:YES
26508:20180627:144257.934 ODBC: NO
26508:20180627:144257.934 SSH2 support: NO
26508:20180627:144257.934 IPv6 support: NO
26508:20180627:144257.934 TLS support: NO
26508:20180627:144257.934 ******************************
26508:20180627:144257.934 using configuration file: /usr/local/zabbix/etc/zabbix_server.conf
26508:20180627:144257.938 connection to database 'zabbix' failed: Access denied for user 'zabbix'@'localhost' to database 'zabbix'
26508:20180627:144257.938 Cannot connect to the database. Exiting...
26533:20180627:144649.189 Starting Zabbix Server. Zabbix 3.4.10 (revision 81503).
原因分析:
由于zabbix启动是调用zabbix_server.conf配置文件，需要是从这个里面排查
http://s1.运维网.com/images/20180627/1530082481197291.png
由于标紫色的框内是注释，把此位置注释去掉，然后配置一下服务器对应的IP地址，再次重启zabbix服务，再观察错误
启动zabbix服务
# service zabbix_server start
Starting zabbix_server: [确定]
#
观察日志是否有报错信息：
26533:20180627:144649.189 Starting Zabbix Server. Zabbix 3.4.10 (revision 81503).
26533:20180627:144649.189 ****** Enabled features ******
26533:20180627:144649.189 SNMP monitoring: YES
26533:20180627:144649.189 IPMI monitoring: NO
26533:20180627:144649.189 Web monitoring: YES
26533:20180627:144649.189 VMware monitoring: NO
26533:20180627:144649.189 SMTP authentication: NO
26533:20180627:144649.189 Jabber notifications: NO
26533:20180627:144649.189 Ez Texting notifications:YES
26533:20180627:144649.189 ODBC: NO
26533:20180627:144649.189 SSH2 support: NO
26533:20180627:144649.189 IPv6 support: NO
26533:20180627:144649.189 TLS support: NO
26533:20180627:144649.189 ******************************
26533:20180627:144649.189 using configuration file: /usr/local/zabbix/etc/zabbix_server.conf
26533:20180627:144649.194 current database version (mandatory/optional): 03040000/03040007
26533:20180627:144649.194 required mandatory version: 03040000
26533:20180627:144649.203 server #0 started
26535:20180627:144649.208 server #2 started
26536:20180627:144649.208 server #3 started
26537:20180627:144649.208 server #4 started
26538:20180627:144649.209 server #5 started
26539:20180627:144649.209 server #6 started
26540:20180627:144649.306 server #7 started
26541:20180627:144649.309 server #8 started
26542:20180627:144649.310 server #9 started
26543:20180627:144649.312 server #10 started
26544:20180627:144649.315 server #11 started
26545:20180627:144649.318 server #12 started
26546:20180627:144649.319 server #13 started
26547:20180627:144649.320 server #14 started
26548:20180627:144649.321 server #15 started
26549:20180627:144649.323 server #16 started
26550:20180627:144649.325 server #17 started
26551:20180627:144649.326 server #18 started
26554:20180627:144649.334 server #21 started
26553:20180627:144649.336 server #20 started
26534:20180627:144649.338 server #1 started
26555:20180627:144649.339 server #22 started
26558:20180627:144649.348 server #25 started
26557:20180627:144649.348 server #24 started
26560:20180627:144649.349 server #27 started
26559:20180627:144649.349 server #26 started
26561:20180627:144649.350 server #28 started
26563:20180627:144649.351 server #30 started
26562:20180627:144649.358 server #29 started
26552:20180627:144649.371 server #19 started
26556:20180627:144649.416 server #23 started
26565:20180627:144649.417 server #32 started
26564:20180627:144649.446 server #31 started
26566:20180627:144649.447 server #33 started
26556:20180627:144737.648 cannot send list of active checks to "127.0.0.1": host not monitored
26556:20180627:144937.695 cannot send list of active checks to "127.0.0.1": host not monitored
26556:20180627:145137.740 cannot send list of active checks to "127.0.0.1": host not monitored
26556:20180627:145337.806 cannot send list of active checks to "127.0.0.1": host not monitored
26556:20180627:145537.914 cannot send list of active checks to "127.0.0.1": host not monitored
上述打印的日志信息并没有之前的错误信息，则说明是zabbix是启动成功了
查看zabbix启动的进程是否存在如下：
# ps -ef|grep zabbix_server
root 26416 35480 14:32 pts/1 00:00:00 tail -100f /tmp/zabbix_server.log
zabbix 26533 10 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server --显示进程
zabbix 26534265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: configuration syncer
zabbix 26535265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: alerter #1 started
zabbix 26536265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: alerter #2 started
zabbix 26537265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: alerter #3 started
zabbix 26538265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: housekeeper
zabbix 26539265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: timer #1
zabbix 26540265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: http poller #1
zabbix 26541265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: discoverer #1
zabbix 26542265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: history syncer #1
zabbix 26543265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: history syncer #2
zabbix 26544265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: history syncer #3
zabbix 26545265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: history syncer #4
zabbix 26546265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: escalator #1
zabbix 26547265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: proxy poller #1
zabbix 26548265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: self-monitoring
zabbix 26549265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: task manager
zabbix 26550265330 14:46 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_server: poller #1
页:
[1]