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 HomeServicesNew 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: 
      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