[00:12:12] !log tools.bd808-pywikibot Running delete.py to clean up Nova_Resource instance pages [00:12:14] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.bd808-pywikibot/SAL [00:13:53] wtf. that script doesn't actually delete the pages? [00:20:07] ah. I have to config a 'sysop' account for pywikibot somehow [00:52:22] 06Labs, 10wikitech.wikimedia.org: Get rid of SemanticMediaWiki/SRF/SF from wikitech.wikimedia.org - https://phabricator.wikimedia.org/T53642#3162367 (10bd808) [03:53:53] !log tools.bd808-pywikibot Running delete.py to clean up Nova Resource:I-* pages [03:53:55] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.bd808-pywikibot/SAL [07:35:34] PROBLEM - Free space - all mounts on tools-docker-builder-04 is CRITICAL: CRITICAL: tools.tools-docker-builder-04.diskspace.root.byte_percentfree (<10.00%) [08:05:48] Are these projects closed source? Where can I learn more about the projects ? https://tools.wmflabs.org/openstack-browser/ [08:08:42] metaphysician, by policy, "Tool Labs projects must be open source software licensed under an OSI approved license." Tool Labs projects must be open source software licensed under an OSI approved license." https://wikitech.wikimedia.org/wiki/Portal:Tool_Labs [08:10:01] now every owner is responsible for documenting it and linking to its source code [08:10:08] jynus: I mean the Wikimedia Labs projects hosted on OpenStack. [08:10:57] same thing, I would say [08:12:23] get in contact with the owners for details if they have not published them themselves [08:14:48] OK. Found info for one of the projects: https://discourse.wmflabs.org/ https://meta.wikimedia.org/wiki/Discourse [08:15:08] yeah, somtimes they are a bit spread over the wikis [08:15:28] I think one of the projects is to make those better discoverable [08:18:17] 06Labs, 10Wikidata: Puppet alert - https://phabricator.wikimedia.org/T162430#3162715 (10Magnus) [08:32:20] 06Labs, 10Wikidata: Puppet alert - https://phabricator.wikimedia.org/T162430#3162760 (10Lydia_Pintscher) a:03hoo @hoo will delete the instance on Tuesday next week. That should solve the issue. [08:34:06] 06Labs, 10Wikidata: Puppet alert from wikidata-mobile labs VM - https://phabricator.wikimedia.org/T162430#3162765 (10hoo) [10:05:10] we have to link to the source code now? *reads* [10:08:30] jynus: uh, i can't find anything anywhere saying so [10:21:41] jynus, I didn't claim that [10:21:52] I said all projects must be open source [10:22:01] 08:10 < jynus> now every owner is responsible for documenting it and linking to its source code [10:22:05] what does that say? [10:22:08] yes [10:22:16] meaning that I will not do it [10:22:32] oh [10:22:47] if you do not do it, the police will not chase you :-) [10:23:27] but expect emails and pings asking for it from other users [10:23:31] that is what I meant [10:26:02] it depends on the project, if you have a project called "mediawiki-testing", probably nobody will ask for the code [10:26:32] if you have a project called "secret-sauce-for-combating-vandalims", probably others will :-) [10:33:10] maybe I was missing a comma? [10:33:24] "now[,] every owner is responsible for documenting it and linking to its source code" [11:10:11] 4TB RAM just for the Discourse instance which is mostly lying idle! Why does it need so much memory for? https://tools.wmflabs.org/nagf/?project=discourse [11:34:03] #en.wikipedia on irc.wikimedia.org is quite colorful and fun [12:43:26] metaphysician: try #wikidata.wikipedia there [12:43:29] moar fun [13:33:55] 06Labs, 06Operations: create a 'root' group strictly for labs/cloud services infrastructure - https://phabricator.wikimedia.org/T162404#3163839 (10chasemp) @MoritzMuehlenhoff (quoting you here just because gerrit sucks for these things) > That's fine. But IMO the access::groups host definitions in Hiera shou... [13:48:25] Hello everybody. I just joined the other day and I hope to be able to be contributing with some usable tools. Mainly things that have to do with IP number info, blacklists and stuff like that for tracking vandals etc. First attempt is under development but live at https://tools.wmflabs.org/ipinfo/ [13:50:28] rompert: that's a good start on something [13:50:35] where does it come up with the random ip's? [13:52:01] I wonder if ban or abuse semantics are available programmatically from various wiki's [13:52:41] the random ip:s are currently just random. i was thinking to fetch the latest ones from ipblocks, but ... for some reason my query takes 1 second, seems the table is missing some index or whatnot. [13:52:52] SELECT ipb_address, ipb_by_text, ipb_timestamp, ipb_expiry, ipb_reason FROM ipblocks where ipb_address is not null order by ipb_timestamp desc limit 10; [13:53:54] i just did a query like that myself, and it seems the latest banned ip is quite nicely listed in the dnsbl:s https://tools.wmflabs.org/ipinfo/q/66.50.105.185 [13:57:55] (03PS1) 10Alexandros Kosiaris: Add profile::backup::director::dbpass dummy pass [labs/private] - 10https://gerrit.wikimedia.org/r/346993 [13:58:15] (03CR) 10Alexandros Kosiaris: [V: 032 C: 032] Add profile::backup::director::dbpass dummy pass [labs/private] - 10https://gerrit.wikimedia.org/r/346993 (owner: 10Alexandros Kosiaris) [14:00:16] rompert: I wonder if you could scrape something like http://www.senderbase.org/lookup/?search_string=76.218.34.111 as well [14:00:24] the whole "scoring" world [14:04:40] chasemp: sure i'll look into it. i prefer clean API:s though. or semi-clean . [14:04:56] understood, just a thought but it would be a pain [14:05:49] hmmm... did someone just add an index on ipblocks? because during a few days until now my query has always taken 1second, now it takes 0seconds :) thanks [14:06:33] chasemp: oh. a challenge. you know what makes me tick. challenge accepted [14:19:17] 06Labs, 06Operations: Standalone puppet masters are broken (uninstallable packages) - https://phabricator.wikimedia.org/T162462#3163952 (10MoritzMuehlenhoff) [14:31:41] chasemp: ok, half way there, need some serious parsing :). you wouldn't happen to have a good ip to check that is listed? https://tools.wmflabs.org/ipinfo/q/77.103.223.250 [15:09:33] rompert: Utf-8? https://tools.wmflabs.org/ipinfo/q/178.203.108.151 <-- the city is � well strange mangled [15:42:46] Wurgl: I hate when that happens. fixed, but there is a cache. it looks ok on for instance https://tools.wmflabs.org/ipinfo/q/178.203.108.152 . thanks for your help [15:44:25] UTF 8 is character set from hell [15:56:21] 06Labs, 06Operations: Standalone puppet masters are broken (uninstallable packages) - https://phabricator.wikimedia.org/T162462#3164111 (10Andrew) p:05Triage>03Normal a:03Andrew [16:01:12] Wurgl: heh. i guess i've turned to the dark side then. i try to convert everything into utf-8 as soon as possible everywhere. sure, strlen doesn't work nice on greek or smileys, but i can live with that. [16:04:28] The real dark side is the combination of UTF-8 and IPv6 :-) [16:07:32] Sagan: Query is nice, but "* Sagan :You must log in with services to message this user" � so � read only for me and therefore ignored [16:07:49] Wurgl: oops [16:07:56] Wurgl: try now :o [16:14:53] Wurgl: yeah. i'm still hesitant towards ipv6. i think we shall abort that little project. everyone i care about already has an ipv4 number. [16:17:19] My provider does not support IPv6 yet(?), the one before did not too. Thats why I do not like it [17:05:21] 06Labs, 06Operations: Standalone puppet masters are broken (uninstallable packages) - https://phabricator.wikimedia.org/T162462#3164217 (10Andrew) This is from the pinning in https://gerrit.wikimedia.org/r/#/c/300870/ -- jessie-backports has upgraded their puppet package which causes conflicts. [17:15:24] 06Labs, 06Operations: Standalone puppet masters are broken (uninstallable packages) - https://phabricator.wikimedia.org/T162462#3164236 (10Andrew) We can add 3.8 packages to reprepro but that will affect puppet clients as well as masters, which we might not want. [17:17:36] 06Labs, 06Operations: Standalone puppet masters are broken (uninstallable packages) - https://phabricator.wikimedia.org/T162462#3164242 (10faidon) My suggestion, which needs a little more time to be fully tested is: - Take the latest 3.8 jessie-backport (from snapshot.debian.org), 3.8.5-2~bpo8+1, and put it in... [17:21:34] 06Labs, 06Operations: Standalone puppet masters are broken (uninstallable packages) - https://phabricator.wikimedia.org/T162462#3164263 (10Joe) Our production puppetmasters run on 3.8, several clients have been tested, and the agent should have minimal differences. I can take a look back at the changelog for... [19:55:12] PROBLEM - Puppet run on tools-webgrid-generic-1401 is CRITICAL: CRITICAL: 22.22% of data above the critical threshold [0.0] [19:58:43] PROBLEM - Puppet run on tools-exec-1405 is CRITICAL: CRITICAL: 55.56% of data above the critical threshold [0.0] [20:01:32] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/StanProg was created, changed by StanProg link https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/StanProg edit summary: Created page with "{{Tools Access Request |Justification=I will use it for development of wikimedia projects maintenance tools. The first tool that I would like to work on is related to the disa..." [20:10:10] RECOVERY - Puppet run on tools-webgrid-generic-1401 is OK: OK: Less than 1.00% above the threshold [0.0] [20:13:42] RECOVERY - Puppet run on tools-exec-1405 is OK: OK: Less than 1.00% above the threshold [0.0] [20:24:56] 06Labs, 06Operations, 10procurement: eqiad: (2) hardware access request for labvirt1019 and labvirt1020 (refresh) - https://phabricator.wikimedia.org/T162486#3164839 (10chasemp) p:05Triage>03Normal a:03RobH [20:25:32] 06Labs, 06Operations, 10procurement: eqiad: (2) hardware access request for labvirt1019 and labvirt1020 (refresh) - https://phabricator.wikimedia.org/T162486#3164827 (10chasemp) [20:25:35] 06Labs, 10DBA, 06Operations: eqiad: (2) hardware access request for labsdb1006 & 7 refresh - https://phabricator.wikimedia.org/T161755#3164860 (10chasemp) [20:25:37] 06Labs, 10DBA, 06Operations: eqiad: (2) hardware access request for labsdb1004 & 5 refresh - https://phabricator.wikimedia.org/T161754#3164861 (10chasemp) [20:35:40] Hi, I'm using vagrant, and updated the wiki via vagrant git-update, but there is still a database error: Function: UserGroupMembership::getMembershipsForUser [20:35:40] Error: 1054 Unknown column 'ug_expiry' in 'field list' (127.0.0.1) [20:35:53] that's the patch for the expiring rights, but how can I fix that? [20:38:31] Sagan: hmmm... so update.php somehow didn't fix that for you? [20:38:34] Sagan be sure the DB is accessiable [20:38:53] bd808: yeah, I used forachwiki update.php with --quick, but that did not help [20:39:04] git-udpate should do that too. [20:39:16] bd808: yeah, but I did it and that did not help too [20:39:21] I wonder if the migrations are messed up for that somehow [20:39:22] and I updated vagrant itself too [20:41:05] the patch is at maintenance/archives/patch-user_groups-ug_expiry.sql [20:41:19] you could try applying manually I guess [20:41:35] ok, I will try. Already dumped the DB before [20:42:13] it does look like that schema patch got updated so maybe that made something crazy [20:42:37] the mediawiki db maintenance stuff is magic to me [20:42:56] you might get better help in #wikimedia-tech or #mediawiki [20:43:06] ok, ty [20:43:21] I will try that manually first, in case it fails, I have my backup [20:44:41] Sagan: let me look at phab and see if theres other reports of this... [20:45:00] ERROR 1060 (42S21) at line 3: Duplicate column name 'ug_expiry' [20:45:01] huh [20:45:09] let me check if it works now at my instance [20:51:27] Sagan: sql? [20:53:11] Zppix: I tried to apply that sql patch, but as you can see it failed. I asked at -tech now [22:36:52] 10Tool-Labs-tools-Xtools, 06Community-Tech: [Epic] Rewrite XTools: Articleinfo - https://phabricator.wikimedia.org/T157602#3165292 (10kaldari) [22:36:53] 10Tool-Labs-tools-Xtools, 03Community-Tech-Sprint: Build new front-end for xtools-articleinfo - https://phabricator.wikimedia.org/T159395#3165291 (10kaldari) 05Open>03Resolved [22:56:15] 06Labs, 10wikitech.wikimedia.org: Get rid of SemanticMediaWiki/SRF/SF from wikitech.wikimedia.org - https://phabricator.wikimedia.org/T53642#3165371 (10bd808) [23:25:08] 06Labs, 10wikitech.wikimedia.org: Get rid of SemanticMediaWiki/SRF/SF from wikitech.wikimedia.org - https://phabricator.wikimedia.org/T53642#545071 (10bd808) * https://wikitech.wikimedia.org/wiki/Form:Nova_Project_Documentation can be deleted * https://wikitech.wikimedia.org/wiki/Form:Server can be deleted At... [23:43:23] 06Labs, 10wikitech.wikimedia.org: Get rid of SemanticMediaWiki/SRF/SF from wikitech.wikimedia.org - https://phabricator.wikimedia.org/T53642#3165463 (10demon) Hah, removing 'edit' from Form: means I can't even delete 😂