Ad Widget

Collapse

Database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dolson
    Junior Member
    • May 2022
    • 3

    #1

    Database error

    We had to rebuild out Zabbix server due to an issue that occurred. I was able to build the server successfully on a test hypervisor and it functioned out of the box. We moved the virtual disk to a production hypervisor, and while the system booted up, the agent on the Zabbix server was no longer able to communicate with the the server on the loopback address. When I tried to start the zabbix agent, it failed with an error, which will be a different post, but based on some of the research I read, I changed the password for zabbix@localhost account in mysql to remove special characters. I updated the zabbix_server.conf file with the new password. When I rebooted the sever, I am now getting the error message : Database error Access denied for user 'zabbix'@'localhost' (using password: YES). I have verified that the new password works for accessing mysql by logging into Mysql with the zabbix credentials.
  • dolson
    Junior Member
    • May 2022
    • 3

    #2
    Originally posted by Billy69

    The error establishing a database connection error basically means that for some reason or another the PHP code was unable to connect to your MySQL database to retrieve the information it needs to fully build that page.
    Thank you for the help Billy. I did find a couple of other posts suggesting that I configure the zabbix.conf.php file. From what I can tell, that file was not active, but I did create it from the example file Zabbix has provided and included the correct database password, but even after a server reboot, I'm still getting the same error. I don't know if the config file is in a different place other than /usr/shared/zabbix/conf

    Comment

    • dolson
      Junior Member
      • May 2022
      • 3

      #3
      Just solved my database connection issue. Thank you.

      Comment


      • tim.mooney
        tim.mooney commented
        Editing a comment
        For the benefit of other people that may find you posts, what was the problem?
    Working...