Error:
[Z3001] connection to database 'zabbixdb' failed: [2003] Can't connect to MySQL server on 'remotehost.rds.amazonaws.com' (13)
I'm having an issue where my Zabbix web console shows that Zabbix server is not running. I'm able to connect to the MySQL db via command line from my Zabbix server successfully, and also able to connect via PHP. The initial configuration of Zabbix web interface was successful, so I'm not sure what's going on. Zabbix server log shows that it can't connect to the database and gives a (13) error. Most of my research indicates that SELINUX or Amazon Security groups to open traffic will resolve the issue, but none of these have helped. Weirdest thing is that I can connect to the DB just fine via Linux CLI and PHP. This issue is driving me insane. Please help!
Current Setup:
Zabbix Server: CentOS 7 on Amazon EC2
Database Server: AmazonAurora (MySQL) on Amazon RDS
Here's what I've done so far:
[Z3001] connection to database 'zabbixdb' failed: [2003] Can't connect to MySQL server on 'remotehost.rds.amazonaws.com' (13)
I'm having an issue where my Zabbix web console shows that Zabbix server is not running. I'm able to connect to the MySQL db via command line from my Zabbix server successfully, and also able to connect via PHP. The initial configuration of Zabbix web interface was successful, so I'm not sure what's going on. Zabbix server log shows that it can't connect to the database and gives a (13) error. Most of my research indicates that SELINUX or Amazon Security groups to open traffic will resolve the issue, but none of these have helped. Weirdest thing is that I can connect to the DB just fine via Linux CLI and PHP. This issue is driving me insane. Please help!
Current Setup:
Zabbix Server: CentOS 7 on Amazon EC2
Database Server: AmazonAurora (MySQL) on Amazon RDS
Here's what I've done so far:
- Installed and configured Zabbix and successfully connected to Database
- Completed initial configuration of Zabbix on Web Server UI
- When logged into Web Server UI, Error on bottom of webpage shows "Zabbix Server is not running: the information displayed may not be current."
- Checked zabbix_server.log and error shows up "1240:20181004:232619.957 [Z3001] connection to database 'zabbixdb' failed: [2003] Can't connect to MySQL server on 'remotehost.rds.amazonaws.com' (13)
- From Zabbix Server cli, used "mysql -h 'remotehost.rds.amazonaws.com' -u zabbixuser -p" and confirmed I can connect to database successfully
- created PHP script to connect to the same database via PHP and confirmed connection is successful.
- Double-checked zabbix_server.conf and confirmed correct DB settings are defined
- Double-checked zabbix.conf.php and confirmed correct DB and zabbix server settings are defined.
- Disabled SELINUX entirely to rule out SELINUX blocking anything. Error persists
- Went to Amazon RDS and EC2 security groups and opened up all traffic to rule out any network connectivity issues. Error persists
Comment