Page Comparison

Follow the step-by-step guide that is described below to deploy the WSO2 Open Banking solution sucessfully.

Table of Contents

Configure databases

Multiexcerpt include

MultiExcerptName	settingupDatabase
PageWithExcerpt	Try Local Setup

Configure Open Banking Key Manager

Follow the steps below to deploy the Open Bnaking Key Manager.

Configure the <WSO2-obkm>/repository/conf/datasources/master-datasources.xml file with the following configurations.

Make sure to update the URL, username, password, and driverClassName accordingly.

Note
TheDatasource with the name NETINFO_DB should point to the OLB database for customer authentication.

Code Block

<datasource>
		<name>WSO2AM_DB</name>
        <description>The datasource used for API Manager database</description>
        <jndiConfig>
        		<name>jdbc/WSO2AM_DB</name>
        </jndiConfig>
        <definition type="RDBMS">
            	<configuration>
                		<url><<JDBC_URL>></url>
		                <username><<USERNAME>></username>
    	    	        <password><<PASSWORD>></password>
        	    	    <driverClassName><<DRIVER CLASS NAME>></driverClassName>
        	    	    <maxActive>50</maxActive>
        	    	    <maxWait>60000</maxWait>
        	    	    <testOnBorrow>true</testOnBorrow>
        	    	    <validationQuery>SELECT 1</validationQuery>
        	    	    <validationInterval>30000</validationInterval>
        	    	    <defaultAutoCommit>false</defaultAutoCommit>
	            </configuration>
        </definition>
</datasource>

<datasource>
		<name>WSO2AM_STATS_DB</name>
        <description>The datasource used for getting statistics to API Manager</description>
        <jndiConfig>
       			<name>jdbc/WSO2AM_STATS_DB</name>
        </jndiConfig>
        <definition type="RDBMS">
            	<configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER CLASS NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
                		<defaultAutoCommit>false</defaultAutoCommit>
            	</configuration>
        </definition>
</datasource>

<datasource>
        <name>WSO2_MB_STORE_DB</name>
        <description>The datasource used for message broker database</description>
        <jndiConfig>
            	<name>WSO2MBStoreDB</name>
        </jndiConfig>
        <definition type="RDBMS">
	            <configuration>
    	            <url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER CLASS NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
                		<defaultAutoCommit>false</defaultAutoCommit>
            	</configuration>
		</definition>
</datasource>

<datasource>
		<name>REGISTRY_DB</name>
		<description>The datasource used for registry- config/governance</description>
		<jndiConfig>
				<name>jdbc/WSO2RegistryDB</name>
		</jndiConfig>
		<definition type="RDBMS">
               <configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER CLASS NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
                		<defaultAutoCommit>false</defaultAutoCommit>
            	</configuration>
        </definition>
</datasource>
<datasource>
		<name>WSO2_USER_DB</name>
		<description>The datasource used for registry and user manager</description>
		<jndiConfig>
               <name>jdbc/WSO2UMDB</name>
		</jndiConfig>
		<definition type="RDBMS">
				<configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER CLASS NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
                		<defaultAutoCommit>false</defaultAutoCommit>
                </configuration>
        </definition>
</datasource>
       
<datasource>
        <name>NETINFO_DB</name>
        <description>The datasource used for vasco 2nd factor authentication</description>
        <jndiConfig>
				<name>netinfoDB</name>
        </jndiConfig>
        <definition type="RDBMS">
            	<configuration> 
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER CLASS NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
                		<defaultAutoCommit>false</defaultAutoCommit>
            	</configuration>
        </definition>
</datasource>

<datasource>
		<name>WSO2_CONSENT_DB</name>
  		<description>The datasource used for registry and user manager</description>
		<jndiConfig>
        		<name>jdbc/WSO2ConsentDB</name>
		</jndiConfig>
		<definition type="RDBMS">
        		<configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER CLASS NAME>></driverClassName>       
                		<maxActive>80</maxActive>
                		<maxWait>60000</maxWait>
						<testOnBorrow>true</testOnBorrow>
						<validationQuery>SELECT 1</validationQuery>
						<validationInterval>30000</validationInterval>
						<defaultAutoCommit>false</defaultAutoCommit>
		        </configuration>
		</definition>
</datasource>

Update the cacheId property in the <WSO2-obkm>/repository/conf/registry.xml file appropriately.

Code Block

<dbConfig name="govregistry">   
		<dataSource>jdbc/WSO2RegistryDB</dataSource>
</dbConfig>

<remoteInstance url="https://localhost:9443/registry">
		<id>instanceid</id>
	    <dbConfig>govregistry</dbConfig>
    	<readOnly>true</readOnly>
    	<enableCache>true</enableCache>
    	<registryRoot>/</registryRoot>
    	<cacheId>wso2dbadmin@jdbc:sqlserver://<DB_HOST>:1433;databaseName=prodwso2_apimgt_regdb</cacheId>
</remoteInstance>

