Zabbix ' failed: [1044] Access denied for user ' Zab

Environment:

Zabbix 3.4

Redhat 6.5 64

PHP 5.5

Mysql 5.6

Nginx 1.6

Symptom: After logging in Zabbix, the service is not runing, Zabbix status is shown as follows

Log analysis:

Log path:/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 [Z3001] connection to database 'Zabbix ' failed: [1044] 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).

Cause Analysis:

Since Zabbix boot is called zabbix_server.conf configuration file, it needs to be cleared from this inside

Because the purple box is a comment, remove this position comment, then configure the server corresponding IP address, restart the Zabbix service again, and then observe the error

Start the Zabbix service

[[Email protected] ~]# service Zabbix_server start
Starting zabbix_server: [OK]
[Email protected] ~]#

See if the log has error messages:

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 [main process]
26535:20180627:144649.208 server #2 started [alerter #1]
26536:20180627:144649.208 server #3 started [alerter #2]
26537:20180627:144649.208 server #4 started [alerter #3]
26538:20180627:144649.209 server #5 started [housekeeper #1]
26539:20180627:144649.209 server #6 started [timer #1]
26540:20180627:144649.306 Server #7 started [http poller #1]
26541:20180627:144649.309 server #8 started [discoverer #1]
26542:20180627:144649.310 server #9 started [history syncer #1]
26543:20180627:144649.312 server #10 started [history syncer #2]
26544:20180627:144649.315 server #11 started [history syncer #3]
26545:20180627:144649.318 server #12 started [history syncer #4]
26546:20180627:144649.319 server #13 started [escalator #1]
26547:20180627:144649.320 server #14 started [proxy poller #1]
26548:20180627:144649.321 server #15 started [self-monitoring #1]
26549:20180627:144649.323 server #16 started [Task Manager #1]
26550:20180627:144649.325 server #17 started [Poller #1]
26551:20180627:144649.326 server #18 started [Poller #2]
26554:20180627:144649.334 server #21 started [Poller #5]
26553:20180627:144649.336 server #20 started [Poller #4]
26534:20180627:144649.338 server #1 started [configuration Syncer #1]
26555:20180627:144649.339 server #22 started [unreachable poller #1]
26558:20180627:144649.348 server #25 started [trapper #3]
26557:20180627:144649.348 server #24 started [trapper #2]
26560:20180627:144649.349 server #27 started [trapper #5]
26559:20180627:144649.349 server #26 started [trapper #4]
26561:20180627:144649.350 server #28 started [ICMP pinger #1]
26563:20180627:144649.351 server #30 started [preprocessing manager #1]
26562:20180627:144649.358 server #29 started [Alert manager #1]
26552:20180627:144649.371 server #19 started [Poller #3]
26556:20180627:144649.416 server #23 started [trapper #1]
26565:20180627:144649.417 server #32 started [preprocessing worker #2]
26564:20180627:144649.446 server #31 started [preprocessing worker #1]
26566:20180627:144649.447 server #33 started [preprocessing worker #3]
26556:20180627:144737.648 cannot send list of active checks to ' 127.0.0.1 ': host [Zabbix server] not monitored
26556:20180627:144937.695 cannot send list of active checks to ' 127.0.0.1 ': host [Zabbix server] not monitored
26556:20180627:145137.740 cannot send list of active checks to ' 127.0.0.1 ': host [Zabbix server] not monitored
26556:20180627:145337.806 cannot send list of active checks to ' 127.0.0.1 ': host [Zabbix server] not monitored
26556:20180627:145537.914 cannot send list of active checks to ' 127.0.0.1 ': host [Zabbix server] not monitored

The above printed log information does not have a previous error message, which means that the Zabbix was started successfully

See if the Zabbix initiated process exists as follows:

[Email protected] ~]# Ps-ef|grep zabbix_server
Root 26416 3548 0 14:32 pts/1 00:00:00 tail-100f/tmp/zabbix_server.log
Zabbix 26533 1 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server--Show process
Zabbix 26534 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:configuration Syncer [Synced Configuration in 0.004973 sec, idle sec]
Zabbix 26535 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:alerter #1 started
Zabbix 26536 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:alerter #2 started
Zabbix 26537 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:alerter #3 started
Zabbix 26538 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:housekeeper [Startup idle for Minutes]
Zabbix 26539 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:timer #1 [processed 0 triggers, 0 events in 0.000008 sec, 0 maintenances in 0.000659 sec, Idle [sec]
Zabbix 26540 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:http poller #1 [got 0 values in 0.000648 sec, idle 5 sec]
Zabbix 26541 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:discoverer #1 [processed 0 rules in 0.000330 sec, idle sec]
Zabbix 26542 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:history syncer #1 [synced 0 items in 0.000001 sec, idle 1 sec]
Zabbix 26543 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:history syncer #2 [synced 0 items in 0.000001 sec, idle 1 sec]
Zabbix 26544 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:history syncer #3 [synced 0 items in 0.000001 sec, idle 1 sec]
Zabbix 26545 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:history syncer #4 [synced 0 items in 0.000001 sec, idle 1 sec]
Zabbix 26546 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:escalator #1 [processed 0 escalations in 0.000497 sec, idle 3 sec]
Zabbix 26547 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:proxy Poller #1 [exchanged data with 0 proxies in 0.000002 sec, idle 5 sec]
Zabbix 26548 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:self-monitoring [Processed data in 0.000004 sec, idle 1 sec]
Zabbix 26549 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:task Manager [processed 0 task (s) in 0.000251 sec, idle 5 sec]
Zabbix 26550 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:poller #1 [got 0 values in 0.000002 sec, idle 5 sec]

Zabbix ' failed: [1044] Access denied for user ' Zab