Skip to main content

How to Create a Secondary JDBC user store for Identity Server


WSO2 Identity server comes with embedded LDAP as a primary user store. But its not recommended  to use in production environment. So; you have to use some other products for primary user store(OpenLDAP, AD, JDBC, etc..). You may required some other user store in practical scenarios. So; I'm going to talk about how to create a JDBC user store as a secondary user store with wso2 IS. I'm using wso2 Identity server latest version(current Identity server version is 5.1.0) for this example.


Step 1 :-

Log in to mysql using below command. Lets create a database first.

mysql -u root -proot

Create a database as below.

create database sampledb;

Use newly created database for other operations. use below command.

use sampledb;

Step 2 :-

Then create tables which are required for user store. You can use mysql.sql file which is located in <IS_HOME>/dbscripts/ directory to import tables to newly created database. please use this command


source /home/madura/Documents/wso2/wso2is-5.1.0/dbscripts/mysql.sql

you can see tables creation after execute above command.

You can select the sql script according to your DB.


Step 3 :-

Copy JDBC drive to <IS_HOME>/repository/components/lib directory and start the server

Step 4 :-

Click add user store button and you will get this page



Our primary goal is to create a JDBC user store. So we have to select JDBC user store from drop down menu.

Then you can see the required page and you have to enter below information to create a user store.

Domain Name*             :  SECONDARY
Description                    : description about the db. this is not required feild.

 Connection URL *        : jdbc:mysql://localhost:3306/sampledb
Connection Name *       : root          
Connection Password * : root    
Driver Name *               : com.mysql.jdbc.Driver


After provide above details, Click Test Connection button and see whether "Connection is healthy" message is displayed or not. If you get the message, Add connection using Add button.

After you add the connection, you can add users to the user store by selecting user store from the drop down menu as below



Labels:

Comments

Post a Comment

Popular posts from this blog

Reverse Proxy configuration with WSO2 Identity Server 5.0.0

Reverse proxy is a type of a proxy which can hide back end servers from the client applications. According to the above figure, Original servers are not exposed to the internet. Only reverse proxy is exposed to the internet.Client knows only the reverse proxy IP address. So he thinks that he is sending a request to the reverse proxy.He doesn't know anything about the original server. You can avoid some attacks using this architecture. Today I'm going to configure Apache HTTPD server(reverse proxy) and WSO2 identity server 5.0. Please download WSO2 identity server 5.0 from here You can install apache httpd server using below commands sudo apt - get update sudo apt - get install apache2 Restart the newly install apache server sudo service apache2 restart Apache is a modular server. This implies that only the most basic functionality is included in the core server.So You have to enable few other required features. Please use below command ...
Post a Comment
Read more

Essential Debug Logs for WSO2 Identity Server

Essential Debug loggers for WSO2 Identity Server  When you are working with WSO2 products, you have to enable debug logs to investigate issues. Its better to enable debug logs only for particular module that you need to investigate. It reduce debug writing time and unnecessary debug reading time.So you can easily understand the root cause when you are reading the console.I'm going to discuss about debug lines one by one. You have to add debug line to [WSO2_HOME]\repository\conf\log4j.properties file, all debug lines are displayed in the console and write to the wso2carbon.log file. To enable loggers for user core.This is helpful to investigate user related issues. log4j.logger.org.wso2.carbon.user.core=DEBUG      To enable debug logs for identity module. This debug log will be helpful to investigate identity related issues. log4j.logger.org.wso2.carbon.identity=DEBUG If you need to investigate saml assertion or assertion related issue, you ca...
Post a Comment
Read more

Test SOAP Client and REST Service in WSO2 ESB

Wso2 ESB can convert anything to anything. Today I'm going to explain the below scenario. Scenario :-  1. Soap client send a request to ESB with soap header. 2. ESB remove soap header and invoke the REST service which only accept XML format. 3. REST service generate a response in xml format 4. ESB adding soap headers to response and send back to SOAP client. As an example REST service, I'm going to use  jaxrs_basic  service in WSO2 Application server. Download wso2 application server from this link Step 1 :-            Change the offset value in carbon.xml file which is located in <AS_HOME>/repository/conf directory.                 If you started WSO2 ESB in offset "0" set offset in application server as "1"   <Offset>1</Offset>                Start wso2 application server Step 2 :-        ...
Post a Comment
Read more