Ad Widget

Collapse

Database error, Connection refused

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • RomanoVroege
    Junior Member
    • Jun 2020
    • 5
    #1

    Database error, Connection refused

    Hello,

    As of lately my zabbix server stoped working. Now i get this weird error message saying "Database error, Connection refused"
    I did not touch any of the database setting recently and everything was working correctly with no strange error messages.

    Click image for larger version Name: Knipsel.PNG Views: 19628 Size: 8.3 KB ID: 405650


    The zabbix server log says the following:


    Click image for larger version Name: Knipsel2.PNG Views: 19107 Size: 326.9 KB ID: 405651

    Could somebody help me with this? I put in a lot of time and i am affraid it has all gone to waste now.

    Tags: None
    • tim.mooney
      Senior Member
      • Dec 2012
      • 1427
      #2
      Have you verified that your MySQL database server is running?

      You don't provide any information about what OS, Linux distro, or version you're using, which makes it difficult for anyone responding to provide specific instructions.

      If you're on a system that uses systemd and systemctl and your mysql service happens to be called mysql.service, you could run

      Code:
      sudo systemctl status -l mysql.service
      to get long output status from the mysql.service. That might provide a clue about what the problem is.

        Comment

        • RomanoVroege
          #2.1
          RomanoVroege commented
          21-07-2020, 22:13
          Editing a comment
          I will try that tomorrow on my zabbix server! I am using ubuntu 20.04 with zabbix version 5.0. I will let you know tomorrow if the mysql server is running! Thanks in advance
        • RomanoVroege
          Junior Member
          • Jun 2020
          • 5
          #3
          tim.mooney I dont think this is good.. any tips or tricks?
          Click image for larger version Name: Knipsel.PNG Views: 18850 Size: 286.2 KB ID: 405707

            Comment

            • tim.mooney
              Senior Member
              • Dec 2012
              • 1427
              #4
              Something is very wrong with your database. systemd is trying to restart it but when it does, the database server intentionally exits with the ABRT signal. Whatever is wrong, the problem is with your database (not Zabbix).

              Start by looking at your mariadb server log files, to see if there are obvious messages in there about what the problem is. Considering how serious it appears to be, I'm not in any position to offer much help on whether it can be "fixed".

              You may end up having to recover from your most recent backup.

                Comment

                • RomanoVroege
                  #4.1
                  RomanoVroege commented
                  28-07-2020, 08:46
                  Editing a comment
                  Well i guess this is where my zabbix servers ends, ive tried everything that there is to find and now its even more broke than what i started with.
                  I did not have any backup because it was a full day of work and the backup doesnt start un till 2am..
                Previous template Next
                Working...