Ad Widget

Collapse

Appliance - MYSQL wont start

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jdoggy31
    Member
    • Feb 2019
    • 39

    #1

    Appliance - MYSQL wont start

    Hello - I've been using the Zabbix appliance 4.0 for about 2 weeks now, and everything has been good. Today, when i try to login to the WEB ui, get Error connecting to Data Base: No such file or directory

    when I try to Start MYSQL I get errors I have attached a snip.

    I'm lost kinda lost, can someone help steer me in the right direction.

    -Jason






    Attached Files
  • dimir
    Zabbix developer
    • Apr 2011
    • 1080

    #2
    Please show us the output of
    Code:
    journalctl -xe
    One of the reasons is that you ran out of disk space.

    Comment

    • jdoggy31
      Member
      • Feb 2019
      • 39

      #3
      dimir Thank You, I have attached the requested output. I tried to increase my disk space following the instructions on the manual. But it looks like the instructions don't match up perfectly and then don't work. I was finally able to extend the volume. using a few different forum threads.

      But still no mysql start
      Attached Files

      Comment

      • kloczek
        Senior Member
        • Jun 2006
        • 1771

        #4
        Check mysql logs.
        http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
        https://kloczek.wordpress.com/
        zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
        My zabbix templates https://github.com/kloczek/zabbix-templates

        Comment

        • dimir
          Zabbix developer
          • Apr 2011
          • 1080

          #5
          Looks like SELinux is blocking MySQL operations. See /var/log/audit/audit.log for details. Did you recently enable/modify SELinux?

          Comment

          • jdoggy31
            Member
            • Feb 2019
            • 39

            #6
            No SELinux changes Does the appliance even come with it .. Still struggling to find the answer. I have attached a snip of the mysql error log - Hopefull someone can help/
            Attached Files

            Comment

            • solomonaom
              Member
              • Feb 2019
              • 58

              #7
              seems plugin error .,can you connect mysql ?

              Comment

              • jdoggy31
                Member
                • Feb 2019
                • 39

                #8
                I Cannot - I get a cannot connect to mysql through socket error

                Comment

                • solomonaom
                  Member
                  • Feb 2019
                  • 58

                  #9
                  you can check mysql.cnf in socket path and check mysql.sock is exist

                  Comment

                  • jdoggy31
                    Member
                    • Feb 2019
                    • 39

                    #10
                    I can find it in mysqld.cnf - Located in the exact same spot as a working version of the appliance. I attached a snip
                    Attached Files

                    Comment

                    • jdoggy31
                      Member
                      • Feb 2019
                      • 39

                      #11
                      Ok navigating to where mysql.sock is supposed to results in an empty directory, Not sure how to get these files back

                      Comment

                      • solomonaom
                        Member
                        • Feb 2019
                        • 58

                        #12
                        stop service mysql and bring mysql.sock back to default location in configuration and start mysql again

                        Comment

                        Working...