Public bug reported:
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.
** Affects: zoneminder (Ubuntu)
Importance: Undecided
Status: New
** Patch added: "Fix compatibility with MySQL 8."
https://bugs.launchpad.net/bugs/1859295/+attachment/5319302/+files/fix-mysql8.patch
** Bug watch added: github.com/ZoneMinder/zoneminder/issues #2685
https://github.com/ZoneMinder/zoneminder/issues/2685
** Bug watch added: github.com/ZoneMinder/zoneminder/issues #2659
https://github.com/ZoneMinder/zoneminder/issues/2659
** Bug watch added: github.com/ZoneMinder/zoneminder/issues #2658
https://github.com/ZoneMinder/zoneminder/issues/2658
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1859295
Title:
zoneminder 1.32.3-2build1 does not work with MySQL 8
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/zoneminder/+bug/1859295/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
