clone script fails if postgres DB_BASE_URL includes a :port

[wezell]

Problem Statement

When trying to clone an environment like this, where we pass the port # in the DB_BASE_URL, e.g.

docker run --rm \
-p 8443:8443 \
-e DOT_IMPORT_ENVIRONMENT=https://demo.dotcms.com \
-e DOT_IMPORT_USERNAME_PASSWORD=admin@dotcms.com:admin \
-e DB_BASE_URL=jdbc:postgresql://localhost:5432/dotcms \
-e DB_PASSWORD=password \
-e DB_USERNAME=dotcmsdbuser \
dotcms/dotcms-dev:latest

We get errors like this:

- DB and Assets backups exist, skipping
- Delete /data/shared/import/https_auth_dotcms_dev_assets.zip and /data/shared/import/https_auth_dotcms_dev_dotcms_db.sql.gz to force a re-download
psql: error: could not translate host name "postgres-rw.postgres.svc.cluster.local:5432" to address: Name or service not known
Unable to import postgres backup

Steps to Reproduce

docker run --rm \
-p 8443:8443 \
-e DOT_IMPORT_ENVIRONMENT=https://demo.dotcms.com \
-e DOT_IMPORT_USERNAME_PASSWORD=admin@dotcms.com:admin \
-e DB_BASE_URL=jdbc:postgresql://localhost:5432/dotcms \
-e DB_PASSWORD=password \
-e DB_USERNAME=dotcmsdbuser \
dotcms/dotcms-dev:latest

Acceptance Criteria

This should work:

docker run --rm \
-p 8443:8443 \
-e DOT_IMPORT_ENVIRONMENT=https://demo.dotcms.com \
-e DOT_IMPORT_USERNAME_PASSWORD=admin@dotcms.com:admin \
-e DB_BASE_URL=jdbc:postgresql://localhost:5432/dotcms \
-e DB_PASSWORD=password \
-e DB_USERNAME=dotcmsdbuser \
dotcms/dotcms-dev:latest

dotCMS Version

26.04

Severity

Medium - Some functionality impacted

Links

PR #34443

[github-actions]

PRs linked to this issue

• Fix(clone): allow port in DB_BASE_URL url by @wezell