[Building Sakai] Sakai 2.7 with mysql 5.5 and SAKAI_PERSON_T?

[Aaron Zeckoski]

I just upgraded my local database to mysql 5.5 (from 5.1) and I am
finding that I cannot get sakai 2.7 to startup with a fresh DB. I am
using the newest connector (5.1.16) but when I try to startup Sakai I
get this failure message when trying to create the SAKAI_PERSON_T
table:

ERROR 1118 (42000): Row size too large

2011-05-12 17:02:27,386  WARN main
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean
- Unsuccessful schema statement: create table SAKAI_PERSON_T (ID
bigint not null auto_increment, PERSON_TYPE varchar(3) not null,
VERSION integer not null, UUID varchar(36) not null unique,
LAST_MODIFIED_BY varchar(36) not null, LAST_MODIFIED_DATE datetime not
null, CREATED_BY varchar(36) not null, CREATED_DATE datetime not null,
AGENT_UUID varchar(99) not null, TYPE_UUID varchar(36) not null,
COMMON_NAME varchar(255), DESCRIPTION varchar(255), SEE_ALSO
varchar(255), STREET varchar(255), SURNAME varchar(255),
TELEPHONE_NUMBER varchar(255), FAX_NUMBER varchar(255), LOCALITY_NAME
varchar(255), OU varchar(255), PHYSICAL_DELIVERY_OFFICE_NAME
varchar(255), POSTAL_ADDRESS varchar(255), POSTAL_CODE varchar(255),
POST_OFFICE_BOX varchar(255), STATE_PROVINCE_NAME varchar(255),
STREET_ADDRESS varchar(255), TITLE varchar(255), BUSINESS_CATEGORY
varchar(255), CAR_LICENSE varchar(255), DEPARTMENT_NUMBER
varchar(255), DISPLAY_NAME varchar(255), EMPLOYEE_NUMBER varchar(255),
EMPLOYEE_TYPE varchar(255), GIVEN_NAME varchar(255), HOME_PHONE
varchar(255), HOME_POSTAL_ADDRESS varchar(255), INITIALS varchar(255),
JPEG_PHOTO blob, LABELED_URI varchar(255), MAIL varchar(255), MANAGER
varchar(255), MOBILE varchar(255), ORGANIZATION varchar(255), PAGER
varchar(255), PREFERRED_LANGUAGE varchar(255), ROOM_NUMBER
varchar(255), SECRETARY varchar(255), UID_C varchar(255),
USER_CERTIFICATE tinyblob, USER_PKCS12 tinyblob,
USER_SMIME_CERTIFICATE tinyblob, X500_UNIQUE_ID varchar(255),
AFFILIATION varchar(255), ENTITLEMENT varchar(255), NICKNAME
varchar(255), ORG_DN varchar(255), ORG_UNIT_DN varchar(255),
PRIMARY_AFFILIATION varchar(255), PRIMARY_ORG_UNIT_DN varchar(255),
PRINCIPAL_NAME varchar(255), CAMPUS varchar(255), HIDE_PRIVATE_INFO
bit, HIDE_PUBLIC_INFO bit, NOTES varchar(4000), PICTURE_URL
varchar(255), SYSTEM_PICTURE_PREFERRED bit, ferpaEnabled bit,
dateOfBirth date, locked bit, FAVOURITE_BOOKS varchar(4000),
FAVOURITE_TV_SHOWS varchar(4000), FAVOURITE_MOVIES varchar(4000),
FAVOURITE_QUOTES varchar(4000), EDUCATION_COURSE varchar(4000),
EDUCATION_SUBJECTS varchar(4000), NORMALIZEDMOBILE varchar(255),
primary key (ID), unique (AGENT_UUID, TYPE_UUID)) ENGINE=InnoDB
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size
too large. The maximum row size for the used table type, not counting
BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

I think this is caused by making varchars which are larger than 255
chars. Dropping those down to 255 chars allows this to run.

Everything else seems to work fine.
-AZ

-- 
Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile