[00:07:06] Warning: There is 1 user waiting for shell: Chess64 (waiting 171 minutes) [00:07:07] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 174 minutes) [00:20:27] Warning: There is 1 user waiting for shell: Chess64 (waiting 184 minutes) [00:20:28] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 187 minutes) [00:33:47] Warning: There is 1 user waiting for shell: Chess64 (waiting 197 minutes) [00:33:48] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 200 minutes) [00:47:07] Warning: There is 1 user waiting for shell: Chess64 (waiting 211 minutes) [00:47:08] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 214 minutes) [01:00:27] Warning: There is 1 user waiting for shell: Chess64 (waiting 224 minutes) [01:00:28] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 227 minutes) [01:13:47] Warning: There is 1 user waiting for shell: Chess64 (waiting 237 minutes) [01:13:48] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 240 minutes) [01:27:07] Warning: There is 1 user waiting for shell: Chess64 (waiting 251 minutes) [01:27:08] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 254 minutes) [01:40:28] Warning: There is 1 user waiting for shell: Chess64 (waiting 264 minutes) [01:40:29] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 267 minutes) [01:53:48] Warning: There is 1 user waiting for shell: Chess64 (waiting 277 minutes) [01:53:49] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 280 minutes) [02:07:08] Warning: There is 1 user waiting for shell: Chess64 (waiting 291 minutes) [02:07:09] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 294 minutes) [02:20:28] Warning: There is 1 user waiting for shell: Chess64 (waiting 304 minutes) [02:20:29] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 307 minutes) [02:33:48] Warning: There is 1 user waiting for shell: Chess64 (waiting 317 minutes) [02:33:50] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 320 minutes) [02:47:09] Warning: There is 1 user waiting for shell: Chess64 (waiting 331 minutes) [02:47:10] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 334 minutes) [03:00:29] Warning: There is 1 user waiting for shell: Chess64 (waiting 344 minutes) [03:00:30] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 347 minutes) [03:13:49] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 357 minutes) Zhuyifei1999 (waiting 4 minutes) [03:13:50] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 360 minutes) [03:27:09] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 371 minutes) Zhuyifei1999 (waiting 18 minutes) [03:27:10] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 374 minutes) Zhuyifei1999 (waiting 5 minutes) [03:40:29] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 384 minutes) Zhuyifei1999 (waiting 31 minutes) [03:40:30] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 387 minutes) Zhuyifei1999 (waiting 18 minutes) [03:53:50] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 397 minutes) Zhuyifei1999 (waiting 44 minutes) [03:53:51] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 401 minutes) Zhuyifei1999 (waiting 31 minutes) [04:07:10] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 411 minutes) Zhuyifei1999 (waiting 58 minutes) [04:07:11] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 414 minutes) Zhuyifei1999 (waiting 45 minutes) [04:20:30] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 424 minutes) Zhuyifei1999 (waiting 71 minutes) [04:20:31] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 427 minutes) Zhuyifei1999 (waiting 58 minutes) [04:33:50] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 437 minutes) Zhuyifei1999 (waiting 84 minutes) [04:33:51] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 441 minutes) Zhuyifei1999 (waiting 71 minutes) [04:47:10] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 451 minutes) Zhuyifei1999 (waiting 98 minutes) [04:47:11] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 454 minutes) Zhuyifei1999 (waiting 85 minutes) [05:00:30] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 464 minutes) Zhuyifei1999 (waiting 111 minutes) [05:00:31] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 467 minutes) Zhuyifei1999 (waiting 98 minutes) [05:13:51] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 477 minutes) Zhuyifei1999 (waiting 124 minutes) [05:13:52] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 481 minutes) Zhuyifei1999 (waiting 111 minutes) [05:27:11] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 491 minutes) Zhuyifei1999 (waiting 138 minutes) [05:27:12] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 494 minutes) Zhuyifei1999 (waiting 125 minutes) [05:40:31] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 504 minutes) Zhuyifei1999 (waiting 151 minutes) [05:40:32] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 507 minutes) Zhuyifei1999 (waiting 138 minutes) [05:53:51] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 517 minutes) Zhuyifei1999 (waiting 164 minutes) [05:53:52] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 521 minutes) Zhuyifei1999 (waiting 151 minutes) [06:07:12] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 531 minutes) Zhuyifei1999 (waiting 178 minutes) [06:07:13] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 534 minutes) Zhuyifei1999 (waiting 165 minutes) [06:20:32] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 544 minutes) Zhuyifei1999 (waiting 191 minutes) [06:20:33] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 547 minutes) Zhuyifei1999 (waiting 178 minutes) [06:33:52] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 557 minutes) Zhuyifei1999 (waiting 204 minutes) [06:33:53] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 561 minutes) Zhuyifei1999 (waiting 191 minutes) [06:47:12] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 571 minutes) Zhuyifei1999 (waiting 218 minutes) [06:47:13] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 574 minutes) Zhuyifei1999 (waiting 205 minutes) [06:59:26] Warning: There are 2 users waiting for shell, displaying last 2: Chess64 (waiting 1 minutes) Zhuyifei1999 (waiting 1 minutes) [06:59:27] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 1 minutes) Zhuyifei1999 (waiting 1 minutes) [07:01:06] legoktm: but do a 'vim `which jsub`' [07:01:06] is very small [07:02:09] perl :/ [07:03:13] legoktm: yup, but still small [07:03:18] legoktm: if we're to write a wrapper, it should deal directly with th eunderlying stuff [07:03:19] than wtih jsub [07:03:21] probably [07:03:22] but i think it might even already exist [07:03:28] !rq Chess64 [07:03:28] https://wikitech.wikimedia.org/wiki/Shell_Request/Chess64?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Chess64?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Chess64 [07:03:41] !rq Zhuyifei1999 [07:03:41] https://wikitech.wikimedia.org/wiki/Shell_Request/Zhuyifei1999?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Zhuyifei1999?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Zhuyifei1999 [07:12:53] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 14 minutes) Zhuyifei1999 (waiting 14 minutes) [07:13:39] legoktm: liking flask so far? [07:13:56] petan: seen https://bugzilla.wikimedia.org/show_bug.cgi?id=49036 [07:13:57] ? [07:26:28] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 28 minutes) Zhuyifei1999 (waiting 28 minutes) [07:39:49] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 41 minutes) Zhuyifei1999 (waiting 41 minutes) [07:53:15] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 54 minutes) Zhuyifei1999 (waiting 54 minutes) [08:03:36] legoktm: any progress? [08:03:41] * YuviPanda has basic widget code running [08:06:35] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 68 minutes) Zhuyifei1999 (waiting 68 minutes) [08:20:01] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 81 minutes) Zhuyifei1999 (waiting 81 minutes) [08:33:30] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 95 minutes) Zhuyifei1999 (waiting 95 minutes) [08:46:51] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 108 minutes) Zhuyifei1999 (waiting 108 minutes) [09:00:20] Warning: There are 2 users waiting for access to tools project, displaying last 2: Tristessa de St Ange (waiting 121 minutes) Zhuyifei1999 (waiting 121 minutes) [09:13:45] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 135 minutes) [09:27:10] Warning: There is 1 user waiting for access to tools project: Tristessa de St Ange (waiting 148 minutes) [09:27:56] !tr Tristessa_de_St_Ange [09:27:57] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Tristessa_de_St_Ange?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Tristessa_de_St_Ange?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [09:28:43] !tr Zhuyifei1999 [09:28:43] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Zhuyifei1999?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Zhuyifei1999?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [09:36:29] WTF? [09:45:24] Proxy Error [09:45:24] The proxy server received an invalid response from an upstream server. [09:45:24] The proxy server could not handle the request GET /xtools/pcount/index.php. [09:45:24] Reason: Error reading from remote server [09:45:24] Apache/2.4.4 (Ubuntu) Server at tools.wmflabs.org Port 80 [09:45:57] If anybody knows what the problem is, please pm the answer to me. I'm going to be at work all day. [10:10:52] Cyberpower678 ? [10:16:14] petan: the Cyberpower678 problem it might come from our stats.php, I'm commenting it [10:46:16] !log tools petrb: created new instance for experiments with sasl memcache tools-mc [10:46:18] Logged the message, Master [10:48:50] @notify hashar [10:48:50] I'll let you know when I see hashar around here [11:15:27] hello [11:15:54] can someone add me to the Bots project? https://wikitech.wikimedia.org/w/index.php?title=Nova_Resource_Talk:Bots&diff=69057&oldid=69028 [11:18:01] Euku: sure you dont want to move to tools? [11:21:54] addshore: I think the tasks that my bot should do are not "tools". for now it should run as a standalone bot for de:wikip [11:22:26] Euku: ignore the namming of the projects :) [11:22:51] imagine that bots is actually called tools-testing [11:23:20] tools is made to be the new place for running all tools (bots included) [11:24:20] ok, I don't need to test, it is already working well... :) [11:24:44] petan: ^^ [11:25:14] !tr Euku [11:25:15] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Euku?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Euku?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [11:26:00] done [11:27:28] petan / addshore : thanks! [11:27:28] Euku: You are added to the tools project =] [11:44:05] Warning: There is 1 user waiting for shell: Aschroet (waiting 0 minutes) [11:57:38] Warning: There are 2 users waiting for shell, displaying last 2: Aschroet (waiting 13 minutes) Xazza (waiting 12 minutes) [11:57:39] Warning: There is 1 user waiting for access to tools project: Aschroet (waiting 10 minutes) [12:11:03] Warning: There are 2 users waiting for shell, displaying last 2: Aschroet (waiting 26 minutes) Xazza (waiting 25 minutes) [12:11:04] Warning: There is 1 user waiting for access to tools project: Aschroet (waiting 23 minutes) [12:24:24] Warning: There are 2 users waiting for shell, displaying last 2: Aschroet (waiting 40 minutes) Xazza (waiting 39 minutes) [12:24:25] Warning: There is 1 user waiting for access to tools project: Aschroet (waiting 37 minutes) [12:32:04] hi [12:32:33] hey [12:32:36] 'sup? [12:32:45] most people aren't awake now but some are [12:32:55] I'd like to run some db queries, what is the right way to do that on tool labs? [12:33:07] ah, yes [12:33:15] moment [12:33:27] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Production_replicas [12:33:28] probably [12:33:36] that entire document is something you should look at :) [12:34:10] * lbenedix likes to write python and python-mysqldb is not installed... [12:34:22] petan: ^ [12:34:29] lbenedix: also virtualenv is installed [12:34:33] lbenedix: so you can use that to install whatever you want [12:37:53] Warning: There are 2 users waiting for shell, displaying last 2: Aschroet (waiting 53 minutes) Xazza (waiting 52 minutes) [12:37:54] Warning: There is 1 user waiting for access to tools project: Aschroet (waiting 50 minutes) [12:39:57] hi [12:40:20] lbenedix heya [12:40:24] hi [12:41:19] lbenedix i have no idea how python works but there are others who use it and they can access db [12:42:11] but if u require -mysqldb package I can install it [12:43:00] actually it is installed [12:43:18] petan: on all hosts? [12:43:23] yes [12:43:38] Looks like it's not working with python3 [12:50:48] _mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") [12:51:18] Warning: There are 2 users waiting for shell, displaying last 2: Aschroet (waiting 67 minutes) Xazza (waiting 66 minutes) [12:51:19] Warning: There is 1 user waiting for access to tools project: Aschroet (waiting 64 minutes) [13:01:03] lbenedix wrong server? [13:01:11] !tr Aschroet [13:01:11] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Aschroet?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Aschroet?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [13:01:15] !rq Aschroet [13:01:15] https://wikitech.wikimedia.org/wiki/Shell_Request/Aschroet?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Aschroet?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Aschroet [13:02:35] !rq Xazza [13:02:35] https://wikitech.wikimedia.org/wiki/Shell_Request/Xazza?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Xazza?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Xazza [13:53:05] YuviPanda my memcached is almost written XD [13:53:25] what took months to c developers takes few days to c# dev ;0 [13:54:45] :P [13:54:48] mmm, C#? [13:55:10] petan: you realize that the initial memcached was in Perl? :P [13:55:20] hah [14:00:15] Warning: There is 1 user waiting for access to tools project: Alessio (waiting 0 minutes) [14:00:29] petan, why would you want to rewrite memcached? [14:00:40] Platonides because the current one sucks? [14:00:46] why? [14:00:53] Platonides it supports no authentication [14:01:12] how would you run memcached server in untrusted environment where people have shell access [14:01:39] I am making a version which support multiple users where each of them has own separate memory others cant access [14:01:47] make everyone prepend user & password to their memcache keys [14:02:25] ^ legit [14:02:54] hmm, not that bad after you also ask them to hash it [14:03:01] still it is simple to do a 'dump' [14:03:08] are you sure it is secure? [14:03:15] oh i'm pretty sure it isn't :) [14:04:49] YuviPanda, dump? [14:04:57] I think there's no command to list the keys [14:05:07] yes there is [14:05:18] stats items [14:05:21] it's trivial enough [14:05:21] ^ [14:05:27] you need to iterate from it, yeah [14:05:29] but still [14:06:39] hmm... you'd need to disable a couple of commands [14:06:53] bleh [14:07:05] you cant disable them other than removing them from source code :/ [14:07:32] which would break the software which expect them :o [14:08:15] at some point what you propose is possible but not sure about it... storing a passwords in memcache is horrible idea, people should rather prefix them with some random hash they generate instead of password [14:09:23] the version I am working on isnt perfect as well, because the authenticate stanza isnt part of current implementation and tools will not know it (but it is going to be very easy to implement) [14:09:43] can't we find something that *does* implement appropriate separation? [14:09:48] *or* we could have per-tool memcached instances [14:09:58] I have no idea how to accomplish that [14:10:02] that should be secure enough, assuming we communicate to them via some sort of sockets that can be secure [14:10:15] there is no version of memcached that supports this [14:10:17] like a unix socket? [14:10:35] that would require instance of memcache to run for every tool [14:10:36] hmm, but that'll have to be local [14:10:40] yeah [14:10:48] oh yes, it would. that was what i was proposing :P [14:10:56] I wonder how much the overhead would be [14:11:41] idk from technical point of view what I am working on is probably most correct, but it is also most complicated to implement and most complicated to implement in tools :3 [14:12:03] I think this has probably not been a problem for anyone before, petan [14:12:08] but it requires only 1 instance of memcache running, listening on network for all tools [14:12:09] can't think of any org that'll need a service like this [14:12:14] did toolserver have memcached? [14:12:19] legoktm: https://github.com/yuvipanda/android-editcountitis :) [14:13:01] YuviPanda I think that every web-host who would like to provide memcached could use it :P [14:13:14] hmm [14:13:16] reason why nobody provides it on shared servers is that it isnt secure [14:13:19] but I am pretty sure [14:13:21] that webhosts [14:13:25] have a per-user memcached instance [14:13:31] I dont think so [14:13:40] Warning: There is 1 user waiting for access to tools project: Alessio (waiting 13 minutes) [14:13:57] the problem with per-user memcached instances is that you would be locking a lot of memory for them [14:14:12] yeah, and for us It should really be 'per-tool' (or service-group)? [14:14:26] Platonides I think that it would lock far less memory than the 2 other proposals :P [14:14:28] !tr Alessio [14:14:28] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Alessio?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Alessio?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [14:14:53] let's just use mysql as memcached :P [14:15:07] lol [14:15:14] petan, which other? [14:15:22] instance per tool [14:15:27] use passwords in keys [14:15:29] these 2 [14:15:36] both of them would consume same or more memory [14:15:41] we could tell people 'do not put sensitive info there' [14:15:42] ? [14:15:43] than what? [14:15:50] than my version... [14:16:00] however, your version will be slower :P [14:16:05] why [14:16:07] and C# :P [14:16:12] but I'd love to hack on more C# [14:16:14] C# FTW! [14:16:19] because you have an authentication step [14:16:22] however, I'll admit that Mono isn't the most tuned server side thing.... [14:16:34] well I could either write it in c and spend 14 years doing it, or I could use c# and make it in 6 hours [14:16:48] indeed [14:16:58] plus it will give me an excuse to write C# again :D [14:17:04] petan: which version are you targetting? [14:17:05] C# I mean [14:17:06] 4.0? [14:17:09] 2.0 [14:17:12] .... [14:17:13] what [14:17:14] why [14:17:14] for compatibility [14:17:17] what [14:17:20] compatibility with WHAT [14:17:28] hmm, wait [14:17:36] did 2.0 have lambdas and LINQ and all that? [14:17:38] or was that 3.0? [14:17:40] that was 3.0, right? [14:17:41] well I dont care I could use 4.0 as well, but I think debian does not support anything higher than 2.0 [14:17:48] and ubuntu support it like few months maybe [14:18:12] wheeze has 2.10 [14:18:16] I dont use LINQ that makes your code slow and crappy :P [14:18:20] bleh [14:18:21] hmpf [14:18:32] I am writing in c style :P but using the modern features :D [14:18:40] that makes my code fast :3 [14:18:44] can you tell the mono version available? [14:18:53] petan: you know that all the 3.0 features are available on the 2.0 runtime too? [14:18:58] they just map back to the same primitives [14:19:02] maybe [14:19:32] hmmm [14:19:34] memcached over ssh? [14:19:37] that should be secure enough [14:19:41] lol [14:19:50] that would be definitely more work and more slow [14:19:57] it would be slow [14:20:36] if I wasnt chatting with you it would be already finished, but thing is that I dont know if there is a point in working on that now when you arent sure if we really need it [14:20:40] alright, I can't actually think of anything other than per-tool instances now [14:20:42] :P [14:20:47] petan: we *definitely* need it [14:20:51] that i'm sure about [14:20:59] petan: so I'm going to shut up now, and you finish up :) [14:21:03] no wavering [14:21:07] * StupidPanda goes back to his code [14:21:11] how would you mane the per tool version? [14:21:15] make [14:21:29] which is also network accessible? [14:21:30] make it on-request? [14:21:33] and use SASL [14:21:38] with a specific password [14:21:41] sasl only support binary protocol [14:21:52] look, there is sasl version running on tools-mc now [14:21:56] that's fine, it is just a library swap [14:21:59] sure, but sasl isn't per-user [14:22:03] it's just network secrecy [14:22:07] make mediawiki work with that and then, after 4 months when you manage to do that, tell me :P [14:22:25] why would anyone run mediawiki on tools? [14:22:27] why?! [14:22:32] lot of people do that [14:22:39] and they dont use memcache [14:22:43] so it is horrid and slow [14:23:29] why? [14:23:34] ok [14:23:38] nevermind, write the tool! [14:24:22] petan: disabling of stats command: http://pastebin.com/6wXFyS9u [14:29:13] Platonides I think we could manage to comment out part of source code :P but question is: is this a better solution? why? [14:29:28] some tools that rely on that command would break [14:29:32] don't reinvent the wheel? [14:29:58] I am not reinventing anything, my implementation is completely different [14:30:12] petan, can provide an example of tools which use stats for anything? [14:30:29] that's good for nagios or a sysadmin peeking at the daemon [14:30:31] I would hardly provide example of tools that use memcache for anything :) [14:30:47] but a normal memcache client shouldn't need it at all [14:30:56] okok [14:31:07] it's easier to change [14:31:08] and faster [14:31:14] so the current solution you want: regular insecure memcache with no stats? [14:31:15] as well as possible to get upstream :P [14:31:39] mhm [14:31:52] well, we could leave the general stats, blocking just the detailed ones [14:31:55] ha I said insecure and Coren woke up [14:33:23] Platonides I would more prefer if instead of pastebin you told me the name of .c file :P [14:33:27] but no worries I can grep it [14:33:41] petan, see at the top: memcached.c [14:33:46] aha [14:33:48] ok [14:33:57] patches contain the filename to be patched :P [14:34:26] LOL +#if 0 [14:34:35] not at all [14:34:36] that is a nice way to comment out stuff [14:34:38] it's quite common [14:34:49] and there are multiline comments in that block [14:34:54] mhm [14:34:58] aha [14:35:01] true [14:35:13] IIRC even common syntax highlighters reccomend that [14:35:22] :0 [14:36:03] s/reccomend/recognize/ [14:42:46] Platonides it is up [14:42:51] on tools-mc port 11211 [14:43:03] that hacked version you can check if its secure enough :P [14:45:02] lol now even stats settings doesnt work :S [14:45:09] I am wondering if it works at all [14:49:05] does it? [14:49:16] yes [14:49:34] it does, you should write a guide how to enable this in mediawiki using the secret hash prefix [14:49:43] I dont know if mediawiki supports that [14:49:45] but it should [14:49:47] meh [14:55:15] petan: I think a solution would be to tell people to *not* run mediawiki on tools :P [14:55:19] do you know anyone who already is? [14:55:56] StupidPanda: why it shouldn't be ran there? [14:56:23] I'm trying to think of reasons why it should be run on *tools* and not coming up with any [14:56:28] they should probably run on their own labs instance [14:56:31] rather than on tools [14:56:42] i see [14:56:50] besides, without memcached they are going to be incredibly horribly slow [14:56:51] i misplaced tools with labs [14:56:56] ah :) [14:57:03] labs is a wonderful place to run mediawiki! [14:57:06] just that tools isn't :) [14:57:14] :o) [15:00:03] There are already a couple of mw installations on tool; they're reasonably fast for what they are doing. [15:00:09] tools* [15:04:32] StupidPanda: reason is that not everyone is smart enough to understand linux, that doesnt mean they cant install mediawiki nor they dont understand php [15:04:39] lot of tools users are windows users [15:04:52] also having 100 mediawiki installations would mean 100 instances [15:04:57] that isnt effective at all [15:06:05] I see nothing wrong on running it on tools now when they can use memcache :P [15:09:52] petan, for the secret prefix in mediawiki, just set $wgCachePrefix [15:10:00] o/ [15:10:09] awesome [15:10:48] although I should check it's not disclosed in the "Saved in parser cache..." line [15:11:10] still, it's trivial to remove it [15:19:28] i also agree that tools is probably not the most ideal environment to run MW [15:19:41] it's a great way to run all the systems out of memory [15:19:57] (all of the tools web servers, that is) [15:21:20] Coren: what *are* they doing? [15:21:32] +1 to Ryan_Lane [15:21:40] if they want to be running mw, well, get a labs instance [15:21:43] rather than a tools instance [15:22:01] yeah. we need some way of not requiring a project per mediawiki idea, though [15:22:26] maybe we can have a single mediawiki project that doesn't allow root [15:22:29] StupidPanda: Not everyone wants to have to sysamin their setup; at least at first. But I agree that having a "make a webserver instance with memcached for mediawiki" system is probably a good idea. [15:22:43] and if people need infrastructure changes, they get a project [15:22:50] * Coren nods. [15:22:55] Sounds sane. [15:22:56] +1, 'shared hosting for mediawiki on labs!' type of thing [15:23:05] Coren: we already have a "all-in-one mediawiki" puppet class [15:23:21] that way we could also perhaps make sure that they are all up to date, for security purposes [15:24:04] Ryan_Lane: Most people who just want to work on a new extension will not want to have to worry about puppet, or setting up instances. [15:26:02] do we know what the people using mediawiki on tools are using them for? [15:26:05] also who are they? [15:27:30] Coren: indeed. I wasn't implying otherwise ;) [15:30:22] so is the memcached instance petan setup now considered part of 'tools labs'? [15:30:26] can I start using it? [15:30:30] should we put that up into the docs/ [15:30:31] ? [15:30:38] (it is regular memcached with stat disabled) [15:30:38] it is experimental now [15:30:47] what's to stop people from reading things out of that memcache? [15:31:04] Ryan_Lane the fact they dont know they name of key? :P [15:31:09] which is prefixed with secret hash [15:31:21] stats is disabled. [15:31:31] .... via a source patch :P [15:31:47] this is packaged? [15:31:54] not yet [15:32:31] * Ryan_Lane nods [15:32:49] StupidPanda I recommend you to start using it on your own risk :P should you find any issue let me know. if you wont find any we can start considering making it more official [15:33:03] sure petan [15:33:14] legoktm and I started working on something that'll need memcached to be viable, he's asleep now [15:33:20] i'll work with him on that [15:33:22] and see how it goes [15:33:36] but I still consider finishing that own daemon I am writing now and use it as alternative to what we have now (we can run multiple instances of it) [15:33:54] I still somehow consider it better for several reasons [15:34:19] petan: an alternative might be to put a thin service in front of memcached that does the actual auth, and then 'passes through' to memcached [15:34:26] via a local socket. [15:34:29] omg [15:34:47] ? [15:35:02] I would rather stick with that my whole brand new daemon which is just cute, fast, reliable and produces meaningfull errors :D [15:35:12] ah [15:35:13] :D [15:35:16] rather than some creepy workaround [15:35:19] :D [15:35:22] alright alright [15:38:19] DB connection error: Unknown MySQL server host 'zhwiki.labsdb' (2) (zhwiki.labsdb) [15:38:25] I see this in my bot outut [15:40:31] Coren: you know it? [15:41:21] liangent: zhwiki is on S7, the only shard not yet replicated. I expect next week. [15:43:04] Coren: no zhwiki is s2 [15:43:09] it was working [15:43:19] o_O My mistake. Lemme check. [15:44:16] Hm. I have no trouble connecting to it. Do you have more detailed debugging output? [15:46:00] DB connection error [15:46:00] Server: zhwiki.labsdb, User: p50380g50497, Password: oon..., error: Unknown MySQL server host 'zhwiki.labsdb' (2) [15:46:00] Failed to connect to database 0 at zhwiki.labsdb [15:46:46] o.O "Unknown host"? [15:47:04] * Coren facepalms. [15:47:07] The new nodes. [15:47:09] Coren: looks like some resolution issue [15:49:38] Should work now. Try again? [15:50:11] working now [17:47:54] legoktm: around? [17:56:43] petan, why is that database really slow? [17:57:30] I'm connected to enwiki_p and I made a simple query to it. [17:57:37] It's still loading. [17:57:38] SELECT COUNT(*) AS count FROM revision WHERE `rev_user_text`='Cyberpower678 [17:57:42] "; [17:57:45] ': [17:57:57] You know what I mean. [17:58:54] Just restarted the query. [17:59:23] depending on how many revisions that might be [17:59:27] it might take a long long time :D [17:59:35] also i'm unsure if user_text is indexed [17:59:36] at all [18:00:37] Cyberpower678: ^ [18:08:10] Cyberpower678: whats the aim or the query? [18:08:40] OMG the query is still running. [18:08:55] SELECT COUNT(*) AS count FROM revision WHERE `rev_user_text`='Cyberpower678'; [18:09:04] seashore, ^ [18:09:20] an edit count? [18:12:13] Cyberpower678: ? [18:12:44] That's just one of many queries X!'s edit counter makes. [18:12:58] We're trying to migrate the tool. [18:13:03] hmm [18:13:14] Ok seriously? [18:13:15] im guessing its so the deleted contrib count can be calculated# [18:13:16] +-------+ [18:13:16] | count | [18:13:16] +-------+ [18:13:16] | 10781 | [18:13:17] +-------+ [18:13:19] 1 row in set (10 min 13.48 sec) [18:13:42] hmmm [18:13:43] TS does it in less than a second. [18:13:50] * seashore goes to check [18:13:56] is that exactly as the query is? [18:15:43] * Cyberpower678 has to leave for a few hours. [18:15:57] Cyberpower678: who are you working on it with [18:15:58] ? [18:16:07] seashore, tparis and JackPotte [18:16:07] Cyberpower678: I believe that table doesn't have indexes for that colum - there's another indexes table you can query [18:16:21] bbl [18:16:35] hi [18:17:23] TParis: revision_userindex is what you want [18:19:18] 0.04 sec on revision_userindex [18:19:32] :) [18:21:23] how can i run a bot from labs? (im never runned bots from servers) [18:25:16] !help [18:25:17] !documentation for labs !wm-bot for bot [18:25:33] !documentation [18:25:33] https://labsconsole.wikimedia.org/wiki/Help:Contents [18:26:32] hi [18:27:05] Base-w you create an account for it, then you copy the software of bot and then you schedule it to run on grid [18:28:47] ok what should i do for it? i have acc at labsconsole.wikimedia.org, i put key there what should i do next? [18:28:53] petan: ^ [18:29:16] i should get access to project bots somehow, right? [18:35:18] Base-w no tools is good [18:35:53] you need access to tools project [18:36:04] what is your user? [18:36:13] @labs-user Base-w [18:36:13] That user is not a member of any project [18:36:23] @labs-user Base [18:36:23] Base is member of 1 projects: Bastion, [18:36:25] Base [18:36:28] ok [18:36:28] yes [18:36:39] !tr Base [18:36:39] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Base?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Base?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [18:37:05] you are there! [18:37:15] !tooldocs [18:37:15] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [18:37:20] read it [18:41:38] i should request tool access now? [18:50:22] you already have it [18:50:23] Warning: There is 1 user waiting for access to tools project: Base (waiting 0 minutes) [18:50:25] I gave it to you [18:50:27] ah [18:50:40] then i shouldnt do requst [18:50:41] ok [18:50:46] np [18:51:35] "you can connect using SSH and SFTP" what i can use for it in Windows? [18:52:38] Base-w: I can recommand Git Bash which is a limited clone of Bash. The most common option is to use PuTTY. Cygwin is another option. [18:56:00] i have git bash [18:56:15] but that all terminals? [18:56:24] i like some interface... [18:58:51] er, what kind of interface? [18:58:57] hmm, 'show index from logging' on labs replica databases shows me empty set [18:59:03] clearly there has to be some indexes? [18:59:06] am i doing something wrong? [19:04:06] aren't the tables there views? [19:04:59] they have a tendency to not expose the indexes of the underlying tables, unfortunately [19:05:15] 'SHOW CREATE TABLE logging' reveals that yes, it is a VIEW [19:06:47] I tend to look at the SQL definition in Git to know which indexes are available, but now I've learned that logging and revision have separate views that expose the *_user_text columns [19:06:55] indexed, that is [19:07:17] (revision_usertext and logging_usertext, respectively) [19:16:36] YuviPanda o/ my memcached can handle set add and get XD [19:16:43] \o/ [19:16:44] + authentication [19:16:45] with auth? [19:16:51] of course [19:16:53] Nettrom: ah, hmm. [19:16:59] Nettrom: but at least, they *are* indexed [19:17:00] so that's good [19:17:09] are you working using raw protocol or some library? [19:17:09] Nettrom: also no EXPLAIN, which is bad [19:17:14] me? [19:17:17] yes [19:17:18] library, of course [19:17:30] if you were using raw you would like the option to have descriptive errors :D [19:17:34] which are good for debugging [19:17:35] ah :) [19:17:38] for library writers [19:17:38] yes [19:17:44] it tell you what the error is instead of just ERROR [19:17:45] Warning: There is 1 user waiting for shell: Masti (waiting 0 minutes) [19:18:07] I will install this thing as 11212 [19:19:19] :D [19:19:23] nice [19:31:04] how to put files to tool? and is tool right thing for running bots? [19:31:16] Warning: There is 1 user waiting for shell: Masti (waiting 13 minutes) [19:38:33] ah no idea what to do(( [19:44:41] Warning: There is 1 user waiting for shell: Masti (waiting 27 minutes) [19:48:40] YuviPanda it is running, login is yuvi:panda [19:48:47] user:password [19:48:56] psst, insecure :P [19:49:03] :P [19:49:11] noone is watching this channel [19:49:24] it is logged, y'know :P [19:49:33] try it with telnet [19:49:37] type [19:49:51] authenticate eh [19:49:51] which hostname, btw? [19:49:51] lol [19:49:54] tools-mc [19:49:58] port 11212 [19:50:46] I enabled compatibility mode so that it tell you ERROR on error with no description :D [19:50:55] SUCCESS it says [19:51:00] heh [19:51:04] that means you authenticated [19:51:05] and i just press 'ENTER' [19:51:09] 'ERROR' its ays :P [19:51:10] now you can use set and get [19:51:16] as in regular memcached [19:51:19] nice! [19:51:26] set KEY flags time size [19:51:31] like set blah 0 0 10 [19:51:37] 1234567890 [19:51:43] get blah will return it [19:51:56] nope [19:52:03] i did set [19:52:05] and no response [19:52:05] get [19:52:07] no respons [19:52:07] I stored secret value as secret [19:52:10] try to read it :D [19:52:33] because after set you must type your data [19:52:42] of exact size as you provided in size [19:52:56] I gave you example [19:53:06] eah [19:53:08] that explains it [19:53:15] if you provided too big size it probably still read [19:53:17] get secret [19:53:18] returns [19:53:19] 'hello' [19:53:20] :D [19:53:45] if you telnet to 11211 and try it with real memcached you wont see a difference [19:53:54] it works exactly same [19:53:57] nice! [19:54:05] just the first stanza for authenticate is alien [19:54:07] petan: did you use any of the memcached test suites? [19:54:14] no [19:54:24] you should! [19:54:31] mhm [19:56:00] YuviPanda the biggest advantage is that if I create a new user now and that person can create this exact key with different value, that is not possible even in sasl version [19:56:07] sasl just prevent you from accessing the shared pool [19:56:11] right [19:56:13] but it is same for all users [19:56:17] so you're just prefixing them with magic? [19:56:22] no [19:56:26] values that aren't derivable without knowing the secret key? [19:56:29] I am using different hashtable for each user [19:56:31] ah [19:56:33] hmmm [19:56:40] completely separate in memory [19:56:40] i wonder how that'll behave under high load conditions [19:56:41] also paging [19:56:42] etc [19:56:50] I can delete one hashtable and others are not affected [19:57:00] I can even restrict memory per user [19:57:10] track how many each user is using etc [19:58:06] Warning: There is 1 user waiting for shell: Masti (waiting 40 minutes) [19:58:46] lol [19:58:54] YuviPanda if you ssh to tools-mc and run htop :D [19:58:56] interesting [19:59:10] memcache is using 320 virtual memory and 2mb of resident [19:59:22] my version is using 290 virtual and 12mb of resident :P [19:59:25] but less threads [19:59:54] put a thousand keys into each? [20:00:12] not easy to do atm [20:00:36] but later once it is finished I can switch it to compatibilty mode and use it with mediawiki [20:00:46] that could be interesting heh [20:01:20] :) [20:01:29] okay [20:01:32] i'm going to head to sleep [20:01:39] k [20:01:41] the tool will have to wait [20:01:42] gnite [20:01:43] and [20:01:44] petan: <3 [20:01:46] :) [20:01:47] gnite [20:02:01] * petan huggles YuviPanda [20:09:11] addshore, how do you rollback? [20:09:21] with the rollback button? :D [20:09:55] on tools I mean? [20:10:14] JackPotte just broke everything there and I need to undo it all. [20:10:32] addshore, ^ [20:10:46] LOL [20:10:49] broke everything as in what? [20:10:52] all your files? :O [20:11:02] cause now all your files is belong to us! [20:11:15] He changed something and now the entire tool is corrupted. [20:11:18] !Cyberpower678 is addshore, how do you rollback? with the rollback button? :D [20:11:19] Key was added [20:11:32] :D [20:11:35] Warning: There is 1 user waiting for shell: Masti (waiting 53 minutes) [20:11:36] -.- [20:11:38] -.- [20:11:40] -.- [20:11:45] Not in the mood. [20:11:59] Cyberpower678: you've told me to cancel one minute ago, don't panic, I tried to repair the tool which was broken [20:12:20] JackPotte, the tool wasn't broken. [20:12:27] The database is slow. [20:12:34] Causing the tool to seem broken. [20:13:35] Cyberpower678: do you know why the production tool is broken since yesterday please? http://toolserver.org/~tparis/ [20:14:10] JackPotte, because TParis modified something on his account which broke everything. [20:14:43] He never changed the code and if he did, I have backup of the old code. [20:14:57] I don't know what and why, but let's transfert it to the LABS ASAP [20:15:08] I'm undoing my tests [20:15:15] JackPotte, thank you. [20:15:41] JackPotte, there's no hurry. [20:16:02] Let's transfer this discussion back to #xlabs ASAP though. :) [20:24:56] Warning: There is 1 user waiting for shell: Masti (waiting 67 minutes) [20:25:01] Openssh 6.2 is interesting, multiple authentication provider support and fetching keys from an external program support :D [20:26:12] hi! [20:26:30] can we have oursql installed on OGE servers? [20:29:00] and wikitools: https://code.google.com/p/python-wikitools/ [20:38:24] Warning: There are 2 users waiting for shell, displaying last 2: Masti (waiting 80 minutes) Forexnewsnow (waiting 9 minutes) [20:39:50] DixonD1 I believe we already have that? [20:40:36] um [20:40:38] we dont [20:40:39] :/ [20:40:48] !log tools petrb: installing oursql cluster wide [20:40:50] Logged the message, Master [20:41:04] how can i put a file to my tool? [20:41:14] can i use some ftp? [20:41:37] Base-w you can use sftp [20:41:38] or scp [20:41:48] for example winscp client [20:42:49] !log tools petrb: installing wikitools cluster wide [20:42:50] Logged the message, Master [20:44:28] and to bots cluster too, please [20:51:09] mhm [20:51:48] @notify anomie [20:51:48] I'll let you know when I see anomie around here [20:51:54] Warning: There are 2 users waiting for shell, displaying last 2: Masti (waiting 94 minutes) Forexnewsnow (waiting 23 minutes) [20:52:02] !rq Forexnewsnow [20:52:02] https://wikitech.wikimedia.org/wiki/Shell_Request/Forexnewsnow?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Forexnewsnow?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Forexnewsnow [20:52:07] !rq Masti [20:52:07] https://wikitech.wikimedia.org/wiki/Shell_Request/Masti?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Masti?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Masti [20:52:11] Edit Counter operational. [20:52:52] zz_YuviPanda: Am now [20:52:56] petan: thanks for setting up memcached [20:53:09] legoktm i am not done yet :DD [20:53:13] oh [20:53:17] my version of memcached is going to be epic [20:53:24] I am writing own server now [20:53:27] er? [20:53:31] :d [20:53:34] read scrollback [20:53:35] !logs [20:53:36] http://bots.wmflabs.org/~wm-bot/logs/%23wikimedia-labs/ [20:53:38] legoktm, it's ready. [20:53:52] https://bugzilla.wikimedia.org/show_bug.cgi?id=49036#c11 says its fixed [20:54:26] andrewbogott_afk hey [20:54:51] andrewbogott_afk I need someone to block and remove rights from user Forexnewsnow I dont want to block him because last time it randomly blocked hashar [20:55:03] legoktm, http://tools.wmflabs.org/xtools/pcount [20:55:25] legoktm yes there is memcached, but I am going to install my own version in future which is going to be epic :P [20:55:35] but I need to write it first [20:56:02] legoktm that one will support some proper authentication [20:56:29] petan: ehhhh. i just want normal memcached! [20:56:42] there is normal memcached now [20:56:59] Cyberpower678: :D [20:57:01] I am going to run that epic version together with this crap [20:57:03] :P [20:57:49] !log tools petrb: installed this to exec nodes because it was on some and not on others cpp-4.4 cpp-4.5 cython dbus dosfstools ed emacs23 ftp gcc-4.4-base iptables iputils-tracepath ksh lsof ltrace lshw mariadb-client-5.5 nano python-dbus python-egenix-mxdatetime python-egenix-mxtools python-gevent python-greenlet strace telnet time -y [20:57:50] Logged the message, Master [20:59:57] >>> mc.set('hi','byeeeeeee') [20:59:57] True [20:59:57] >>> mc.get('hi') [20:59:57] 'byeeeeeee' [20:59:59] :DDDDD [21:00:11] >>> mc.set('password', 'lol') [21:00:13] hueheheheh [21:00:45] now to re-write my code to prefix all keys with "legoktm|" [21:01:08] legoktm you better rewrite it to support my epic version :> [21:01:18] that one is listening on 11212 [21:01:24] as long as it works with the python library that im using, sure! [21:01:31] of course it is not [21:01:32] none of my info is even remotely private [21:01:36] :( [21:01:37] it require authentication stanza [21:01:48] which is easy to implement [21:02:00] you just need to prefix the session with authenticate user:pass [21:02:18] (first line to send to memcache server before anything else [21:02:26] otherwise it is same [21:02:48] hm [21:02:49] ok [21:02:57] but I am still working on it :P [21:03:04] it support only some basic commands now [21:03:09] like set get delete replace add [21:03:39] petan, why are there two wikidata databases? [21:04:01] The real one is incomplete. [21:04:04] Cyberpower678 I dont know, I have no access over the replicas neither I am managing them [21:05:18] petan, are they both up to date? [21:05:43] idk [21:06:00] time to find out. [21:06:43] cyberpower678@tools-login:~$ sql wikidata [21:06:44] This is unknown db to me, if you don't like, blame petan on freenode [21:06:44] Make sure to ask for a db in format of _p [21:07:00] lol [21:07:03] petan: is there a wikilink shortcut to get to tools on tolls labs? [21:07:30] like the [[tools:~addshore]] ? [21:07:33] for toolserver [21:09:36] ping me if there is :D [21:10:26] Why do I get 'Make sure to ask for a db in format of _p' when I ctrl+c out of an sql prompt? [21:11:31] ERROR 1146 (42S02): Table 'wikidatawiki_p.recentchanges' doesn't exist [21:12:04] Coren: ^ [21:12:35] ill file a bug [21:13:45] Krenair that is weird [21:14:15] Krenair can tell me the steps to get it? [21:14:51] oh I think I know :/ [21:14:58] mhm [21:15:03] that needs a fix of some kind [21:15:53] Krenair that is because of recursive _p fix the script calls itself with _p if you forget to append it and in case the child process exit with non 0 it consider it to fail so it tell you the database name is wrong [21:16:03] but your ctrl+c made it exit with non 0 as well [21:16:30] filed https://bugzilla.wikimedia.org/show_bug.cgi?id=49046 [21:17:23] I hate the way my terminal line-wraps mysql output [21:20:53] well, i've uploaded file into /home/base [21:20:59] how to execute it? [21:23:58] Has anyone attempted to recreate luxo's global contribs tool in labs? [21:24:29] Krenair, shouldn't luxo do that? [21:24:58] Not unless the plan is to use luxo's code [21:25:19] Let's see. [21:25:55] I'll see if I can contact luxo [21:28:08] Krenair: something like that should really be an extension.... [21:29:31] !jobs [21:30:28] how to see to my job when submitted it? i'm 80% that it will not be successful but i at least want to see an error message [21:39:00] is [21:39:01] jsub -once -N "portal" java -jar "/home/base/portalBot.jar" [21:39:01] ok if i want to run file scp://base@tools-dev.wmflabs.org/home/base/portalBot.jar ? [21:42:35] wow seems that bot was running [21:42:36] cool [21:44:24] but where can i read some logs? [21:44:49] like job xxxx was successfuly done bla bla bla? [21:49:49] queries on revision are quite slow... [21:50:52] lbenedix1, what query are you running? [21:51:28] as a small test it's only: "select * from revision where rev_user = 11276263 limit 1;" [21:52:17] Try it against revision_userindex instead of revision, lbenedix1 [21:52:41] ok [21:52:58] 1 row in set (0.03 sec) [21:53:11] yes [21:53:25] the revision-table has no index for user_id? [21:53:40] Coren is the person to talk to about this [22:05:45] ah nobody wants to aswer my noob questions( [22:10:48] Base: what is your noob question? [22:13:58] Lbenedix1 how to see jobs i submitted status? [22:14:20] and how to kill them? [22:14:48] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Job_Information [22:19:28] :-) [22:19:45] hi addshore [22:19:48] thank you [22:20:09] Hi! [22:20:52] what is the progress of your apartment search? [22:21:14] I have found one :-) [22:21:23] inside the ring? [22:21:49] As far as I can tell, I haven't emailed them yet [22:22:22] It is near CheruskerstraBe [22:22:49] Near Kleist park [22:23:11] slightly inside the ring ;) [22:23:44] :D I think I can see the ring a few roads away from it on a map! [22:34:32] Hey petan. https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Database_access says I can create DBs on tools-db but how do I even get into that sql server? [22:34:57] krenair@tools-login:~$ mysql --defaults-file=~/replica.my.cnf -h tools-db [22:34:58] ERROR 1045 (28000): Access denied for user 'u2170'@'tools-login.pmtpa.wmflabs' (using password: YES) [22:40:06] TS has a powered by toolserver button to affix on the bottom of a page. What about labs? [23:36:02] what is wikidata database name? [23:36:32] wikidatawiki_p [23:36:45] Though, it's a broken databse. [23:37:10] replag is horrendous [23:40:40] replag where? [23:41:07] Cyberpower678: thanks [23:43:18] Jasper_Deng, where? [23:43:28] the wikidata databsae [23:43:39] well, that is, on TS at least [23:44:05] There is no replag on this database. It's just broken. [23:45:31] petan: http://meta.wikimedia.org/wiki/User_talk:Addshore#Huggle_for_IOS_and_Android [23:45:36] im sleep ;p [23:54:38] lbenedix: Use the revision_userindex table instead. [23:55:28] Krenair: Your tools can create DBs there, not you. :-)