Hi, I’m having a problem connecting to an AWS Aurora MySQL instance with the beta Airbyte MySql connector. When I hit the “Set up source” button the progress bar runs for about a minute and then gives me the following message.

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.

There’s an airbyte worker message

airbyte-worker      | 2022-10-11 01:47:42 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):109 - HikariPool-1 - Start completed.

And 60 seconds later

airbyte-worker      | 2022-10-11 01:48:42 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):109 - HikariPool-1 - Shutdown initiated...

I’m using the latest server 0.40.14 and latest connector (airbyte/source-mysql:1.0.3). I’m connecting to MySql 5.6 in AWS Aurora. I tried the

enabledTLSProtocols=TLSv1.2

JDBC parameter even though I’m not seeing the poolable connection error. I’ve tested my credentials connecting directly to MySql both from inside my VPC and externally through a SSH tunnel and it works fine everywhere other than from an Airbyte Server. Any other ideas for me to try? Any other ways to troubleshoot? Thanks in advance for the help!

I would try getting the check config from the docker volume, and trying to manually run a check from the airbyte machine. Seems like a network issue from the docker container to reach the MySQL instance, you may need to check that, you can also try using a docker image with a MySQL client just to try connecting to the instance, to rule out if it is an airbyte problem

As I’ve dug into this it seems like there issue has something to do with security. It doesn’t look like the TLS thing but disabling SSL made it work. Obviously need to re-enable that so will post back when I make progress. Any hints would be welcome!