How to debug an error to understand why the url for the database is incorrect?

Question

JavaScript

Good afternoon!

I'm trying to connect to an App Engine database and compose a URL. This error comes out:

throw new Error('SASL: SCRAM-SERVER-FIRST-MESSAGE: 
client password must be a string')

Where she appears:

const pool = slonik_1.createPool(
`socket:userName:[email protected]/cloudsql/teest-123986:europe-west3:test?db=dbName`
)

I tried to parse the same line like this:

var parse = require('pg-connection-string').parse;
var config = parse(
`socket:userName:[email protected]/cloudsql/teest-123986:europe-west3:test?db=dbName`
)
console.log('config', config)

The result is ok, read as a string:

config [Object: null prototype] {
  db: 'dbName',
  user: 'userName',
  password: 'password',
  port: null,
  host: '/cloudsql/teest-123986:europe-west3:test',
  database: 'dbName',
  client_encoding: undefined
}

Question: how else can you try to get close to the error?

Answer 1

In the end this worked:

socket://${process.env.SQL_USER}:${process.env.SQL_PASSWORD}@${process.env.IP_DB_PRIVATE}?db=${process.env.DB}