On Sat, Aug 20, 2016 at 10:41 PM, Shakila Sivagnanarajah <shak...@wso2.com> wrote:
> 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/ > -- 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