Add latest MariaDB/MySQL support

XMLWordPrintable

    • Type: Change Request
    • Resolution: Duplicate
    • Priority: Major
    • None
    • Affects Version/s: 5.4.3
    • Component/s: Frontend (F)
    • None
    • Environment:
      MariaDB/MySQL from 10.6.1

      Steps to reproduce:

      1. When use MariaDB >= 10.6.1
      2. Cannot install Zabbix 

      Result:
      "Incorrect default charset for Zabbix database: "utf8mb4" instead "utf8"."

      See attached screenshot as well..

      *SQL query:*
MariaDB [zabbix]> SELECT @@character_set_database, @@collation_database; 
+--------------------------+----------------------+ 
| @@character_set_database | @@collation_database | 
+--------------------------+----------------------+ 
| utf8mb4                  | utf8mb4_unicode_ci   | 
+--------------------------+----------------------+ 
1 row in set (0.000 sec)

      Conversion it is no longer possible to simple UTF8!

      See Changes here:
      https://mariadb.com/kb/en/supported-character-sets-and-collations/

      We tried modify DEFAULT _CHARSET in "defines.inc.php' for workaround, but we did not succeed

        1. zabbix_proxy.PNG
          80 kB
          Gerd
        2. zabbix_proxy_db.PNG
          8 kB
          Gerd
        3. blackPanther_20210824_085514.jpg
          55 kB
          Karoly Charles Barcza

            Assignee:
            Zabbix Development Team
            Reporter:
            Karoly Charles Barcza
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: