Grouper Users - Open Discussion List

[Chris Hyzer <>]

Another addition... if you want transactions to work (i.e. when doing a unit 
of work in grouper, it either all completes or none), which is definitely 
recommended, though not required, your mysql table format needs to be 
transactional, e.g. innodb, which is not the default (myisam is the default).

I enabled innodb in my mysql with this line in the my.cnf:

default-storage-engine=innodb

Thanks,
Chris

> -----Original Message-----
> From: Chris Hyzer
> Sent: Saturday, January 31, 2009 9:42 AM
> To: Chris Hyzer; 'Martin van Es'
> Cc: 
> ''
> Subject: RE: [grouper-users] grouper-ws and tomcat5.5/java6
>
> I fixed that for 1.4.1:
>
> https://bugs.internet2.edu/jira/browse/GRP-216
>
> Grouper will now work on mysql case sensitive.
>
> However, if there are issues, besides letting us know, you can start
> mysql on unix without being case sensitive with:
>
> http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
>
> Set the mysqld startup var:
>
> lower_case_table_names=1
>
> We will test on mysql case sensitive before releases:
>
> https://wiki.internet2.edu/confluence/display/GrouperWG/Release+steps
>
> Regards,
> Chris
>
> > -----Original Message-----
> > From: Chris Hyzer
> > Sent: Friday, January 30, 2009 11:53 AM
> > To: Chris Hyzer; 'Martin van Es'
> > Cc: 
> > ''
> > Subject: RE: [grouper-users] grouper-ws and tomcat5.5/java6
> >
> > Martin let me know that worked for him...
> >
> > 1. Lets change the documentation for mysql so people startup with
> that
> > param
> > 2. On the next call lets discuss if we want to look through all our
> > queries to see if we can make them case-sensitive.  If so we need to
> > specifically do the unit tests on linux mysql (without the param)
> > before releases...
> >
> > Thanks!
> > Chris
> >
> > > -----Original Message-----
> > > From: Chris Hyzer
> > > Sent: Friday, January 30, 2009 11:20 AM
> > > To: 'Martin van Es'
> > > Cc: 
> > > 
> > > Subject: RE: [grouper-users] grouper-ws and tomcat5.5/java6
> > >
> > > Uh oh...
> > >
> > > Looks like mysql is case-sensitive by default on linux????   That
> is
> > > not good.
> > >
> > > http://dev.mysql.com/doc/refman/5.0/en/identifier-case-
> > sensitivity.html
> > >
> > > Can you set the mysqld startup var:
> > >
> > > lower_case_table_names=1
> > >
> > > And see if it works?  If so, we should change our documentation for
> > > mysql.
> > >
> > > Let us know.
> > >
> > > Thanks!
> > > Chris
> > >
> > > > -----Original Message-----
> > > > From: Martin van Es 
> > > > [mailto:]
> > > > Sent: Friday, January 30, 2009 11:13 AM
> > > > To: Martin van Es
> > > > Cc: 
> > > > 
> > > > Subject: Re: [grouper-users] grouper-ws and tomcat5.5/java6
> > > >
> > > > On Friday 30 January 2009 16:55:42 Martin van Es wrote:
> > > > > I changed it to point to my /var/lib/tomcat5.5/log directory
> > (hard)
> > > > and
> > > > > moved back to java5 (other tip). That did the trick. Thanks a
> > > bunch!
> > > > Now
> > > > > let's check java6 again... step by step ;)
> > > >
> > > > And that's working too (so add java6 to "tested" platforms,
> > although
> > > > preliminary, if you want).
> > > >
> > > > Now only the addSubject() in gsh problem is remaining. Nailed it
> > down
> > > > to this
> > > > error. Hope that Chris has anything sensible to say about it:
> > > >
> > > > 2009-01-30 15:04:52,977: [main] ERROR
> > > > JDBCExceptionReporter.logExceptions(78)
> > > > - Table 'grouper.Subject' doesn't exist
> > > >
> > > > Which is true, because there's only a grouper.subject table, that
> > was
> > > > created
> > > > using the bootstrap scripts.
> > > >
> > > > Regards and many thanks to all who replied!
> > > > Martin