<mount path="/_system/config" overwrite="true">
		<instanceId>instanceid</instanceId>
    	<targetPath>/_system/config</targetPath>
</mount>

Change the datasource of the <WSO2-obkm>/repository/conf/user-mgt.xml file to point to the WSO2UM_DB.
Code Block
<Property name="dataSource">jdbc/WSO2UM_DB</Property>

Configure Open Banking API Manager

Configure the <WSO2-obam>/repository/conf/datasources/master-datasources.xml file with the following configurations.

Note
Make sure to update the url, `username`, `password`, and `driverClassName` accordingly.

Code Block

<datasource>
		<name>REGISTRY_DB</name>
		<description>The datasource used for registry- config/governance</description>
		<jndiConfig>
				<name>jdbc/WSO2RegistryDB</name>
		</jndiConfig>
		<definition type="RDBMS">
				<configuration>
						<url><<JDBC_URL>></url>
	                	<username><<USERNAME>></username>
    	            	<password><<PASSWORD>></password>
        	        	<driverClassName><<DRIVER_CLASS_NAME>></driverClassName>
	        	        <maxActive>50</maxActive>
                	    <maxWait>60000</maxWait>
                    	<testOnBorrow>true</testOnBorrow>
                    	<validationQuery>SELECT 1</validationQuery>
                    	<validationInterval>30000</validationInterval>
                </configuration>
		</definition>
</datasource>
 
<datasource>
		<name>WSO2_USER_DB</name>
		<description>The datasource used for registry and user manager</description>
		<jndiConfig>
				<name>jdbc/WSO2UMDB</name>
		</jndiConfig>
		<definition type="RDBMS">
				<configuration>
						<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER_CLASS_NAME>></driverClassName>
                		<maxActive>50</maxActive>
                    	<maxWait>60000</maxWait>
                    	<testOnBorrow>true</testOnBorrow>
                    	<validationQuery>SELECT 1</validationQuery>
                    	<validationInterval>30000</validationInterval>
                </configuration>
		</definition>
</datasource>
 
<datasource>
		<name>WSO2AM_DB</name>
		<description>The datasource used for API Manager database</description>
		<jndiConfig>
				<name>jdbc/WSO2AM_DB</name>
		</jndiConfig>
		<definition type="RDBMS">
            	<configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER_CLASS_NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
            	</configuration>
		</definition>
</datasource>
 
<datasource>
		<name>WSO2AM_STATS_DB</name>
		<description>The datasource used for getting statistics to API Manager</description>
		<jndiConfig>
            	<name>jdbc/WSO2AM_STATS_DB</name>
		</jndiConfig>
		<definition type="RDBMS">
            	<configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER_CLASS_NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
             	   		<testOnBorrow>true</testOnBorrow>
                		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
            	</configuration>
		</definition>
</datasource>
 
<datasource>
		<name>WSO2_MB_STORE_DB</name>
		<description>The datasource used for message broker database</description>
		<jndiConfig>
				<name>WSO2MBStoreDB</name>
		</jndiConfig>
		<definition type="RDBMS">
				<configuration>
                		<url><<JDBC_URL>></url>
                		<username><<USERNAME>></username>
                		<password><<PASSWORD>></password>
                		<driverClassName><<DRIVER_CLASS_NAME>></driverClassName>
                		<maxActive>50</maxActive>
                		<maxWait>60000</maxWait>
                		<testOnBorrow>true</testOnBorrow>
           	     		<validationQuery>SELECT 1</validationQuery>
                		<validationInterval>30000</validationInterval>
                		<defaultAutoCommit>false</defaultAutoCommit>
            	</configuration>
		</definition>
</datasource>

Update the <cacheID> property in the <WSO2-obam>/repository/conf/registry.xml file appropriately.

Code Block

<dbConfig name="govregistry">   
        <dataSource>jdbc/WSO2RegistryDB</dataSource>
</dbConfig> 

<remoteInstance url="https://localhost:9443/registry">
		<id>instanceid</id>
		<dbConfig>govregistry</dbConfig>
		<readOnly>true</readOnly>
		<enableCache>true</enableCache>
		<registryRoot>/</registryRoot>
		<cacheId>wso2dbadmin@jdbc:sqlserver://<DB_HOST>:1433;databaseName=prodwso2_apimgt_regdb</cacheId>
</remoteInstance>

<mount path="/_system/config" overwrite="true">
		<instanceId>instanceid</instanceId>
		<targetPath>/_system/config</targetPath>
</mount>Update the datasource in the <OB_APIM_HOME>/repository/conf/user-mgt.xml file to point to the WSO2UM_DB.

Update the datasource in the <WSO2-obam>/repository/conf/user-mgt.xml file to point to the WSO2UM_DB.
Code Block
<Property name="dataSource">jdbc/WSO2UM_DB</Property>

Configure user stores

...

successfully.

Child pages (Children Display)

Versions Compared

Old Version 5

New Version Current

Key

Configure databases

Configure Open Banking Key Manager

Configure Open Banking API Manager

Configure user stores