Hi Thank you Hemika and Tharindu.
The error was due to repeating the same datasource name in master-datasources.xml file and also need to create database using create database <DATABASE_NAME> character set latin1; not simply create database <DATABASE_NAME>; Thanks. On Mon, Apr 4, 2016 at 5:37 PM, Tharindu Edirisinghe <[email protected]> wrote: > Hi Elimatha, > > The error log has following. > > *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)* > > *Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Specified key was too long; max key length is 767 bytes* > > > So the reason for this is the index *REG_PATH_IND_BY_PATH_VALUE *exceeds > the maximum key length. > > The REG_PATH table creation db script is as following. > > CREATE TABLE IF NOT EXISTS REG_PATH( > REG_PATH_ID INTEGER NOT NULL AUTO_INCREMENT, > * REG_PATH_VALUE VARCHAR(750) *NOT NULL, > REG_PATH_PARENT_ID INTEGER, > *REG_TENANT_ID INTEGER *DEFAULT 0, > CONSTRAINT PK_REG_PATH PRIMARY KEY(REG_PATH_ID, REG_TENANT_ID) > )ENGINE INNODB; > > So the combination of REG_PATH_VALUE and REG_TENANT_ID columns should not > exceed this limit. > > More information on [1] where this is reported previously, however the > ticket is still not resolved. > > A temporary fix would be to reduce the character length of REG_PATH_VALUE, > but if this is a bug, then it has to be fixed. > > [1] https://wso2.org/jira/browse/CARBON-5917 > > On Mon, Apr 4, 2016 at 5:32 PM, Elilmatha Sivanesan <[email protected]> > wrote: > >> Hi Hemika, >> >> Yes I have created the corresponding databases. >> >> Thanks. >> >> On Mon, Apr 4, 2016 at 5:22 PM, Hemika Kodikara <[email protected]> wrote: >> >>> 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 <[email protected]> >>> 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 >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >> >> >> -- >> *S.Elilmatha* >> Associate Software Engineer, >> >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> Mobile 0779842221. >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > > Tharindu Edirisinghe > Software Engineer | WSO2 Inc > Platform Security Team > Blog : tharindue.blogspot.com > mobile : +94 775181586 > -- *S.Elilmatha* Associate Software Engineer, WSO2 Inc.; http://wso2.com lean.enterprise.middleware Mobile 0779842221.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
