When I try tunnelling through bastion.wmcloud.org or primary.bastion.wmcloud.org I just get:

pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 61] Connection refused)")

I can resolve and connect to the trove instance from toolforge, and as I mentioned in my original email, I tried connecting through mwcurator.mwoffliner.eqiad1.wikimedia.cloud which is our VPS box.

Thanks,
-Travis

On Fri, Jun 21, 2024 at 10:21 AM Daniel Zahn <dzahn@wikimedia.org> wrote:
I noticed you say it's a VPS as in Cloud VPS project but you attempt to tunnel via login.toolforge.org.

Maybe try tunneling via bastion.wmcloud.org or primary.bastion.wmcloud.org

as the bastion hosts for the cloud VPS projects.

https://wikitech.wikimedia.org/w/index.php?go=Go&search=bastion.wmcloud.org&title=Special:Search

On Fri, Jun 21, 2024 at 9:36 AM Travis Briggs <audiodude@gmail.com> wrote:
Hello,

I'm trying to tunnel to my VPS Trove instance, so that I can test some code against the production database.

I'm using the following:

ssh -N -L 4177:tdlqt33y3nt.svc.trove.eqiad1.wikimedia.cloud:3306 login.toolforge.org

I've also tried:

ssh -N -L 4177:tdlqt33y3nt.svc.trove.eqiad1.wikimedia.cloud:3306 mwcurator.mwoffliner.eqiad1.wikimedia.cloud

The initial connection seems to work, but in my application I'm getting dropped connections. I see the following in the terminal where I set up the tunnel:

channel 2: open failed: connect failed: Connection refused
channel 2: open failed: connect failed: Connection refused

I imagine this isn't a fully supported workflow but I'm wondering if there's some way to get it to work?

Thanks,
-Travis
_______________________________________________
Cloud mailing list -- cloud@lists.wikimedia.org
List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/


--
Daniel Zahn <dzahn@wikimedia.org>
Site Reliability Engineer
_______________________________________________
Cloud mailing list -- cloud@lists.wikimedia.org
List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/