Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper install on mysql with unicode

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper install on mysql with unicode


Chronological Thread 
  • From: Richard James <>
  • To: "'Damien Mannix'" <>, Chris Hyzer <>, "" <>
  • Subject: [grouper-users] RE: Grouper install on mysql with unicode
  • Date: Fri, 3 Sep 2010 10:18:14 +0100
  • Accept-language: en-US, en-GB
  • Acceptlanguage: en-US, en-GB

Title: Re: Grouper install on mysql with unicode

Hi,

 

I have just done a quick install on a test server to refresh my memory on how exactly we got this running. To execute this successfully,

 

1)      Run the normal command   ./gsh.sh -registry –runscript, to produce the error.

2)      Edit the ddl file as mentioned previously.

3)      Then you can either remove the two tables that have already been created in the database, and run ./gsh.sh –registry –runsqlfile ../ddlScripts/<latestddl.sql> which will create the database from scratch. Or you can remove all the SQL commands that precede “CREATE INDEX attribute_field_value_idx ON grouper_attributes (field_id, value(960));”  in the ddl file, save the file and run this sql file.

4)      Then hopefully you should get a “Script was executed successfully message” J

 

Just for info, our mysql DB variables are all Latin1,  except for character_set_system which is set to utf8. 1.6.1 is running very well in a production environment with these db variables.

 

Hopefully the above will help you out.

 

Cheers

 

Richard

 

From: Damien Mannix [mailto:]
Sent: 03 September 2010 02:28
To: Chris Hyzer; Richard James;
Subject: 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
 




Archive powered by MHonArc 2.6.16.

Top of Page