Question Re: AWS Postgres sql via cloud connector - unable to conn... in Technology Q&A

AWS Postgres sql via cloud connector - unable to connect using socket

sreehari_vpillai — Tue, 02 Apr 2024 07:51:05 GMT

Hi ,

I have a Postgres DB instance from AWS. The host is not exposed to public internet access, hence a cloud foundry instance does not have direct access . But my cloud foundry instance has access to it. I added a TCP connection - Connectivity check passes ( telnet successfully connects to 5432 port of this host , from OS level )

Now, following similar questions and git repo by piejanssens , I set up the codebase for it.
code and log is uploaded here

error thrown "

OUT Socket error: Error: getaddrinfo ENOTFOUND aws-rds-dev

" , though the authentication is successful .

@gregorw Have you tried this already ?

Re: AWS Postgres sql via cloud connector - unable to conn...

Ivan-Mirisola — Tue, 02 Apr 2024 13:58:57 GMT

Hi @sreehari_vpillai,

Please read the following note:

https://me.sap.com/notes/2822480/E

Read the preparation steps on the following blog as it should help with the troubleshooting:

https://community.sap.com/t5/technology-blogs-by-sap/how-to-connect-apache-kafka-via-sap-cloud-connector-with-sap-cloud-platform/ba-p/13462917

Best regards,
Ivan

Re: AWS Postgres sql via cloud connector - unable to conn...

sreehari_vpillai — Tue, 02 Apr 2024 14:02:02 GMT

thank you . Let me have a look and update here