Pushpalanka. -- Pushpalanka Jayawardhana, B.Sc.Eng.(Hons). Senior Software Engineer, WSO2 Lanka (pvt) Ltd; wso2.com/ Mobile: +94779716248 Blog: pushpalankajaya.blogspot.com/ | LinkedIn: lk.linkedin.com/in/pushpalanka/ | Twitter: @pushpalanka
On Fri, Jan 8, 2016 at 10:04 AM, Anupama Pathirage <[email protected]> wrote: > Hi, > > When Setting up MySQL with Identity Server(wso2is-5.1.0) as described in > [1], it gives the following error on server startup. This error occurs only > when we create the database tables using the scripts located at > "<PRODUCT_HOME>/dbscripts/mysql.sql" using the following command as > mentioned in the documentation.[1] > > > *Command:* > > mysql -u regadmin -p -Dregdb < '<PRODUCT_HOME>/dbscripts/mysql.sql'; > > > *Error:* > > [2016-01-07 18:07:10,230] ERROR > {org.wso2.carbon.idp.mgt.internal.IdPManagementServiceComponent} - Error > while activating Identity Provider Management bundle > org.wso2.carbon.idp.mgt.IdentityProviderManagementE xception: Error > occurred while retrieving Identity Provider information for tenant : > carbon.super and Identity Provider name : LOCAL > ... > ... > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'regdb.IDP' doesn't exist. > > > That <PRODUCT_HOME>/dbscripts/mysql.sql script in the Identity server > bundle doesn't contain the scripts for tables IDN_*, IDP_*, SP_*, and WF_*. > Even though table creation can be done by -Dsetup option at runtime without > any issue, when following the documentation users gets this error. > > Thought to mention this since I found several forum posts regarding the > same issue. So my suggestion is to either, > > - update <PRODUCT_HOME>/dbscripts/mysql.sql (and scripts for other > dbs as well ) with all the required tables OR > - update the documentation to work with -Dsetup option only > instead of using script based method > > The Identity related tables are created from the scripts located at wso2is-5.1.0/dbscripts/identity folder. The subtopic 'Changing the database for identity-related data' talks about it, but not clearly state those scripts are required to be executed as well. +1 to update the docs with -Dsetup option and improve the docs to mention the need of running identity scripts as well. > because the users who follows the steps in the document gets this error > for the first time. > > *[1] *https://docs.wso2.com/display/IS510/Setting+up+MySQL > > Thank You, > > -- > Anupama Pathirage > Associate Technical Lead > WSO2, Inc. http://wso2.com/ > Email: [email protected] > Mobile:+94 71 8273 979 > Blog:http://mycodeideas.blogspot.com/ > > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
