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 <audiod...@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 <dz...@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 <audiod...@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 <dz...@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/
