New default database charset / collation

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
1 Like