AWS RDS with SSL does not connect to Mastra/Nextjs
Hey team,
I’m deploying my app to AWS using RDS with SSL (per my customer’s requirements). The app runs in ECS and connects to the RDS instance over an internal network. I’ve tried multiple approaches to get the SSL connection working, but it consistently fails on AWS—even though the same setup works both locally and when deployed to GCP Cloud SQL with SSL. This makes me suspect there may be a bug involved.
My connection string from my docker compose file is:
Dependencies version:
Here are the two errors I get:
Error 1:
I get this error with out changing anything that is describe above and in the code file attached:
Error 2:
This one appear after appending to the connection string sslmode=require to be
I am not sure what to do from here, it looks like it related to Unable to use Postgres config.ssl with connectionString, which says the fix got merged but it look like I still have this error. And this is also the same error: https://www.answeroverflow.com/m/1433253107743195136.
I have also drop a file of how my memory and postgres is setup in this post.
Any help would be most appreciated!
I’m deploying my app to AWS using RDS with SSL (per my customer’s requirements). The app runs in ECS and connects to the RDS instance over an internal network. I’ve tried multiple approaches to get the SSL connection working, but it consistently fails on AWS—even though the same setup works both locally and when deployed to GCP Cloud SQL with SSL. This makes me suspect there may be a bug involved.
My connection string from my docker compose file is:
DB_URL=postgres://postgres:postgres@database:5432/postgresDependencies version:
Here are the two errors I get:
Error 1:
I get this error with out changing anything that is describe above and in the code file attached:
Error 2:
This one appear after appending to the connection string sslmode=require to be
DB_URL=postgres://postgres:postgres@database:5432/postgres?sslmode=requireI am not sure what to do from here, it looks like it related to Unable to use Postgres config.ssl with connectionString, which says the fix got merged but it look like I still have this error. And this is also the same error: https://www.answeroverflow.com/m/1433253107743195136.
I have also drop a file of how my memory and postgres is setup in this post.
Any help would be most appreciated!
pgSteup.ts1.41KB
```
Error: self-signed certificate in certificate chain
at P.init (.next/server/chunks/6690.js:362:1871) {
id: 'MASTRA_STORAGE_POSTGRES_STORE_INIT_FAILED',
domain: 'STORAGE',
category: 'THIRD_PARTY',
details: {},
[cause]: Error: self-signed certificate in certificate chain
at J.createTable (.next/server/chunks/6690.js:267:161...
Error: self-signed certificate in certificate chain
at P.init (.next/server/chunks/6690.js:362:1871) {
id: 'MASTRA_STORAGE_POSTGRES_STORE_INIT_FAILED',
domain: 'STORAGE',
category: 'THIRD_PARTY',
details: {},
[cause]: Error: self-signed certificate in certificate chain
at J.createTable (.next/server/chunks/6690.js:267:161...
