FR - Consider adding support for MySQL 8

[fraenki]

Environment

• OS: CentOS 8
• Browser: Firefox
• Znuny version: 6.0.33

Expected behaviour

As a software that is maintained and under active development, Znuny should support current database versions like MySQL 8.

Actual behaviour

The README clearly states:

MySQL 8+ is not supported

So I'd assume that Znuny does not work when using MySQL 8.

How to reproduce

Not tested.

Additional information

We're considering to migrate to Znuny. However, having MySQL 8 on the roadmap would allow us to plan the next steps. Other applications are already dropping support for MySQL 5.7, so it's getting harder for Znuny to co-exist with other applications on the same infrastructure.

For OTRS 6.x a patch was provided by a community member that should address some MySQL 8 issues:
https://bugs.otrs.org/show_bug.cgi?id=13866
Maybe this could be seen as a starting point for some progress towards MySQL 8 support.

Screenshots

[hanneshal]

Hi @fraenki ,

there are two ways to fix this:

• we can escape the reserverd keyword in code
• we could rename the existing table (thats what OTRS 7+ has done)

We discussed this and will postpone support for MySQL 8 to the first feature branch. This will be released at the end of June / beginning of July.

In both cases existing addons would not work anymore, if they rely on the groups table (for what ever reason).
If this is not your case, we are sorry you have to wait for the feature version.

Regards
Johannes

[fraenki]

@hanneshal Sounds great, thanks for the status update!

[rkaldung]

@fraenki I don't know if you have it seen: fafd56a

[fraenki]

@rkaldung Great news, thanks for the update! 👍

[rkaldung]

@fraenki It's already in Znuny, starting with version 6.1.1

[rokj]

This means that in https://doc.znuny.org/doc/manual/admin/stable/en/html/otrs.html#software-requirements

MySQL 5.0 or higher (MySQL 8+ is [not supported](https://bugs.otrs.org/show_bug.cgi?id=13866))

is not valid anymore?

[hanneshal]

This means that in https://doc.znuny.org/doc/manual/admin/stable/en/html/otrs.html#software-requirements

MySQL 5.0 or higher (MySQL 8+ is [not supported](https://bugs.otrs.org/show_bug.cgi?id=13866))

is not valid anymore?

Correct. Since 6.1 MySQL 8 can be used.
You are in the old doc, for 6.0.
The updated doc can be found here:

https://doc.znuny.org/manual/releases/installupdate/install.html