[02:14:30] I will let you know when I see Neha16 around here [02:14:30] @notify Neha16 [11:48:00] !help A few years ago I created a Tool-labs account with my nick Debenben. I don't have my password and ssh-key anymore. [11:48:00] Debenben: If you don't get a response in 15-30 minutes, please create a phabricator task -- https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?projects=wmcs-team [11:48:33] Would it be possible to reset it or delete it, so I can create a new one under that name? [12:06:47] Debenben: https://wikitech.wikimedia.org/wiki/Special:PasswordReset might help you [12:07:41] @annika thanks, that worked [14:17:13] !log wikidata-dev wikidata-constraints upgraded Debian from Jessie (8) to Stretch (9) [14:17:14] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikidata-dev/SAL [14:49:53] hi! on T194380 I'm enumerating some tools running on toolforge using a soon deprecated TLS ciphersuite (AES128-SHA). Apparently those tools are running on Mono 3.2.8 or 4.8.0, I'd like to know how the tool maintainer picks the mono version for its tool and what's the exact mono packages that we're using on the tools-exec nodes [14:49:53] T194380: Identify bots using AES128-SHA maintainers running on toolforge - https://phabricator.wikimedia.org/T194380 [14:51:00] basically.. because I've run some pretty basic tests on a docker container using mono 4.8.0 with the same DotNetWikiBot version, and I get a decent TLS setup, so apparently something is deprecated in the mono 4.8.0 setup provided on toolforge [14:51:47] vgutierrez: what is teh tool name do you know based on UA? [14:52:05] oh unless it's DotNetWikiBot :) [14:52:23] chasemp: I've identified two tools so far, https://tools.wmflabs.org/admin/tool/dibot and https://tools.wmflabs.org/admin/tool/mbh [14:52:52] vgutierrez: I think our only mono runtime is on the grid engine servers. That would mean that we are using packages from the Ubuntu Trusty apt repositories today. [14:53:06] AFAIK, dibot is using always mono 3.2.8 and mbh mono 4.8.0 [14:53:20] (from the UAs I've captured) [14:53:23] I think one of them is using a custom mono binary or something iirc [14:54:25] so they can upload their own mono runtime? [14:55:29] for https://tools.wmflabs.org/admin/tool/dibot I see https://phabricator.wikimedia.org/p/Dmitry89/ (maintainer) hasn't been around on phab in along time [14:56:08] vgutierrez: in the sense that they could upload one and run from their home dir yes [14:56:15] or the Tool's home dir anyway [14:56:44] ok, could you tell me which mono environment is provided by default? 3.2.8 or 4.8.0? [14:58:00] ii libmono-2.0-1 3.2.8+dfsg-4ubuntu1.1 amd64 Mono JIT library (Default version) [14:58:24] awesome, thx [14:59:20] it would be possible to provide an up-to-date mono environment? It would be great to provide the users a mono version that's able to comply with our own TLS requirements :) [15:01:14] vgutierrez: apt-cache policy mono-runtime says that's the latest in Trusty repos, we would have to package something up I expect, so definitely but I'm unsure of the effort required [15:07:06] chasemp: cool thx, I'd try to set up a mono environment running on Trusty that's able to talk modern TLS and I'll get back to you [15:08:12] vgutierrez: kk, Toolforge has its own little apt repo for situations like this fyi so it wouldn't need to pollute anything else but yeah no idea how much work making that sane is, tx for thinking about it [17:18:34] annika: thanks again for helping out while we Ops were asleep :) [17:18:55] np :) i used to do that in the past [18:24:11] bd808: I've just did https://gerrit.wikimedia.org/r/433016 -- hope it's okay [23:51:38] Yo. [23:51:50] It looks like someone (re?)instated a 60-minute query killer? [23:51:57] My SQL query keeps getting killed after an hour. [23:56:13] Ivy: are you running against the *.web replicas or the *.analytics ones? As far as I know only the analytics one is actively running a query killer. We are having problems from the last round of changes to the `page` view layer though so it is possible that the DBAs turned on a killer everwhere. [23:56:45] err... only the web should in theory be running a killer [23:58:23] the `page` issue is T194341 [23:58:23] T194341: SELECT query on page table appears to also reference revision table - https://phabricator.wikimedia.org/T194341