JDBC driver installation

Depending on the used database a specific JDBC driver needs to be installed.

For example, MS SQL JDBC driver is available in

http://www.microsoft.com/en-us/download/details.aspx?id=11774

Note: Kindly use MS SQL JDBC driver version 9.4 or earlier with SSO 9.x . Ref: https://ubisecuredev.atlassian.net/wiki/x/CYDfMAI

On linux the driver should be placed in

/usr/local/ubisecure/ubilogin-sso/tomcat/lib

Or on Windows

%PROGRAMFILES%\Ubisecure\ubilogin-sso\tomcat\lib

SQL Service creation in SSO Management

New service needs to be added to Ubisecure SSO. Open Ubisecure Management with administrative privileges and navigate to Home → Services. Create new service as instructed below:

Configuration key	Description
`policy.password.encoding`	The encoding of passwords in the associated directory.
`password-name`	The password authentication method that is used with this directory. This also defines the password method for step-up methods used with this directory.
`url`	The JDBC URL that is used to connect to the database.
`username`	The username that is used to connect to the database.
`password`	The password that is used to connect to the database. This is not visible in the UI after setting it.

Example configuration with an external MS SQL database:

Browser not supported