Ad Widget

Collapse

Configuration File Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jtnnettech
    Junior Member
    • Apr 2017
    • 4

    #1

    Configuration File Error

    Zabbix error when browsing: "Configuration file error DB type "MYSQL" is not supported by current setup. Possible values."

    This happened after I upgraded the server from Ubuntu 16.04 to Ubuntu 16.04.2 () I shouldn't have done that.

    Mysql service is running, I can connect to the zabbix DB with the mysql account in the zabbix conf files and show tables and info inside of those tables.

    The error in zabbix_server.log is:

    "1584:20170413:111329.002 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

    system:~$ ls -l /var/run/mysqld/
    total 8
    -rw-r----- 1 mysql mysql 4 Apr 13 11:13 mysqld.pid
    srwxrwxrwx 1 mysql mysql 0 Apr 13 11:13 mysqld.sock
    -rw------- 1 mysql mysql 4 Apr 13 11:13 mysqld.sock.lock

    Any help would be greatly appreciated.
  • batchenr
    Senior Member
    • Sep 2016
    • 440

    #2
    Originally posted by jtnnettech
    Zabbix error when browsing: "Configuration file error DB type "MYSQL" is not supported by current setup. Possible values."

    This happened after I upgraded the server from Ubuntu 16.04 to Ubuntu 16.04.2 () I shouldn't have done that.

    Mysql service is running, I can connect to the zabbix DB with the mysql account in the zabbix conf files and show tables and info inside of those tables.

    The error in zabbix_server.log is:

    "1584:20170413:111329.002 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

    system:~$ ls -l /var/run/mysqld/
    total 8
    -rw-r----- 1 mysql mysql 4 Apr 13 11:13 mysqld.pid
    srwxrwxrwx 1 mysql mysql 0 Apr 13 11:13 mysqld.sock
    -rw------- 1 mysql mysql 4 Apr 13 11:13 mysqld.sock.lock

    Any help would be greatly appreciated.
    i think maybe the service stuck ?
    i have this :

    [root@zabbix:~:] ls -l /var/run/mysqld/
    total 4
    -rw-rw-r-- 1 mysql mysql 6 Apr 9 09:12 mysqld.pid


    can you try restart mysql ?
    or mv /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock_old and restart ?

    Comment

    • jtnnettech
      Junior Member
      • Apr 2017
      • 4

      #3
      I ended up backing up the database, reinstalling ubuntu 14, reinstalling zambia, and restoring the database. I *think* that ubuntu not supporting PHP5 was the issue.

      Thanks though!!!!

      Comment

      Working...