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/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
