Ad Widget

Collapse

Zabbix server is not running message on Web Console. Log shows mysql (13) error.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zabbixgreenie
    Junior Member
    • Oct 2018
    • 2

    #1

    Zabbix server is not running message on Web Console. Log shows mysql (13) error.

    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:
    1. Installed and configured Zabbix and successfully connected to Database
    2. Completed initial configuration of Zabbix on Web Server UI
    3. When logged into Web Server UI, Error on bottom of webpage shows "Zabbix Server is not running: the information displayed may not be current."
    4. 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)
    5. From Zabbix Server cli, used "mysql -h 'remotehost.rds.amazonaws.com' -u zabbixuser -p" and confirmed I can connect to database successfully
    6. created PHP script to connect to the same database via PHP and confirmed connection is successful.
    7. Double-checked zabbix_server.conf and confirmed correct DB settings are defined
    8. Double-checked zabbix.conf.php and confirmed correct DB and zabbix server settings are defined.
    9. Disabled SELINUX entirely to rule out SELINUX blocking anything. Error persists
    10. Went to Amazon RDS and EC2 security groups and opened up all traffic to rule out any network connectivity issues. Error persists



  • LenR
    Senior Member
    • Sep 2009
    • 1005

    #2
    See if this post applies: https://www.zabbix.com/forum/zabbix-...ect-on-install

    I the selinux rules for mysql client may be permitted by default but there won't be any default rules for zabbix.

    Comment

    • zabbixgreenie
      Junior Member
      • Oct 2018
      • 2

      #3
      I actually did set all the selinux rules necessary for zabbix. I even tried disabling selinux altogether and rebooted the linux box, but still getting that same error.

      Comment

      • LenR
        Senior Member
        • Sep 2009
        • 1005

        #4
        Post your server config file. You have 2 problems, neither the server nor the web frontend can connect.

        Comment

        Working...