If you have a small snippet of code doing the connection that has the issue that can be looked at it would help a lot debugging.
Something that comes to mind might be that it's trying to use a unix socket (as it's connecting to `localhost`), but that might depend on your configuration and the options passed to the connection.
Connectivity-wise, as you checked with the mysql cli there should be no difference :/
On 06/21 12:08, Travis Briggs wrote:
I also have just now tried the command line mysql client through the tunnel and things seem to work, so maybe it's some Python setting that's causing the connection to drop?
-Travis
On Fri, Jun 21, 2024 at 12:06 PM Travis Briggs audiodude@gmail.com wrote:
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....
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/
Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/