...
1. Edit $GREG_HOME/repository/conf/registry.xml
and give the following:
...
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 | ||
---|---|---|
| ||
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.
...