[Building Sakai] Learning - Development Environment Setup Walkthrough

[Mark J. Norton]

 >  Should #2 recommend MySql 5.5 instead of 5.1?

Interesting that this should come up just now.  I recently spent a day 
trying to figure a problem I was getting on 2.9 startup.  The error read,

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was 
too long; max key length is 1000 bytes

Eventually, I tracked it down toBug 4541 
<http://bugs.mysql.com/bug.php?id=4541> in MySQL.  It had to do with 
using UTF8.  Since UTF8 supports multibyte characters, if a database is 
set up to use UTF8 (as Sakai is), then the size of keys are tripled.  
MySQL had a max key size of 1000 bytes, hence the error message.  This 
bug wasn't fixed for close to EIGHT YEARS in MySQL, but was eventually 
fixed in 5.5.  This came up because I was installing 2.9 on a Debian 
machine and apt-get got me a 5.1 version of MySQL.

FWIW,
Mark Norton

On 12/4/2012 8:43 PM, Aaron Zeckoski wrote:
> On Tue, Dec 4, 2012 at 8:22 PM, Neal Caidin
> <nealcaidin at sakaifoundation.org> wrote:
>> Hey Aaron,
>>
>> Step 6 i. Configure tomcat 7 to use the old tomcat 5.5 classloader dirs .
>> Is that recommended?
> Not only recommended but actually required.
>
>> Should #2 recommend MySql 5.5 instead of 5.1?
> The CLE team calls indicate that there has not been enough 5.5 testing
> yet to recommend it.
>
>> Should #4 have Maven 3 instead of 2.2?
> I don't think so but I will leave it to others to comment. I use Maven 2.2.
>
> -AZ
>
>
>> On Dec 4, 2012, at 7:59 PM, Aaron Zeckoski <azeckoski at unicon.net> wrote:
>>
>> Neal,
>> The docs refer to "Download and setup tomcat 7.0.21+ (stable only)"
>> already. What else do you think it should say?
>> -AZ
>>
>>
>> On Tue, Dec 4, 2012 at 1:29 PM, Neal Caidin
>>
>> P.S. I think the Confluence doc needs updating to reflect Tomcat 7 support,
>>
>>
>>
>> --
>> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
>>
>>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121205/02223022/attachment.html