Skip to content
This repository has been archived by the owner on Jul 14, 2023. It is now read-only.

ssl config without certificate #41

Open
a-kuller opened this issue Aug 12, 2021 · 0 comments
Open

ssl config without certificate #41

a-kuller opened this issue Aug 12, 2021 · 0 comments

Comments

@a-kuller
Copy link

Hi all,

i think there is a problem with ssl connections that do not have a certificate. In cds-pg, ssl:true is sufficient to establish a connection. cds-dbm always throws:

error: no pg_hba.conf entry for host "xxx", user "xxx", database "xxx", SSL off
at Parser.parseErrorMessage (C:\Users\xxx\Desktop\git\sap.cap.demo\authentication\node_modules\pg-protocol\dist\parser.js:287:98)
at Parser.handlePacket (C:\Users\xxx\Desktop\git\sap.cap.demo\authentication\node_modules\pg-protocol\dist\parser.js:126:29)
at Parser.parse (C:\Users\xxx\Desktop\git\sap.cap.demo\authentication\node_modules\pg-protocol\dist\parser.js:39:38)
at Socket. (C:\Users\xxx\Desktop\git\sap.cap.demo\authentication\node_modules\pg-protocol\dist\index.js:11:42)
at Socket.emit (events.js:400:28)
at addChunk (internal/streams/readable.js:290:12)
at readableAddChunk (internal/streams/readable.js:265:9)
at Socket.Readable.push (internal/streams/readable.js:204:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23) {
length: 166,
severity: 'FATAL',
code: '28000',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'auth.c',
line: '496',
routine: 'ClientAuthentication'`

i try to add ssl:true in the PostgresAdapter.ts and url ssl=true. but its not working.

my default-env.json:

{
"VCAP_SERVICES": {
"postgres": [
{
"name": "postgres",
"label": "postgres",
"tags": [
"postgres"
],
"credentials": {
"host": "xxx",
"port": "5432",
"database": "xxx",
"user": "xxx",
"password": "xxx",
"ssl": true
}
}
]
}
}

certificate is not available.

thank you very much

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant