Hi Thanuja, I too faced with that situation. Changing the collation of the database solved the problem for me. I think it's because current mysql scripts shipped with the product's doesn't support the "utf8"
Thanks, On Sun, Jul 13, 2014 at 7:51 AM, Thanuja Jayasinghe <[email protected]> wrote: > Hi all, > > MySQL default character set is 'latin1' and collation is > 'latin1_swedish_ci'. So I change it to 'utf8' and 'utf8_general_ci' by > adding followings to '/etc/mysql/my.cnf' file. > > [client] > default-character-set=utf8 > > [mysqld_safe] > default-character-set=utf8 > > [mysqld] > collation-server = utf8_unicode_ci > init-connect='SET NAMES utf8' > character-set-server = utf8 > > Now I'm trying to start IS-5.0.0 with '-Dsetup' option, and getting > following error. > > Caused by: java.lang.Exception: Error occurred while executing : CREATE > INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON REG_PATH(REG_PATH_VALUE, > REG_TENANT_ID) > at > org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:169) > at > org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:325) > at > org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:278) > ... 19 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Specified key was too long; max key length is 767 bytes > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > Does anyone know solution or workaround here, or we do not support 'utf8'? > > Thanks, > Thanuja. > -- > *Thanuja Lakmal* > Software Engineer > WSO2 Inc. http://wso2.com/ > *lean.enterprise.middleware* > Mobile: +94715979891 > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Rajith Vitharana Software Engineer, WSO2 Inc. : wso2.com Mobile : +94715883223 Blog : http://lankavitharana.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
