Make initialize-database : "couldn't get version"

RT Users
1

I am using Ubuntu 18.04LTS and mysql 5.7.24.

This is my output of “make initialize-database”:

/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/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: rt4
User: rt_user
DBA: root
Couldn’t finish ‘create’ step.

ERROR: couldn’t get version of the mysql server

Makefile:387: recipe for target ‘initialize-database’ failed
make: *** [initialize-database] Error 255

I’ve tried “make dropdb” but I get “database doesn’t exist”.

I have only the root mysql user. I can log in with that account manually.

Can anyone point me towards some further info I can use to get past this? Is there an alternate manual database initialization process?

Thanks in advance.

2

That error looks to possibly come from RT::Handle.pm. If you manually connect to the MySQL server, what output do you get if you type:

show variables like 'version';

as that’s what is executed to check the MySQL version number.

3

Thank you a lot for the response, but…

I got it fixed. I had a relic of mariadb that needed manual removal. Once done, I got past the version issue.

Now I need to figure out my fastcgi & apache2.4 problem - but that is not an RT issue…

Thank you again.