Hi Shakila, You need to import the mysql script inside identity folder to the database specified in the Identity.xml along with any other script you want.
If you point WSO2CarbonDB from both user-mgt.xml and identity.xml you need to import both mysql scripts in dbscripts directory and dbscripts/identity directory. Thanks, On Aug 20, 2016 10:44 PM, "Shakila Sivagnanarajah" <[email protected]> wrote: > > > On Sat, Aug 20, 2016 at 10:41 PM, Shakila Sivagnanarajah <[email protected] > > 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 < >> [email protected]> 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 <[email protected]> >>> 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 <[email protected]> >>>> 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 < >>>>> [email protected]> 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 <[email protected]> >>>>>> 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: [email protected] >>>>>>> Mobile: +94 (77) 1690552 >>>>>>> Web: WSO2 Inc <https://wso2.com/signature> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Shakila Sivagnanarajah >>>>>> Software Engineer >>>>>> Mobile :+94 (0) 768 856837 >>>>>> [email protected] >>>>>> WSO2, Inc. >>>>>> lean . enterprise . middleware >>>>>> http://www.wso2.com/ >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> *Chandana Napagoda* >>>>> Senior Software Engineer >>>>> WSO2 Inc. - http://wso2.org >>>>> >>>>> *Email : [email protected] <[email protected]>**Mobile : >>>>> +94718169299 <%2B94718169299>* >>>>> >>>>> *Blog : http://cnapagoda.blogspot.com >>>>> <http://cnapagoda.blogspot.com>* >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> Thank You, >>>> Best Regards, >>>> >>>> Sidath Weerasinghe >>>> >>>> >>>> *Intern* >>>> >>>> *WSO2, Inc. * >>>> >>>> *lean . enterprise . middleware * >>>> >>>> >>>> *Mobile: +94719802550 <%2B94719802550>* >>>> >>>> *Email: *[email protected] >>>> >>>> Blog: https://medium.com/@sidath >>>> >>>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe >>>> >>> >>> >>> >>> -- >>> Shakila Sivagnanarajah >>> Software Engineer >>> Mobile :+94 (0) 768 856837 >>> [email protected] >>> WSO2, Inc. >>> lean . enterprise . middleware >>> http://www.wso2.com/ >>> >> >> >> >> -- >> Shakila Sivagnanarajah >> Software Engineer >> Mobile :+94 (0) 768 856837 >> [email protected] >> WSO2, Inc. >> lean . enterprise . middleware >> http://www.wso2.com/ >> > > > > -- > Shakila Sivagnanarajah > Software Engineer > Mobile :+94 (0) 768 856837 > [email protected] > WSO2, Inc. > lean . enterprise . middleware > http://www.wso2.com/ >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
