Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17745

Several errors after "Changing database character set and collation"

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Duplicate
    • 4.4.8
    • None
    • Frontend (F), Server (S)
    • None
    • Debian 10 Buster
      MariaDB 10.4

    Description

      Steps to reproduce:

      1. Have an old Zabbix Database on MySQL or MariaDB from pre 3.0 era
      2. Patch to 4.4.4 or higher
      3. Try to repair according to:
        https://www.zabbix.com/documentation/current/manual/appendix/install/db_charset_coll
      4. Use query from ZBX-17740 instead

      Result:

      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.

      Expected:
      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?

      Attachments

        Activity

          People

            rvaliahmetovs Renats Valiahmetovs (Inactive)
            starko Marco Hofmann
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: