Page Comparison

...

Excerpt

Info
Edit the the `WSO2_CARBON_DB, WSO2_EMM_DB and WSO2AM_DB` datasources in the `master-datasources.xml` and `cdm-datasources.xml` file by replacing the `url`, `username`, `password` and `driverClassName` settings with your custom values and also the other values accordingly.

master-datasources.xml

Panel

This file contains the following default datasource configurations to configure EMM with the Carbon database and the WSO2 API Manager database.

Expand

title	WSO2_Carbon_DB datasource

Code Block

language	xml

<datasource>
   <name>WSO2_CARBON_DB</name>
   <description>The datasource used for registry and user manager</description>
   <jndiConfig>
      <name>jdbc/WSO2CarbonDB</name>
   </jndiConfig>
   <definition type="RDBMS">
      <configuration>
         <url>jdbc:h2mysql:repository//databaselocalhost:3306/WSO2CARBON_DB;DB_CLOSE_ON_EXIT=FALSE<DB</url>
         <username>wso2carbon</username>
         <password>wso2carbon</password>
         <driverClassName>org<driverClassName>com.mysql.h2jdbc.Driver</driverClassName>
         <maxActive>50</maxActive>
         <maxWait>60000</maxWait>
         <testOnBorrow>true</testOnBorrow>
         <validationQuery>SELECT 1</validationQuery>
         <validationInterval>30000</validationInterval>
      </configuration>
   </definition>
</datasource>

Expand

title	WSO2AM_DB datasource

Code Block

language	xml

<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:h2mysql:repository//databaselocalhost:3306/WSO2AM_DB;DB_CLOSE_ON_EXIT=FALSE<DB</url>
         <username>wso2carbon</username>
         <password>wso2carbon</password>
         <driverClassName>org<driverClassName>com.mysql.h2jdbc.Driver</driverClassName>
         <maxActive>50</maxActive>
         <maxWait>60000</maxWait>
         <testOnBorrow>true</testOnBorrow>
         <validationQuery>SELECT 1</validationQuery>
         <validationInterval>30000</validationInterval>
      </configuration>
   </definition>
</datasource>

cdm-datasources.xml

Panel

This file contains the following default datasource configurations to configure EMM with the Connected Device Management Framework and for mobile device management.

Expand

title	DM_DS datasource

Code Block

language	xml

 <datasource>
   <name>DM_DS</name>
   <description>The datasource used for EMM</description>
   <jndiConfig>
      <name>jdbc/DM_DS</name>
   </jndiConfig>
   <definition type="RDBMS">
      <configuration>
         <url>jdbc:h2mysql:repository//databaselocalhost:3306/WSO2DM_DB;DB_CLOSE_ON_EXIT=FALSE<DB</url>
         <username>wso2carbon</username>
         <password>wso2carbon</password>
         <driverClassName>org<driverClassName>com.mysql.h2jdbc.Driver</driverClassName>
         <maxActive>50</maxActive>
         <maxWait>60000</maxWait>
         <testOnBorrow>true</testOnBorrow>
         <validationQuery>SELECT 1</validationQuery>
         <validationInterval>30000</validationInterval>
      </configuration>
   </definition>
</datasource>

Expand

title	MobileIOSDM_DS datasource

This datasource is specifically used to manage mobile devices on the iOS platform.

Code Block

language	xml

<datasource>
   <name>MobileIOSDM_DS</name>
   <description>The datasource used for EMM Mobile Device Management</description>
   <jndiConfig>
      <name>jdbc/MobileIOSDM_DS</name>
   </jndiConfig>
   <definition type="RDBMS">
      <configuration>
         <url>jdbc:h2mysql:repository//databaselocalhost:3306/WSO2MobileIOS_DB;DB_CLOSE_ON_EXIT=FALSE<DB</url>
         <username>wso2carbon</username>
         <password>wso2carbon</password>
         <driverClassName>org<driverClassName>com.mysql.h2jdbc.Driver</driverClassName>
         <maxActive>50</maxActive>
         <maxWait>60000</maxWait>
         <testOnBorrow>true</testOnBorrow>
         <validationQuery>SELECT 1</validationQuery>
         <validationInterval>30000</validationInterval>
      </configuration>
   </definition>
</datasource>

Expand

title	MobileAndroidDM_DS datasource

This datasource is specifically used to manage mobile devices on the Android platform.

Code Block

language	xml

<datasource>
   <name>MobileAndroidDM_DS</name>
   <description>The datasource used for EMM Mobile Device Management</description>
   <jndiConfig>
      <name>jdbc/MobileAndroidDM_DS</name>
   </jndiConfig>
   <definition type="RDBMS">
      <configuration>
         <url>jdbc:h2mysql:repository//databaselocalhost:3306/WSO2MobileAndroid_DB;DB_CLOSE_ON_EXIT=FALSE<DB</url>
         <username>wso2carbon</username>
         <password>wso2carbon</password>
         <driverClassName>org<driverClassName>com.mysql.h2jdbc.Driver</driverClassName>
         <maxActive>50</maxActive>
         <maxWait>60000</maxWait>
         <testOnBorrow>true</testOnBorrow>
         <validationQuery>SELECT 1</validationQuery>
         <validationInterval>30000</validationInterval>
      </configuration>
   </definition>
</datasource>

Expand

title	MobileWindowsDM_DS datasource

This datasource is specifically used to manage mobile devices on the Windows platform.

Code Block

language	xml

<datasource>
   <name>MobileWindowsDM_DS</name>
   <description>The datasource used for EMM Mobile Device Management</description>
   <jndiConfig>
      <name>jdbc/MobileWindowsDM_DS</name>
   </jndiConfig>
   <definition type="RDBMS">
      <configuration>
         <url>jdbc:h2mysql:repository//databaselocalhost:3306/WSO2MobileWindows_DB;DB_CLOSE_ON_EXIT=FALSE<DB</url>
         <username>wso2carbon</username>
         <password>wso2carbon</password>
         <driverClassName>org<driverClassName>com.mysql.h2jdbc.Driver</driverClassName>
         <maxActive>50</maxActive>
         <maxWait>60000</maxWait>
         <testOnBorrow>true</testOnBorrow>
         <validationQuery>SELECT 1</validationQuery>
         <validationInterval>30000</validationInterval>
      </configuration>
   </definition>
</datasource>

...

Database	DB Script name and Location
`WSO2_CARBON_DB`	`<PRODUCT_HOME>/dbscripts/mysql.sql`	`WSO2_EMM_DB`	`<PRODUCT_HOME>/dbscripts/emm/mysql.sql`
`WSO2AM_DB`	`<PRODUCT_HOME>/dbscripts/apimgt/mysql.sql`

...

Versions Compared

Old Version 1

New Version 2

Key