Can't get Zabbix installed - Unsupported charset or collation for tablese

[lpossamai]

Hi all.

I'm setting up a brand-new Zabbix server in AWS, and its database will be in RDS. I'm following these steps to install Zabbix on Ubuntu 20:

# Download Zabbix .deb package: 
wget https://repo.zabbix.com/zabbix/5.5/ubuntu/pool/main/z/zabbix-release/zabbix-release_5.5-1%2Bubuntu20.04_all.deb

#Install package: 
dpkg -i zabbix-release_5.5-1+ubuntu20.04_all.deb

#Update Apt:
apt update -y

# Install Zabbix
apt install -y zabbix-server-mysql zabbix-frontend-php zabbix-nginx-conf zabbix-sql-scripts zabbix-agent

# In the MySQL Database, I'm creating the new DB:
CREATE DATABASE IF NOT EXISTS zabbix character set utf8 collate utf8_bin;

# Creating User:
create user zabbix@localhost identified by 'password';
grant all privileges on zabbix.* to zabbix@'%';

# Importing the /usr/share/doc/zabbix-sql-scripts/mysql/server.sql.gz file
mysql -h dbhost -uzabbix zabbix < /usr/share/doc/zabbix-sql-scripts/mysql/server.sql

When I go to the Zabbix web console and start completing the setup.php, I get the following error when trying to connect to the DB

Unsupported charset or collation for tables: acknowledges, actions, alerts, auditlog, autoreg_host, conditions, config, config_autoreg_tls, corr_condition_tag, corr_condition_tagpair, corr_condition_tagvalue, correlation, dashboard, dashboard_page, dchecks, drules, dservices, event_tag, events, expressions, functions, globalmacro, graph_theme, graphs, graphs_items, group_discovery, group_prototype, ha_node, history_log, history_str, history_text, host_discovery, host_inventory, host_tag, hostmacro, hosts, housekeeper, hstgrp, httpstep, httpstep_field, httptest, httptest_field, httptest_tag, icon_map, icon_mapping, ids, images, interface, interface_snmp, item_condition, item_discovery, item_parameter, item_preproc, item_rtdata, item_tag, items, lld_macro_path, lld_override, lld_override_condition, lld_override_operation, lld_override_ophistory, lld_override_opperiod, lld_override_optag, lld_override_optrends, maintenance_tag, maintenances, media, media_type, media_type_message, media_type_param, module, opconditions, operations, opmessage, problem, problem_tag, profiles, proxy_autoreg_host, proxy_dhistory, proxy_history, regexps, report, report_param, role, role_rule, script_param, scripts, service_problem_tag, service_tag, services, services_times, sessions, sysmap_element_url, sysmap_shape, sysmap_url, sysmaps, sysmaps_element_tag, sysmaps_elements, sysmaps_link_triggers, sysmaps_links, tag_filter, task_data, task_remote_command, task_remote_command_result, task_result, token, trigger_tag, triggers, users, usrgrp, valuemap, valuemap_mapping, widget, widget_field.

My database looks like it already has the correct charset and collation:

mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8 | utf8_general_ci |
+--------------------------+----------------------+

What am I missing here?

Thanks in advance!

[gofree]

Youre installing development version 5.5 ( aka future 6.0 ) which may be just like any development version - try 5.4.x or 5.0.x

[gofree]

Youre installing development version 5.5 ( aka future 6.0 ) which may be just like any development version - try 5.4.x or 5.0.x

[Steve.B]

As gofree mentions above you are using the latest alpha release, and you may want to change to the LTS or other stable versions.

However if you are trying to use Zabbix 6.0alpha then to fix this on server itself you need to run "dpkg-reconfigure locales" and select the en_US.utf8 locale (not sure if a reboot is needed or not I did for other reasons at the time of the fix). This should then get rid of that error, you also do not need to change teh default locale.

[lpossamai]

Right! That makes sense. Thanks for your help guys!