openITCOCKPIT version 4.6.1 has been released. This release contains a workaround for a bug within the
Usually we never release a new version on a friday and the last stable release has happen only four days ago.
How ever, we noticed a breaking change within the
mysqldump command from version
Bug report: https://bugs.mysql.com/bug.php?id=109685
mysqldump command used by openITCOCKPIT’s Backup and Restore feature makes use of the
--single-transaction option which requires now
FLUSH_TABLES privileges. Both privileges belongs to the
Server administration context according to the MySQL documentation.
Due to the MySQL user used by openITCOCKPIT does not have these privileges,
mysqldump returns the following error message
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)
and creates an empty SQL file.
It looks like it is a bit unclear if this is a wanted behavior or not. To restore the “Backup and Restore” feature of openITCOCKPIT, and also the automatic generation of database backups we decided to release openITCOCKPIT 4.6.1.
For now we applied a simple workaround by removing the
--single-transaction option from the
mysqldump command. (See the patch)
This workaround gives us the time required, to come up with a proper solution.
Sorry for the inconvenience.
Please see the official documentation of how to update openITCOCKPIT.
Your openITCOCKPIT Team