Grouper Developers Forum

[Chris Hyzer <>]

If we are supporting all databases, then MySQL surely should be supported, and it still doesn’t work.  The problem with the schema init still happens with hib3 and mysql5.  I think it is a mysql problem:

 

create table grouper_attributes (id varchar(128) not null, group_id varchar(128), field_name varchar(32) not null, value varchar(1024) not null, primary key (id), unique (group_id, field_name, value))

 

Specified key was too long; max key length is 767 bytes

 

http://bugs.mysql.com/bug.php?id=4541

 

Can we do one of two things:

 

1.       Change the grouper_attributes.value so that it is not in the unique index with group_id and name?  With all three it allows a group to have two attributes with the same name, do we have a use case for that?

2.       –or- Make the size of that column 766.  If someone wanted to increase it, that is probably easier than having the schemaExport fail for mysql users and having to wonder what to do

 

Im not having much luck searching the listservs since I know this has been discussed…

 

https://mail.internet2.edu/wws/arcsearch_form/grouper-dev

https://mail.internet2.edu/wws/arcsearch_form/grouper-users

 

I search for mysql and don’t see the message, does the search work or am I not doing it right?

 

Thanks,

Chris