Enable innodb for bugzilla

bislinks's picture
Submitted by bislinks on Wed, 07/15/2020 - 10:25 Pro Licensee

How do i enable innodb on mysql

I tried

innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

but it failed

Status: 
Active
Files: 
Image icon screenshot_2020-07-15_at_19.22.41.png

Comments

bislinks's picture
Submitted by bislinks on Wed, 07/15/2020 - 10:26 Pro Licensee

update

Version: MariaDB version 10.3.17 OS CentOS 8

Ilia's picture
Submitted by Ilia on Wed, 07/15/2020 - 11:24

Hi,

MariaDB 10.3.17 has InnoDB engine already set and enabled by default. You don't need to do anything extra.

You can check that in MySQL System Variables:

bislinks's picture
Submitted by bislinks on Wed, 07/15/2020 - 22:53 Pro Licensee

But why does Bugzilla complain about it?

[edge@edge bugzilla]$ ./checksetup.pl
* This is Bugzilla 3.6.13 on perl 5.26.3
* Running on Linux 4.18.0-193.6.3.el8_2.x86_64 #1 SMP Wed Jun 10 11:09:32 UTC 2020

Checking perl modules...
Checking for              CGI.pm (v3.51)   ok: found v3.63
Checking for          Digest-SHA (any)     ok: found v6.02
Checking for            TimeDate (v2.21)   ok: found v2.24
Checking for            DateTime (v0.28)   ok: found v1.52
Checking for   DateTime-TimeZone (v0.71)   ok: found v2.39
Checking for                 DBI (v1.41)   ok: found v1.641
Checking for    Template-Toolkit (v2.22)   ok: found v3.008
Checking for          Email-Send (v2.00)   ok: found v2.201
Checking for          Email-MIME (v1.861)  ok: found v1.949
Checking for Email-MIME-Encodings (v1.313)  ok: found v1.315
Checking for Email-MIME-Modifier (v1.442)  ok: found v1.949
Checking for                 URI (any)     ok: found v1.73

Checking available perl DBD modules...
Checking for              DBD-Pg (v1.45)    not found
Checking for          DBD-Oracle (v1.19)    not found
Checking for           DBD-mysql (v4.00)   ok: found v4.046

The following Perl modules are optional:
Checking for                  GD (v1.20)   ok: found v2.71
Checking for               Chart (v2.1)    ok: found v2.4.10
Checking for         Template-GD (any)     ok: found v1.56
Checking for          GDTextUtil (any)     ok: found v0.86
Checking for             GDGraph (any)     ok: found v1.54
Checking for            XML-Twig (any)     ok: found v3.52
Checking for          MIME-tools (v5.406)  ok: found v5.509
Checking for         libwww-perl (any)     ok: found v6.45
Checking for         PatchReader (v0.9.4)  ok: found v0.9.6
Checking for           perl-ldap (any)     ok: found v0.66
Checking for         Authen-SASL (any)     ok: found v2.16
Checking for          RadiusPerl (any)     ok: found v0.31
Checking for           SOAP-Lite (v0.710.06) ok: found v1.27
Checking for            JSON-RPC (any)     ok: found v1.06
Checking for          Test-Taint (any)     ok: found v1.08
Checking for         HTML-Parser (v3.40)   ok: found v3.72
Checking for       HTML-Scrubber (any)     ok: found v0.19
Checking for Email-MIME-Attachment-Stripper (any)     ok: found v1.317
Checking for         Email-Reply (any)     ok: found v1.204
Checking for         TheSchwartz (any)     ok: found v1.15
Checking for      Daemon-Generic (any)     ok: found v0.85
Checking for            mod_perl (v1.999022) ok: found v2.000011
Checking for  Math-Random-Secure (v0.05)   ok: found v0.080001
Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

    http://cyberelk.net/tim/patchutils/

Checking for           DBD-mysql (v4.00)   ok: found v4.046
Checking for           MySQL (v4.1.2)  ok: found v10.3.17-MariaDB

Use of uninitialized value $innodb_on in string ne at Bugzilla/DB/Mysql.pm line 313, <DATA> line 755.
InnoDB is disabled in your MySQL installation.
Bugzilla requires InnoDB to be enabled.
Please enable it and then re-run checksetup.pl.

[edge@edge bugzilla]$

Ilia's picture
Submitted by Ilia on Thu, 07/16/2020 - 05:53

I think you addressing your question to the wrong place.

* Bugzilla Installation Error

Note: Thank you for the report - I started looking into it and discovered very unpleasant bug. Besides, I will update install script to the latest with few bug fixes.

Hang on.

bislinks's picture
Submitted by bislinks on Thu, 07/16/2020 - 09:14 Pro Licensee

Nevertheless, I got the latest/stable version of Bugzilla installed/working, fyi.

Ilia's picture
Submitted by Ilia on Thu, 07/16/2020 - 11:06

Nevertheless, I got the latest/stable version of Bugzilla installed/working, fyi.

If you reload the left menu, do you see all domain names listed as expected?