Hi all,
So we have a VM with Ubuntu Server 20.04 and MysqlDB Ver 8.0.20 and I tried to install RT v5 Beta1 and I have a SQL syntax error, when I’m trying to make initialize-database
root@ucmssasrt01:/home/iacob/rt-5.0.0beta1# make initialize-database /usr/bin/perl -I/opt/rt5/local/lib -I/opt/rt5/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost (port '') as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Port: Name: rt5 User: rt_user DBA: root Now creating a mysql database rt5 for RT. Done. Now populating database schema. [139415] [Mon Jun 22 11:38:05 2020] [critical]: 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 /home/iacob/rt-5.0.0beta1/sbin/../lib/RT/Handle.pm line 548. (/home/iacob/rt-5.0.0beta1/sbin/../lib/RT.pm:409) 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 t o use near 'Groups ( id INTEGER NOT NULL AUTO_INCREMENT, Name varchar(200) NULL , De' at line 1 at /home/iacob/rt-5.0.0beta1/sbin/../lib/RT/Handle.pm line 548. make: *** [Makefile:390: initialize-database] Error 9 root@ucmssasrt01:/home/iacob/rt-5.0.0beta1# mysql --version mysql Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
I know is a related problem with this forum post RT on MySQL8 and Ubuntu - #3 by linuxos77 . Is there a solution to this issues on RT v5 or I have to try install another version of mysql DB ?