Steps to reproduce:
- Have an old Zabbix Database on MySQL or MariaDB from pre 3.0 era
- Patch to 4.4.4 or higher
- Try to repair according to:
- Use query from
See log file: 3_alter.sql
Trying to login failed. Wrong user name and password. I had to use a backup admin account, a rename my account to function again.
Then I tried to add a trigger, but it says template not found. I had to rename the template twice, first a dummy name and then back to it's original name.After that it worked.
I'm not sure I haven't even discovered every problem, yet.
I know that the DB is now case-sensitive and this switch had to be done, but I have now a load of problems.
Did I do anything wrong, is this expected?