Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] MySQL and Grouper

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] MySQL and Grouper

Chronological Thread 
  • From: "caleb racey" <>
  • To: "Michael R. Gettes" <>, "Grouper-Users" <>
  • Subject: RE: [grouper-users] MySQL and Grouper
  • Date: Sat, 15 Sep 2007 13:03:15 +0100

Hi michael we are currently using grouper with mysql 5

it mostly works with the exception that the table "grouper_attributes"
doesn't get created becuase hibernate tries to create something mysql5 is not
happy with. The long term solution would be an upgrade to the latest
hibernate which has a mysql5 dialect, but that would be non trivial.

A work around is to manualy create the table then it will work fine,
something like the sql below will do it. Be warned though most of the build
process likes to empty out the database and recreat the tables so you can
loose the table several times. I've taken to keeping a copy of the table
called grouper_attribute_copy and copying it back to grouper_attributes
whenever the build process stomps on the origional

mysql5 compatable grouper attributes creation sql:

CREATE TABLE IF NOT EXISTS `grouper_attributes` (
`id` varchar(128) NOT NULL,
`group_id` varchar(128) default NULL,
`field_name` varchar(32) NOT NULL,
`value` text NOT NULL,
UNIQUE KEY `group_id` (`group_id`,`field_name`,`value`(255)),
KEY `attribute_value_idx` (`value`(255)),
KEY `attribute_group_idx` (`group_id`),
KEY `attribute_field_idx` (`field_name`)

One day i might get round to seeing if an innodb table type improves
performance but for now MyISAM in acceptible (performace experience email to
follow once we've done some more testing)

hope this helps


Caleb Racey
GFIVO project
Newcastle University


From: Michael R. Gettes
Sent: Fri 9/14/2007 7:49 PM
To: Grouper-Users
Subject: [grouper-users] MySQL and Grouper

Has anyone gotten Grouper and MySQL (5+) to work together? If so,
please let me know?



Archive powered by MHonArc 2.6.16.

Top of Page