[06:14:33] <Polomo>	 Hi. I messaged here yesterday to ask about making a Toolforge tool. However, there's something more useful to me:
[06:14:38] <Polomo>	 How can I connect to the Wikimedia databases using the Python module `mariadb`, from my computer?
[06:14:43] <Polomo>	 Thanks, Polomo
[06:14:46] <Polomo>	 !help
[06:14:46] <wm-bot>	 If you don't get a response in 15-30 minutes, please email the cloud@ mailing list -- https://wikitech.wikimedia.org/wiki/Help:Cloud_Services_communication
[06:16:53] <Polomo>	 I'm currently trying [this program](https://github.com/PolomoPT/estranhezas-wiktionary/blob/ddc5446776349c364a9284340cdb124886d72aa9/sem%20Brazil%201990/criar%20lemmas.py), but it's not working. I don't know if it's an issue with the code itself, or maybe with the credentials I'm trying to use...
[06:18:54] <wm-bb>	 <jeremy_b> https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#Connecting_to_the_database_replicas_from_your_own_computer
[06:19:04] <wm-bb>	 <jeremy_b> https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#MySQL_Workbench
[06:20:33] <Polomo>	 Right... I need to improve my documentation-browsing skills. Will look. Many thanks for the reference!
[06:22:29] <wm-bb>	 <jeremy_b> why are you connecting to s4 for enwiktionary?
[06:22:52] <wm-bb>	 <jeremy_b> https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#Naming_conventions
[06:23:25] <wm-bb>	 <jeremy_b> reduce test cases
[06:23:33] <wm-bb>	 <jeremy_b> connect with CLI client
[06:25:15] <Polomo>	 Right. I didn't where to find the proper place to connect. Many thanks again.
[06:25:28] <Polomo>	 What does "reduce test cases" mean? Like, start with a simpler SQL query?
[06:25:50] <wm-bb>	 <jeremy_b> I guess maybe
[06:28:05] <wm-bb>	 <jeremy_b> start with e.g. `show status` and `select 1` and then move on to `select count(*) from page`
[06:28:43] <wm-bb>	 <jeremy_b> if you're not sure if the credentials are working then test the credentials.
[06:30:05] <wm-bb>	 <jeremy_b> with CLI and also Python. (re @jeremy_b: if you're not sure if the credentials are working then test the credentials.)
[07:58:02] <Polomo>	 Hi, wm-bb (or anyone else). I set up an SQL tunnel using MySQL, but now when I try to run it, it says ```mariadb.OperationalError: Can't connect to server on '127.0.0.1' (10061)```. How can I identify what leads to this error? Thanks.
[07:59:51] <Polomo>	 !help
[07:59:51] <wm-bot>	 If you don't get a response in 15-30 minutes, please email the cloud@ mailing list -- https://wikitech.wikimedia.org/wiki/Help:Cloud_Services_communication
[08:02:44] <Polomo>	 I messes up the previous link to my code. Should be this: https://github.com/PolomoPT/estranhezas-wiktionary/blob/main/sem%20Brazil%201990/criar%20lemmas.py
[08:15:43] <Polomo>	 Oh, managed to get it running.
[08:17:01] <dcaro>	 Polomo: awesome :), I was about to ask you some questions (most of us are in an offsite, so we are kinda spotty in the chat)
[08:17:53] <dcaro>	 if you still have issues, following up on a phabricator task might get you more answers (until we are all back at least)
[08:19:04] <Polomo>	 I really appreciate the help! I didn't know this "LiberaChat", but turns out it's pretty active
[08:20:39] <RhinosF1>	 Polomo: wm-bb is a relay by the way. The actual person whose talking through wm-bb is the bit between < > so Jeremy_b for you
[08:22:06] <Polomo>	 Yeah, I realized that right afterwards... embarassing.