Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Re: grouper ddl sql initialization error with mariadb

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: grouper ddl sql initialization error with mariadb


Chronological Thread 
  • From: Satya Mohapatra <>
  • To: grouper-users <>
  • Subject: [grouper-users] Re: grouper ddl sql initialization error with mariadb
  • Date: Tue, 27 Feb 2018 16:26:45 +0000
  • Accept-language: en-US
  • Ironport-phdr: 9a23:BJAcYx+OAbvi0/9uRHKM819IXTAuvvDOBiVQ1KB30e8cTK2v8tzYMVDF4r011RmVBd6ds6oMotGVmpioYXYH75eFvSJKW713fDhBt/8rmRc9CtWOE0zxIa2iRSU7GMNfSA0tpCnjYgBaF8nkelLdvGC54yIMFRXjLwp1Ifn+FpLPg8it2O2+55Pebx9UiDahfLh/MAi4oQLNu8cMnIBsMLwxyhzHontJf+RZ22ZlLk+Nkhj/+8m94odt/zxftPw9+cFAV776f7kjQrxDEDsmKWE169b1uhTFUACC+2ETUmQSkhpPHgjF8BT3VYr/vyfmquZw3jSRMMvrRr42RDui9b9mRh/2hikaKz43/mLZisJyg6JavB2uqAdyw4HIbIGQLvdyYr/RcNEcSGFcXshRTStBAoakYoUSFeUBIeZZoJPgrFUJqhu+BROjBPv1xT9UnH/5x7Ax3uM5EQ7cwAwgBcgBvW/RrNX0KKceS/66w7TVzTjaaf5dxDnz6I/Nch87oPGMW6p9cdHNyUY1CwzFjVKQqZL7MDOP2OQNt2+b7uR6We2zjG4nrgd8qSWsyMc0koTFm4EYxkrA+Clj3oo4Jce0RFN0bNK8DZddtDuWO5Z1T84mWW1luiQ3xqcJtJO6ZCQG1ZUqyhrFZ/CZc4WF7QjvWPuLLTtlh39od7SyjAuo/0e60O3zTMy03U5KriVbltnMsWgA2AHW6smGU/d9+12u2TeL1wDI9O5LPVk4lbHHJJE7xL4wkIQcsV7aEiL4gkn2ia6Wdlk+9ue29uvnf63qpp6aN4BqlgHzKrkil8+lDek8KAQCQWiW9f6h2LDs5UH5Ra9FjvwykqnXqpDaIsEbq7ahAwBPzoYj8QywAiyj0NQZgXkLNkxKdw+aj4TxIVHBPOj4Deujg1SriDpryOrGPrr8ApXVMHfDiq7tfatm60FC0goz1stS55ZVCrEaPPLzQVH9uMbZDh8/Lwy73fznCNNj2YMCR26DGLGWP77PsQzA2uV6LPOLeZcYonPgMPU//La6gmU+hEcQZ+y0xpYNc1i5GOhrOUOUfSCqj9scRzQkpA07GdfjlEyLGRtUZ3+qVr4m73lvEIu6F47rQ4GxxrGNwXHoTdVtemlaBwXUQj/TfIKeVqJUZQ==

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.
 
 
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




Archive powered by MHonArc 2.6.19.

Top of Page