Grouper Users - Open Discussion List

[Damien Mannix <>]

Title: Re: Grouper install on mysql with unicode

Hi,

Right this is still occurring even though I’ve made the changes you mentioned, Do I need to drop what’s currently in the database and run the script? 

This is what DB variables looks like:

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     | 
| character_set_connection | latin1                     | 
| character_set_database   | utf8                       | 
| character_set_filesystem | binary                     | 
| character_set_results    | latin1                     | 
| character_set_server     | utf8                       | 
| character_set_system     | utf8                       | 
| character_sets_dir       | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+

This is different to Chris’ example. Should this to be changed to reflect all utf8? If so any suggestions how to this ?


Thanks in advance,

Damien


On 2/09/10 10:49 PM, "Chris Hyzer" <> wrote:

> Whoops, sqlserver introduced that bug, I fixed it in 2.0.  If we have another 1.6 release I will fix there too.  I will document on the wiki.
>  
> Thanks,
> chris
>  
>
> From: Richard James [] 
> Sent: Thursday, September 02, 2010 4:49 AM
> To: ; 
> Cc: Chris Hyzer
> Subject: RE: Grouper install on mysql with unicode
>  
> 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
>