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 <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/ -- David Caro SRE - Cloud Services Wikimedia Foundation <https://wikimediafoundation.org/> PGP Signature: 7180 83A2 AC8B 314F B4CE 1171 4071 C7E1 D262 69C3 "Imagine a world in which every single human being can freely share in the sum of all knowledge. That's our commitment."
signature.asc
Description: PGP signature
_______________________________________________ Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
