I will try to keep this short
Zabbix 4.4.0, running on CentOS and MariaDB 5.5
I had some guys trying to build zabbix in a docker container, but using the current DB instead of trying to do some form of backup/restore into a container. Something happened, and even though the docker containers were not running any longer, MariaDB would no longer start. After we finally got it to start, we could still not log into Zabbix. It appeared that the users table was completely empty.
After many hours of troubleshooting, the current state is that I was able to get the zabbix DB rebuilt and the Admin user available to log in. I still have the original 56G ibdata file, and I did a full restore of a backup we made last night (unknown if the backup is corrupted with the same issue, however). I also have a backup from a month ago that 'should' be good. All of these are full zabbix DB dumps, and have been compressed due to lack of space.
We also made a full copy of the entire mysql directory (including zabbix db folder and ibdata files) to another directory as a secondary backup.
I thought perhaps after recreating the zabbix db, which allowed me to finally log in as Admin, and then copying the backup zabbix DB directory over (overwriting everything), it might relink all my data. It does not appear to have done so.
I am at a loss as to what steps to take next, and any help will be greatly appreciated.
Zabbix 4.4.0, running on CentOS and MariaDB 5.5
I had some guys trying to build zabbix in a docker container, but using the current DB instead of trying to do some form of backup/restore into a container. Something happened, and even though the docker containers were not running any longer, MariaDB would no longer start. After we finally got it to start, we could still not log into Zabbix. It appeared that the users table was completely empty.
After many hours of troubleshooting, the current state is that I was able to get the zabbix DB rebuilt and the Admin user available to log in. I still have the original 56G ibdata file, and I did a full restore of a backup we made last night (unknown if the backup is corrupted with the same issue, however). I also have a backup from a month ago that 'should' be good. All of these are full zabbix DB dumps, and have been compressed due to lack of space.
We also made a full copy of the entire mysql directory (including zabbix db folder and ibdata files) to another directory as a secondary backup.
I thought perhaps after recreating the zabbix db, which allowed me to finally log in as Admin, and then copying the backup zabbix DB directory over (overwriting everything), it might relink all my data. It does not appear to have done so.
I am at a loss as to what steps to take next, and any help will be greatly appreciated.