Ad Widget

Collapse

The usual - Zabbix Server is not running - user zabbix denied access to db

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SeanRinVA
    Junior Member
    • Jan 2021
    • 1

    #1

    The usual - Zabbix Server is not running - user zabbix denied access to db

    Zabbix 5.0.1 on Ubuntu 20.04
    MariaDB

    Receiving the dreaded Access denied for user 'zabbix'@'localhost' using password error when Zabbix server starts

    I have confirmed proper settings in zabbix_server.conf and zabbix.conf.php
    I have run mysql -uzabbix -p'pwd', including running various queries without error

    Zabbix Server Log:
    Code:
    549075:20210108:130320.580 Starting Zabbix Server. Zabbix 5.0.7 (revision 1b3db7f980).
    549075:20210108:130320.580 ****** Enabled features ******
    549075:20210108:130320.580 SNMP monitoring: YES
    549075:20210108:130320.580 IPMI monitoring: YES
    549075:20210108:130320.580 Web monitoring: YES
    549075:20210108:130320.580 VMware monitoring: YES
    549075:20210108:130320.580 SMTP authentication: YES
    549075:20210108:130320.580 ODBC: YES
    549075:20210108:130320.580 SSH support: YES
    549075:20210108:130320.580 IPv6 support: YES
    549075:20210108:130320.580 TLS support: YES
    549075:20210108:130320.580 ******************************
    549075:20210108:130320.580 using configuration file: /etc/zabbix/zabbix_server.conf
    549075:20210108:130320.585 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
    549075:20210108:130320.585 database is down: reconnecting in 10 seconds
    zabbix.server.conf:
    Code:
    DBHost=localhost
    DBName=zabbix
    DBUser=zabbix
    DBPassword='pwd'
    DBSocket (defaults)
    DBPort (defaults)
    zabbix.conf.php:
    Code:
    $DB['TYPE'] = 'MYSQL';
    $DB['SERVER'] = 'localhost';
    $DB['PORT'] = '0';
    $DB['DATABASE'] = 'zabbix';
    $DB['USER'] = 'zabbix';
    $DB['PASSWORD'] = 'pwd';
    
    $ZBX_SERVER = '192.168.1.63';             #Tried 'localhost' w/ same results
    $ZBX_SERVER_PORT = '10051';            #Tried '10050' w/ same results
    $ZBX_SERVER_NAME = '';
    Am I missing any bits of info which would help troublehoot?
Working...