I found the following in the logs:
create table `REMOTEGROUPMEMBERS` (`REMOTEGROUPDIRECTORYID` bigint not null, `REMOTEGROUPNAME` varchar(255) not null, `REMOTEPRINCIPALDIRECTORYID` bigint not null, `REMOTEPRINCIPALNAME` varchar(255) not null, primary key (`REMOTEGROUPDIRECTORYID`, `REMOTEGROUPNAME`, `REMOTEPRINCIPALDIRECTORYID`, `REMOTEPRINCIPALNAME`))
This never gets created - when I run it manually I get:
Error 1071 - Specified key was too long; max key length is 1000 bytes
I can't find a setting to change the max key length to work around this while a fix is found. Another work around would be useful as I cannot continue investigating using Crowd at this point.