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.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 > <%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* *Email: *sid...@wso2.com Blog: https://medium.com/@sidath Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev