error during new install

[dave B]

I am following the instructions at https://bugzilla.readthedocs.io/en/5.0/installing/quick-start.html
I am installing on a Virtualbox fresh install of Ubuntu 14.04.6 server

Everything goes well.
after I run .checksetup.pl the first time it tells me I need to run /usr/bin/perl install-module.pl --all
which I did.

If I skip that step it does not create the localconfig file.

after that when I run .checksetup.pl the second time I get this text in red:

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, <DATA> line 751.
Bugzilla::DB::_bz_add_table_raw('Bugzilla::DB::Mysql=HASH(0x86ae808)', 'bugs_fulltext', 'HASH(0x8871828)') called at Bugzilla/DB.pm line 809
Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HASH(0x86ae808)', 'bugs_fulltext', 'HASH(0x8871828)') called at Bugzilla/DB.pm line 518
Bugzilla::DB::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x86ae808)') called at Bugzilla/DB/Mysql.pm line 575
Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x86ae808)') called at ./checksetup.pl line 123

I am a noob when it comes to this so if anyone can help it would be appreciated

[Thorsten Schöning]

Guten Tag dave B,
am Samstag, 27. April 2019 um 02:02 schrieben Sie:

> I am following the instructions at
> https://bugzilla.readthedocs.io/en/5.0/installing/quick-start.html
> I am installing on a Virtualbox fresh install of Ubuntu 14.04.6 server

While the version of Bugzilla you are using is correct, don't use UB
14.04 anymore, it runs out of support this month. Use at least 16.04,
I have that running as well, but am somewhat sure that 18.04 would do
fine for Bugzilla as well.

Don't take docs too serious on such things sometimes, they are often
only not as current as they should be. This might even be your chance
to file a bug to update the docs because UB 14.04 seems to not work
out of the box anymore.

> Everything goes well.
> after I run .checksetup.pl the first time it tells me I need to run
> /usr/bin/perl install-module.pl --all
> which I did.

Don't do that unless absolutely necessary, prefer APT instead for
providing missing dependencies. That's what the docs are doing as
well:

https://bugzilla.readthedocs.io/en/5.0/installing/quick-start.html#install-prerequisites

"install-module.pl" is only for dependencies not available by APT,
which are very few optional ones only, which you might not need at
all. The problem with "install-module.pl" is that if you e.g. upgrade
UB the packages managed privately by Bugzilla will most likely fail
because of a new binary incompatible Perl and APT handles such things
a lot better. There are quite some messages on this list about people
running into trouble after upgrading their Linux which result in that
they used "install-module.pl", which didn't take part in the upgrade.

The only downside is that you need to search for APT-names of packages
using your search engine of choice or have a look at lists like the
following:

https://packages.ubuntu.com/xenial/perl/

> 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, <DATA> line 751.

Your version of MySQL is too old, you need at least 5.6 and I'm
somewhat sure 14.04 came with 5.5 by default. 5.6 supports FULLTEXT
INDEX for tables using InnoDB, which is the default these days by
Bugzilla. While you might be able to get 5.6 running in 14.04 as well,
I suggest simply starting over with 16.04 instead.

https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html
https://packages.ubuntu.com/xenial/database/mysql-server
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-14-04

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail: Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[dave B]

Got it working on 18.04.2 thanks for the pointers