Ad Widget

Collapse

Zabbix database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CD2
    Junior Member
    • Oct 2017
    • 5

    #1

    Zabbix database error

    Hi Folks

    I have problem with Zabbix database it says that "Error connecting to database: No such file or directory"

    so when i look up the logs it show me something like this



    Could any one hlep me here


    Regards
    Attached Files
  • kaspars.mednis
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Oct 2017
    • 349

    #2
    From your screenshot it seems there is a mariadb, not a zabbix problem...

    Can you connect to mysql from commandline ?
    if yes, does the /var/run/mysqld/mysqld.sock exist ?

    Regards,
    Kaspars

    Comment

    • CD2
      Junior Member
      • Oct 2017
      • 5

      #3
      is not exist

      Comment

      • kaspars.mednis
        Senior Member
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Oct 2017
        • 349

        #4
        Have you attempted to fix your database ?
        your logs are pointing to this article

        https://dev.mysql.com/doc/refman/5.6...-recovery.html

        there is a guide how to fix it
        For example, you can add the following line to the [mysqld] section of your option file before restarting the server:
        Code:
        [mysqld]
        innodb_force_recovery = 1
        It's highly recommended to take a copy of all your DB files to some safe place before attempting to fix them !!! Read the warning on that page !!!

        Regards,
        Kaspars

        Comment

        Working...