Grouper Users - Open Discussion List

[Richard James <>]

Hi Damien,

 

When installing grouper 1.6.1 we also encountered the same error saying the specified key was too long; max key length is 1000 bytes using a mysql database. We have a character set similar to the one giving on the webpage that Chris linked to.

 

The error was triggered on trying to create one of the indexes on the grouper_attributes table. To get round this we ran the initialize script as normal which will throw the mysql error. After this has run, amend the latest ddl script that was created, changing the line,

 

CREATE INDEX attribute_field_value_idx ON grouper_attributes (field_id, value);

 

To

 

CREATE INDEX attribute_field_value_idx ON grouper_attributes (field_id, value(960));

 

Run the sql script,

 

./gsh.sh –registry –runsqlfile ../ddlScripts/<latestddl.sql>

 

We were then able to complete the creation of the database successfully.

 

I hope this is of some help.

 

Regards

 

Richard James

ISS Middleware Team

Newcastle University (UK)

 

 

From: [mailto:] On Behalf Of Chris Hyzer
Sent: 01 September 2010 20:56
To:
Cc:
Subject: [grouper-users] Grouper install on mysql with unicode

 

Damien,

 

I think it is a mysql issue, though not sure.  Any chance you can run parts of script at a time to see which part is failing exactly?  And can you tell us your database settings or can someone let us know which settings work with Grouper and international chars?

 

http://www.xaprb.com/blog/2006/04/17/max-key-length-in-mysql/

 

when I run this query I see utf8 and have no problems:

 

SHOW VARIABLES LIKE '%char%';

Variable_name Value

character_set_client      utf8

character_set_connection           utf8

character_set_database               utf8

character_set_filesystem            binary

character_set_results    utf8

character_set_server     utf8

character_set_system   utf8

character_sets_dir          C:\\Program Files\\MySQL\\MySQL Server 5.1\\share\\charsets\\

 

 

Thanks

Chris

 

###########

Hi Chris,

 

Thanks for your reply.

 

I’m not getting past sorting mysql

 

Here’s the error:

 

Error running script: /opt/grouper/1.6/grouper.apiBinary-1.6.1/ddlScripts/grouperDdl_20100901_17_10_32_721.sql, com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes

 

Thanks

 

Damien

 

 

On 31/08/10 10:36 PM, "Chris Hyzer"  wrote:

 

 

Try this doc:

 

https://spaces.internet2.edu/display/GrouperWG/Grouper+hosted+on+a+cloud+server

 

But do version 1.6.1 (latest)

 

Also, might want to join the grouper users mailing list, they have more people to help.  Next email, let us know which steps you have done and where you are getting stuck.

 

Thanks,

Chris

 

 

--------------------------------------------------------------------------------

From: Damien Mannix

To: Chris Hyzer

Sent: Tue, August 31, 2010 4:17:53 AM

Subject: FW: Grouper

 

Just incase you didn’t get this as your other address bounce.

 

 

------ Forwarded Message

From: Damien Mannix <>

Date: Tue, 31 Aug 2010 15:55:14 +1000

Conversation: Grouper

Subject: Grouper

 

HI Chris,

 

My name is Damien Mannix, I am based in Melbourne Australia, I work for a group called VeRSI which is a small eResearch group with strong ties to the broader Higher Education Community. I am working part time on the Australian Access Federation and I am looking at options for users to be able to manage groups for callaboration.

 

I’ve been trying to install grouper without much success, I was wondering if you could offer some advice or is there an image I could use? I am struggling with the documentation.

 

Any assistance would be greatly appreciated.

 

Thanks in advance

 

Damien