RT on MySQL8 and Ubuntu


#1

Trying to install the latest RT on Ububtu with Mysq8 as the database. I kep getting the following error when initializing the database (either via web console OR commendline:

Stack:
[/opt/rt4/sbin/…/lib/RT/Handle.pm:552]
[/opt/rt4/share/html/Install/Initialize.html:112]
[/opt/rt4/share/html/Install/autohandler:60] (/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:208)
[219626] [Tue Dec 18 18:53:47 2018] [warning]: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle dbname=rt4;host=localhost at /usr/local/share/perl/5.26.1/DBIx/SearchBuilder/Handle.pm line 331. (/usr/local/share/perl/5.26.1/DBIx/SearchBuilder/Handle.pm:331)
[219626] [Tue Dec 18 18:53:47 2018] [error]: DBD::mysql::st execute failed: 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 ‘Groups (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(200) NULL ,
De’ at line 1 at /opt/rt4/sbin/…/lib/RT/Handle.pm line 552.


#2

Turns out ‘Groups’ is a reserved word in MySQL 8. I haven’t double checked but I suspect RT isn’t quoting the table name. Rather, I didn’t check, they don’t - don’t know if it will help.
I suspect that’s the purpose of commit 866adbf7302b6f0b97461fcac858b4397b664a67 in the latest git. :frowning:


#3

Yeah figured that was the issue, looks like mysql 8.03 added Groups as a reserved word. Ayone have an idea when a fix would be available?