9.4 Configuring Self Service Password Reset to Work with the External Database

After you have created the external database, you must configure Self Service Password Reset to communicate with the database. Self Service Password Reset uses the JDBC driver for the specific database. Download the JDBC driver from the vendor’s website to connect to the JDBC database.

To configure an external database to store the challenge-response information:

  1. Ensure that you have downloaded the JDBC driver from the vendor’s website.

  2. Log in to Self Service Password Reset at https://dns-name/sspr as an administrator.

  3. In the toolbar, click your name.

  4. Click Configuration Editor.

  5. Click Default Settings.

    1. Select the LDAP directory type you are using.

    2. Select where to store information as Remote Database

    3. In the toolbar, click Save changes.

  6. (Conditional) If you are using anything other than Active Directory to store challenge-response information in an external database, click Modules > Authenticated > Forgotten Password > Settings.

    1. Set Response Read Location to Database.

    2. Set Response Write Location to Database.

    3. Click Save.

  7. Click Settings > Database (Remote) > Connection.

  8. Use the following information to configure the database connection:

    Database Driver

    Upload the JDBC database driver you downloaded from the vendor’s website.

    Database Class

    Specify the Java class name of the JDBC driver. For example:

    • Microsoft SQL: com.microsoft.sqlserver.jdbc.SQLServerDriver

    • Microsoft SQL using jTDS: net.sourceforge.jtds.jdbc.Driver

    • Oracle: oracle.jdbc.OracleDriver

    • PostgreSQL: org.postgresql.Driver

    Database Connection String

    Specify the database connections string that configures the Java JDBC database driver with the information required to reach your database server such as IP address, port number, and database name. For example:

    • Microsoft SQL: jdbc:sqlserver://host.example.net:port;databaseName=SSPR

    • Microsoft SQL using jTDS: jdbc:jtds:sqlserver://host.example.net:port/SSPR

    • Oracle: jdbc:oracle:thin:@//host.example.net:1521/SSPR

    • PostgreSQL: jdbc:postgresql://host:port/database

    Database User Name

    Specify the name of the user who can connect to the database.

    Database Password

    Specify a password for the database user.

    Database Vendor

    Select the vendor for your database. The options are Other or Oracle.

  9. Click Test Database Connection to validate the information you entered.

  10. In the toolbar, click Save changes.