Hi Hemika, Yes I have created the corresponding databases.
Thanks. On Mon, Apr 4, 2016 at 5:22 PM, Hemika Kodikara <hem...@wso2.com> 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 <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 >> >> > -- *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