Connection to database ‘zabbix’ failed: [2002]

Hello IT fellas, When I came to the office today, I saw a warning on our monitoring system that said database error, connection refused. You can see the mentioned picture below.

Then I checked out the logs of the Zabbix which is given error below.

[root@appliance ~]# tail -f /var/log/zabbix/zabbix_server.log
  1144:20210531:082544.703 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
  1144:20210531:082544.703 database is down: reconnecting in 10 seconds

I’ve seen the same problem in the past and didn’t check the DB username and password whether it works. Let’s check the partition which is running on our MySQL. As you see in the picture below the file system /var/lib/mysql which is linked to /dev/sda5 is full. Seems this partition needs to be extended, I also have to check the housekeeper out not to get a similar problem in the future after solving this problem.

I prefer to extend the partition using the GParted Live CD. I shut down the server and started it with GParted. In this case, I will just extend the current disk size, and will not interested in the housekeeper issue. I won’t write anything and give any information from now on, you will just see how to extend your Linux partition with GParted.

Extending disk size of the linux partition is done. Let’s reject the GParted Live Cd and start the Zabbix OS.

The problem with the disk filling up has been resolved by extending the disk size. After this post, I will take a look housekeeper issue. Thanks for your time reading my article.