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

   systemctl start ubilogin-server

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 
   

   systemctl stop ubilogin-server
   systemctl start ubilogin-server