Questions tagged [amazon-rds-proxy]

89 questions
1
vote
0 answers

How to check if a connection is still established to the database using TypeORM?

I'm using typeorm "typeorm": "0.3.9" in a serverless architecture using AWS lambdas + RDS Proxy. Following some suggestions I found on the internet, I chose to keep a connection open after the lambdas are executed so that it can be reused by the…
1
vote
1 answer

Downsides to opening and closing a connection to RDS Proxy with every DB query made with Knex.js?

The Postgres query builder my Lambda functions use, Knex, uses prepared statements so I'm unable to fully take advantage of RDS Proxy since the sessions are pinned. I try to ensure that the lambdas run for as little time as possible so that the…
1
vote
1 answer

RDS Proxy successfully connected after that disconnecting by showing "RDS Proxy supports only IAM or MD5 authentication"

I have followed these steps to connect RDS Proxy to connect RDS from lambda https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/ Whenever I'm running in lambda, it's connecting but later whenever we execute query it will…
1
vote
1 answer

RDS Proxy IAM role unable to retrieve credentials from secret

I am trying to implement a proxy to our Aurora RDS instance, but having difficulty getting the IAM access to work properly. We have a microservice in an ECS container that is attempting to access the database. The steps I've followed so…
1
vote
1 answer

Need some help connecting Flask-SQLAlchemy to RDS Proxy

So I've been running into an error getting a connection from my Flask-SQLAlchemy Module to connect to my RDS proxy. Both the EC2 instance running the python and the DB are setup on the same VPC and I can visualize the DB running a psql command (I'm…
1
vote
1 answer

RDS Proxy rotating passwords

We are using the alternating users rotation strategy to make sure our RDS passwords are rotated regularly. Our warm (and provisioned) lambdas hang on to the current userid/password for a short period (approx. 1 hour) to reduce the number of times we…
Craig Edwards
  • 2,118
  • 1
  • 18
  • 23
1
vote
2 answers

RDS Proxy currently doesn’t support the option ssl_renegotiation_limit

I'm trying to connect to RDS PostgreSQL Proxy with enabled "Require Transport Layer Security" from .NET Core 3.1 Web API, using Npgsql 3.1.2 When I set SSLMode=Require in ConnectionString, I receive "RDS Proxy currently doesn’t support the option…
1
vote
0 answers

How do I use Terraform to add an existing RDS proxy to my AWS Lambda Function?

In the AWS Lambda service's console, there is a Configuration tab called Database proxies, shown here: However, in the Terraform registry's entry for an AWS Lambda Function, there does not seem to be a place to define this relationship for my…
1
vote
0 answers

RDS Proxy DatabaseConnectionRequests

I am having a higher number of DatabaseConnectionRequests on the RDS proxy. I am not sure how should I interpret it? I tried the AWS documentation but it did not…
1
vote
2 answers

Can't connect to RDS proxy via EC2 instance

Currently been trying to connect to RDS proxy via a centos EC2 instance, however I keep getting this error: psql: FATAL: This RDS proxy has no credentials for the role centos. Check the credentials for this role and try again. I am assuming that…
1
vote
1 answer

Using MariaDB JDBC client to perform IAM authentification with AWS RDS Proxy

I have a very hard time configuring RDS Proxy w/ IAM authentification. On the RDS Proxy: TLS is enable IAM authentification is enable as well A secret containing native MySQL credentials is created and use by the RDS Proxy, on the monitoring I saw…
maathor
  • 121
  • 1
  • 3
  • 12
1
vote
1 answer

iterate over data source for a list of secrets arn

I have a few secerts in aws that were created manually. Is there a way to list them with data "aws_secretsmanager_secret"? My goal is to get an list/index of the ARNs and then use it in a daymnic block. I want to try and avoid writing multiple data…
1
vote
2 answers

AWS RDS Proxy error (postgres) - RDS Proxy currently doesn’t support command-line options

I try to read or write from/to an AWS RDS Proxy with a postgres RDS as the endpoint. The operation works with psql but fails on the same client with pg8000 or psycopg2 as client libraries in Python. The operation works with with pg8000 and psycopg2…
1
vote
1 answer

Is JDBC the only option to connect to aws hosted rds from aws lambda function

Like the title asks, im wondering if the only way of connecting to my aws hosted rds through aws lambda function in java is through a jdbc connection? Does the aws sdk provide a way of doing this, querying the data and returning results without the…
1
vote
2 answers

AWS RDS reducing connection time from Lambda

I’m calling my AWS Rds database from within an AWS lands function. I’m successfully able to call the database just fine, but I’m trying to reduce the execution time. I’m finding that 95% of the time is spent creating the connection to the AWS RDS…
Football52
  • 123
  • 3
  • 14