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
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
