In https://github.com/librenms/librenms/pull/12501 we migrated to utf8mb4 / utf8mb4_unicode_ci as the character set and collation.
If you receive one of the following when running the validator:
[FAIL] MySQL Database collation is wrong: utf8mb4 utf8mb4_unicode_ci
[FAIL] MySQL tables collation is wrong
[FAIL] MySQL column collation is wrong
First make sure you have the latest migrations:
./lnms migrate
If this doesn’t help, please try re-running the migration by:
./lnms tinker --execute="DB::table('migrations')->where('migration', '2021_02_09_122930_migrate_to_utf8mb4')->delete();"
./lnms migrate