Db migration error on Mariadb Database

[nbrechet]

Infos:

• Used Zammad version: 3.4
• Used Zammad installation source: (source, package, …) package
• Operating system: Centos7
• Database: mariadb 10.1.x
• DB Charset: utf8_unicode_ci

Expected behavior:

• rake db:migrate running successfully

Actual behavior:

• throws error Specified key was too long; max key length is 767 bytes: CREATE INDEX `index_smime_certificates_on_modulus` ON `smime_certificates`

Steps to reproduce the behavior:

• updating Zammad with MariaDB as Database

Did someone else had the same Problem?

Thanks
Nicolas

[nbrechet]

I had to activate larg index keys.

SET GLOBAL innodb_default_row_format = dynamic;
SET GLOBAL innodb_large_prefix = 1;