Grouper Users - Open Discussion List

["caleb racey" <>]

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,
  PRIMARY KEY  (`id`),
  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`)
) ENGINE=MyISAM DEFAULT;

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 
 
Cal 
 
Caleb Racey 
GFIVO project 
Webteam 
ISS
Newcastle University

________________________________

From: Michael R. Gettes 
[mailto:]
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?

Thanks

/mrg