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:
zabbix.server.conf:
zabbix.conf.php:
Am I missing any bits of info which would help troublehoot?
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
Code:
DBHost=localhost DBName=zabbix DBUser=zabbix DBPassword='pwd' DBSocket (defaults) DBPort (defaults)
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 = '';