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_da...
On Mon, Jun 24, 2024 at 10:47 AM David Caro dcaro@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 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/
-- 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/