After updating to the latest schema today i’m not getting a whole host of mysql utf and language errors when I run validate.
These weren’t present prior to the update.
I’m still getting graph data and the web front end loads fine.
Here is the output.
https://dl.dropboxusercontent.com/u/9040545/LibreNMS-MYSQL-Error.txt
I also don’t get the error on my remote poller that I haven’t updated yet.
https://dl.dropboxusercontent.com/u/9040545/Librenms-Remote-Poller.txt
Please update again, it could be that you schema change is still running but I’d hope it wouldn’t have took 30 minutes.
Same deal.
==========================================================
| Component | Version |
|---|---|
| LibreNMS | 55384ad1b0370378aefe9ed81d90e0f341e15049 |
| DB Schema | 170 |
| PHP | 7.0.15-0ubuntu0.16.04.2 |
| MySQL | 10.0.29-MariaDB-0ubuntu0.16.04.1 |
| RRDTool | 1.5.5 |
| SNMP | NET-SNMP 5.7.3 |
==========================================================
[OK] Database connection successful
[FAIL] MySQL Database collation is wrong: utf8mb4 utf8mb4_general_ci
[FAIL] MySQL tables collation is wrong: api_tokens latin1 latin1_swedish_ci
ciscoASA latin1 latin1_swedish_ci
cmpMemPool latin1 latin1_swedish_ci
config latin1 latin1_swedish_ci
Please show the output of ./daily.sh as you’re missing a schema update
I don’t have the output that I ran from before the last validate, turns out my terminal logging died.
I just ran it again.
librenms@librenms-web:~$ ./daily.sh
Updating to latest codebase OK
Updated from 55384ad1b0370378aefe9ed81d90e0f341e15049 to db58fea2d2a8b02cc1b3ee55ed088bec9e9682c6 OK
Validate is showing the same error but i’ll give it some time to see if the schema change catches up and run it again later.
You will need to apply the schema change again: mysql -u librenms -p librenms < /opt/librenms/sql-schema/171.sql
Done.
It’s mostly fixed, it’s only mad about Swedish now.
https://dl.dropboxusercontent.com/u/9040545/LibreNMS-MYSQL-ErrorV2.txt
See the first command : Post DB Collation/CharacterSet update fixes
Some of those tables don’t exist anymore so you’ve had a failed schema update at some stage. Leave them for now.
I ran the DB command from the other post and I still get a few errors.
They don’t seem to be impacting anything so i’ll ignore it for now.
Thanks for the help.
Hi Guys,
having a collation error also
| Component | Version |
|---|---|
| LibreNMS | 9868e517dcbbea60ed76bf063b38218e3942e0ce |
| DB Schema | 176 |
| PHP | 7.0.16 |
| MySQL | 5.5.52-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | NET-SNMP 5.7.2 |
==========================================================
[OK] Database connection successful
[FAIL] MySQL column collation is wrong: [FIX] http://bit.ly/2lAG9H8
mefinfo mefType utf8 utf8_general_ci
mefinfo mefIdent utf8 utf8_general_ci
mefinfo mefAdmState utf8 utf8_general_ci
mefinfo mefRowState utf8 utf8_general_ci
any idea?
Managed to fix it with this
ALTER TABLE mefinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;