sensu-plugins-mysql icon indicating copy to clipboard operation
sensu-plugins-mysql copied to clipboard
verified publisher icon sensu-plugins

Doesn't work with MySQL 8 due to different default charset

Open jonaslm opened this issue 7 years ago • 4 comments

MySQL 8 changed the default charset to utf8mb4. It seems this broke the mysql sensu scripts, as they all error out when connecting now.

CheckMySQLHealth CRITICAL: MySQL check failed: unknown charset number: 255

As far as I can tell, there's no configuration option for the scripts to tell what charset they should use when connecting.

jonaslm avatar Sep 13 '18 07:09 jonaslm

@jonaslm , had a similar issue when I upgraded mysql from 5 to 8 with latin1 as the charset. however, this problem later morphed into: CheckMysqlReplicationStatus CRITICAL: undefined method encoding' for nil:NilClass` Any idea on how to go approach this?

gonja-dude avatar Feb 13 '19 12:02 gonja-dude

@gonja-dude No clue, sorry. We stopped using these checks since they didn't work for us anymore.

jonaslm avatar Feb 27 '19 09:02 jonaslm

@jonaslm Alright! Do you mind telling me what you guys are using now to check the replication status on your DBs?

gonja-dude avatar Feb 27 '19 10:02 gonja-dude

We still haven't replaced them, sadly. If anyone finds a workable alternative we're also interested :)

jonaslm avatar Mar 04 '19 09:03 jonaslm