[ #306350 ] create_engine.ddl fails on mySQL with “Specified key was too long. Max key length is 500”
Date: 2006-11-04 20:30
Priority: 5
Submitted By: Ralph Plawetzki (ng-corsar)
Assigned To: Stefano Nichele (nichele)
Category: distribution/installation
State: Open
Summary: create_engine.ddl fails on mySQL with “Specified key was too long. Max key length is 500”
Detailed description: Trying to install the non-bundled version of funambol-ds-server-5.0.10 on
Debian 3.1 including these components:
Java: JDK 5.0 Update 9 from java.sun.com, installed with included install script
Application Server:Tomcat 5.0.30-12 installed Debian Package
DBMS: mySQL 4.0.24-10s installed Debian Package
I followed the installations instructions in
funambol_ds_server_administration_guide.pdf until the step where “sh
bin/install.sh tomcat50” is executed
After asking, if I want to recreate the database (“y”), the script
Funambol/ds-server/default/sql/mysql/create_engine.ddl fails in line 311. The
statement “create index ind_user on fnbl_user (username,
password);” leads to “Specified key was too long. Max key length is 500”
All other sql statements in the scipt before were executed without errors and
the tables have been created.
The workaround as described in
http://sourceforge.net/mailarchive/message.php?msg_id=13135170 worked.
