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: "Hyzer, Chris" <>
  • To: Satya Mohapatra <>, grouper-users <>
  • Subject: [grouper-users] RE: grouper ddl sql initialization error with mariadb
  • Date: Sat, 24 Feb 2018 00:33:22 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:v1fgRhFQwKCgVXk0rIhlY51GYnF86YWxBRYc798ds5kLTJ7yocWwAkXT6L1XgUPTWs2DsrQY07GQ6/iocFdDyK7JiGoFfp1IWk1NouQttCtkPvS4D1bmJuXhdS0wEZcKflZk+3amLRodQ56mNBXdrXKo8DEdBAj0OxZrKeTpAI7SiNm82/yv95HJbAhEmDSwbaluIBmqsA7cqtQYjYx+J6gr1xDHuGFIe+NYxWNpIVKcgRPx7dqu8ZBg7ipdpesv+9ZPXqvmcas4S6dYDCk9PGAu+MLrrxjDQhCR6XYaT24bjwBHAwnB7BH9Q5fxri73vfdz1SWGIcH7S60/VDK/5KlpVRDokj8KOT4n/m/Klsx+gqFVoByjqBx+34Hbb5qYO+Bicq/BZ94WWXZNU8RXWidcAo28dYwPD+8ZMOpWrYf8p1oPogWkBQW0Geji1D9IhmX33a0h3egqDAbL3Ak8ENIOsHXVrcv6NL0JXOC016nH0S/Pb+5O2Tjj7ojIdAotru+RUrJtaMfcz1QkGQ3CjlWVs4PlPjWV2/wWs2iH9eVvSeGvi2k5qw5vuDivyMMsio7Hh44P1l/E8iB5zYAoLtO7UE52ecCoHIdSui2AOIZ7Q9kuT3xptSs00LEKpIO3cSgSxJg6yRPTd+aLfoyV7h75SuqdPDN1iGh4dL+9hhu+6UagxfP/W8Wo1VtHqzdJncTPu30C0hHc9NKIRud480qixzmDyQTe5+RfLk00m6rUN5gsyaMqmJUJq0TMBCr2lV32jKCIckUk/fCl5fz7b7vhupOQKpZ4hBzmPKgzg8C/Bv83PRYUU2ic5OS8yKbs/UrkQLVMk/I6iLHZsIrdJcQHuKG2HxNV0ock6xa5FTum18kYnWUDLFJCfxKHjJLlNE3JIPD9Ffu/glKsnyl3x/3eILHtHpfAImLMnbrgZ7px9k9RxQQpwdxC+p5ZCqkNIPfpVU/wsNzYAAU5Mwuxw+v/DdVyyoMeWGKOA6CHKqPfql6I5vkzLOWWeY8VoCjyK/4j5/L0k3A2hEIdcbGz3ZQLcHC4AuhmI0KBbHrjmNcBFnoKvhIgQ+zwkVGCTCVTaGioX6In/Tw7DIOmDZzfRoC2nrCNxia7HptKZm9YEFCMF2nnd5maV/sWdi2dP9JhwXQ4Uu2aQpMw3FmLsw/z07N7NOOcrjURqYjq/N10+6vemQxksXR7FcOAy2yXCnxvk3kTD2s5xqdiuUFnj0qY3LJjq/1eCdFJ4f5VCEE3OYOKnMJgDNWnECLQbNqTDB6NQs+nGnt5Gtc6w84cblxVGs6pyA3b0iysRbIZiurYV9QP7qvA0i2pdI5GwHHc2fx5gg==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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: [mailto:] 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

 

 


Archive powered by MHonArc 2.6.19.

Top of Page