[05:22:21] Hi all! The first Wishathon showcase session is in ~4 hours from now and the second one in ~12 hours from now! Do any of you have something to present? It could be a work-in-progress patch, a proof of concept, a good first task, or something you have been exploring on your localhost for the Wishathon. Please see “Tips for Showcase participants” to learn more about how to part [05:22:22] icipate: https://etherpad.wikimedia.org/p/wishathon-march-2024-showcase. @gopavasanth @sohom_datta @Yetkin @Nikki @bthierry23 @zvczzxk @athulvis @abelmbula Looks like you have been working on a Wishathon related task/project. Would you like to share it with others during the showcase? Thank you! [05:23:48] I am still in a roadblock. Didn't get a way to connect toolforge with the database. (re @athulvis: Still I didn't get a method to connect toolforge with commons database @tehreedy @lucaswerkmeister using toolforge package) [05:58:06] Hi @srishakatux, [05:58:07] [05:58:08] We will be there in the second round. Thank you! (re @srishakatux: Hi all! The first Wishathon showcase session is in ~4 hours from now and the second one in ~12 hours from now! Do any of you hav...) [06:38:25] @freosam will be hosting the first showcase, so those attending can direct their questions to him. @HarumiMonroy and I will be hosting the second session. However, for both sessions, we will be using the same slide deck, so please continue to add your project details to it. (re @srishakatux: Hi all! The first Wishathon showcase session is in ~4 hours from now and the second one i [06:38:26] n ~12 hours from now! Do any of you hav...) [06:47:05] Hi, Does the `pl_title` column in wiki db is only available for en wiki / simple wiki and not for test wiki? [06:47:05] [06:47:07] ``` [06:47:08] pymysql.err.OperationalError: (1054, "Unknown column 'pl_title' in 'field list'") [06:47:10] 127.0.0.1 - - [17/Mar/2024 12:14:38] "GET /api/getdabs/test/WikUuU2?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 200 -``` [06:52:08] Will the showcase be recorded and put on Commons, or does one need to join Google meet to see it? (re @srishakatux: Hi all! The first Wishathon showcase session is in ~4 hours from now and the second one in ~12 hours from now! Do any of you hav...) [07:06:49] use page_title (re @gopavasanth: Hi, Does the pl_title column in wiki db is only available for en wiki / simple wiki and not for test wiki? [07:06:50] [07:06:52] pymysql.err.Operatio...) [07:11:28] @Jan_ainali it will be recorded yep [08:32:16] The first showcase session will start in half an hour from now. https://meta.wikimedia.org/wiki/Event:WishathonMarch2024#Sunday,_March_17th [08:33:12] (There will a second one 8 hours after the first.) [09:27:40] Please session not coming on? (re @freosam: The first showcase session will start in half an hour from now. https://meta.wikimedia.org/wiki/Event:WishathonMarch2024#Sunday,...) [09:28:00] Oh sorry! We were a very small group, and it's already finished! [09:28:28] But let's start again, and we can do more 😊 [09:35:55] No problem (re @freosam: Oh sorry! We were a very small group, and it's already finished!) [09:36:58] Thanks for the meet up. [09:36:59] [09:37:01] Gonna chat you for some few discussions😊 (re @freosam: But let's start again, and we can do more 😊) [16:10:23] Hello.. I was trying to work with the nfp tool project. For that I followed python-toolforge tutorial [16:10:24] [16:10:26] ``` [16:10:27] import toolforge [16:10:29] [16:10:30] conn = toolforge.connect("enwiki") ``` [16:10:32] [16:10:33] [16:10:35] This is the command they mention in the tutorial. [16:10:36] [16:10:38] But this error happens when I run above command: [16:10:39] [16:10:41] ``` [16:10:42] pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'enwiki.web.db.svc.wikimedia.cloud' (timed out)")``` [16:10:44] [16:10:45] [16:10:47] It seems like I have to connect the database from my own instance in toolforge, right? How can I do this? Can someone guide me to work on this? [16:11:47] to clarify: did you run that command on your local system when you got that error? [16:12:00] yes (re @lucaswerkmeister: to clarify: did you run that command on your local system when you got that error?) [16:12:43] https://tools-static.wmflabs.org/bridgebot/ee04283d/file_58818.jpg [16:12:52] ok, yeah, that doesn’t work by default – you can only connect to the databases from within Toolforge [16:13:14] so if you tried that on Toolforge (inside `webservice python3.11 shell`, say), it should work [16:13:27] ``` [16:13:27] ssh -L 4711:enwiki.analytics.db.svc.wikimedia.cloud:3306 login.toolforge.org``` [16:13:29] [16:13:30] [16:13:32] this one should work, right? (re @lucaswerkmeister: ok, yeah, that doesn’t work by default – you can only connect to the databases from within Toolforge) [16:13:33] there’s also https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#SSH_tunneling_for_local_testing_which_makes_use_of_Wiki_Replica_databases for being able to access the databases locally, but I’m not sure how well it works, I haven’t tried it myself [16:14:10] you’ll also need the `/etc/hosts` step from the link I just pasted, but hopefully, yes (re @athulvis: ssh -L 4711:enwiki.analytics.db.svc.wikimedia.cloud:3306 login.toolforge.org [16:14:11] [16:14:12] this one should work, right?) [16:15:22] in local or in toolforge? (re @lucaswerkmeister: you’ll also need the /etc/hosts step from the link I just pasted, but hopefully, yes) [16:15:26] locally [16:20:25] ``` [16:20:26] You might need to copy over the replica.my.cnf file to your local machine for this to work. [16:20:27] ``` [16:20:29] [16:20:30] [16:20:32] where should I keep this file? (re @lucaswerkmeister: locally) [16:21:12] it needs to be in your home directory, I think [16:21:18] `~/replica.my.cnf` [16:21:33] Thanks.. let me try. (re @lucaswerkmeister: ~/replica.my.cnf) [16:24:45] Hi all! Welcome to Day 3 of Wishathon. We are hosting final session of the Wishathon which is the project showcase in ~30 minutes from now. Details below: [16:24:49] Coming up at #wikimediawishathon [16:24:50] 🕰️ 17:00 UTC [16:24:51] [16:24:53] Project Showcase [16:24:54] User:SSethi (WMF), User:HMonroy (WMF) [16:24:56] [16:24:57] 📍 Meet link: meet.google.com/rjq-mxde-kys [16:24:59] 📝 Etherpad: https://etherpad.wikimedia.org/p/wishathon-march-2024-showcase [16:26:26] If you are interested in presenting, you still have some time :) Please add to the deck here: https://docs.google.com/presentation/d/1Z_edgEHaESxp72PcN4kj_mEgbcft0_L8-eebBjyja0o/edit. So far, 5 contributors have signed up to present [16:35:22] it is steady for a long time.. is it working?Python code is still throwing the error : https://tools-static.wmflabs.org/bridgebot/7d925667/file_58821.jpg [16:36:48] well, it looks like the port should be forwarded, and since you used `-N` it’s normal that the ssh command doesn’t look like it does anything [16:37:19] (side note, you don’t need to censor the key fingerprint, and it’s a good idea to check that you see it at https://wikitech.wikimedia.org/wiki/Help:SSH_Fingerprints/dev.toolforge.org to make sure you’re connecting to the right host) [16:38:36] Didn't know that.. Thanks. Yes, it is connecting to right host. (re @lucaswerkmeister: (side note, you don’t need to censor the key fingerprint, and it’s a good idea to check that you see it at https://wikitech.wiki...) [16:38:42] what happens if you run `telnet localhost 3306`? [16:39:18] (you should get some output with `MariaDB` in it) [16:39:36] I think so : https://tools-static.wmflabs.org/bridgebot/9b4dc0d9/file_58822.jpg [16:39:46] okay, then the forwarding is working at least [16:39:56] did you add the line to your `/etc/hosts` file? [16:40:46] yeah.. I did : https://tools-static.wmflabs.org/bridgebot/e380d6fd/file_58823.jpg [16:41:43] oh, you probably need another line with `web` instead of `analytics` [16:41:49] since the `toolforge` library defaults to that cluster [16:42:02] (or add `cluster='analytics'` to your `connect()` call) [16:44:31] throws this error. [16:44:32] [16:44:33] ``` [16:44:35] pymysql.err.OperationalError: (1045, "Access denied for user 'athulvis'@'10.64.151.2' (using password: NO)")``` [16:44:36] [16:44:38] [16:44:39] Actually this is not my username. its athulvis1 for toolforge (re @lucaswerkmeister: (or add cluster='analytics' to your connect() call)) [16:45:31] athulvis1 would not be the right name either, the user would look like `u14826` (user account) or `s53788` (tool account) [16:45:42] did you copy the `replica.my.cnf` file from toolforge to your home directory? [16:45:52] yes it is (re @lucaswerkmeister: did you copy the replica.my.cnf file from toolforge to your home directory?) [16:45:54] because that’s where the user name (and password) would be configured [16:46:18] do I need to give path to that file in toolforge library? (re @lucaswerkmeister: because that’s where the user name (and password) would be configured) [16:46:44] no, the library has `~/replica.my.cnf` hard-coded [16:46:48] what does the output of `ls -l ~/replica.my.cnf` look like? [16:47:30] got it thanks.. I made a small typo.. (re @lucaswerkmeister: no, the library has ~/replica.my.cnf hard-coded) [16:47:51] alright ^^ [16:51:48] I ran the nfp tool. [16:51:50] [16:51:51] This error happens [16:51:53] [16:51:54] ``` [16:51:56] pymysql.err.OperationalError: (1044, "Access denied for user 'u*****'@'%' to database 'commonswiki_p'")``` [16:51:57] (re @lucaswerkmeister: alright ^^) [16:52:08] https://meta.wikimedia.org/wiki/Special:OAuthListConsumers/view/cb4f10528065e9b0b50c6534aae9a66d [16:52:09] [16:52:11] Review needed.. [16:54:15] hm, I have no idea why that happens :/ (re @athulvis: I ran the nfp tool. [16:54:15] [16:54:17] This error happens [16:54:18] [16:54:20] pymysql.err.OperationalError: (1044, "Access denied for user 'u*****'@'%' to database '...) [16:54:51] @bd808 Aaah, Can we update the desc any point of time? (re @gopavasanth: https://meta.wikimedia.org/wiki/Special:OAuthListConsumers/view/cb4f10528065e9b0b50c6534aae9a66d [16:54:51] [16:54:53] Review needed..) [16:55:59] Thanks for the effort anyway (re @lucaswerkmeister: hm, I have no idea why that happens :/) [16:57:30] @gopavasanth: Nope. You can only update the IP range and page allow list. If you could update the description then you could submit with a benign description and then later update it to attempt to impersonate some other OAuth consumer. [16:59:00] You can at any time submit a new request instead [16:59:13] Second showcase and final Wishathon session starting in ~5 minutes! [16:59:25] Sure :) (re @wmtelegram_bot: You can at any time submit a new request instead) [17:00:56] @gopavasanth: if it was not clear to you that the description filed gets shown to your future users, maybe that is worth a documentation/help text improvement task against the OAuth extension? [17:01:03] *field [17:02:00] +1 Yeah I didn't notice that it will be visible to end users. Worth having a info icon on the same... [17:53:32] I've definitely noticed that oauth descriptions are often written as explanations of why the user was requesting the oauth consumer, sometimes with plaintext urls. it really messes up special:tags (re @wmtelegram_bot: @gopavasanth: if it was not clear to you that the description filed gets shown to your future users, maybe that is worth...) [17:54:04] I don't know where else they're shown though, I don't see it when authorising things [17:57:00] like https://commons.wikimedia.org/wiki/Special:Tags scrolls horizontally below 1582px wide for me [21:08:24] Hello everyone, thank you all for joining us for Wishathon this weekend! The event has officially concluded. You can watch the showcase recordings linked from the event wiki. Once again, thank you for your contributions and presence at the Wishathon. Please feel encouraged to follow up on tasks and seek technical guidance from the Community Tech team and volunteer developers. If [21:08:24] you have any feedback on how we can improve the design of future events like this, please ping me on Telegram to discuss ideas further! Thank you for your time 🙏https://meta.wikimedia.org/wiki/Event:WishathonMarch2024