[01:29:46] i have a tech issue [01:30:02] What is it? [01:30:47] the wikipedia app problem [01:33:17] it lets me edit when i am blcoek [01:33:19] blocked [01:34:39] Does it? [01:34:44] What username on wiki? [01:34:51] SparkyHelper2 [01:34:58] Which wiki? [01:35:02] I have been blocked from 2006 [01:35:08] wikipedia [01:35:10] the app [01:35:12] english? [01:35:15] yes [01:35:26] i reported but people said it was fake [01:35:31] https://en.wikipedia.org/wiki/Special:Contributions/SparkyHelper2 [01:35:31] so please fix it [01:35:40] 10:20, 6 November 2017 Yunshui (talk | contribs) blocked SparkyHelper2 (talk | contribs) with an expiration time of indefinite (account creation blocked) (Abusing multiple accounts: User:ScooterBeanieBoo) [01:35:46] You were blocked after the last edit [01:35:50] yep that's me [01:35:58] The previous block [01:35:58] 23:12, 20 October 2017 Ponyo (talk | contribs) blocked SparkyHelper2 (talk | contribs) with an expiration time of 24 hours (account creation blocked) (Vandalism) [01:36:04] I can still edit [01:36:14] There's no evidence of it [01:36:23] The last contribution was before the indefinite block [01:36:29] but i will prove it ok [01:36:40] Sure, please do [01:36:53] watch the eraser page on english wikipedia [01:37:35] I can't get there [01:38:31] sorry i got to leave [01:44:10] lol [01:48:08] To be on the safe side, check his ip for vandalisms [01:48:48] Nothing recent [09:00:12] 4/win 2 [14:13:09] Hello. I'd like to ask when will the cloud discussions begin. Kindly confirm 4pm UTC as noticed in the mail list. Regards [14:19:29] Antime: What are the cloud discussions? [14:19:42] Antime: Do you mean https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting ? [14:23:41] Thanx. @andre__ [15:03:26] Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @addshore & @Christoph_Jauera_(WMDE) - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [16:00:22] \o/ [16:01:33] Welcome everybody to the 12th Technical Advice IRC Meeting! [16:02:01] 0/ [16:05:15] Silence? May I start asking? [16:05:25] Sure! [16:05:52] on database dewiki_p I miss the prividege for the EXPLAIN clause [16:07:01] I tend to do a lot of logic with SQL, but since I do not see what keys exist and I do cannot use EXPLAIN … well, its a lttle bit hard [16:07:18] sounds like something for the ops people [16:07:38] you should create a ticket on Phabricator [16:07:38] https://quarry.wmflabs.org/query/22259 <-- an example for a nice query. Description is in german language [16:08:28] okay [16:09:21] and you could additionally ask in #wikimedia-operations [16:09:59] https://phabricator.wikimedia.org/T179922 <-- another one for those people. [16:15:12] Another thing which took a few hours to find out … https://www.mediawiki.org/wiki/API:Login#How_to_log_in [16:15:18] The login sequence [16:15:49] Looking at https://wikimediafoundation.org/wiki/Staff_and_contractors#Technical%20Operations : [16:15:49] Yes, you need a token. And with the next call, this token has to be sent back to the server [16:15:52] For Database related stuff you could probably poke people like https://wikimediafoundation.org/wiki/User:JCrespo_(WMF) and https://wikimediafoundation.org/wiki/User:MArostegui_(WMF) [16:17:04] But what I missed: You also get a few cookies set and you need to send those cookies back to the server too. If you do not you get a message like "logintoken is missing" [16:17:37] So it would be nice if someone mentions the need for cookies in this two-step login procedure [16:18:16] … or change the error message … [16:18:41] Oh, nice finding. You could probably add that additional info ... it's a wiki ;-)! [16:19:22] Well my english is a little bit … not so nice [16:19:29] Hehe [16:21:07] So if I understand it correctly, when you request the token to login, there are cookies set that will be needed for the 2nd step, the actual login? [16:21:24] silly wifi! [16:21:47] wb addshore ;-) [16:21:54] exactly [16:22:06] *reads up* [16:23:16] hmm, I think all of the indexes are explained somewhere [16:23:25] No question that one needs the cookies set by the login itself. But I did not expect a need for those when requesting the token [16:23:48] Yes, the indexes can be found in the dump files [16:24:25] there you see create table statements at the very beginning. [16:24:44] https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#Replica_database_schema_.28tables_and_indexes.29 [16:33:19] Wurgl: https://www.mediawiki.org/w/index.php?diff=2613935&oldid=2502127&title=API%3ALogin&type=revision ;-) [16:33:59] perfect [16:37:38] :D [16:41:28] Anyone else with questions? :-) [16:41:43] Trivial patches that need reviews ;-) [16:46:45] 1 liners! [16:47:06] *g* [16:47:48] Ah, I have one addshore https://gerrit.wikimedia.org/r/#/c/389951/ ^^ [16:48:13] ooooh [16:48:37] hahahahhaaa [16:56:58] Found a workaround for the missing EXPLAIN … https://tools.wmflabs.org/tools-info/optimizer.py [16:57:55] wooo! [16:58:09] https://phabricator.wikimedia.org/T50875 <-- mentioned here [16:59:07] Wurgl: if you can manage to work a link to that into the docs then do! :D [16:59:56] Right thats about it! [17:00:40] :-) [17:01:30] Until next time! [17:05:58] I have bookmarked that tool-page, I will try to find some nice place [22:35:01] I have a bug with the Wikipedia app [22:45:10] SparkyHelper2: no you don't [22:45:52] Oh sorry bye [22:51:16] lol, that conversation :D [22:51:38] Gotta love it [22:55:07] legoktm-kenobi. [23:01:47] tgr: :) [23:03:27] damn. phab doesn't have quips function, does it? [23:06:47] DanielK_WMDE: https://www.mediawiki.org/wiki/Quips [23:06:51] https://tools.wmflabs.org/bash/top [23:10:52] https://tools.wmflabs.org/bash/quip/AV-d16bjJfYMc0lpkgTu ;) [23:18:06] !bash I have a bug with the Wikipedia app RandomGuy2: no you don't Oh sorry bye [23:18:06] DanielK_WMDE: Stored quip at https://tools.wmflabs.org/bash/quip/AV-d7Sm-F4fsM4DBdbLP [23:18:12] \o/ [23:18:40] Yes [23:18:45] Love [23:19:03] stashbot should randomly post qips when the channel is quiet [23:19:04] See https://wikitech.wikimedia.org/wiki/Tool:Stashbot for help. [23:19:28] sssshhh, shut up stashbot! [23:19:34] i wasn't talking to you [23:20:19] Now it's there stored twice in quips [23:20:20] eddiegp was waaaayyy ahead of me, I see :) [23:21:05] *sigh* yea... [23:21:33] I've felt free to delete the second one, hope you don't mind :) [23:23:04] DanielK_WMDE: ^ [23:41:41] Krinkle: sorry, had another meeting [23:42:30] I was thinking of things like Mobile Content Service [23:44:16] which was initially created for Wikipedia-specific mobile apps, so there wasn't really a point to making it usable for third parties, and then the mobile web has become increasingly more reliant on it, but it's still mostly treated as a Wikimedia-specific tool (e.g. no assumption that the wiki might be configured differently from Wikimedia wikis, to not even mention installation support) [23:45:46] and there isn't any place in that process where one could point to and say "an RfC should have happened here", at least with how we think of RfCs today