dbscripts | Database management tools for Drupal web development -- dump

You are building your project here with the 4.7.2 framework, but in the yml you are referencing the .Net Core Framework. Could this be the problem?

You are creating 4 nearly identical resources all named execute[Create_scripts] and when the notification fires from the first cookbook_file resource being updated it finds the last one of them to be notified and runs against test4 (no matter which cookbook_file resource updates).

The fix is to use string interpolation to change the name of the execute resources to be unique and to notify based on that unique name:

Check these 2 things:

The init scripts are triggered only on the first deploy. On the subsequent docker-compose ups you probably see as well on the logs the following message:

1. As I have not used MultiTenantConnectionProvider so not sure at what point the datasource is chosen by the framework.

2. But I have a great suspicion it is done by the interceptor auto created by @Transactional, and the framework never reads the TenantContext inside the method. I.e one datasource for one transactional method. So may be worth identifying if my suspicion is true.

   • You can put a breakpoint at the following :

The CARBON_DB contains product-specific data. And by default that stores in the embedded h2 database. There is no requirement to point that DB to the PostgreSQL database. Hence you need to worry only about these databases SHARED_DB, USERSTORE_DB, IDENTITY_DB, CONSENT_MGT_DB and BPS_DB.

As per your next question, You can find the DB scripts related to USER_DB(USERSTORE_DB) in /dbscripts/postgresql.sql file. This file has tables starting with the name UM_. These tables are the user management tables. You can use those table sql scripts to create tables in USERSTORE_DB.

Refer the following doc for more information

[1]https://is.docs.wso2.com/en/5.10.0/administer/user-management-related-tables/

With the 4.5.0 carbon-kernel release, all WSO2 products such as APIM 3.0.0, IS 5.9.0 introduced a new config model. According to the new config model, there is a centralized configuration file (deployment.toml) where users add the configurations, then those configurations will be added to the respective .xml files.

So if you want to do some changes in the master-datasources.xml file, you have to add the relevant configs in deployment.toml file according to the new config model. With the new config model, all the changes made by you in the xml config files will be overridden by the toml configs during the server startup.

Please follow this documentation to refer further information on this new config model

Related documents:

https://wso2.com/blogs/thesource/2019/10/simplifying-configuration-with-WSO2-identity-server

Please follow this documentation if you are using trying to configure WSO2 Identity server with postgres db. https://is.docs.wso2.com/en/next/setup/changing-to-postgresql/

[updated according to the new issue]

Please execute this script also

/dbscripts/postgresql.sql

. From the error logs it says "um_domain" does not exist. That table creation happens from this script and you haven't executed this particular script.

If you use spring's Mockito features you should be able to use the @MockBean annotation like so:

Here's a recursive CTE that I think should list all your tables in the order that you should do the inserts. Assuming that all tables are in your current schema. Anything with a lvl of 0 can be run in any order.

By default Identity server comes with an embedded H2 database. But WSO2 recommends changing this to any production level database. By refering to your configuration i can see that you are trying to change it to a mysql database.

You are using a database called regdb for identity and shared database. and for consent management and bps database you are using a different database called bepl_db.

Hence you will have to execute the following DB scrips as per the documentation for regdb.