11/13/2023 0 Comments Tableplus aws rds![]() ![]() This token is generated using the aws cli: aws rds generate-db-auth-token -hostname XXX -port 5432 -region us-east-1 -username XXX. We are using RDS IAM auth - This means users use a short-lived token to log, instead of a password.This issue is already mentioned in #2241 and #2003 It seems that it's not using my ssh config However, tableplus does not accept lenus-prod-eu as a host. Prox圜ommand sh -c "aws ssm start-session -target XXX -document-name AWS-StartSSHSession -parameters 'portNumber=%p'" Notice that we are using Prox圜ommand to call the AWS cli to start the session In practice we have the following in our. Basically, what that means is that you use the AWS CLI to open the SSH session, and access are then handled via IAM, instead of via ssh keys. However, instead of a regular ssh bastion host, we use what AWS calls a managed instance. Our database is in a private VPC - therefore we need to open an ssh tunnel to connect to it.We have two problems that we need to solve - Connecting to a database via an ssh tunnel, and getting a temporary password each time a user needs to log in: ![]() ![]() Let me know if I should post it somewhere else. So this is is not an issue per se, but more a question about how to work best with tableplus in the context of AWS RDS. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Which driver are you using and version of it (Ex: PostgreSQL 10.0): ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |