[17:51:01] Analytics / EventLogging: Cleaning up of some (?) EventLogging schemata for Growth - https://bugzilla.wikimedia.org/68931 (christian) NEW>RESO/FIX [19:43:31] qchris_away, when you get back, got a sec for a quick question around XFFs? [20:50:46] Analytics / Tech community metrics: "Age of unreviewed changesets by affiliation" shows negative number of changesets - https://bugzilla.wikimedia.org/70600#c6 (Quim Gil) Álvaro, when do you think we will have a solution for this problem? This is the last bug in http://korma.wmflabs.org/browser/gerrit_... [22:36:16] Ironholds: What's up with XFFs? [22:36:49] qchris, ack, sorry, resolved and I forgot to update in here. My bad :( [22:37:01] No worries. [22:37:04] :-) [22:37:16] Erik and I were discussing how he handled spider identification, and he got confused between the read and edit identification, and informed me that any IP with more than N requests in a time period would be excluded [22:37:30] ...at which point I went "..wait. But, HTTPS.". We got it worked out. [22:38:58] I do not fully follow ... but if you got it worked out ... all the better :-D [22:49:02] qchris: Are you there? If not, can someone PM me an email address for them? [22:49:24] andrewbogott: Who is "them"? [22:49:39] my email address is christian@quelltextlich.at [22:49:48] 'them' is you :) [22:50:26] qchris: You have quite a lot of labs instances with broken puppet. Can I count on you to catch them up to the ldap change sometime soon? [22:50:58] I was going to fix them myself but quickly noticed that puppet is explicitly disabled on qchris-master (which rules over many of the other troubled instances) [22:50:59] Oh. We should update them. I missed that. [22:51:03] and I didn't want to break things too much :) [22:51:19] I do not use ldap much there ... [22:51:29] So I guess I just kill them and recreate them. [22:51:32] you do, actually :) [22:51:56] ldap governs every single user account. So every time you log in it involves an ldap check [22:52:13] Right :-) [22:52:26] But, yeah, fix puppet or recreate the instances, either way is fine with me :) [22:54:14] Anyway, I'll keep my hands off those instances until later tomorrow :) [22:54:37] Ok. I'll take care of all that start in "qchris-" [22:54:50] Any other instances that I should go over? [22:55:35] hm… zookeeper0 relies on a puppetmaster that doesn't exist anymore. I think that's also in the analytics project [22:55:59] I guess that's an ottomata instance. [22:56:03] I'll ping him. [22:56:06] The full list of troubled instances is here: https://wikitech.wikimedia.org/wiki/Ldap_rename [22:56:18] Thanks! [22:56:24] Totally unsorted, though -- I'll see if I can produce a similar report sorted by project or something [22:56:47] When I generated that report I was expecting the list to be… smaller [22:56:49] kafka ones too. [22:57:10] yeah [22:57:38] Ok ... there are even more analytics instances. [22:57:44] I'll reach out to the team as a whole. [22:57:54] Yeah, looks like more or less all of them. y'all must like your role::puppet::self [22:58:06] Totally! [22:58:08] :-) [22:58:30] Sorry about the short notice -- generally I try to leave multiple weeks for something like this but I'm pinched between not having had a new ldap server until a few days ago and the impending doom of the old one in Tampa. [22:59:03] We only have one problematic instance (wikimetrics1) [22:59:14] I guess we need to update that one. [22:59:32] That might take some time. [23:00:31] how is that one different? [23:01:09] It serves Wikimetrics ... a service analytics considers to be "production". [23:01:27] This is bad in many ways, but still ... that's the way it is. [23:02:15] Since the switch for the instances (although I saw the switch in the puppet repo) caught me a bit by surprise ... was there some [23:02:20] email with upgrading instructions? [23:05:15] sure, if you look in the labs list... [23:05:28] subject " IMPORTANT: ldap renaming" [23:05:40] There's the original announcement, and also bryan responded with a step-by-step [23:05:47] Oh ... labs list ... I am not on that one. ... I guess I should subscribe there. [23:05:52] yep! [23:06:03] Ok thanks. I'll point the analytics team to that email then. [23:06:05] https://lists.wikimedia.org/mailman/listinfo/labs-l [23:06:09] Thanks! [23:06:10] thanks