Fork me on GitHub

Wikimedia IRC logs browser - #wikimedia-tech

Filter:
Start date
End date

Displaying 383 items:

2019-02-13 02:10:21 <foks> having trouble getting https://en.wikipedia.org/wiki/Special:Log?type=newusers&user=&page=&wpdate=2017-06-11&tagfilter= to load
2019-02-13 02:14:03 <Reedy> You're not the only one :P
2019-02-13 02:14:10 <Reedy> It was slow, but loaded on PHP7 for me
2019-02-13 02:17:27 <AntiComposite> It took long enough for me (PHP7 as well) that I got bored and closed the tab
2019-02-13 02:26:26 <foks> It just throws a "too long" error
2019-02-13 02:26:33 <foks> for me anywayz
2019-02-13 11:13:33 <MatmaRex> what would it take to enable webm embedding on our phabricator? https://phabricator.wikimedia.org/T215360
2019-02-13 12:39:20 <jem> Hi, I'd need some quick help with my bot, it's getting "Please wait 5 minutes before trying again" from two different servers now
2019-02-13 13:01:36 <bawolff> For login?
2019-02-13 13:02:04 <bawolff> Make sure the password is right and wait 5 minutes before trying again
2019-02-13 13:02:41 <bawolff> The ratelimitting is crosswiki. So you should wait 5 min for all sites
2019-02-13 13:03:14 <jem> Hi, bawolff
2019-02-13 13:03:27 <jem> The problem is that is not just 5 minutes
2019-02-13 13:03:54 <jem> This has happened again in the past and it went over for days until someone fixed it
2019-02-13 13:04:28 <jem> And for no clear reason it says 5 minutes first, then 2 days...
2019-02-13 13:05:16 <jem> It was hapenning in the Wikimedia Spain server, I moved to Toolforge, then I did a test and now both servers have the same problem
2019-02-13 13:06:44 <bawolff> Well there's a good reason. If you hit the five minute warning too many times the system thinks you are trying to bruteforce passwords and locks you out for two days
2019-02-13 13:06:47 <jem> Last time: https://phabricator.wikimedia.org/T195541 , anomie fixed it and I have tried to ping him
2019-02-13 13:07:23 <jem> How many times would be "too many"?
2019-02-13 13:07:41 <bawolff> Yes, developers can manually delete the lock out
2019-02-13 13:07:57 <jem> I think it has been one or two times in Toolforge, I would say
2019-02-13 13:08:51 <bawolff> But making sure your bot isnt hitting the login form repetitively is also a good solution
2019-02-13 13:10:10 <jem> Well, I stopped the bot from running from the WM-ES server 5 days ago, I have just made one or two single tests a day since then
2019-02-13 13:11:20 <bawolff_> Just a second I'll check the logs
2019-02-13 13:11:24 <bawolff_> for reference, you get the five minute warning after five failed attempts, and the 2 day lockout after 150 attempts
2019-02-13 13:11:30 <jem> Thanks, bawolff_
2019-02-13 13:12:03 <jem> I'd say it's not the case but maybe there's something strange going on
2019-02-13 13:12:21 <bawolff_> So there are two recent attempts n the last 20 minutes that were both using the wrong password
2019-02-13 13:12:47 <bawolff_> And there's been 5076 attempts in the last 30 days
2019-02-13 13:13:32 <bawolff_> The last attempt that was due to the 5 minute lock out was at 2019-02-13T12:46:45 UTC
2019-02-13 13:13:52 <jem> Ok, 5076 in 30 days with the correct password should be right
2019-02-13 13:13:53 <bawolff_> After that there were 6 attempts using the wrong password
2019-02-13 13:14:06 <bawolff_> These are all with the wrong password
2019-02-13 13:14:12 <jem> 5076 ?
2019-02-13 13:14:34 <bawolff_> largely from feb 9
2019-02-13 13:16:07 <jem> Well, on feb 9 the WM-ES had a problem, but I don't understand why that creates logins with wrong password
2019-02-13 13:16:18 <jem> WM-ES server*
2019-02-13 13:17:25 <jem> And why that has happened two o three times before...
2019-02-13 13:17:29 <jem> or*
2019-02-13 13:19:27 <bawolff_> So you do also generally have lots of good logins too (except major falloff around feb 10. The number of good logins falls in half starting around feb 12 (from ~100 hour -> ~30 an hour)
2019-02-13 13:20:01 <jem> That is quite strange
2019-02-13 13:20:50 <bawolff_> So maybe you have multiple bot processes, and one of them has an old config file or something, that's trying to login with the wrong bot password, and occasionally locking out the account
2019-02-13 13:20:52 <jem> I had to launch it manually but on feb 11 I decided to use the crontab
2019-02-13 13:21:42 <jem> Well, the password is correct in both servers, maybe it is a problem when reading the secret file
2019-02-13 13:21:52 <jem> I can't think of another explanation
2019-02-13 13:22:07 <bawolff_> If it helps, the failed logins are from from WMF labs ips. and see to be for eswiki only
2019-02-13 13:23:01 <bawolff_> hmm or at least the recent ones are
2019-02-13 13:23:41 <bawolff_> There's a failed attempt at 2019-02-13T12:28:18 which is from wikimedia.es server
2019-02-13 13:23:59 <jem> The most recent ones... well, I have tried but always with the right password, but I was getting the "incorrect" or "5 minutes" answers
2019-02-13 13:24:12 <jem> From both servers
2019-02-13 13:25:15 <bawolff_> It definitely seems to be only for login attempts to eswiki
2019-02-13 13:25:35 <bawolff_> There are some login attempts that fail due to account lockout for other wikis, but all the wrong password failures are for eswiki only
2019-02-13 13:26:12 <jem> And the wrong passwords come from WMF or WM-ES IPs?
2019-02-13 13:28:11 <Gopa> Volker_E: ping ?
2019-02-13 13:29:13 <bawolff_> jem: Most recent ones are WMF, but older ones (that are still reccent) are WM-ES
2019-02-13 13:29:57 <jem> I'm quite shocked then
2019-02-13 13:31:29 <bawolff_> So there are 53 failures in the last 3 hours
2019-02-13 13:32:04 <bawolff_> Then nothing until feb 12 at 9:00 UTC
2019-02-13 13:32:30 <bawolff_> Although many of those 53 are the five minute lockout
2019-02-13 13:33:08 <bawolff_> ok, ignoring throttling
2019-02-13 13:33:57 <jem> Thanks, bawolff_, so I can try now?
2019-02-13 13:33:59 <bawolff_> 29 failures between feb 13 12:00 UTC and 14:00 UTC. then 13 failures at feb 12 9:00 UTC
2019-02-13 13:34:47 <bawolff_> yeah, none of the most recent failures were throttle related
2019-02-13 13:35:14 <jem> Well, I'd like to check if there's some wrong config somewhere, but right now I have no clues
2019-02-13 13:35:37 <jem> All the edits use the same function, which uses the same secret file...
2019-02-13 13:36:22 <jem> I try again from WM-ES now
2019-02-13 13:37:47 <jem> Ok, seems good
2019-02-13 13:40:48 <jem> And now another fail :/
2019-02-13 13:42:24 <jem> bawolff_: I really don't understand, I'm seeing the debug of the parameters for the API, and the password is the same, it just changes the lgname from Jembot (ok) to jembot (fail)
2019-02-13 13:44:20 <jem> And supposedly the first letter is not case sensitive... anyway, I'll try to change that...
2019-02-13 13:44:39 <bawolff_> yeah. Maybe API is picky somehow? That'd be odd
2019-02-13 13:44:47 <bawolff_> FWIW, everything in the logs use capital J
2019-02-13 13:46:15 <jem> I changed to Jembot in the code but the debug still says jembot
2019-02-13 13:46:43 <jem> And of course it failed again
2019-02-13 13:47:10 <bawolff_> I think you're back to hitting the more than 5 attempts in 5 minutes throttle
2019-02-13 13:48:48 <jem> Ok, that's because I activated the crontab
2019-02-13 13:48:56 <jem> Deactivated again
2019-02-13 13:50:47 <jem> And now I see Jembot, correct password, but again "wait 5 minutes"
2019-02-13 13:53:08 <jem> This is a little annoying, anyway, thanks for the help, bawolff_
2019-02-13 13:54:44 <bawolff_> fwiw, i looked in a different logfile, and I can confirm that sometimes you login with jembot and sometimes Jembot
2019-02-13 13:55:12 <jem> I have used a third server now and it seems Ok
2019-02-13 13:55:48 <jem> So I'll do a few manual launchs, as I have to leave now
2019-02-13 13:56:26 <jem> Maybe I can be in time for the technical hour in URC and get more help
2019-02-13 13:56:31 <jem> in IRC*
2019-02-13 13:56:57 <bawolff_> You do seem right, that the password fail ones seem to correspond with using lowercase j
2019-02-13 13:58:00 <bawolff_> except the most recent failed wrong pass login at 2019-02-13T13:56:58 was using an uppercase J
2019-02-13 13:58:07 <bawolff_> so maybe that's just a coincidence
2019-02-13 14:07:03 <bawolff> jem: maybe you are hitting captchas. I think failing captcha will result in wrong pass error
2019-02-13 14:07:20 <bawolff> not sure how captchas work from api
2019-02-13 14:08:54 <bawolff> Logs suggest thats not the case
2019-02-13 14:10:27 <jem> Captchas for a 390K edit account... that would be so strange
2019-02-13 14:10:42 <jem> (now writing from a tablet)
2019-02-13 14:12:45 <jem> The last manual launchs from the third server seem ok
2019-02-13 14:30:30 <bawolff> The login process will send you captchas after a certain number of failures
2019-02-13 14:30:48 <bawolff> I think 3
2019-02-13 14:31:06 <bawolff> But i think the tool labs ips are whitelisted
2019-02-13 14:34:01 <bawolff_> omg its a wild sumanah!
2019-02-13 14:34:05 <bawolff_> waves
2019-02-13 14:34:10 <sumanah> Hi bawolff_! how are you?
2019-02-13 14:34:17 <bawolff_> I'm good
2019-02-13 14:35:05 <bawolff_> I was in the museum of pop culture in Seattle a while back, and totally saw your name there
2019-02-13 14:35:27 <sumanah> so this is possibly a ridiculous request, but do you have access to a quotes database where Andrew Garrett once said something about a cake vending machine as a very American thing? I looked in https://tools.wmflabs.org/bash/ and couldn't find it
2019-02-13 14:35:38 <sumanah> bawolff_: oh nice :-) right, that interview about Star Trek
2019-02-13 14:36:08 <bawolff_> Hmm, was it in the old bugzilla quips db?
2019-02-13 14:36:21 <sumanah> bawolff_: I thought it was. But maybe it's something in a staff-only space.
2019-02-13 14:36:33 <bawolff_> unfortunately bugzilla isn't a thing anymore and I don't know what happened to its quip db
2019-02-13 14:37:02 <sumanah> I found out! The quips db went to https://tools.wmflabs.org/bash/
2019-02-13 14:37:11 <sumanah> But the cake thing is not there AFAICT
2019-02-13 14:37:13 <bawolff_> There's a big page at https://office.wikimedia.org/wiki/Bash that's staff only
2019-02-13 14:37:23 <sumanah> Might be there then
2019-02-13 14:37:24 <bawolff_> I don't see andrew on it
2019-02-13 14:38:08 <Krinkle> https://www.mediawiki.org/wiki/Quips
2019-02-13 14:39:01 <sumanah> Krinkle: I think that links to the same thing I just mentioned? Also, hi!
2019-02-13 14:39:12 <Krinkle> https://www.mediawiki.org/w/index.php?title=Quips&oldid=2100736
2019-02-13 14:39:39 <Krinkle> Yeah, this shows it got imported to Bash in tools
2019-02-13 14:39:43 <Krinkle> (hi!)
2019-02-13 14:40:28 <sumanah> Maybe I'll just email Andrew. "Hi, hope you are well, but the reason I am reaching out is that ... did you say a funny thing 10 years ago about a vending machine?"
2019-02-13 14:40:45 <bawolff_> wait
2019-02-13 14:40:51 <bawolff_> "When I first came to the US, I bought cake-flavored soda from a vending machine that took AMEX. Everything about that experience was American. "
2019-02-13 14:40:57 <sumanah> THAT. THANK YOU.
2019-02-13 14:41:08 <bawolff_> I was looking for his fullname and werdna
2019-02-13 14:41:11 <bawolff_> It was under andrew
2019-02-13 14:41:36 <sumanah> bawolff_: I vote you the hero of the hour.
2019-02-13 14:41:39 <bawolff_> https://office.wikimedia.org/wiki/Bash/archive#January_2011 (staff only)
2019-02-13 15:00:36 <wm-bot> Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @milimetric & @amir1 - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting
2019-02-13 15:30:35 <ShakespeareFan00> Okay yet more template/CSS interactions
2019-02-13 15:30:36 <ShakespeareFan00> https://en.wikisource.org/wiki/Wikisource:Scriptorium/Help#Okay_why_does_parameterising_line-height_completely_stop_something_working?
2019-02-13 15:30:55 <ShakespeareFan00> line-height parameter is ignored for SPANs that aren't also blocks
2019-02-13 15:31:11 <ShakespeareFan00> Yet somene in writing the relevant template thought otherwise
2019-02-13 15:31:14 <ShakespeareFan00> (sigh)
2019-02-13 15:31:23 <ShakespeareFan00> *Someone
2019-02-13 15:36:58 <superyetkin> hello there
2019-02-13 15:39:24 <AntiComposite> Hello superyetkin!
2019-02-13 15:39:57 <rhinosf1> If I'm not back for the tech meeting, could phab T213616?
2019-02-13 15:40:17 <rhinosf1> I'm happy to give access if needed.
2019-02-13 15:42:42 <rhinosf1> Off now
2019-02-13 15:50:18 <wm-bot> Technical Advice IRC meeting starting in 10 minutes in channel #wikimedia-tech, hosts: @milimetric & @amir1 - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting
2019-02-13 15:59:14 <milimetric> hello world
2019-02-13 15:59:27 <yannf> hi
2019-02-13 15:59:35 <milimetric> I'm here to help
2019-02-13 15:59:54 <milimetric> I'm one of the https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting people
2019-02-13 16:00:26 <Amir1> o/
2019-02-13 16:00:28 <milimetric> quick background: I'm on the Analytics team, I build and publish datasets and dashboards
2019-02-13 16:01:12 <yannf> I don't know if that is in scope, but https://commons.wikimedia.org/wiki/File:Edittools_JS_errors.png
2019-02-13 16:01:14 <Amir1> And as of my background: I work in two projects: wikidata and ores
2019-02-13 16:02:26 <Amir1> yannf: let me check
2019-02-13 16:02:35 <Amir1> Can I see the code for edittools?
2019-02-13 16:02:54 <Amir1> (Basically steps to reproduce the issue)
2019-02-13 16:03:21 <milimetric> (also - everything is in scope :))
2019-02-13 16:03:45 <bawolff> rhinosf1: ill make a note to nag some people about that
2019-02-13 16:04:12 <bawolff> It was sort of already on my todo list to nag some people about it
2019-02-13 16:04:19 <Gopa> Hello,
2019-02-13 16:04:19 <Gopa> I thought of working on the Special:ViewData to improve the UI and make it much more user friendly manner, for that I made a mock-up https://app.moqups.com/TdoAvwD2nF/view which is not so great though, So any suggestions or examples to make the ViewData much more userfriendly ?
2019-02-13 16:04:44 <yannf> Amir1, do you see Edittools above the editbox (in source mode) on Commons?
2019-02-13 16:05:32 <Amir1> yannf: yup
2019-02-13 16:05:42 <yannf> it seems to be on for everyone
2019-02-13 16:06:15 <yannf> for me, it appears around once every 10 edits, with these JS erros
2019-02-13 16:06:25 <yannf> *r
2019-02-13 16:06:48 <bawolff> Maybe load order related if its that intermittent
2019-02-13 16:07:15 <yannf> Chrome Version 71.0.3578.98 (Official Build) (64-bit)
2019-02-13 16:08:28 <Amir1> yannf: okay. It's a little bit hard to reproduce, my gut feeling is that there is something with your enabled tools/custom js
2019-02-13 16:08:30 <Amir1> the conflict
2019-02-13 16:08:49 <Amir1> so 1- Try disabling all and enabling them one by one
2019-02-13 16:08:53 <milimetric> Gopa: taking a look
2019-02-13 16:09:11 <Gopa> :)
2019-02-13 16:09:33 <milimetric> I'm not familiar with Special:ViewData, so I have some catching up to do first, but I could help with the UI
2019-02-13 16:09:35 <rhinosf1> Bawolf - Thanks, I'll be on at some point
2019-02-13 16:09:37 <Amir1> 2- if still it's not working with everything disabled. Put a debug=true at the end of your url and report the error to phabricator
2019-02-13 16:09:39 <yannf> Amir1, I ama pretty sure I didn't change my setup
2019-02-13 16:09:54 <yannf> it is like this for 2-3 days now
2019-02-13 16:10:09 <Amir1> yannf: yes but it might be someone edited one of those gadgets, etc.
2019-02-13 16:10:31 <bawolff> Maybe related to the onload shenagians in mediawiki:edittools.js
2019-02-13 16:10:46 <milimetric> Gopa: which wiki is this enabled on so I can play with it
2019-02-13 16:10:48 <Amir1> yannf: try with this https://commons.wikimedia.org/w/index.php?title=File:Edittools_JS_errors.png&action=edit&safemode=1
2019-02-13 16:11:08 <Amir1> bawolff has a point too
2019-02-13 16:11:12 <Gopa> Special:ViewData is the cargo extension.
2019-02-13 16:12:10 <yannf> Amir1, no Edittools
2019-02-13 16:12:29 <Amir1> Gopa: we have a design style guide that you can find at design.wikimedia.org (which has detailed resources)
2019-02-13 16:12:40 <Amir1> Gopa: Also you can make it work with OOUI
2019-02-13 16:12:49 <yannf> I think Edittools crashes, so it does appear
2019-02-13 16:13:19 <Amir1> Gopa: https://phabricator.wikimedia.org/project/view/24/ look at the column "Conversion to OOUI"
2019-02-13 16:13:39 <Amir1> e.g. https://phabricator.wikimedia.org/T192099
2019-02-13 16:13:52 <Gopa> Looking through
2019-02-13 16:14:16 <bawolff> I dont even know if mediawiki:edittools.js is used though. So may be false lead
2019-02-13 16:14:17 <Amir1> yannf: https://commons.wikimedia.org/w/index.php?title=MediaWiki:Edittools.js&action=history it's not changed in the past couple of months
2019-02-13 16:14:19 <yannf> I am trying to get output of the JS console
2019-02-13 16:14:49 <Amir1> yannf: try with debug=true (https://commons.wikimedia.org/w/index.php?title=File:Edittools_JS_errors.png&action=edit&debug=1)
2019-02-13 16:14:50 <Gopa> The current ui looks like https://ibb.co/QKz1rjc
2019-02-13 16:15:18 <Amir1> It's already ooui, that's good
2019-02-13 16:15:44 <bawolff> Err. Nevermind it is loaded from common.js
2019-02-13 16:16:01 <yannf> Amir1, no tool at all with debug=1
2019-02-13 16:16:17 <Gopa> Amir1: I think Special:ViewData is using OOUI for now.
2019-02-13 16:16:17 <Amir1> what's the output in console?
2019-02-13 16:16:26 <Gopa> I doesnt think*
2019-02-13 16:16:41 <Amir1> Hmm, let me check the codebase
2019-02-13 16:17:05 <Gopa> I mean, I doesn't think It is using OOUI now.
2019-02-13 16:17:09 <Gopa> Sure :)
2019-02-13 16:18:23 <Amir1> https://github.com/wikimedia/mediawiki-extensions-Cargo/blob/master/specials/CargoViewData.php
2019-02-13 16:18:45 <Amir1> you're right, making it use ooui would help it align more with wikimedia design style guide
2019-02-13 16:19:42 <milimetric> there's some light use of OOUI, https://github.com/wikimedia/mediawiki-extensions-Cargo/search?q=OOUI&unscoped_q=OOUI
2019-02-13 16:19:44 <Gopa> do you have any idea to make it more user friendly ? May be somethings like auto filling or tokens method or something
2019-02-13 16:20:15 <milimetric> Gopa: so this allows people to query any table or just tables that have data used in templates?
2019-02-13 16:20:43 <Gopa> Yeah you are right :)
2019-02-13 16:21:02 <Amir1> Gopa: Using HTMLForm and defining which type of input they are would help greatly https://www.mediawiki.org/wiki/HTMLForm
2019-02-13 16:21:27 <Amir1> for example it has a dedicated type of page which has auto filing
2019-02-13 16:21:57 <Amir1> HTMLTitleTextField: Textbox to take Page Name
2019-02-13 16:22:08 <Amir1> https://www.mediawiki.org/wiki/HTMLForm/tutorial3#Class
2019-02-13 16:22:14 <rhinosf1> Bawolf - Thanks for The help. It definitely doesn't show on Oversight just revdel (using visual diff). Let me know if you get an estimated fix date.
2019-02-13 16:22:23 <rhinosf1> ^ Bawolff
2019-02-13 16:22:31 <milimetric> agreed with Amir1 that using the style guide and OOUI elements would help a lot
2019-02-13 16:22:39 <Gopa> Do you know any UI in any wiki such a way already? for Inspiration !
2019-02-13 16:22:57 <Amir1> Gopa: Moving pages is one of them
2019-02-13 16:23:13 <Amir1> https://www.mediawiki.org/wiki/Special:MovePage/Manual_talk:Coding_conventions/PHP
2019-02-13 16:24:04 <milimetric> Gopa: VisualEditor uses OOUI more heavily than any other project, so if you're looking for examples you'd probably find them there: https://github.com/wikimedia/mediawiki-extensions-VisualEditor
2019-02-13 16:25:47 <Gopa> Yeah I already have VisualEditor and any interface had the implementaion of the autofilling? That gives the best services to the users.
2019-02-13 16:26:08 <Amir1> milimetric: thanks. It's really good. Some demos can be found in https://doc.wikimedia.org/oojs-ui/master/demos/?page=widgets&theme=wikimediaui&direction=ltr&platform=desktop
2019-02-13 16:27:29 <milimetric> Gopa: yeah, if you can generate a list of tables that the users can query, then you can auto-complete the Table input box. Then, when they tab out of there, you can query "desc the_table_they_chose" and auto-complete the Field(s) input box
2019-02-13 16:28:35 <milimetric> You could also add a little info icon that you either click or hover to see the full list of columns listed in alphabetical order or something
2019-02-13 16:29:12 <milimetric> you could also run a basic "select * from the_table_they_chose limit 10" to show them a sample
2019-02-13 16:29:15 <rhinosf1> I know it's user maintained but anyone know anything about this https://en.wikipedia.org/wiki/User_talk:Scottywong#https://tools.wmflabs.org/jackbot/snottywong/cgi-bin/afdadminstats.cgi?max=250&name=Evad37_-_is_unavailable?
2019-02-13 16:29:20 <Gopa> Oo okay :)
2019-02-13 16:30:53 <Amir1> rhinosf1: it probably means the query is too heavy. If you get it all the time
2019-02-13 16:31:00 <Gopa> Do you advice me to use any specific thing in making the mock up to propose the new UI? Generally how the Wikimedia's General mock ups are made ?
2019-02-13 16:31:16 <Amir1> if it's a one time thing, just try to reload (it happens sometimes due to network issues)
2019-02-13 16:31:26 <milimetric> rhinosf1: I agree, that query would time out, that join is really rough on enwiki
2019-02-13 16:32:18 <yannf> Amir1, I got the JS console https://commons.wikimedia.org/wiki/Commons:Village_pump/Technical#Edittools_JS_errors
2019-02-13 16:32:31 <Amir1> Gopa: design.wikimedia.org is a good starting point IMO
2019-02-13 16:32:43 <rhinosf1> Anything I can do on my end??
2019-02-13 16:32:56 <milimetric> page/revision join without timestamp filter. Basically any range greater than a few days to weeks on enwiki revision will most likely not work
2019-02-13 16:33:21 <Gopa> Thank you Amir1 :)
2019-02-13 16:33:42 <milimetric> Gopa: do you mean what tools should you use for drawing up the actual mockup?
2019-02-13 16:33:54 <Gopa> Yes !
2019-02-13 16:34:00 <milimetric> Gopa: there's no real standard there, whatever tool you like, but the designers have some opinions, I believe Sketch is popular
2019-02-13 16:34:30 <Amir1> rhinosf1: nothing unfortunately, you can contact the maintainer and ask them to improve the query optimization
2019-02-13 16:34:47 <Amir1> but nothing much can be done
2019-02-13 16:34:51 <Gopa> Oook thanks your insights milimetric
2019-02-13 16:35:01 <Amir1> yannf: checking
2019-02-13 16:35:08 <milimetric> rhinosf1: oh, I didn't see the user filter, maybe that's not so bad then. Lemme see
2019-02-13 16:35:23 <rhinosf1> I've messaged the maintainer as linked above but they're not active
2019-02-13 16:37:06 <milimetric> rhinosf1: I'm working on the query now to see if there's any easy fix. If there is we can just see where the repo is and send a patch
2019-02-13 16:37:18 <milimetric> if not, you could always run the query in quarry and get your results manually
2019-02-13 16:38:02 <rhinosf1> Let me know if you find anything if not, how would quarry work?
2019-02-13 16:38:20 <milimetric> rhinosf1: what wiki were you working on?
2019-02-13 16:38:28 <milimetric> AFD is not enabled everywhere
2019-02-13 16:38:43 <yannf> Amir1, there is clear error message about MediaWiki:Edittools
2019-02-13 16:39:01 <Amir1> yes
2019-02-13 16:39:11 <rhinosf1> enwiki
2019-02-13 16:39:23 <Amir1> for whatever reason $toolbar = $( '#wpTextbox1' ); doesn't work
2019-02-13 16:39:45 <Amir1> yannf: can you run "$toolbar = $( '#wpTextbox1' );" in your console and tell me what you get?
2019-02-13 16:40:01 <rhinosf1> I'm trying to query AfD closes on Evad37 (as he's at RfA)
2019-02-13 16:40:10 <Amir1> then run "$toolbar.wikiEditor"
2019-02-13 16:41:21 <yannf> Amir1, jQuery.fn.init {}
2019-02-13 16:41:24 <Amir1> rhinosf1: actually, you can have higher timeout by querying the database directly through quarry.wmflabs.org
2019-02-13 16:41:37 <Amir1> rhinosf1: have you worked with it?
2019-02-13 16:41:39 <yannf> __proto__: Object(0)
2019-02-13 16:41:51 <rhinosf1> No Amir1
2019-02-13 16:42:07 <Amir1> yannf: it can't find your textbox :/ something has changed that
2019-02-13 16:42:29 <Amir1> rhinosf1: is it okay if I write the query for you?
2019-02-13 16:42:54 <rhinosf1> Definitely Amir1
2019-02-13 16:43:52 <yannf> jQuery.fn.init [textarea#wpTextbox1.mw-editfont-monospace]
2019-02-13 16:44:17 <milimetric> Amir1: I can mess with this query if you want
2019-02-13 16:44:47 <Amir1> milimetric: sure thing! it's fun it doesn't have a limit, try adding that
2019-02-13 16:45:11 <milimetric> rhinosf1: what would've been the startdate in the query you were running? That tool is trying to pass it in the regex for the page title
2019-02-13 16:47:13 <rhinosf1> Last 2-3 months would probably be good enough - I think it was doing last 250 AfDs in the check
2019-02-13 16:47:35 <jem> Hi, when it's possible I'd need some advice, bawolff knows about it
2019-02-13 16:49:09 <milimetric> rhinosf1: right, but I'm not familiar with these page titles, so the query looks for titles that DO match Articles_for_deletion%, but DO NOT match Articles_for_deletion/Log/%<<some-start-date-goes-here>>
2019-02-13 16:49:18 <Amir1> jem: how can we help?
2019-02-13 16:49:25 <milimetric> so I was wondering what the "some-start-date-goes-here" should be to make the query work
2019-02-13 16:50:03 <jem> Amir1: I'm having some very very strange issues when logging in with my bot with action=login
2019-02-13 16:50:37 <shreyasminocha> o/
2019-02-13 16:50:38 <Volker_E> Lucas_WMDE: Do you feel comfortable with me to merge at least the non-icon change patches like https://gerrit.wikimedia.org/r/c/mediawiki/extensions/Wikibase/+/490358?
2019-02-13 16:50:41 <jem> The current situation is that sometimes it is ok, sometimes it fails, with the same password and from the same host
2019-02-13 16:50:59 <yannf> Amir1, see pm
2019-02-13 16:51:02 <Amir1> jem: are you using botpasswords?
2019-02-13 16:51:17 <jem> No, just action=login with two steps
2019-02-13 16:51:22 <rhinosf1> millimetric - Yes??
2019-02-13 16:51:32 <jem> It began to fail after problems with the server, and then it was throttled... now I just don't know
2019-02-13 16:51:41 <milimetric> rhinosf1: I was wondering what the "some-start-date-goes-here" should be to make the query work
2019-02-13 16:52:33 <jem> I still believe it is related to throttling because from a third server it has no problems
2019-02-13 16:53:15 <Lucas_WMDE> Volker_E: yeah, sure
2019-02-13 16:53:17 <jem> But first in WM-ES server and this morning in Toolforge, it has
2019-02-13 16:53:26 <Amir1> jem: It's very possible. We need to dig the logs. Can you send me username of the bot?
2019-02-13 16:53:26 <jem> *since this morning
2019-02-13 16:53:28 <Lucas_WMDE> (but CI seems to be broken at the moment, due to the WMCS outage I guess?)
2019-02-13 16:53:34 <jem> Yes Amir1: Jembot
2019-02-13 16:53:35 <Amir1> (private message if you prefer)
2019-02-13 16:53:42 <jem> No problem :)
2019-02-13 16:53:42 <Amir1> okay
2019-02-13 16:54:03 <rhinosf1> millimetric - Id be unsure - Amir1, you understand?
2019-02-13 16:54:11 <jem> A few minutes ago I've been doing more tests, from WM-ES and from the third server
2019-02-13 16:54:20 <jem> And from WM-ES it justs fails randomly
2019-02-13 16:54:30 <milimetric> rhinosf1: I'm seeing examples like Articles_for_deletion/Log/2005_March_29
2019-02-13 16:55:13 <milimetric> it's weird, it's as if the query tries to exclude a single day of Article_for_deletion titles
2019-02-13 16:55:30 <milimetric> maybe I'll just ignore that for now, and you can see what the results are without it
2019-02-13 16:55:31 <Amir1> jem: In the logs there are two UAs that try to log in to that account
2019-02-13 16:55:49 <Amir1> the first one succeeds the second is giving wrong passowrd
2019-02-13 16:57:13 <Amir1> jem: so you have the right passowrd in one of the tools and wrong password in the other (or someone is trying to break into your bot's account)
2019-02-13 16:57:52 <rhinosf1> Millimetric- so some data might be missing???
2019-02-13 17:01:12 <milimetric> rhinosf1: no, there will just be extra data
2019-02-13 17:01:24 <milimetric> that check was in the negative, so it would exclude. Leaving it out means more will be included
2019-02-13 17:01:30 <milimetric> rhinosf1: ok, I gotta run but I got your query here:
2019-02-13 17:01:30 <milimetric> https://quarry.wmflabs.org/query/33384
2019-02-13 17:01:36 <milimetric> it looks like there are no results
2019-02-13 17:01:55 <milimetric> Amir1: if you want to check my logic, feel free, but it looks like that user has no results for this query, meaning I guess no AfD?
2019-02-13 17:02:08 <milimetric> rhinosf1: if you know of a counter-example, let me know and I'll see where the query went wrong
2019-02-13 17:02:39 <Amir1> I need to go to a meeting right now
2019-02-13 17:02:46 <Amir1> will check later. Sorry
2019-02-13 17:03:25 <jem> (Thanks, Amir1, we're in private now)
2019-02-13 17:04:09 <rhinosf1> millimetric- You could try against me as I should have a few closes
2019-02-13 17:05:50 <milimetric> rhinosf1: is your wiki name also rhinosf1?
2019-02-13 17:06:02 <rhinosf1> Yes millimetric
2019-02-13 17:07:10 <milimetric> rhinosf1: no it's not :) https://en.wikipedia.org/wiki/User:Rhinosf1
2019-02-13 17:09:14 <rhinosf1> Oh yeah didn't think about caps.
2019-02-13 17:09:32 <rhinosf1> ^milimetric
2019-02-13 17:09:53 <milimetric> rhinosf1: how do you spell it exactly, because that one still doesn't exist
2019-02-13 17:10:04 <milimetric> like, send me a link to your actual user page
2019-02-13 17:10:56 <rhinosf1> https://en.wikipedia.org/wiki/User:RhinosF1
2019-02-13 17:14:56 <rhinosf1> Millimetric - Is that working?
2019-02-13 17:22:59 <jem> Hi again, I have used botpasswords for my login problem but I'm still stuck or I don't understand it...
2019-02-13 17:24:05 <jem> I just gave permissions to the bot, the page returned a new password and... this is it? the API code is still the same, two steps, just with the new password?
2019-02-13 17:24:33 <jem> (I tried and I still get incorrect password, of course)
2019-02-13 17:24:55 <pajz> Hi, if I use two-factor authentication and my old cell phone with the Google Authenticator app is broken, is there a way to maintain my existing 2FA setup when reinstalling the app on my new phone, or do I have to disable and re-enable 2FA, and then set it up all afresh (I suppose that would work?)? Or do I have to do something else?
2019-02-13 17:26:19 <rhinosf1> Need to go again, either ping me or use PM to follow up (PM might be easier)
2019-02-13 17:27:17 <Volker_E> Amir1: milimetric: thanks for helping Gopa! Gopa: Let me know when you want more feedback
2019-02-13 17:28:13 <Gopa> Thanks Volker_E for reaching me Sure :)
2019-02-13 17:28:17 <Volker_E> Gopa: We've got SVGs with OOUI widgets as downloads in the Design Style Guide repo's 'resources' folder https://github.com/wikimedia/WikimediaUI-Style-Guide
2019-02-13 17:28:23 <Volker_E> There's also the Sketch files
2019-02-13 17:29:07 <Volker_E> WMDE designers also use Figma as alternative design tool
2019-02-13 17:29:08 <Volker_E> https://www.figma.com/
2019-02-13 17:29:10 <Gopa> But Sketch can be used only in mac os I guess ?
2019-02-13 17:29:15 <Volker_E> indeed
2019-02-13 17:29:33 <Volker_E> Figma is web-based and hence cross-platform
2019-02-13 17:29:53 <Volker_E> it has SVG import as well
2019-02-13 17:30:29 <Gopa> Ookay I'm going through :)
2019-02-13 17:33:14 <Volker_E> Gopa: when looking at Special:ViewData screenshot https://ibb.co/QKz1rjc I would recommend to evaluate if all fields are needed from the beginning
2019-02-13 17:33:15 <jem> Any help? This is getting worse :(
2019-02-13 17:34:22 <Volker_E> or if some of those could be hidden by default. General rule: Less user inputs needed leads to better form conversion and simpler usage
2019-02-13 17:34:29 <Gopa> yeah all the fields are needed to pass the sql query.
2019-02-13 17:34:50 <Volker_E> Give them options to fill out when they really need them, not all the options there are
2019-02-13 17:35:21 <Volker_E> so are some of those fields pre-fillable, like you've said and dependent on others in the form?
2019-02-13 17:36:12 <Gopa> No :)
2019-02-13 17:37:50 <Gopa> but somethings like table names, fileds we can make the user autofillable if atleast the user types first two charecters of the Table_Name or such things. I hope you understood ?
2019-02-13 17:38:34 <MatmaRex> jem: i think you need to use "<botname>@<botpassword>" as your password when logging in. where <botname> is the name you input in the "Bot name:" field, and <botpassword> is the generated password
2019-02-13 17:41:39 <jem> MatmaRex: Thanks, I'll try
2019-02-13 17:43:56 <jem> No, fail again :(
2019-02-13 17:48:44 <Volker_E> Gopa: I guess you meant autocomplete… yes, that would be an improvement
2019-02-13 17:49:45 <Volker_E> Gopa: if I understand you correctly, you're saying that every form input needs to be filled out before 'submitting'
2019-02-13 17:50:15 <Volker_E> btw, I'd consider renaming the button from 'submit' to 'View data' or 'View'
2019-02-13 17:53:00 <jem> MatmaRex: After reading again, it seems that the user name must be changed to -jem-@Jembot, but the Jembot account still has the old password (I just did a web login), so who will be those edits assigned to?
2019-02-13 17:53:56 <Gopa> Sorry Volker_E I expressesd autofilling in the wrong way, I actually ment to say, Lets assume the table name is "Employees", If the user just types 'Em', It has the particular input box has to autofill 'Employees'
2019-02-13 17:55:02 <Gopa> Yeah Your Idea seems coool to replace "Submit" with "View data", Thanks :)
2019-02-13 17:55:15 <milimetric> rhinosf1: ok, here's what I got as a result:
2019-02-13 17:55:18 <milimetric> https://www.irccloud.com/pastebin/khhkx2Ug/
2019-02-13 17:55:41 <MatmaRex> jem: there are actually two ways to log in with a botpassword - username=username, password=botname@botpassword; or username=username@botname, password=botpassword. both of these will log you in as "username" (the '@' character is normally invalid in usernames).
2019-02-13 17:56:09 <MatmaRex> (i forgot about the second way, i found the documentation after i already answered your previous question)
2019-02-13 17:56:36 <jem> Ok, now I see, it works but the edits are assigned to -jem-
2019-02-13 17:56:58 <jem> (I used the second way)
2019-02-13 17:57:18 <MatmaRex> note that the botpassword on your main account is not related to your separate bot account
2019-02-13 17:57:34 <jem> I'm noting that now
2019-02-13 17:57:36 <jem> So I guess I have to use Special:Botpasswords from inside the Jembot account
2019-02-13 17:57:38 <MatmaRex> you probably want to create another botpassword while logged in to your bot account
2019-02-13 17:57:41 <MatmaRex> yeah
2019-02-13 17:57:47 <milimetric> rhinosf1: so that's the same query but running for you. Running that with the other user you mentioned, Evad37, gives no results. That means that after October 1st, 2018, that user made no edits on pages called "Articles_for_deletion<<something>>". Unless those pages were deleted since then, for which you'd have to run the same query but inside of the archive table.
2019-02-13 17:58:35 <milimetric> rhinosf1: you can always edit this query: https://quarry.wmflabs.org/query/33384 by changing the user_id and the date
2019-02-13 17:59:09 <milimetric> for example your user_id is "select user_id from user where user_name = 'RhinosF1';" --> 34741242
2019-02-13 17:59:27 <jem> (And now I understand why I could give permissions from my user account to my bot account)
2019-02-13 18:00:10 <jem> Well... no, I see those permissions also appear now
2019-02-13 18:03:30 <rhinosf1> Millimetric-that covers AfD edits not specific closes.
2019-02-13 18:08:04 <rhinosf1> Evad37 makes little edits might have to widen search range.
2019-02-13 18:09:11 <rhinosf1> (to that area)
2019-02-13 18:10:30 <rhinosf1> Would it be possible to go back to 2014?
2019-02-13 18:10:53 <rhinosf1> That's the last votes (not sure on close)
2019-02-13 18:12:17 <jem> MatmaRex: Ok, things look good, but now it seems the second login with token isn't needed, but it is not clear for me when it is needed and when it isn't
2019-02-13 18:36:21 <jem> Ok, MatmaRex, I think all is working now with BotPasswords... thanks again for the help :)
2019-02-13 18:54:13 <Gopa> Volker_E: I have made a patch by taking your suggestion, but I always wonder why jenkins is always bad with me ^_^'
2019-02-13 18:54:22 <Gopa> https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Cargo/+/490384/
2019-02-13 19:06:17 <Gopa> haa got it, I was in the old branch, cherry picked to the master now, fixed the problem :)
2019-02-13 19:25:51 <milimetric> rhinosf1: yeah, you see where it says rev_timestamp >= '20181001000000'? Just change that to rev_timestamp between '20140101000000' and '20140701000000'. That would search the first 6 months of 2014, and you can do a similar thing to search the next 6 months. I would recommend searching 6 months at a time, that's what seems to be about on the border of what will execute quickly
2019-02-13 19:26:19 <milimetric> rhinosf1: and you can play with the title you're searching for, the page_title like ... clause
2019-02-13 19:46:27 <rhinosf1> Okay, what about looking for AfD closing. It would need to search for certain content being added/removed millipede
2019-02-13 20:05:02 <milimetric> rhinosf1: if you need to search for pages being deleted, you can look in the archive table. If you have a very precise question you can write it on the Quarry talk page: https://www.mediawiki.org/wiki/Talk:Quarry
2019-02-13 20:05:43 <milimetric> rhinosf1: if you write your questions well there, people can help you work on the query to run. Make sure to include a link to the query I sent you or any modified version of it that you're working on.
2019-02-13 20:14:14 <rhinosf1> I might try there later in the week.

This page is generated from SQL logs, you can also download static txt files from here