Grouper Users - Open Discussion List

["Michael R. Gettes" <>]

Cal,

thanks so much for the reply.  I too ran into a similar problem but  
solved
differently the SQL problem.  But I got stuck in the mysql5 and  
hibernate
interactions.  What dialect did you use?  Any special tweaks you made to
allow for the current hibernate and mysql5 to get along?

Thanks!

/mrg

On Sep 15, 2007, at 8:03, caleb racey wrote:

> 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