Database Error : Error connecting to database: No such file or directory

[AmrHashem]

Hello Everybody, I hardly post about a problem unless i tried to troubleshoot for a while myself..

I am hosting an offline Zabbix 4.2.5 OVF on VirtaulBox, when the electricity went out on the server and after it got back up, I kept getting that error on the UI..



So I checked the forums and tried to do the following...

vi /etc/mysql/my.mycnf and added another line innodb_froce_recovery=1 saved and restarted instance, but still no change.

Then I found another post to...
vi /etc/zabbix/zabbix_server.conf and change the db password manually from its random generated one to anyone i like so I made it like "DBPassword=zabbix"... then...
vi /etc/zabbix/web/zabbix.conf.php and did the same thing "$DB[‘PASSWORD’] =zabbix", restarted instance and then...
mysql -u root -p to try to change zabbix mysql user password, it prompts me to enter password, so zabbix is not working and not the old one either..



This is also a tail for the log file..



What should I do to get the UI back up, there are several months of data on that build, and I don't want to lose it all !!

[Atsushi]

Is the MySQL server running? If the MySQL server has not been started, check the MySQL server log.

[corona]

Hi, i have excactly the same problem, the electricity went out and restarted Zabbix with this problem

[cgrafner]

Corona, did you ever find a fix for this? I am having the exact same problem. Power outage and now this "No such file or directory" message. I really don't want to reload.

[epizarro]

Same problem,
Zabbix 5.0

After power outage, cant login but sabbix server is runnin

[epizarro]

Typo error: After power outage, cant login but zabbix server is running.

btw: can't edit posts

[epizarro]

[epizarro]

[studenttmb]

Добрый день! присоединяюсь к данной проблеме (Ubuntu 18.04, Zabbix 5.2). Был критический сбой в основной ОС (BSOD), после чего такая же ошибка mysql. Как ее можно исправить, чтобы все данные не слетели?!