[1045] Access denied for user

[jepoytengco]

Hi, after following the guide below from installing, configuring zabbix in a Centos machine, when I tried to access the GUI config page of Zabbix, I get the value as "no" for the status of the Zabbix server

https://www.unixmen.com/how-to-install-zabbix-server-on-centos-7/

I checked the log under

/etc/log/zabbix/zabbix_server.log

I see a lot of messages that says:

16849:20161119:001814.719 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
16849:20161119:001814.719 database is down: reconnecting in 10 seconds

I tried to disable Firewalld just to ensure not a firewall issue but still the same. I also tried interchanging the ports from 10050 to 10051 but I'm pretty sure that username and password are both correct.

Appreciate any help for this issue.

Thanks
Jeff

[jepoytengco]

I tried to reinstall the machine, thinking might have missed something or done something incorrectly. When I checked the logs under /var/log/zabbix/zabbix_server.log I see a single error message

12801:20161120:012335.035 cannot send list of active checks to [zabbix ip address]: host [hostname.domain name] not found

I also checked the zabbix_agentd.log and below is the log messages

12855:20161120:012335.035 no active checks on server [zabbix ip address]: host [hostname.domain name] not found
12855:20161120:012535.133 no active checks on server [zabbix ip address]: host [hostname.domain name] not found
12855:20161120:012735.249 no active checks on server [zabbix ip address]: host [hostname.domain name] not found

Thanks
Jeff

[SDPCR]

Are you able to connect to mysql locally using the password configured during the install?

mysql -u zabbix@localhost -p

If that works, is your server config file setup using the same user/pass?

sudo cat /etc/zabbix/zabbix_server.conf | grep -v "^ *\(#.*\|\)$" | grep -e 'DBUser\|DBPassword\|DBName'

[jepoytengco]

issue has been solved. No idea what this command for, I'm guessing its for SELinux fw. But Im really not sure what for, but this command helped me, and the status became yes.

setsebool -P httpd_can_network_connect=true

Yes, I'm able to connect to mysql no probelm with that.

Thanks for the input
Jeff