Fresh Znuny Installer Fails

[baggar11]

Hi All,

Currently trying to spin up a fresh install of znuny so I can test migrating otrs 6.0.30 data. I've tried using the 6.0.32 and 6.0.33 znuny tar.gz packages, but both produce a Grant Privileges error after creating the database. I'm unable to proceed through the rest of the installation because of it.

GRANT ALL PRIVILEGES
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'xxxxxxxxxxxxx' WITH GRANT OPTION' at line 1

System Specs:(all freshly installed)
Ubuntu 20.04
mysql 8.0.23
apache 2.4.41
znuny 6.0.33

Any help on getting past this? Thanks!

baggar11

[zzz]

Hey,

MySQL 8+ is not supported. Use a lower version or MariaDB.

— Emin

[baggar11]

Ah, that makes sense. I'll give it a go. Thanks!

[baggar11]

Definitely did the trick. For some reason stock mariadb did not want to install properly so I canned that and got mysql 5.7 installed. Znuny installer went off without a hitch after that. Thanks again for the help and quick reply!