I'm trying to connect hyperledger-explorer to IBM Cloud Databases for Postgres instance. I provide the correct credentials to connect to DB. However, the app gives authentication errors.
[2021-08-19T10:38:01.088] [ERROR] PgService - error when connecting to db: error: no pg_hba.conf entry for host "172.30.229.241", user "ibm_cloud_a55353b8_7766_4dbb_9c6b_89ee7b666773", database "ibmclouddb", SSL off
at Connection.parseE (/opt/explorer/node_modules/pg/lib/connection.js:614:13)
at Connection.parseMessage (/opt/explorer/node_modules/pg/lib/connection.js:413:19)
at Socket.<anonymous> (/opt/explorer/node_modules/pg/lib/connection.js:129:22)
at Socket.emit (events.js:315:20)
at addChunk (_stream_readable.js:297:12)
at readableAddChunk (_stream_readable.js:273:9)
at Socket.Readable.push (_stream_readable.js:214:10)
at TCP.onStreamRead (internal/stream_base_commons.js:186:23) {
From inside the explorer pod, I installed psql -for investigation- and tried to connect to my instance using
PGPASSWORD=xxx psql 'host=xxx po
rt=xxx dbname=ibmclouddb user=ibm_cloud_user'
and it works, I was able to connect to the DB.
I'm sure the application uses incorrect connection strings to DB. But, I can't see what it sends to verify
any idea how can I resolve this?