Comments on: mycheckpoint (Rev. 118): alerts, email notifications and more https://shlomi-noach.github.io/blog/mysql/mycheckpoint-rev-118-alerts-email-notifications-and-more Blog by Shlomi Noach Fri, 21 May 2010 13:28:03 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/mycheckpoint-rev-118-alerts-email-notifications-and-more/comment-page-1#comment-11845 Tue, 30 Mar 2010 05:26:01 +0000 https://shlomi-noach.github.io/blog/?p=2221#comment-11845 @Jelder,

I’d appreciate if you could now test with revision 119:
Downloads page.

I believe it should now be fixed.
I would also greatly appreciate if you could report back on the Issue 3 page.

Regards

]]>
By: shlomi https://shlomi-noach.github.io/blog/mysql/mycheckpoint-rev-118-alerts-email-notifications-and-more/comment-page-1#comment-11844 Tue, 30 Mar 2010 03:53:26 +0000 https://shlomi-noach.github.io/blog/?p=2221#comment-11844 @Jelder,

Thank you.
This has already been reported.

It relates to a bug in MySQL, already fixed in later versions (sorry for not specifying the bug number right now). I’m still wondering if there is a workaround.

]]>
By: jelder https://shlomi-noach.github.io/blog/mysql/mycheckpoint-rev-118-alerts-email-notifications-and-more/comment-page-1#comment-11835 Mon, 29 Mar 2010 18:28:57 +0000 https://shlomi-noach.github.io/blog/?p=2221#comment-11835 This looks really exciting but I’ve hit a snag. Using r118 against MySQL 5.0.51a on Ubuntu 8.04, I getting a syntax error when I try to deploy:

root@db01:~# mycheckpoint –skip-disable-bin-log –skip-check-replication –defaults-file=/etc/mycheckpoint
.cnf deploy
(1140, ‘Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause’)

— Make sure `mycheckpoint` schema exists, e.g.
— CREATE DATABASE `mycheckpoint`
— Make sure the user has ALL PRIVILEGES on the `mycheckpoint` schema. e.g.
— GRANT ALL ON `mycheckpoint`.* TO ‘my_user’@’my_host’ IDENTIFIED BY ‘my_password’
— The user will have to have the SUPER privilege in order to disable binary logging
— – Otherwise, use –skip-disable-bin-log (but then be aware that slaves replicate this server’s status)
— In order to read master and slave status, the user must also be granted with REPLICATION CLIENT or SUPER privileges
— – Otherwise, use –skip-check-replication

]]>
By: mycheckpoint revision 118 is available | openark forge https://shlomi-noach.github.io/blog/mysql/mycheckpoint-rev-118-alerts-email-notifications-and-more/comment-page-1#comment-11750 Thu, 25 Mar 2010 17:39:48 +0000 https://shlomi-noach.github.io/blog/?p=2221#comment-11750 […] the full announcement on openark.org […]

]]>