Bonita server & MySql: Specified key was too long
i'm trying to connect BonitaServer Tomcat with a MySql empty database. But when i execute ./setup.sh init --debug, i've got this exception :
org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #53 of URL [file:/opt/BonitaSubscription-7.9.4-tomcat/setup/platform_conf/sql/mysql/createTables.sql]: CREATE INDEX idx_message_instance ON message_instance (messageName(255), targetProcess(255), correlation1(128), correlation2(128), correlation3(128)); nested exception is java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes
Coul you help me ? I really don't know how to solve this.
Edit the file setup/platform_conf/sql/mysql/createTables.sql, replace all occurences of (128) by (64), then replace all occurences of (255) by (128), and retry to execute the command.