This documentation is for WSO2 Enterprise Mobility Manager 2.2.0. View documentation for the latest release.
Page Comparison - Setting up PostgreSQL (v.11 vs v.12) - Enterprise Mobility Manager 2.2.0 - WSO2 Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
  • master-datasources.xml

    Panel

    Edit the WSO2_CARBON_DBandWSO2AM_DB datasources in the master-datasources.xml file by replacing the url, username, password and driverClassName settings with your custom values.

    Expand
    titleWSO2_Carbon_DB datasource
    Code Block
    languagexml
    <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:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleWSO2AM_DB datasource
    Code Block
    languagexml
    <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:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleWSO2_Social_DB
    Code Block
    <?xml version="1.0" encoding="UTF-8"?>
    <datasource>
       <name>WSO2_SOCIAL_DB</name>
       <description>The datasource used for Store social database. You are able to like/dislike/comment and rate apps in the store. All the required 	details are stored in this database</description>
       <jndiConfig>
          <name>jdbc/WSO2_SOCIAL_DB</name>
       </jndiConfig>
       <definition type="RDBMS">
    	<configuration>
             <url>jdbc:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleJAGH2
    Code Block
    <datasource>
       <name>JAGH2</name>
       <description>The datasource used for by the Jaggery Storage Manager</description>
       <jndiConfig>
          <name>jdbc/ES_Storage</name>
       </jndiConfig>
       <definition type="RDBMS">
          <configuration>
             <url>jdbc:h2:repository/database/ES_STORAGE;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=60000</url>
             <username>wso2carbon</username>
             <password>wso2carbon</password>
             <driverClassName>org.h2.Driver</driverClassName>
             <maxActive>50</maxActive>
             <maxWait>60000</maxWait>
          </configuration>
       </definition>
    </datasource>
  • emm-datasources.xml

    Panel

    Edit the DM_DS, MobileIOSDM_DS, MobileAndroidDM_DS and MobileWindowsDM_DS datasources in the emm-datasources.xml file by replacing the url, username, password and driverClassName settings with your custom values.

    Expand
    titleDM_DS datasource
    Code Block
    languagexml
     <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:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleMobileIOSDM_DS datasource

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

    Code Block
    languagexml
    <datasource>
       <name>MobileIOSDM_DS</name>
       <description>The datasource used for EMM Mobile iOS Device Management</description>
       <jndiConfig>
          <name>jdbc/MobileIOSDM_DS</name>
       </jndiConfig>
       <definition type="RDBMS">
          <configuration>
             <url>jdbc:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleMobileAndroidDM_DS datasource

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

    Code Block
    languagexml
    <datasource>
       <name>MobileAndroidDM_DS</name>
       <description>The datasource used for EMM Mobile Android Device Management</description>
       <jndiConfig>
          <name>jdbc/MobileAndroidDM_DS</name>
       </jndiConfig>
       <definition type="RDBMS">
          <configuration>
             <url>jdbc:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleMobileWindowsDM_DS datasource

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

    Code Block
    languagexml
    <datasource>
       <name>MobileWindowsDM_DS</name>
       <description>The datasource used for EMM Mobile Windows Device Management</description>
       <jndiConfig>
          <name>jdbc/MobileWindowsDM_DS</name>
       </jndiConfig>
       <definition type="RDBMS">
          <configuration>
             <url>jdbc:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource> 
  • analytics-datasoruces.xml

    Panel

    Point to WSO2_ANALYTICS_EVENT_STORE_DB and WSO2_ANALYTICS_PROCESSED_DATA_STORE_DB in the <EMM_HOME>/repository/conf/datasources/analytics-datasources.xml file as shown below.

    Expand
    titleWSO2_Analytics_Processed_Data_Store_DB
    Code Block
    <datasource>
       <name>WSO2_ANALYTICS_EVENT_STORE_DB</name>
       <description>The datasource used for analytics record store</description>
       <definition type="RDBMS">
          <configuration>
             <url>jdbc:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>
    Expand
    titleWSO2_Analytics_Processed_Data_Store_DB
    Code Block
    <?xml version="1.0" encoding="UTF-8"?>
    <datasource>
       <name>WSO2_ANALYTICS_PROCESSED_DATA_STORE_DB</name>
       <description>The datasource used for analytics record store</description>
       <definition type="RDBMS">
          <configuration>
             <url>jdbc:postgresql://localhost:5432/gregdb</url>
             <username>regadmin</username>
             <password>regadmin</password>
             <driverClassName>org.postgresql.Driver</driverClassName>
             <maxActive>80</maxActive>
             <maxWait>60000</maxWait>
             <minIdle>5</minIdle>
             <testOnBorrow>true</testOnBorrow>
             <defaultAutoCommit>true</defaultAutoCommit>
             <validationQuery>SELECT 1</validationQuery>
             <validationInterval>30000</validationInterval>
          </configuration>
       </definition>
    </datasource>

...