Symptom - none of the devices is being polled…
Output from ./validate.php
$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 21.2.0-52-g61316ce2c |
| DB Schema | 2021_02_09_122930_migrate_to_utf8mb4 (201) |
| PHP | 7.4.16 |
| Python | 3.8.5 |
| MySQL | 10.5.9-MariaDB-1:10.5.9+maria~focal |
| RRDTool | 1.7.2 |
| SNMP | NET-SNMP 5.8 |
====================================
[OK] Composer Version: 2.0.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2021_02_09_122930_migrate_to_utf8mb4). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[FAIL] MySQL Database collation is wrong: utf8mb4 utf8mb4_unicode_ci
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
[FAIL] MySQL tables collation is wrong:
[FIX]:
Check http://bit.ly/2lAG9H8 for info on how to fix.
Tables:
mefinfo utf8mb4 utf8mb4_unicode_ci
mpls_saps utf8mb4 utf8mb4_unicode_ci
mac_accounting utf8mb4 utf8mb4_unicode_ci
dbSchema utf8mb4 utf8mb4_unicode_ci
mpls_lsp_paths utf8mb4 utf8mb4_unicode_ci
device_perf utf8mb4 utf8mb4_unicode_ci
ports_fdb utf8mb4 utf8mb4_unicode_ci
notifications utf8mb4 utf8mb4_unicode_ci
callback utf8mb4 utf8mb4_unicode_ci
notifications_attribs utf8mb4 utf8mb4_unicode_ci
ipv6_addresses utf8mb4 utf8mb4_unicode_ci
device_graphs utf8mb4 utf8mb4_unicode_ci
migrations utf8mb4 utf8mb4_unicode_ci
component_statuslog utf8mb4 utf8mb4_unicode_ci
syslog utf8mb4 utf8mb4_unicode_ci
and 122 more…
[FAIL] MySQL column collation is wrong:
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
Columns:
mefinfo mefType utf8mb4 utf8mb4_unicode_ci
mefinfo mefIdent utf8mb4 utf8mb4_unicode_ci
mefinfo mefAdmState utf8mb4 utf8mb4_unicode_ci
mefinfo mefRowState utf8mb4 utf8mb4_unicode_ci
mpls_saps ifName utf8mb4 utf8mb4_unicode_ci
mpls_saps sapEncapValue utf8mb4 utf8mb4_unicode_ci
mpls_saps sapRowStatus utf8mb4 utf8mb4_unicode_ci
mpls_saps sapType utf8mb4 utf8mb4_unicode_ci
mpls_saps sapDescription utf8mb4 utf8mb4_unicode_ci
mpls_saps sapAdminStatus utf8mb4 utf8mb4_unicode_ci
mpls_saps sapOperStatus utf8mb4 utf8mb4_unicode_ci
mac_accounting mac utf8mb4 utf8mb4_unicode_ci
mac_accounting in_oid utf8mb4 utf8mb4_unicode_ci
mac_accounting out_oid utf8mb4 utf8mb4_unicode_ci
mpls_lsp_paths mplsLspPathRowStatus utf8mb4 utf8mb4_unicode_ci
and 497 more…
[OK] Database schema correct
$
I suspect a rogue update, but I’ve been out of the office for a few weeks… Followed both the links and they send me to a post from Feb 2017
Any pointers to recover gratefully received.
