Hi Maduranga,
WSO2CarbonDB is used in identity.xml [1] and 'WSO2CARBON_DB' is the
corresponding database specified in master-datasources.xml. Since queries
for some other relevant tables(E.g um_dialect) are not in the mysql scripts
resides in identity folder, I imported from dbscripts folder.
[1]
<DataSource>
<Name>jdbc/WSO2CarbonDB</Name>
</DataSource>
Thanks
On Sat, Aug 20, 2016 at 10:22 PM, Shakila Sivagnanarajah <shak...@wso2.com>
wrote:
> Hi,
>
> I am using mysql 5.7.14 and I manually imported the below mentioned sql
> files into corresponding databases.
>
> WSO2_CARBON_DB_STORE - <wso2es-2.1.0>/dbscripts/mysql5.7.sql
> WSO2SOCIAL_DB - <wso2es-2.1.0>/dbscripts/social/mysql/resource.sql
>
> Seems we need to have idp and sp_app tables into the database named '
> WSO2_CARBON_DB_STORE'. But I imported <wso2es-2.1.0>/dbscripts/mysql5.7.sql
> and there are no queries for these tables.
>
> Thanks
>
> On Sat, Aug 20, 2016 at 8:43 PM, Sidath Weerasinghe <sid...@wso2.com>
> wrote:
>
>> Hi Shakila,
>>
>> If you are using MYSQL 5.7; It can be make some errors.
>>
>> On Sat, Aug 20, 2016 at 9:03 AM, Chandana Napagoda <chand...@wso2.com>
>> wrote:
>>
>>> Hi Shakilla,
>>>
>>> What is the MySQL server version you are using? Are you trying to create
>>> DB tables manually or using -Dsetup?
>>>
>>> Regards,
>>> Chandana
>>>
>>> On Fri, Aug 19, 2016 at 9:58 PM, Shakila Sivagnanarajah <
>>> shak...@wso2.com> wrote:
>>>
>>>> Hi Danesh thanks, 'AddAdmin' was set to false.
>>>>
>>>> mysql create queries for some tables are not found in the given in the
>>>> sql query file(<wso2es-2.1.0>/dbscripts/mysql5.7.sql).
>>>>
>>>> 1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>>>> 'wso2_carbon_db_store.idp' doesn't exist
>>>> 2. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>>>> 'wso2_carbon_db_store.sp_app' doesn't exist
>>>>
>>>> Am I importing wrong sql file?
>>>>
>>>> Thanks
>>>>
>>>> On Fri, Aug 19, 2016 at 7:07 PM, Danesh Kuruppu <dan...@wso2.com>
>>>> wrote:
>>>>
>>>>> Hi Shakila,
>>>>>
>>>>>
>>>>>> Caused by: org.wso2.carbon.user.core.UserStoreException: Admin user
>>>>>> can not be created in primary user store. Add-Admin has been set to
>>>>>> false.
>>>>>> Please pick a User name which is exist in the primary user store as Admin
>>>>>> user
>>>>>> at org.wso2.carbon.user.core.comm
>>>>>> on.AbstractUserStoreManager.addInitialAdminData(AbstractUser
>>>>>> StoreManager.java:3749)
>>>>>> at org.wso2.carbon.user.core.jdbc
>>>>>> .JDBCUserStoreManager.<init>(JDBCUserStoreManager.java:281)
>>>>>> at org.wso2.carbon.user.core.jdbc
>>>>>> .JDBCUserStoreManager.<init>(JDBCUserStoreManager.java:220)
>>>>>> ... 27 more
>>>>>>
>>>>>>
>>>>> Check whether you set <AddAdmin>False</AddAdmin> in user-mgt.xml.
>>>>> Seems like admin user doesn't exist in your primary user store and server
>>>>> cannot create the user since it is set to false.
>>>>>
>>>>> Thanks
>>>>> --
>>>>>
>>>>> *Danesh Kuruppu*
>>>>> Senior Software Engineer | WSO2
>>>>>
>>>>> Email: dan...@wso2.com
>>>>> Mobile: +94 (77) 1690552
>>>>> Web: WSO2 Inc <https://wso2.com/signature>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Shakila Sivagnanarajah
>>>> Software Engineer
>>>> Mobile :+94 (0) 768 856837
>>>> shak...@wso2.com
>>>> WSO2, Inc.
>>>> lean . enterprise . middleware
>>>> http://www.wso2.com/
>>>>
>>>
>>>
>>>
>>> --
>>> *Chandana Napagoda*
>>> Senior Software Engineer
>>> WSO2 Inc. - http://wso2.org
>>>
>>> *Email : chand...@wso2.com <chand...@wso2.com>**Mobile : +94718169299
>>> <%2B94718169299>*
>>>
>>> *Blog : http://cnapagoda.blogspot.com
>>> <http://cnapagoda.blogspot.com>*
>>>
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>> Thank You,
>> Best Regards,
>>
>> Sidath Weerasinghe
>>
>>
>> *Intern*
>>
>> *WSO2, Inc. *
>>
>> *lean . enterprise . middleware *
>>
>>
>> *Mobile: +94719802550 <%2B94719802550>*
>>
>> *Email: *sid...@wso2.com
>>
>> Blog: https://medium.com/@sidath
>>
>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
>>
>
>
>
> --
> Shakila Sivagnanarajah
> Software Engineer
> Mobile :+94 (0) 768 856837
> shak...@wso2.com
> WSO2, Inc.
> lean . enterprise . middleware
> http://www.wso2.com/
>
--
Shakila Sivagnanarajah
Software Engineer
Mobile :+94 (0) 768 856837
shak...@wso2.com
WSO2, Inc.
lean . enterprise . middleware
http://www.wso2.com/
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
