Hi Shakila, The tables idp and sp_app are in the scripts in identity folder.
What is the datasource you have used in identity.xml? Seems like you have used wso2_carbon_db_store there. As you have created WSO2_IDENTITY_DB datasource already use the mysql script inside identity folder to create the tables and use WSO2_IDENTITY_DB datasource in identity.xml. Thanks, On Aug 19, 2016 9:59 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.common.AbstractUserStoreManager.ad >> dInitialAdminData(AbstractUserStoreManager.java:3749) >> at org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.<init>(J >> DBCUserStoreManager.java:281) >> at org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.<init>(J >> DBCUserStoreManager.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/ _______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev