Dear all
after migration, i get the following error:
The fix provided in the link doesn’t helped. Any idea?
Regards
Stefan
====================================
| Component | Version |
|---|---|
| LibreNMS | 21.2.0-38-gb1dbd332d |
| DB Schema | 2021_02_21_203415_location_add_fixed_coordinates_flag (200) |
| PHP | 7.4.3 |
| Python | 3.8.5 |
| MySQL | 10.3.25-MariaDB-0ubuntu0.20.04.1 |
| RRDTool | 1.7.2 |
| SNMP | NET-SNMP 5.8 |
====================================
[OK] Composer Version: 2.0.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] MySQL tables collation is wrong:
[FIX]:
Check http://bit.ly/2lAG9H8 for info on how to fix.
Tables:
services utf8mb4 utf8mb4_unicode_ci
devices utf8mb4 utf8mb4_unicode_ci
graph_types utf8mb4 utf8mb4_unicode_ci
ciscoASA utf8mb4 utf8mb4_unicode_ci
bill_data utf8mb4 utf8mb4_unicode_ci
alert_transports utf8mb4 utf8mb4_unicode_ci
route utf8mb4 utf8mb4_unicode_ci
vrf_lite_cisco utf8mb4 utf8mb4_unicode_ci
alert_transport_map utf8mb4 utf8mb4_unicode_ci
service_templates_device_group utf8mb4 utf8mb4_unicode_ci
poller_cluster utf8mb4 utf8mb4_unicode_ci
processors utf8mb4 utf8mb4_unicode_ci
migrations utf8mb4 utf8mb4_unicode_ci
dbSchema utf8mb4 utf8mb4_unicode_ci
application_metrics utf8mb4 utf8mb4_unicode_ci
and 121 more…
[FAIL] MySQL column collation is wrong:
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
Columns:
services service_ip utf8mb4 utf8mb4_unicode_ci
services service_type utf8mb4 utf8mb4_unicode_ci
services service_desc utf8mb4 utf8mb4_unicode_ci
services service_param utf8mb4 utf8mb4_unicode_ci
services service_message utf8mb4 utf8mb4_unicode_ci
services service_ds utf8mb4 utf8mb4_unicode_ci
services service_name utf8mb4 utf8mb4_unicode_ci
devices hostname utf8mb4 utf8mb4_unicode_ci
devices sysName utf8mb4 utf8mb4_unicode_ci
devices overwrite_ip utf8mb4 utf8mb4_unicode_ci
devices community utf8mb4 utf8mb4_unicode_ci
devices authlevel utf8mb4 utf8mb4_unicode_ci
devices authname utf8mb4 utf8mb4_unicode_ci
devices authpass utf8mb4 utf8mb4_unicode_ci
devices authalgo utf8mb4 utf8mb4_unicode_ci
and 497 more…
[OK] Database schema correct