Set up an external database on Red Hat Single Sign-On for Openshift

Solution Verified - Updated -

Environment

  • Red Hat Single Sign-On (RH-SSO)
    • 7.2 or later
  • Red Hat Openshift Container Platform (OCP)
    • 3 or later
  • External Database instance

Issue

  • Deploying while using an external database instance
  • Example usage
  • Externalize DB in image

Resolution

In Red Hat Single Sign-On 7.3, the issues discussed below have been corrected and the documentation has been updated with instructions. See RH-SSO 7.3: Connecting to an external database or RH-SSO 7.4: Connecting to an external database.

The documentation has a broken link. It should point to Assigning an IP Address to the Service

If you are using, Red Hat Single Sign-On 7.2, the following provides some workarounds that may assist you:

Disclaimer: Links contained herein to an external website(s) are provided for convenience only. Red Hat has not reviewed the links and is not responsible for the content or its availability. The inclusion of any link to an external website does not imply endorsement by Red Hat of the website or their entities, products or services. You agree that Red Hat is not responsible or liable for any loss or expenses that may result due to your use of (or reliance on) the external site or content.

Examples using PostgreSQL:

These should work for any database, though the variables can be changed.

Root Cause

There was an issue where DB_URL, when assigned, would be truncated if it had & characters or it was not used properly. This has been corrected. More information can be found in this jira: RHSSO-1733.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.