Hello! New to meltano and very excited to get setup! I'm running into a roadblock with configuring my tap-mysql extractor. Basically this database resides on a private subnet on AWS (The mysql instance is using Aurora). I've been trying (and failing) to figure out how to properly set up this extractor to pass through an SSH tunnel. Any guidance would be super helpful!

Hi, @deactivateduser278489 - do you have any ability to launch an instance inside the private subnet? If not, you may need to add a "bastion host" which can echo commands from a public subnet into the private one. If you have IT support, you may be able to ask them if one already exists, or if they can create one.

@aaronsteers Thanks for the reply! I can launch a bastion host to forward the communication. What I'm not sure about is how to configure the ssh credentials in the current tap-mysql extractor. Where do I include the ssh username, password, ip address, and related pem key?

Gotcha. Thanks for the clarification. I've been through this once before but I don't recall exactly how we got through it. I think for some of those things we were able to create an os-level or container-level setup of the ssh config to the bastion. Someone else might have more info. In the worst case, I think this would require forking the repo, but I seem to remember there was another way...