Page Comparison

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

   Code Block
   language text
   net start UbiloginServer

   
   

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
   • Directory Factory: com.ubisecure.ubilogin.directory.spi.sql.SQLDirectoryFactory


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 customerid\application\win32.config

   • Username:
     Use database.user value from customerid\application\win32.config. This value is usually customerid_user

   • Credentials:
     Use database.password value from customerid\application\win32.config

     Note
     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 
   

   Code Block
   language text
   net stop UbiloginServer net start UbiloginServer