Grouper Users - Open Discussion List

[Chris Hyzer <>]

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