Zabbix server was running smoothly from quite long time. In last week, i have installed "Zabbix-get" package but after that server went down.
I am getting error "Server is not running" and logs shows Database authentication error. It looks like logs also not get generated after server was down.
I have checked sever config and matched with mysql password and looks good. I also changed DBuser in sever.conf to see any new log but i didnt see new error in log.
server config:
I am able to login to Mysql DB with both root and zabbix user.
I did lot of googling, tried to fix the issue but still no luck. Appreciate if someone help me with this issue.
Thank you in advance.
I am getting error "Server is not running" and logs shows Database authentication error. It looks like logs also not get generated after server was down.
Code:
696:20180312:002856.517 database is down: reconnecting in 10 seconds 696:20180312:002906.617 [Z3001] connection to database 'zabbix' failed: [0] FATAL: password authentication failed for user "zabbix" FATAL: password authentication failed for user "zabbix"
server config:
Code:
DBName=zabbix DBUser=zabbix DBPassword=MyDBPassword DBSocket=/var/run/mysqld/mysqld.sock
Code:
zabbix-server.service - LSB: Start zabbix-server daemon
Loaded: loaded (/etc/init.d/zabbix-server; generated; vendor preset: enabled)
Active: active (exited) since Thu 2018-03-15 23:14:43 IST; 1 day 9h ago
Docs: man:systemd-sysv-generator(8)
Process: 907 ExecStart=/etc/init.d/zabbix-server start (code=exited, status=0/SUCCESS)
CGroup: /system.slice/zabbix-server.service
Mar 15 23:14:43 systemd[1]: Starting LSB: Start zabbix-server daemon...
Mar 15 23:14:43 systemd[1]: Started LSB: Start zabbix-server daemon.
Code:
sudo mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 634 Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> mysql -u zabbix -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 689 Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Thank you in advance.
Comment