Ubuntu
zoneminder package

zoneminder 1.32.3-2build1 does not work with MySQL 8

Bug #1859295 reported by Joseph Yasi on 2020-01-11

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	zoneminder (Ubuntu)	Fix Released	Undecided	Unassigned

Bug Description

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.

Tags:

Related branches

~ahasenack/ubuntu/+source/zoneminder:focal-zoneminder-mysql8

Merged into ~ahasenack/ubuntu/+source/zoneminder:master at revision ebdcb0ab8587f01cf4c6b448bf0d5773e2be7dcf

Christian Ehrhardt  (community): Approve on 2020-02-25

Canonical Server: Pending requested 2020-02-24

Revision history for this message

Joseph Yasi (joe-yasi) wrote on 2020-01-11:

Fix compatibility with MySQL 8. Edit (19.6 KiB, text/plain)

Revision history for this message

Joseph Yasi (joe-yasi) wrote on 2020-01-11:

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

Revision history for this message

Ubuntu Foundations Team Bug Bot (crichton) wrote on 2020-01-11:

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.]

tags:

added: patch

Revision history for this message

Launchpad Janitor (janitor) wrote on 2020-02-25:

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