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.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/ > -- *Chandana Napagoda* Senior Software Engineer WSO2 Inc. - http://wso2.org *Email : chand...@wso2.com <chand...@wso2.com>**Mobile : +94718169299* *Blog : http://cnapagoda.blogspot.com <http://cnapagoda.blogspot.com>*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev