Hi Omindu, Thanks for your mail, my datasource was correctly set but I missed to configure these 2 lines:
[authentication.consent] data_source="jdbc/WSO2CONSENT_DB" In deed I missed the documentation page you referred, thanks so, now it's working ok. Regards from Belgium, Bernard https://uclouvain.be/en/index.html Le 8 janv. 2020 à 07:48, Omindu Rathnaweera <[email protected]<mailto:[email protected]>> a écrit : Hi Bernard, If you are changing the default datasource for consent (default is IDENTITY_DB), make sure you do the ncesary config changes following [1]. [1] - https://is.docs.wso2.com/en/5.9.0/setup/changing-datasource-consent-management/<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fis.docs.wso2.com%2Fen%2F5.9.0%2Fsetup%2Fchanging-datasource-consent-management%2F&data=02%7C01%7Cbernard.paris%40uclouvain.be%7C69b4ea91ab854672a76008d79406d583%7C7ab090d4fa2e4ecfbc7c4127b4d582ec%7C0%7C0%7C637140629969406555&sdata=lj6LOEbJfpxMwCcVtOflGpcLF3dZ3sNL53Kh5Qt72BY%3D&reserved=0> Regards, Omindu. On Tue, Jan 7, 2020 at 3:45 PM Bernard Paris <[email protected]<mailto:[email protected]>> wrote: Hi devs, I just installed WSO2 IS 590 with mysql DBs. I can create/edit a new service provider entry and it is shown in the service providers list. When I later try to delete it: <GraphiqueCollé-1.png> In the logs : > Caused by: java.sql.SQLSyntaxErrorException: Table > 'WSO2IS590_IDENTITY_DB.CM_RECEIPT' doesn't exist Strange because the CM_RECEIPT table is being looked up into DB WSO2IS590_IDENTITY_DB, while I see this table in WSO2IS590_CONSENT_DB What's the problem ?? Thanks, Bernard Paris _______________________________________________ Dev mailing list [email protected]<mailto:[email protected]> http://wso2.org/cgi-bin/mailman/listinfo/dev<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwso2.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fdev&data=02%7C01%7Cbernard.paris%40uclouvain.be%7C69b4ea91ab854672a76008d79406d583%7C7ab090d4fa2e4ecfbc7c4127b4d582ec%7C0%7C0%7C637140629969406555&sdata=yY8WsZUVe1bAt88T3sS47KCLr%2BMb%2FVfnFa2EJpLi4wQ%3D&reserved=0> -- Omindu Rathnaweera Associate Technical Lead, WSO2 Inc.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
