-
Problem report
-
Resolution: Fixed
-
Trivial
-
6.0.7
-
None
-
Centos 7, MariaDB 10.6.8
-
Sprint 91 (Aug 2022)
-
0.5
Steps to reproduce:
- Install and run Zabbix proxy 6.0.7 in the mentioned above environment
Result:
See log file /var/log/zabbix/zabbix_proxy.log
Â
25494:20220805:075711.885 Starting Zabbix Proxy (active) [Zabbix proxy]. Zabbix 6.0.7 (revision 442920c8f69). 25494:20220805:075711.885 **** Enabled features **** 25494:20220805:075711.885 SNMP monitoring:    YES 25494:20220805:075711.885 IPMI monitoring:    YES 25494:20220805:075711.885 Web monitoring:     YES 25494:20220805:075711.885 VMware monitoring:   YES 25494:20220805:075711.885 ODBC:          YES 25494:20220805:075711.885 SSH support:      YES 25494:20220805:075711.885 IPv6 support:      YES 25494:20220805:075711.885 TLS support:      YES 25494:20220805:075711.885 ************************** 25494:20220805:075711.885 using configuration file: /etc/zabbix/zabbix_proxy.conf 25494:20220805:075711.888 cannot set MySQL character set to "utf8" 25494:20220805:075711.897 cannot set MySQL character set to "utf8"
Expected:
No any such error
Additional information:
select default_character_set_name,default_collation_name from information_schema.SCHEMATA where schema_name='zabbix';
+----------------------------+------------------------+
| default_character_set_name | default_collation_name |
+----------------------------+------------------------+
| utf8mb4           | utf8mb4_bin       |
+----------------------------+------------------------+
SHOW CHARACTER SET; +----------+-----------------------------+---------------------+--------+ | Charset  | Description         | Default collation  | Maxlen | +----------+-----------------------------+---------------------+--------+ | big5   | Big5 Traditional Chinese   | big5_chinese_ci   |    2 | | dec8   | DEC West European      | dec8_swedish_ci   |    1 | | cp850   | DOS West European      | cp850_general_ci   |    1 | | hp8    | HP West European       | hp8_english_ci    |    1 | | koi8r   | KOI8-R Relcom Russian    | koi8r_general_ci   |    1 | | latin1  | cp1252 West European     | latin1_swedish_ci  |    1 | | latin2  | ISO 8859-2 Central European | latin2_general_ci  |    1 | | swe7   | 7bit Swedish         | swe7_swedish_ci   |    1 | | ascii   | US ASCII           | ascii_general_ci   |    1 | | ujis   | EUC-JP Japanese       | ujis_japanese_ci   |    3 | | sjis   | Shift-JIS Japanese      | sjis_japanese_ci   |    2 | | hebrew  | ISO 8859-8 Hebrew      | hebrew_general_ci  |    1 | | tis620  | TIS620 Thai         | tis620_thai_ci    |    1 | | euckr   | EUC-KR Korean        | euckr_korean_ci   |    2 | | koi8u   | KOI8-U Ukrainian       | koi8u_general_ci   |    1 | | gb2312  | GB2312 Simplified Chinese  | gb2312_chinese_ci  |    2 | | greek   | ISO 8859-7 Greek       | greek_general_ci   |    1 | | cp1250  | Windows Central European   | cp1250_general_ci  |    1 | | gbk    | GBK Simplified Chinese    | gbk_chinese_ci    |    2 | | latin5  | ISO 8859-9 Turkish      | latin5_turkish_ci  |    1 | | armscii8 | ARMSCII-8 Armenian      | armscii8_general_ci |    1 | | utf8mb3  | UTF-8 Unicode        | utf8mb3_general_ci  |    3 | | ucs2   | UCS-2 Unicode        | ucs2_general_ci   |    2 | | cp866   | DOS Russian         | cp866_general_ci   |    1 | | keybcs2  | DOS Kamenicky Czech-Slovak  | keybcs2_general_ci  |    1 | | macce   | Mac Central European     | macce_general_ci   |    1 | | macroman | Mac West European      | macroman_general_ci |    1 | | cp852   | DOS Central European     | cp852_general_ci   |    1 | | latin7  | ISO 8859-13 Baltic      | latin7_general_ci  |    1 | | utf8mb4  | UTF-8 Unicode        | utf8mb4_general_ci  |    4 | | cp1251  | Windows Cyrillic       | cp1251_general_ci  |    1 | | utf16   | UTF-16 Unicode        | utf16_general_ci   |    4 | | utf16le  | UTF-16LE Unicode       | utf16le_general_ci  |    4 | | cp1256  | Windows Arabic        | cp1256_general_ci  |    1 | | cp1257  | Windows Baltic        | cp1257_general_ci  |    1 | | utf32   | UTF-32 Unicode        | utf32_general_ci   |    4 | | binary  | Binary pseudo charset    | binary        |    1 | | geostd8  | GEOSTD8 Georgian       | geostd8_general_ci  |    1 | | cp932   | SJIS for Windows Japanese  | cp932_japanese_ci  |    2 | | eucjpms  | UJIS for Windows Japanese  | eucjpms_japanese_ci |    3 | +----------+-----------------------------+---------------------+--------+
Â
- part of
-
ZBX-21437 Cannot set MySQL character set to "utf8mb3"
-
- Closed
-