Airbyte server error due to expired certificate

Summary

The Airbyte server is showing a ‘Communications link failure’ error due to the ‘rds-ca-2019’ certificate expiration. Support for the certificate ended today, causing the issue. Need assistance in resolving this.


Question

Hey Team,
All of Sudden today , Our Airbyte server is giving the below Error:

State code: 08S01; Message: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.```
The Support from 'rds-ca-2019'  certificate ended Today, so we are seeing this error from today Morning 10AM.

```Certificate authority Info: rds-ca-rsa2048-g1
Certificate authority date: May 25, 2061, 04:29 (UTC+05:30)


Old CA info: On  August 22, 2024 - 'rds-ca-2019' will expire. You will need to take action before August 22, 2024```
Can Someone help us on this.

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1724389527828799) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["airbyte-server", "error", "certificate-expiration", "rds-ca-2019"]
</sub>

Hi Team, did you find any solution to this issue?

I do believe you need to recreate the certificate used by your AWS RDS instance.

Thank you <@U01MMSDJGC9>, looks like the issue is very specific to AWS RDS. That helps :octavia-thanks:

Hi <@U07HK8E5NQ1>

Even i got the same error today.

Were you able to find a solution or is it still the same?

Thanks

Following thread. Experiencing same issue.

The connection to RDS MySQL from Airbyte deployed on AWS EC2 used to work for the last 8 months, suddenly this issue has come up.

Not facing this issue with any other connections, only happens for all RDS MySQL connections.

The same DBs are connectable through Python Scripts on the same EC2 instance that the Airbyte is deployed on.

<Issues · airbytehq/airbyte · GitHub raised isssue>.

<@U01MMSDJGC9> Can you help here?

	at java.base/sun.security.x509.CertificateValidity.valid(CertificateValidity.java:182)
	at java.base/sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java:534)
	at java.base/sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java:507)
	at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:392)
	at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1430)
	at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java:1302)```
Sharing Traceback for reference