librenms got a database error after the update. I tried to resolve the error by following this method but the problem persists
Post DB Collation/CharacterSet update fixes
------------------------------------------Error Message -------------------------------------------------------------
$ git pull
Already up-to-date.
$ ./daily.sh
Updating to latest codebase OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 21.2.0-23-g0a8f24c |
| DB Schema | 2021_02_21_203415_location_add_fixed_coordinates_flag (200) |
| PHP | 7.4.15 |
| Python | 3.5.2 |
| MySQL | 10.4.18-MariaDB-1:10.4.18+maria~xenial-log |
| RRDTool | 1.5.5 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[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:
component_statuslog utf8mb4 utf8mb4_unicode_ci
graph_types utf8mb4 utf8mb4_unicode_ci
component_prefs utf8mb4 utf8mb4_unicode_ci
application_metrics utf8mb4 utf8mb4_unicode_ci
alert_log utf8mb4 utf8mb4_unicode_ci
mpls_sdp_binds utf8mb4 utf8mb4_unicode_ci
sensors_to_state_indexes utf8mb4 utf8mb4_unicode_ci
mac_accounting utf8mb4 utf8mb4_unicode_ci
stp utf8mb4 utf8mb4_unicode_ci
ipsec_tunnels utf8mb4 utf8mb4_unicode_ci
loadbalancer_vservers utf8mb4 utf8mb4_unicode_ci
device_outages utf8mb4 utf8mb4_unicode_ci
plugins utf8mb4 utf8mb4_unicode_ci
bill_port_counters utf8mb4 utf8mb4_unicode_ci
alert_templates 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:
component_statuslog message utf8mb4 utf8mb4_unicode_ci
graph_types graph_type utf8mb4 utf8mb4_unicode_ci
graph_types graph_subtype utf8mb4 utf8mb4_unicode_ci
graph_types graph_section utf8mb4 utf8mb4_unicode_ci
graph_types graph_descr utf8mb4 utf8mb4_unicode_ci
component_prefs attribute utf8mb4 utf8mb4_unicode_ci
component_prefs value utf8mb4 utf8mb4_unicode_ci
application_metrics metric utf8mb4 utf8mb4_unicode_ci
mpls_sdp_binds sdpBindRowStatus utf8mb4 utf8mb4_unicode_ci
mpls_sdp_binds sdpBindAdminStatus utf8mb4 utf8mb4_unicode_ci
mpls_sdp_binds sdpBindOperStatus utf8mb4 utf8mb4_unicode_ci
mpls_sdp_binds sdpBindType utf8mb4 utf8mb4_unicode_ci
mpls_sdp_binds sdpBindVcType utf8mb4 utf8mb4_unicode_ci
mac_accounting mac utf8mb4 utf8mb4_unicode_ci
mac_accounting in_oid utf8mb4 utf8mb4_unicode_ci
and 497 more…
[OK] Database schema correct
Thanks
