Grouper Users - Open Discussion List

[Satya Mohapatra <>]

Hi Chris, 

Thanks for the pointer. Due to some dependency issues I cannot upgrade mariadb to a later version now. 

I also didn’t want to customize the index script. 

What I did simply was to remove mariadb and stick to mysql 5.7 provided by mysql Debian repo.  That works. 

Best,

---
Satya Mohapatra, ସତ୍ୟ ମହାପାତ୍ର, सत्य महापात्र,  ستیا موہپترا

On Feb 23, 2018, at 7:33 PM, Hyzer, Chris <> wrote:

This says perhaps use a more recent mariadb, or you can edit the index script to use prefixes and not the whole col.

 

https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

 

Thanks

Chris

 

From:  [] On Behalf Of Satya Mohapatra
Sent: Thursday, February 22, 2018 12:08 PM
To: grouper-users <>
Subject: [grouper-users] grouper ddl sql initialization error with mariadb

 

Hi,

 

 

I am trying to install grouper 2.1.5 on a Debian 9 server, with has  Mariadb as the default OS Mysql variant. 

 

I am seeing this particular error which I believe is a common error with mysql to mariadb transition. 

 

 

$ /opt/grouper/grouper.api-2.1.5/ddlScripts/grouperDdl_20180220_08_57_33_012.sql

Error running script: /opt/grouper/grouper/ddlScripts/grouperDdl_20180220_08_57_33_012.sql, com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

Does anyone know any work around ? I have tried both the Java mysql connector and Java Mariadb connector, and I am seeing the same error. 

 

Best, 

---
Satya Mohapatra, ସତ୍ୟ ମହାପାତ୍ର, सत्य महापात्र,  ستیا موہپترا
LIGO laboratory @ MIT

Attachment: smime.p7s
Description: S/MIME cryptographic signature