SQL directory service creation on Linux - CustomerID

You need to define a directory service in Ubisecure SSO Management that is used for accessing the Ubisecure CustomerID's SQL database. To create the service open Ubisecure SSO Management.

1. Start Ubisecure SSO

   /etc/init.d/ubilogin-server start

2. Access the URL UAS_URL/ubilogin in a browser
3. Create a new Service in Services tab (Select Home → Services → New Service...)
   
   • Title:  CustomerID SQL

   • Directory type:  SQL
     

     
     

4. Click OK
5. Edit following information:
   
   • Service URL:
     jdbc:postgresql://host:port/customeriddb – replacing hostname and port number as needed using database.host and database.port settings from /usr/local/ubisecure/customerid/application/linux.config
   • Username:
     Use database.user value from /usr/local/ubisecure/customerid/application/linux.config. This value is usually customerid_user

   • Credentials:
     Use database.password value from /usr/local/ubisecure/customerid/application/linux.config

     NOTE: If there are escape characters ("\") in the database.password value, remove them before copying the value to the Credentials field.

   • Configuration: 
     Enter the following text in the Configuration String text area: 
     validationQuery= SELECT 1

     This defines the PostgreSQL specific query called when determining if a JDBC connection is open and operating.
     

     Figure 2, SQL Configuration

6. Click Update

7. Restart Ubisecure SSO 
   

   /etc/init.d/ubilogin-server stop
   /etc/init.d/ubilogin-server start