As mentioned in my earlier post on converting my webserver from Fedora30 to CentOS7 it was fairly painless.
I have found one new issue since then, which is that the latest version of mariadb shipped with CentOS7 does not support features needed by the latest vesrion of Bugzilla.
On Fedora30 I was using bugzilla bugzilla-5.0.6 installed from the Fedora repositories; and it seems extremely lucky I did not bother to update the database schema as I should have (it was upgraded by a ‘dnf update -y’ so I missed it had been updated luckily).
Bugzilla does not exist in the CentOS7 repositories but all versions are available from http://ftp.mozilla.org/pub/webtools/ which includes 5.0.6. Which unfortunately is not usable on CentOS7.
As mentioned in my earlier post all the mariadb databases from my Fedora30 system had been dumped, and loaded into the CentOS7 system without issues, so I have an database I wish to keep the contents of.
Trying to upgrade the database to bugzilla-5.0.6 from the mozilla.org website results in the following errors.
Converting table bugs_fulltext... DBD::mysql::db do failed: The used table type doesn't support FULLTEXT indexes [for Statement "ALTER TABLE bugs_fulltext ENGINE = InnoDB"] at Bugzilla/DB/Mysql.pm line 391, line 747.
Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x64ecdc0)') called at ./checksetup.pl line 123
Being rather bloody minded at this point I took a dump of that database and then dropped the existing database and created a new empty one and tried checksetup.pl again, as it should create all the tables if none exist. And again I get errors. If it cannot be installed as a fresh install there is no hope of upgrading.
Adding new table bz_schema...
Initializing bz_schema...
Creating tables...
DBD::mysql::db do failed: The used table type doesn't support FULLTEXT indexes [for Statement "CREATE FULLTEXT INDEX `bugs_fulltext_short_desc_idx` ON `bugs_fulltext` (short_desc)"] at Bugzilla/DB.pm line 848, line 747.
Bugzilla::DB::_bz_add_table_raw('Bugzilla::DB::Mysql=HASH(0x5bddfd0)', 'bugs_fulltext', 'HASH(0x5d74098)') called at Bugzilla/DB.pm line 809
Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HASH(0x5bddfd0)', 'bugs_fulltext', 'HASH(0x5d74098)') called at Bugzilla/DB.pm line 518
Bugzilla::DB::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x5bddfd0)') called at Bugzilla/DB/Mysql.pm line 575
Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x5bddfd0)') called at ./checksetup.pl line 123
So I reloaded my database dump back into mariadb and settled on the version of Bugzilla which does work on CentOS7 which was the bugzilla-5.0 release which (as I had not updated the database schema on F30 was still a usable database) is working OK on CentOS7.
As far as I am aware that is the last issue to fix in my migration from F30 to C7.
Annoyingly the admin dashboard did keep saying there is an update available to new version 5.0.6; so I disabled that message as there is no point in having it.
So for CentOS7 I cannot upgrade Bugzilla beyond 5.0… but am still stuck on CentOS7 as I will only look at CentOS8 when the docker maintainers have a release of Docker that will work on CentOS8 (or Fedora as my only reason to move to CentOS7 was docker is not supported on F31 onward). As C7 is not EOL until 2024 I can wait.
