Hi Eilimatha, Did you try creating the database with the following command :
create database <DATABASE_NAME> character set latin1; Regards, Hemika Hemika Kodikara Software Engineer WSO2 Inc. lean . enterprise . middleware http://wso2.com Mobile : +94777688882 On Mon, Apr 4, 2016 at 5:18 PM, Elilmatha Sivanesan <elilma...@wso2.com> wrote: > Hi All, > > I tried to $subject by following the documentation [1] . I have added the > master-datasources.xml [2]. After doing the necessary config, I have > installed mysql version 5.6.20 and correspondind mysql connector > (mysql-connector-java-5.1.38-bin.jar ) in repository/components/lib folder. > I get the following error. > > What could be the reason for this. > > [2016-04-04 17:05:02,407] ERROR > {org.wso2.carbon.user.core.internal.Activator} - Cannot start User Manager > Core bundle > > java.lang.Exception: Error in creating the database > > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:306) > > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:85) > > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:109) > > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:68) > > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > > at java.security.AccessController.doPrivileged(Native Method) > > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > > 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:296) > > ... 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:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) > > at com.mysql.jdbc.Util.getInstance(Util.java:387) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547) > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505) > > at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840) > > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740) > > at > org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:139) > > ... 22 more > > > [1] https://docs.wso2.com/display/ES200/Setting+up+MySQL > [2] > -- > *S.Elilmatha* > Associate Software Engineer, > > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > Mobile 0779842221. > > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
