A multi instance deployment of WSO2 products would require the
registry (config and governance) space to be mounted on an external database. WSO2 Products can be mounted on many types of
databases. Below instructions explain how WSO2 products can be mounted on a MS
SQL database that is secured via Windows Authentication.
1.
download jTDS from the following link
2.
Extract the folder and copy the jtds-1.2.2.Jar file to the {WSO2
Product}/components/lib folder
3.
The extracted folder also includes ntlmauth.dll file in
the \x64\SSO folder copy the dll file to java bin folder(C:\Program
Files\Java\jre7\bin)
4.
download and install the jdbc driver for mssql from the following
location
5.
Once this is installed set the class path to the following location {JDBC
driver Installation Path}\sqljdbc_4.0\enu\auth\x86
6.
Make sure that the IP and the port is enabled at the MSSQL side, this can be
verified through telnet.
7.
Change the datasources.xml to the following configuration (Please change the DB
name and the hostname accordingly)
<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:jtds:sqlserver://localhost:1433/testDB;integratedSecurity=true;</url>
<driverClassName>net.sourceforge.jtds.jdbc.Driver</driverClassName>
<maxActive>80</maxActive>
<maxWait>60000</maxWait>
<minIdle>5</minIdle>
<testOnBorrow>true</testOnBorrow>
<validationQuery>SELECT
1</validationQuery>
<validationInterval>30000</validationInterval>
</configuration>
</definition>
</datasource>
8.
Start the ESB.
No comments:
Post a Comment