[Koha-bugs] [Bug 23022] New: Koha is not compatible with MySQL >= 8.0.11 because of NO_AUTO_CREATE_USER mode

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23022

            Bug ID: 23022
           Summary: Koha is not compatible with MySQL >= 8.0.11 because of
                    NO_AUTO_CREATE_USER mode
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: solaris.smoke at gmail.com
        QA Contact: testopia at bugs.koha-community.org
  Target Milestone: ---

The NO_AUTO_CREATE_USER mode was removed in MySQL 8.0.11 - see
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

But Koha attempts to set this mode here:
https://github.com/Koha-Community/Koha/blob/3a150b5d7519c2969de6d966193af242e1e787e0/Koha/Database.pm#L79-L82

This results in the following exception when using MySQL 8.0.11 or higher:

DBD::mysql::db do failed: Variable 'sql_mode' can't be set to the value of
'NO_AUTO_CREATE_USER' [for Statement "SET sql_mode =
'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"]
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1440.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.