Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Install script fails when using Azure PostgreSQL Services

Description

The Azure PostgreSQL Service only accepts username in the form of "username@hostname", and Liquibase fails when creating the user for OpenNMS. For instance, if I use the following:

The IP 14.0.1.5 comes from an Azure Private Endpoint associated with the Azure PostgreSQL Service to avoid exposing the database to the Internet.

I get the following error when executing the install script:

If I change the user-name for OpenNMS:

I get:

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Benjamin Reed February 22, 2022 at 8:41 PM

FYI, I cherry-picked this back to foundation-2022 so it gets into the next Meridian (and Horizon 29)

Benjamin Reed November 15, 2021 at 7:30 PM

Should this be backported to 29?

Yang Li November 9, 2021 at 8:54 PM

Yang Li November 9, 2021 at 4:57 PM

I did run the MigratorIT with the OpenNMS data-source username with/without "@hostname" and both executed succeed. I will add new unit tests for the new method.

Yang Li November 8, 2021 at 9:43 PM

The data source config file should be something like this

 

 

 

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

PagerDuty

Created November 2, 2021 at 6:18 PM
Updated February 22, 2022 at 8:41 PM
Resolved November 12, 2021 at 2:44 PM