[00:02:21] I think I do. I just don't remember where I ssh to. [00:04:43] hmm, but then maybe I don't? https://wikitech.wikimedia.org/w/index.php?title=Special:Ask&offset=0&limit=500&q=%5B%5BCategory%3AShell+Access+Requests%5D%5D%5B%5BIs+Completed%3A%3Atrue%5D%5D&p=format%3Dbroadtable%2Fheaders%3Dshow%2Fsearchlabel%3DCompleted-20Requests%2Fdefault%3D%28No-20completed-20requests%29&po=%3FShell+Justification%0A%3FModification+date%0A&sort=Modification+date&order=asc doesn't mention me. [00:07:48] huh. Things seem to have changed since Feb 2012... Perhaps my inactive account was killed?! [00:08:11] does Wikitech not use SUL? [00:08:29] No [00:08:37] What's your username? [00:08:56] oh. I _did_ definitely have an account, on some wiki with a lot of mentions of "nova", if memory serves. Was that not wikitech? [00:09:11] It was. [00:09:49] aha: "There was either an authentication database error or you are not allowed to update your external account." [00:10:02] which suggests I _do_ have a shell account, but not a wikitech account. Now what? [00:12:45] (relying on this message: "The error message "There was either an authentication database error or you are not allowed to update your external account." generally indicates an invalid shell account name was used (see bug 16524)." [00:13:20] Ryan_Lane, do you remember, maybe? [00:13:38] Coren, ^ [00:19:06] abartov: yes, usually means that [00:19:37] Ryan_Lane, thanks, so how do I now create an account on wikitech? [00:21:31] abartov: https://wikitech.wikimedia.org/w/index.php?title=Special:UserLogin&returnto=Main+Page&type=signup [00:21:59] Ryan_Lane, but... wasn't that what I just tried? [00:22:14] I couldn't specify 'abartov' as my shell account because it already exists. [00:22:18] one sec [00:22:38] your user account is Abartov [00:22:43] as well as your shell accountname [00:23:04] my shell account is capital A? [00:23:08] no [00:23:11] ah! Successfully logged in. [00:23:13] just your username [00:23:14] ok, whew :) [00:23:44] ok, so I have my login and my shell account name. How do I get a machine to work on? [00:24:07] what are you going to be working on? [00:24:21] you need to be added to a project, or a project needs to be created for your work [00:25:32] Oh. I'm interested in working on a bunch of improvements to Mediawiki-gateway (the Ruby API client), as well as the DumpHTML extension, and possibly some related bots (i.e. related to dumping and offline generation). [00:25:56] for bots, you'd want to use the tools project [00:26:18] let me add you to that and link you to the docs [00:26:21] !tools-help [00:26:21] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [00:27:09] thanks! [00:27:11] no need to make an access request to tools. I've already added ou [00:27:12] *you [00:27:17] but follow the rest of the docs [00:27:24] what's the difference from the "Bots" group? [00:27:31] bots was the old project [00:27:36] ok [00:27:51] tools is the new project, which has a proper privacy policy and a set of admins that have NDAs [00:29:45] abartov: hm. it's late on a friday. I can help you find a proper place for the rest later [00:29:46] I was denied access to tools-login.wmflabs.org. But I uploaded my SSH key maybe a minute ago. Will this be resolved in a couple of minutes? [00:29:51] yes [00:30:04] cool, no worries, thanks! [00:30:08] it takes a bit for your key to be added to the share [02:11:44] New review: coren; "Took some time, but LGM." [labs/toollabs] (master) C: 2; - https://gerrit.wikimedia.org/r/70771 [02:17:33] New review: coren; "Builds properly." [labs/toollabs] (master); V: 2 - https://gerrit.wikimedia.org/r/70771 [02:17:33] Change merged: coren; [labs/toollabs] (master) - https://gerrit.wikimedia.org/r/70771 [07:06:26] wm-bot dced? [07:06:34] poor freenode [07:06:52] they really need to get at least 1 server that can hold uptime at least a week [07:44:45] freenode needs a bether dDos protection. [07:54:06] Steinsplitter: not *.net *.split [07:54:24] o_O [07:56:27] I am running http://meta.wikimedia.org/wiki/WM-Bot version wikimedia bot v. 1.10.16.0 my source code is licensed under GPL and located at https://github.com/benapetr/wikimedia-bot I will be very happy if you fix my bugs or implement new features [07:56:45] petan: ^ wm-bot working [08:55:02] zhuyifei1999 net split is result of ddos [08:55:47] and dDos is verry evil o_O [08:56:58] Coren: http://superuser.com/questions/618687/why-do-programs-on-linux-kernel-eat-so-much-more-vmem-than-resident-memory [11:47:34] petan: The answer is very shitty, actually. [12:04:26] Coren hm, at some point it is, but no better answer so far [12:04:44] Correct answer: [12:05:00] if you know a better answer you better send it there :P [12:05:37] vmem is the sum of the *maps* of the process, so: the executable, all the shared libraries, etc and finally the actual allocated data. [12:05:43] btw it say virt memory contains also size of all open files by process [12:05:55] petan: No, that's just insane. [12:06:24] petan: If you mmap() a file, it will (because it's a map). But only if you actually mmap() not just open/read/etc [12:07:26] petan: Want to see what exactly eats the vmem? Check /proc//maps [12:07:36] hmm [12:07:54] there should be some command for that [12:13:54] AzaToth hey [12:13:58] can u help with http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=715315 [12:24:10] petan: what you need help with? [12:24:18] it's rfp [12:24:28] so you want me to itp it? [12:24:37] I need either someone who make a proper package from it or some help with making it :D [12:24:42] I am just reading tutorial [12:24:47] heh [12:24:50] but I guess I can't itp myself [12:25:38] also latest version is 1.2.4 no idea how to bump it [12:25:39] well, offcourse you can itp it yourself [12:26:10] the version isn't that important to keep updated on a rfp [12:26:19] k [12:26:55] what you might want to do it join #debian-mentors on irc.debian.org [12:29:43] hmm irc://irc.debian.org/#debian-mentors is a 1 click link ;) [12:34:22] AzaToth is there a tutorial? [12:34:38] I am following http://www.debian.org/doc/manuals/maint-guide/index.en.html it's unhelpful [12:36:20] petan: ask the people there in the channel, they are usually helpful and are able to help you better than I can [13:06:17] @trusted [13:06:17] I trust: petan!.*@wikimedia/Petrb (2admin), .*@wikimedia/.* (2trusted), .*@mediawiki/.* (2trusted), .*@wikimedia/Ryan-lane (2admin), .*@wikipedia/.* (2trusted), .*@nightshade.toolserver.org (2trusted), .*@wikimedia/Krinkle (2admin), .*@[Ww]ikimedia/.* (2trusted), .*@wikipedia/Cyberpower678 (2admin), .*@wirenat2\.strw\.leidenuniv\.nl (2trusted), .*@unaffiliated/valhallasw (2trusted), .*@mediawiki/yuvipanda (2admin), [13:07:02] * Damianz doesn't trust wm-bot [13:15:51] @untrusted [13:16:07] I am running http://meta.wikimedia.org/wiki/WM-Bot version wikimedia bot v. 1.10.16.0 my source code is licensed under GPL and located at https://github.com/benapetr/wikimedia-bot I will be very happy if you fix my bugs or implement new features [13:16:12] AzaToth: ^ [13:16:20] ツ [14:39:10] Coren: around? [14:39:39] i created a new tool and then try "become" [14:39:43] and get "sudo: sorry, a password is required to run sudo" [14:40:05] i can "become" for my already existing tool [14:46:58] ok, it works now :) [14:47:01] patience..... [14:54:17] what's your tool 4 [14:54:34] * OrenBochman guesses wikidata ... [15:03:40] OrenBochman: no :) [15:03:59] for my bot [15:50:15] @notify AzaToth [15:50:16] This user is now online in #wikimedia-dev. I'll let you know when they show some activity (talk, etc.) [16:01:37] AudeBot! [16:06:17] o.o [16:23:42] aude: yes you operate a bot! neat [16:23:50] I forgot [16:24:58] how can I find which fields in a mysql table/view are indexed ? Specificaly revision_userindex [16:26:17] my queries are still taking too too long [16:27:48] I've created a query to calculate how much time a user spends editing ... [16:40:35] I'm here now. And yes, there is a ~1-2 min delay before permissions for new service groups propagate. :-) [18:30:57] OrenBochman, take a look at mediawiki schema [19:49:44] Coren: Could you install cmake on -login? [19:56:12] Damianz: I would do that if you didn't want specificaly Coren... [19:56:30] petan: You work also [19:56:43] done [19:56:43] Coren just talked last :P [19:56:45] Thanks [19:56:50] :0 [19:57:08] Also - disk seems slow :( [19:57:26] * Damianz doesn't like a 30 second wait for a directory listing of an empty directory [19:57:26] yes I know :( [19:57:31] local or shared? [19:57:52] NFS probably, whatever shared homes are on under /data/ [19:58:02] Damianz: hint [19:58:05] -dev works faster :P [19:58:13] it also has lot of development tools including cmake [19:58:33] which is probably reason why we didn't have it on -login [19:58:39] But then I have to mess around copying files betwean hosts after building my libs [19:58:54] aren't you working on nfs? [19:59:30] Yes [19:59:32] you would have to work in /tmp as that is only local fs accessible to users [19:59:45] well, if you work on nfs, you don't need to copy files to hosts [20:00:08] For actually compiling maybe, my headers/objects need to live on nfs unless I static link the binary that I might just do anyway [20:00:45] If dev uses nfs too, it makes it no faster right now :P [20:01:00] at least nobody is using it [20:01:10] so nfs IO is the only what would slow you [20:02:43] Apart from the person running their bot on -login it oes pretty much nothing [20:03:12] hmm [20:04:42] I niced it [20:04:50] they shouldn't do that... [20:08:56] crap [20:11:27] .j #sql [20:15:36] Now I remember why I hate compiling things, so many dependancies [20:15:49] * Damianz goes to figure out what he can get you to install everywhere to compile the minimal amount possible [20:18:11] Platonides: this table is not documented [20:21:51] If anyone up to optimising some sql have a look at http://sqlfiddle.com/#!2/09c4d1 and see if you can reduce it from O(N^2) to O(N) ? [20:22:51] or less ;-) [20:57:09] OrenBochman: optimize a insert? [20:58:17] OrenBochman: I assume you forgot to include a query [20:59:30] OrenBochman: the current query is O(0) ツ [21:13:48] Coren: ping [21:35:10] OrenBochman, revision_userindex isn't a table [21:35:40] it's the revision table but with less data so the userindex can be used [22:05:21] [bz] (8NEW - created by: 2Quim Gil, priority: 4Normal - 6enhancement) [Bug 51050] Connecting wikitech.wikimedia.org user profiles with community metrics - https://bugzilla.wikimedia.org/show_bug.cgi?id=51050 [23:54:07] sorry the query is missing indeed [23:55:18] perhaps this one will work http://sqlfiddle.com/#!2/09c4d1/3/0