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
