Follow the below instructions to set up a MySQL database.
...
Table of Contents | ||||
---|---|---|---|---|
|
...
|
...
Setup Database and the Database User
1. Download and install MySQL on your computer. Use the following command:
Code Block |
---|
sudo apt-get install mysql-server mysql-client
|
...
2. Start the MySQL service using the following command:
Code Block |
---|
sudo /etc/init.d/mysql start
|
...
Code Block |
---|
create database regdb; |
6. Give authorization of the registry database to the user "regadmin."
Code Block |
---|
GRANT ALL ON regdb.* TO regadmin@localhost IDENTIFIED BY "regadmin" |
7. Log out from the MySQL prompt by typing the "quit" command.
...
Setup Configuration Files
1. Edit the registrydefault database configuration defined in the master-datasources.xml
file file located in the at $GREG_HOME/repository/conf
directory /datasources
directory of the deployed registry instance as shown below. Both the database configurations in registry.xml
and user-mgt.xml
refer this data source.
Info | ||
---|---|---|
| ||
Replace these settings with your own custom values: |
...
Code Block |
---|
<currentDBConfig>mysql-db</currentDBConfig> <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="mysql-dbRDBMS"> <configuration> <url>jdbc:mysql://localhost:3306/regdb</url> <userName>regadmin</userName> <username>regadmin</username> <password>regadmin</password> <driverName>com <driverClassName>com.mysql.jdbc.Driver</driverName>driverClassName> <maxActive>80</maxActive> <maxWait>60000</maxWait> <minIdle>5</minIdle> <testOnBorrow>true</testOnBorrow> </dbConfig> |
...
<validationQuery>SELECT 1</validationQuery>
<validationInterval>30000</validationInterval>
</configuration>
</definition>
</datasource> |
The database configuration options
- url - The URL of the database.
- userName
username - The name of the database user.
- password - The password of the database user.
- driverName driverClassName - The class name of the database driver.
- maxActive - The maximum number of active connections that can be allocated from this pool at the same time or negative for no limit.
- maxWait - The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception or <= 0 to wait indefinitely.
- minIdle - The minimum number of active connections that can remain idle in the pool without extra ones being created or 0 to create none.
2. Edit the user-mgt.xml
file located in the $GREG_HOME/repository/conf
directory of the deployed instance as below.
Info | ||
---|---|---|
| ||
Replace these settings with your own custom values. |
...
- .
...
...
Setup Drivers
Download the MySQL Java connector JAR from http://dev.mysql.com/downloads/connector/j/5.1.html and place it in the $GREG_HOME/repository/components/lib
directory.
...
Code Block |
---|
wso2server.sh -Dsetup |
- For Windows:
Code Block |
---|
wso2server.bat -Dsetup |
2. The WSO2 Governance Registry is configured to run with MySQL database.
Manual Database Creation
...
- For Linux:
Code Block |
---|
wso2server.sh |
- For Windows:
Code Block |
---|
wso2server.bat
|
Excerpt | ||
---|---|---|
| ||
Instructions on how to set up Governance Registry with MySQL database. |