я поменял кодировку, некоторые проблемы ушли из лога, но все равно осталось:
1856:20200520:135524.711 character set name or collation name that is not supported by Zabbix found in 101 column(s) of database "zabbix"
1856:20200520:135524.711 only character set "utf8" and collation "utf8_bin" should be used in database
Хотя вывод выглядит вот так:
+--------------------------+----------------------+
| @
@character_set_database | @
@collation_database |
+--------------------------+----------------------+
| utf8 | utf8_bin |
+--------------------------+----------------------+
до исправления было вот так:
27731:20200520:125830.343 Zabbix supports only "utf8_bin" collation. Database "zabbix" has default collation "utf8_general_ci"
27731:20200520:125830.353 character set name or collation name that is not supported by Zabbix found in 101 column(s) of database "zabbix"
27731:20200520:125830.353 only character set "utf8" and collation "utf8_bin" should be used in database
27731:20200520:125830.354 database is not upgraded to use double precision values