Test connection failed due to timeout

💬 App Building
1

Hello - getting this issue on our AWS / RDS instance. We've implemented the allowlist, but still running into this. Any suggestions?

Test connection failed
Connection terminated due to connection timeout
View in console

This is the console output:

â–¶

Test connection failed (10.763s):Connection terminated due to connection timeout

1. {query: "Select 1 as result", error: Object}

  1. query: "Select 1 as result"

  2. error: Object

    1. message: "Connection terminated due to connection timeout"

Troubleshoot resource connections

3

Hi @Ramji_Srinivasan, welcome to the forum, and thanks for stopping by office hours! Based on this error, it seems Retool is not able to connect to the database at all. Is the RDS instance publicly accessible?

4

No, it’s not publicly accessible. But then, it might have customer data, so we don’t want to make public. Any workarounds?

5

Hi @Ramji_Srinivasan, if you need to keep the RDS private, I think you will need to setup a bastion host on the same VPC/subnet as your RDS instance, and then setup ssh tunneling to connect to your resource.

6

Just want to double check, are you on a public subnet or a private subnet?