This instrcution seems wrong. I cannot startup Identity server with a
database created like this. I get the following exception trace;
TID: [0] [IS] [2015-06-25 14:27:28,207] ERROR
{org.wso2.carbon.user.core.util.DatabaseUtil} - Database Error - Incorrect
string value: '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1
{org.wso2.carbon.user.core.util.DatabaseUtil}
java.sql.SQLException: Incorrect string value: '\xE2\x80\x91200...' for
column 'UM_DESCRIPTION' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227)
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at
org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101)
at
org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at
org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at
org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114)
at
org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69)
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)
TID: [0] [IS] [2015-06-25 14:27:28,284] ERROR
{org.wso2.carbon.user.core.common.DefaultRealmService} - Cannot initialize
the realm. {org.wso2.carbon.user.core.common.DefaultRealmService}
org.wso2.carbon.user.core.UserStoreException: Database Error - Incorrect
string value: '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:261)
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at
org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101)
at
org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at
org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at
org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114)
at
org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69)
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.sql.SQLException: Incorrect string value:
'\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227)
... 23 more
TID: [0] [IS] [2015-06-25 14:27:28,285] ERROR
{org.wso2.carbon.user.core.internal.Activator} - Cannot start User Manager
Core bundle {org.wso2.carbon.user.core.internal.Activator}
org.wso2.carbon.user.core.UserStoreException: Cannot initialize the realm.
at
org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:231)
at
org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at
org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114)
at
org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69)
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: org.wso2.carbon.user.core.UserStoreException: Database Error -
Incorrect string value: '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at
row 1
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:261)
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at
org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101)
at
org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
... 19 more
Caused by: java.sql.SQLException: Incorrect string value:
'\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
at
org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227)
... 23 more
On Thu, Jun 25, 2015 at 1:05 PM, Chamara Ariyarathne <[email protected]>
wrote:
> For the script api-manager 1.9.0 apimgt/mysql.sql.
>
> On Thu, Jun 25, 2015 at 1:02 PM, Chamara Ariyarathne <[email protected]>
> wrote:
>
>> I got this same error for apimanager table creation in following
>> environment.
>> mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using
>> readline 5.1
>>
>> ERROR 1071 (42000): Specified key was too long; max key length is 767
>> bytes
>> ERROR 1146 (42S02): Table 'apimanager.IDN_OAUTH2_ACCESS_TOKEN' doesn't
>> exist
>>
>> What difference does it make when using "character set latin1" ?
>>
>> On Fri, Apr 17, 2015 at 10:32 AM, Vinod Kavinda <[email protected]> wrote:
>>
>>> Hi Godwin,
>>> It worked. thanks a lot.
>>>
>>> Regards,
>>> Vinod
>>>
>>> On Fri, Apr 17, 2015 at 2:47 PM, Godwin Amila Shrimal <[email protected]>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Use latin1 character set.
>>>>
>>>>
>>>> Thanks
>>>> Godwin
>>>>
>>>>
>>>> On Fri, Apr 17, 2015 at 2:40 PM, Vinod Kavinda <[email protected]> wrote:
>>>>
>>>>> Hi,
>>>>> I'm getting the following error while trying to setup a mysql
>>>>> datastore, when running the dbscript located at
>>>>> '<PRODUCT_HOME>/dbscripts/mysql.sql'.
>>>>> Error - *ERROR 1071 (42000) at line 31: Specified key was too long;
>>>>> max key length is 767 bytes*
>>>>>
>>>>> I tried reducing the REG_PATH_VALUE length to 100(mysql.sql attached),
>>>>> with no luck.
>>>>> There is a similar issue[1] that has already resolved.
>>>>>
>>>>> mysql version - mysql Ver 14.14 Distrib 5.6.22, for osx10.9 (x86_64)
>>>>> mysql command used - mysql -u root -p BAR < mysql.sql
>>>>>
>>>>> Any help is appreciated.
>>>>>
>>>>> [1] - https://wso2.org/jira/browse/CARBON-5917
>>>>>
>>>>> Regards,
>>>>> Vinod Kavinda
>>>>>
>>>>> --
>>>>> Vinod Kavinda
>>>>> Software Engineer, *WSO2, Inc <http://www.wso2.com>.*
>>>>> Mobile : +94 (0) 712 415544
>>>>> [email protected]
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list
>>>>> [email protected]
>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> *Godwin Amila Shrimal*
>>>> Senior Software Engineer
>>>> WSO2 Inc.; http://wso2.com
>>>> lean.enterprise.middleware
>>>>
>>>> mobile: *+94772264165*
>>>> linkedin: *http://lnkd.in/KUum6D <http://lnkd.in/KUum6D>*
>>>> twitter: https://twitter.com/godwinamila
>>>>
>>>
>>>
>>>
>>> --
>>> Vinod Kavinda
>>> Software Engineer, *WSO2, Inc <http://www.wso2.com>.*
>>> Mobile : +94 (0) 712 415544
>>> [email protected]
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> [email protected]
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>> *Chamara Ariyarathne*
>> Associate Technical Lead - Quality Assurance
>> WSO2 Inc; http://www.wso2.com/
>> Mobile; *+94772786766 <%2B94772786766>*
>>
>
>
>
> --
> *Chamara Ariyarathne*
> Associate Technical Lead - Quality Assurance
> WSO2 Inc; http://www.wso2.com/
> Mobile; *+94772786766 <%2B94772786766>*
>
--
*Chamara Ariyarathne*
Associate Technical Lead - Quality Assurance
WSO2 Inc; http://www.wso2.com/
Mobile; *+94772786766*
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
