Versions Compared

Key

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

...

1. Edit $GREG_HOME/repository/conf/registry.xml and give the following:

...

Image Added

Code Block

        <datasource>
            <name>WSO2_CARBON_DB</name>
            <description>The datasource used for registry and user manager</description>
            <jndiConfig>
                <name>jdbc/WSO2CarbonDB</name>
            </jndiConfig>
            <dbConfig<definition nametype="mssql-db">RDBMS">
                <configuration>
                    <url>jdbc:jtds:sqlserver://10.100.3.251:1433/wso2greg</url>
           	<url>jdbc:jtds:sqlserver://SERVER_NAME:PORT/DB_NAME</url>
	         <userName>USER_NAME<<userName>regadmin</userName>
	                    <password>PASSWORD<<password>regadmin</password>
	
                    <driverName>net<driverClassName>net.sourceforge.jtds.jdbc.Driver</driverName>driverClassName>
                    <maxActive>80</maxActive>
                    <maxWait>60000</maxWait>
                    <minIdle>5</minIdle>
                    </dbConfig><testOnBorrow>true</testOnBorrow>
                    <validationQuery>SELECT 1</validationQuery>
                    <validationInterval>30000</validationInterval>
                </configuration>
            </definition>
        </datasource>

2. Edit $GREG_HOME/repository/conf/user-mgt.xml and give the following:

...

Info
titleTip

JDBC driver can be downloaded from http://sourceforge.net/projects/jtds/files/

...

Create Database Tables

Database tables can be created either manually by running scripts or automatically by using start-up parameters.

...