zoneminder 1.32.3-2build1 does not work with MySQL 8

[Joseph Yasi]

The zoneminder 1.32.3-2 package was rebuilt against MySQL for eoan. However, zoneminder 1.32.3 is incompatible with MySQL 8. The database uses several reserved keywords as table and column names that are not escaped with backticks in php, perl and C++ code in the project. Reserved keywords include Function, Groups and System. It also uses the MySQL password command which is no longer available in MySQL.

It doesn't look like the package was tested after doing the rebuild against MySQL 8.

I've backported a patch to 1.32.3 from upstream git master. I'm not sure it's complete, but it works for my use cases.

[Joseph Yasi (joe-yasi)]

Upstream bug reports:
https://github.com/ZoneMinder/zoneminder/issues/2685
https://github.com/ZoneMinder/zoneminder/issues/2659
https://github.com/ZoneMinder/zoneminder/issues/2658

[Ubuntu Foundations Team Bug Bot (crichton)]

The attachment "Fix compatibility with MySQL 8." seems to be a patch. If it isn't, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are a member of the ~ubuntu-reviewers, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issues please contact him.]

[Launchpad Janitor (janitor)]

This bug was fixed in the package zoneminder - 1.32.3-2ubuntu1

---------------
zoneminder (1.32.3-2ubuntu1) focal; urgency=medium

  * d/p/mysql8_my_bool.patch: Reintroduce my_bool to fix build with MySQL 8.
    (LP: #1863026)
  * d/rules: override build-dep to fix FTBFS (thanks to
    <email address hidden>) (LP: #1863793, Closes: #951600)
  * MySQL8 runtime fixes (LP: #1859295):
    - d/p/mysql8-password-deprecated.patch: password() is deprecated
    - d/p/mysql8-reserved-keywords.patch: quote MySQL8 reserved keywords
    - d/p/mysql8-replace-password-call.patch: replace password()
  * d/README.Debian: quick update for MySQL8 and Focal

 -- Andreas Hasenack <email address hidden> Tue, 25 Feb 2020 10:22:20 -0300