Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

Parasoft DTP fails to connect to Postgres by hem chart

guyam
guyam Posts: 5 ✭
in DTP

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

  • Vinay
    Vinay Posts: 11 ✭
    Answer ✓

    In your value.yaml, instead of:

    username: "psqladmin"
    password: XXXXXXXXXX # User psqladmin password

    Set 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.

  • guyam
    guyam Posts: 5 ✭
    Answer ✓

    Thanks
    user: "psqladmin" solved the issue

Categories