openITCOCKPIT 4.6.1 released

openITCOCKPIT version 4.6.1 has been released. This release contains a workaround for a bug within the mysqldump command.

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 8.0.31 to 8.0.32.

Bug report: https://bugs.mysql.com/bug.php?id=109685

The mysqldump command used by openITCOCKPIT’s Backup and Restore feature makes use of the --single-transaction option which requires now RELOAD or 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.

All changes are available in the changelog.

How to Update

Please see the official documentation of how to update openITCOCKPIT.

Your openITCOCKPIT Team