This could be the same issue as T367464 [0], due to Trove databases having a default wait_timeout=120, which means that idle connections get terminated after 2 minutes. Interactive connections (the ones created when using the "mysql" CLI) have a different `interactive_timeout` so are not affected.
You can customize the value of wait_timeout for your Trove instance by creating a "configuration group". [1] HTH, Francesco [0] https://phabricator.wikimedia.org/T367464 [1] https://wikitech.wikimedia.org/wiki/Help:Trove_database_user_guide#Modify_database_configuration On Mon, Jun 24, 2024 at 10:47 AM David Caro <dc...@wikimedia.org> wrote: > > > 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." > _______________________________________________ > Cloud mailing list -- cloud@lists.wikimedia.org > List information: > https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ -- Francesco Negri (he/him) -- IRC: dhinus Site Reliability Engineer, Cloud Services team Wikimedia Foundation _______________________________________________ Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
