Grouper Users - Open Discussion List

[Damien Mannix <>]

Title: Re: Grouper install on mysql with unicode

Hi Richard,

Thanks for this. Unfortunately I haven’t had a chance to try again today, I will look at it tomorrow and report back!

Regards

Damien




On 2/09/10 6:49 PM, "Richard James" <> wrote:

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