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 <elilma...@wso2.com>
wrote:
> 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
>
>
--
Tharindu Edirisinghe
Software Engineer | WSO2 Inc
Platform Security Team
Blog : tharindue.blogspot.com
mobile : +94 775181586
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
