Ad Widget

Collapse

Zabbix Database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Buercky
    Junior Member
    • Apr 2021
    • 2

    #1

    Zabbix Database error

    Zabbix newby here. Recently installed the Zabbix appliance to VMware. All systems were go until I tried changing from dhcp to a static IP address. I followed this article to change it. 11.2. Interface Configuration Files Red Hat Enterprise Linux 6 | Red Hat Customer Portal after changing the IP address and checking the ifcfg-profile file everything looked like it changed correctly. I rebooted the appliance and an OS update auto installed. Now when I attempt to open Zabbix I get this Click image for larger version  Name:	Zabbix.JPG Views:	3 Size:	13.4 KB ID:	423651
    further investigation
    Running find / -type s gets me this
    /run/php-fpm/zabbix.sock

    in /etc/zabbix/zabbix_server.conf SocketDir=/var/run/zabbix

    Zabbix server log I get this error:

    3716:20210322:143803.827 using configuration file: /etc/zabbix/zabbix_server.conf
    3716:20210322:143803.891 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    3716:20210322:143803.891 database is down: reconnecting in 10 seconds

    In /etc/zabbix/web/zabbix.conf.php I get this:

    <?php
    // Zabbix GUI configuration file.

    $DB['TYPE'] = 'MYSQL';
    $DB['SERVER'] = 'localhost';
    $DB['PORT'] = '0';
    $DB['DATABASE'] = 'zabbix';
    $DB['USER'] = 'zabbix';
    $DB['PASSWORD'] = 'XXXXXXXX';

    // Schema name. Used for PostgreSQL.
    $DB['SCHEMA'] = '';

    // Used for TLS connection.
    $DB['ENCRYPTION'] = false;
    $DB['KEY_FILE'] = '';
    $DB['CERT_FILE'] = '';
    $DB['CA_FILE'] = '';
    $DB['VERIFY_HOST'] = false;
    $DB['CIPHER_LIST'] = '';

    // Vault configuration. Used if database credentials are stored in Vault secrets manager.
    $DB['VAULT_URL'] = '';
    $DB['VAULT_DB_PATH'] = '';
    $DB['VAULT_TOKEN'] = '';

    // Use IEEE754 compatible value range for 64-bit Numeric (float) history values.
    // This option is enabled by default for new Zabbix installations.
    // For upgraded installations, please read database upgrade notes before enabling this option.
    $DB['DOUBLE_IEEE754'] = true;

    $ZBX_SERVER = 'localhost';
    $ZBX_SERVER_PORT = '10051';
    $ZBX_SERVER_NAME = '';

    $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;



    Any help would be greatly appreciated.
    Last edited by Buercky; 27-04-2021, 22:02.
Working...