Parasoft DTP fails to connect to Postgres by hem chart
Hey,
In values.yaml
db:
# Type must be one of: "mysql" | "oracle" | "postgresql"
type: "postgresql"
# Correct JDBC URL for PostgreSQL
url: "jdbc:postgresql://parasoft-devex-postgres.postgres.database.azure.com:5432/DTP?sslmode=require"
# Download URL for the JDBC driver
jdbcDriverUrl: "https://artifactory.ultracruise.gm.com/artifactory/ultracruise-3rd-party-dev-local/postgres/42.7.5/postgresql-42.7.5.jar"
username: "psqladmin"
password: XXXXXXXXXX # User psqladmin password
port: 5432
The error is
FATAL: no PostgreSQL user name specified in startup packet
Command execution failed. Please review the rs.log file for more information.
Using "psql" succeeded:
psql "postgresql://psqladmin:XXXXXXXXX@parasoft-devex-postgres.postgres.database.azure.com/DTP?sslmode=require"
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
DTP=>
Any idea what am I missing?
Best Answers
-
In your value.yaml, instead of:
username: "psqladmin"
password: XXXXXXXXXX # User psqladmin passwordSet using:
user: "psqladmin"For password - don't use clear text string. You need to use "passwordSecret" and "passwordSecretKey".
See, reference documentations under DTP configuration https://hub.docker.com/r/parasoft/dtp-helm. This provides example of using MySQL, but for the user + password it would similar to whatever DB you used.
1 -
Thanks
user: "psqladmin" solved the issue0