[01:39:02] Warning: There is 1 user waiting for shell: Yzhang (waiting 0 minutes) [01:52:22] Warning: There is 1 user waiting for shell: Yzhang (waiting 13 minutes) [02:05:43] Warning: There is 1 user waiting for shell: Yzhang (waiting 26 minutes) [02:19:03] Warning: There is 1 user waiting for shell: Yzhang (waiting 40 minutes) [03:26:57] !bot [03:26:57] http://meta.wikimedia.org/wiki/WM-Bot | troubleshooting bots -> https://labsconsole.wikimedia.org/wiki/Nova_Resource:Bots/Documentation#Troubleshooting [03:29:28] @RC+ en_wikipedia Wikipedia:Request an account/Guide [03:29:29] Inserted new item to feed of changes [03:30:38] @RC- en_wikipedia Wikipedia:Request an account/Guide [03:30:38] Deleted item from feed [03:30:46] @RC+ en_wikipedia Wikipedia:Request_an_account/Guide [03:30:47] Inserted new item to feed of changes [03:32:35] /facepalm [03:32:39] wrong channel [03:32:57] @RC- en_wikipedia Wikipedia:Request_an_account/Guide [03:32:58] Deleted item from feed [03:40:51] petan, I'm having some trouble with wm-bot. Is it me or the bot? [04:09:58] hrmmmm, what happened to the bots project docs? [04:10:14] seems like someone forgot to update... [04:10:57] who made the ascii unicorn?!???! [04:28:39] Change on 12mediawiki a page User:Petrb/spam was modified, changed by Jeremyb link https://www.mediawiki.org/w/index.php?diff=691442 edit summary: [+11] [04:32:48] !log bots [wm-bot] booted wmib && bouncer @ bots-labs. (wasn't relaying my test edits) [04:32:50] Logged the message, Master [05:27:29] Warning: There is 1 user waiting for shell: CoveyHill (waiting 0 minutes) [05:40:50] Warning: There is 1 user waiting for shell: CoveyHill (waiting 13 minutes) [05:54:11] Warning: There is 1 user waiting for shell: CoveyHill (waiting 26 minutes) [06:07:36] Warning: There is 1 user waiting for shell: CoveyHill (waiting 40 minutes) [06:21:01] Warning: There is 1 user waiting for shell: CoveyHill (waiting 53 minutes) [06:34:22] Warning: There is 1 user waiting for shell: CoveyHill (waiting 66 minutes) [06:47:42] Warning: There is 1 user waiting for shell: CoveyHill (waiting 80 minutes) [07:01:07] Warning: There is 1 user waiting for shell: CoveyHill (waiting 93 minutes) [07:14:27] Warning: There is 1 user waiting for shell: CoveyHill (waiting 107 minutes) [07:16:53] Special:import does not work for admins on the Heb Wikivoyage. Anyone knows why ? [07:27:52] Warning: There is 1 user waiting for shell: CoveyHill (waiting 120 minutes) [07:41:21] Warning: There is 1 user waiting for shell: CoveyHill (waiting 133 minutes) [07:54:46] Warning: There is 1 user waiting for shell: CoveyHill (waiting 147 minutes) [08:08:10] Warning: There is 1 user waiting for shell: CoveyHill (waiting 160 minutes) [08:21:31] Warning: There is 1 user waiting for shell: CoveyHill (waiting 174 minutes) [08:34:51] Warning: There is 1 user waiting for shell: CoveyHill (waiting 187 minutes) [08:48:16] Warning: There is 1 user waiting for shell: CoveyHill (waiting 200 minutes) [09:01:41] Warning: There is 1 user waiting for shell: CoveyHill (waiting 214 minutes) [09:15:02] Warning: There is 1 user waiting for shell: CoveyHill (waiting 227 minutes) [09:28:23] Warning: There is 1 user waiting for shell: CoveyHill (waiting 240 minutes) [09:41:47] Warning: There is 1 user waiting for shell: CoveyHill (waiting 254 minutes) [09:55:08] Warning: There is 1 user waiting for shell: CoveyHill (waiting 267 minutes) [10:08:28] Warning: There is 1 user waiting for shell: CoveyHill (waiting 281 minutes) [10:21:53] Warning: There is 1 user waiting for shell: CoveyHill (waiting 294 minutes) [10:35:14] Warning: There is 1 user waiting for shell: CoveyHill (waiting 307 minutes) [10:40:46] hi [10:40:54] I am back who needed me? [10:41:07] I think Ryan and Coren did ping me? :o [10:41:16] !rq CoveyHill [10:41:16] https://wikitech.wikimedia.org/wiki/Shell_Request/CoveyHill?action=edit https://wikitech.wikimedia.org/wiki/User_talk:CoveyHill?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/CoveyHill [10:52:23] Coren what happened to mysql server? it has 28 hours uptime [13:23:44] jeremyb if you ever needed to restart wm-bot you can just type @restart there is no need to restart bouncer unless it disconnects from freenode ;) [13:24:08] @resttart [13:24:22] ok. [13:24:43] Why isn't it restarting? [13:24:44] bouncer is keeping the messages as well in memory so the bot will not lose any logs [13:25:12] Spelling fail. [13:25:14] Cyberpower678 1) you typed tt 2) how do you know it doesn't? [13:25:27] @restart [13:25:27] restart isn't visible [13:25:27] Permission denied [13:25:39] You are admin identified by name .*@wikipedia/Cyberpower678 [13:26:01] What permission do you need to restart? [13:26:04] root [13:26:08] oh [13:26:09] You are root identified by name .*@wikimedia/Petrb [13:26:21] petan, can you restart it? [13:26:27] what for? [13:26:34] it works fine [13:26:35] It's not working as it should. [13:26:41] what isn't working? [13:26:56] recentchanges feed. [13:27:14] When I was trying to have it monitor changes to a page, it never reported. [13:31:06] petan, it doesn't give you a restart confirmation, before and after it restarts? [13:31:18] it does in #wm-bot [13:31:29]

System is shutting down, requested by petan from #wikimedia-labs [13:34:19] Cyberpower678 does it work now? [13:34:27] @rc+ en_wikipedia W* [13:34:37] petan, how long does it take to restart? [13:34:45] few seconds? [13:34:52] @RC+ en_wikipedia W* [13:34:53] Inserted new item to feed of changes [13:34:57] Change on 12en_wikipedia a page Wikipedia talk:Articles for creation/Richard Buckland was modified, changed by Maociao link https://en.wikipedia.org/w/index.php?diff=555646679 edit summary: [+2258] /* Richard Buckland */ new section [13:34:59] @RC- en_wikipedia W* [13:34:59] Deleted item from feed [13:35:04] seems to work [13:36:32] petan, could you wander over to #wikipedia-en-accounts-unreg? [13:38:04] nevermind. [13:38:09] It's working now. [13:53:39] Hello, how can i login into an instance? I haven't make any [13:53:49] I just got shell login [13:56:28] Amir1 hi, what exactly do you need? [13:57:02] @labs-user Amir1 [13:57:03] login for running my python bot [13:57:03] That user is not a member of any project [13:57:06] ok so you need to run a bot [13:57:12] what is your labs username? [13:57:13] my username is ladsgroup [13:57:23] @labs-user Ladsgroup [13:57:23] Ladsgroup is member of 1 projects: Bastion, [13:57:53] !toolsdocs | Amir1 [13:58:11] !toolsdoc [13:58:14] !toolsdocs [13:58:16] wtf [13:58:22] !tooldocs [13:58:23] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [13:58:31] !toolsdocs alias tooldocs [13:58:32] Created new alias for this key [13:58:47] !toolsdocs | Amir1 read this [13:58:47] Amir1 read this: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [13:58:59] Ok [14:00:21] Thank you [14:01:10] you need to create a service account on tools project with name of your bot, then you need to install your bot on tools project [14:01:24] I did just wmib first and it was still broke. so then I did bouncer and redid wmib [14:02:07] jeremyb-phone ok, however in order to fix rc feed, restarting bouncer doesn't help, because the bot is using bouncer only for freenode [14:02:31] .@restart usually fix it ;) [14:02:34] I have no explanation :-) [14:02:41] just know what I saw [14:02:41] no problem [14:02:55] the documentation suck I know [14:05:57] well it still says bots-1. I had to log in everywhere I could and `ps -fA | fgrep wmib` [14:06:17] what's ibnr1? [14:06:34] I guess non-root. but ib? [14:08:27] interactive bots [14:08:34] that is rather a test [14:08:38] oh [14:09:03] I believe that interactive bots will be slow on heavily loaded boxes and might require a separate environment with minimal load [14:09:21] but first we need to go and try to run some on heavily loaded box... which we don't have now [14:09:27] not even sure how you define them [14:09:33] like irc bots [14:09:38] oh [14:09:42] whatever you query and expect quick response [14:09:51] !ping [14:09:51] pong [14:09:52] wmib! [14:10:03] on loaded box this could take more seconds /I think/ [14:10:13] yeah… [14:10:54] yes wm-bot is now on bots-labs I deleted bots-1... [14:10:55] petan; You make the presumption that there will /be/ heavily loaded boxen. Teh fact that I prevent memory overcommit makes that unlikely (anything interactive that is mostly idle ends up with high priority, and there is to trashing to slow things down) [14:11:15] Coren yes it's still just a test maybe we won't need it [14:11:31] So that, beyond the cost of a context switch, you'll never get really noticable latency. [14:11:55] is no* trashing [14:12:26] I am wondering if host would ever be swapping or not [14:12:28] Coren: how do you do that? nice? [14:12:32] is there a swap on kvm hosts? [14:12:57] jeremyb: By doing allocation based on total vmem commitment. [14:13:02] I guess all puppetized [14:13:31] btw Coren what happened to -db? [14:13:33] I see it was down [14:13:39] the sql was [14:13:43] :/ [14:14:10] petan: 14:13:58 up 72 days, 18:21, 2 users, load average: 0.24, 0.19, 0.16 [14:14:26] yes, but mysqld... [14:14:31] it is like 1d+ [14:15:02] I was searching syslog but didn't find it [14:15:11] Hm. [14:15:39] dist-upgrade, I expect, signaled mysqld for a restart [14:15:52] do you use vagrant? what's your workflow like? [14:16:22] (I hated that forcible dist-upgrade, but we had no choice) [14:18:01] dist-upgrade?? [14:18:07] wasn't that a latest image [14:18:24] I thought it was ubuntu 12.04 [14:19:10] btw Coren are you following that linux kernel issue on wikitech-l are we going to update the kernels on all boxens [14:19:36] petan: I have been aware of this and been working on it in ops since well before that announcement. :-) [14:19:45] aha [14:19:54] so we don't need a patch? [14:20:15] is this problem related to perf_events or is that a bug I couldn't find? [14:20:19] petan: It says i have to create a new tool account [14:20:22] It's applied already, and will become live Monday when the actual openstack cluster is rebooted. [14:20:24] https://wikitech.wikimedia.org/wiki/Special:NovaProject [14:20:28] Amir1 yes - you can do that [14:20:33] There were no Nova credentials found for your user account. Please ask a Nova administrator to create credentials for you. [14:20:43] Amir1 logout / login ;) [14:20:44] it's a bug [14:20:50] Amir1: You'll have to log out and back in. [14:20:51] OK [14:20:53] :) [14:21:03] it's very old bug :) [14:21:17] we don't want to fix it just to preserve nostalgy... [14:21:59] also Ryan announced like 4 times he fixed it :) [14:22:08] he never really did :P [14:23:08] :)) [14:36:54] Hi ! I have a question : where is the wikipedia.py file in the rewrite pywikipedia ? Because when I want to start redirect.py (in "shared/pywikipedia/rewrite/scripts") with a .sh file, I receive an error : " File ".pywikibot/scripts/redirect.py", line 62, in //// import pywikibot //// ImportError: No module named pywikibot" [14:40:34] Hawk-Eye: It's a PWB bug not wikitech, and as a PWB dev I say you must use import wikipedia as pywikibot instead of pywikibot [14:40:43] (Maybe I'm wrong) [14:42:44] Yes but ... I'm not be able to modify this "redirect.py" ! How to use "import wikipedia as wikibot" ? [15:24:19] So... does someone can change the "redirect.py" file --> line 62 ? [16:56:02] hey all [16:56:45] anyone know why mysql doesnt work anymore at shell prompts? [16:58:33] A guess: Coren's working on DB replication and fiddling with some stuff. [16:58:51] No, and it's not supposed not to. [16:59:12] Okay, but then on tools-exec-01: "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" [16:59:24] (Local, I'm an idiot.) [16:59:39] No comment. :-) [16:59:43] could totally mysql proxy that, but then it would get confusing [16:59:48] yesm im talking about the local database [17:00:09] I created a new project and its not available from shell [17:00:18] however the database IS there [17:00:35] greenrosetta: What error message are you getting? [17:00:38] I also logged into my older projects where it worked and mysql doesnt work there either [17:00:53] Still on tools-exec-01: "mysql -htools-db" -> "ERROR 1045 (28000): Access denied for user 'scfc'@'tools-exec-01.pmtpa.wmflabs' (using password: NO)" [17:01:08] The program 'mysql' is currently not installed. To run 'mysql' please ask your administrator to install the package 'mysql-client-core-5.5' [17:01:10] use the pass? [17:01:15] oh! [17:01:26] Stupid puppet! [17:01:41] well tbf to puppet, someone broke the manifest [17:01:43] computers are dumb [17:01:46] oh... my latest tool btw. http://tools.wmflabs.org/quickquery [17:02:13] my goal is to let anyone run a query off of any of the wiki databases [17:02:24] Damianz: Hmmm. Where did my ~/.my.cnf go? Did plain users have one ever? [17:02:25] That's going to end badly imo [17:02:35] displays both the results and lets you download a csv [17:02:36] scfc_de: I think only tools do [17:02:37] greenrosetta: That's a very, very bad goal and I disaprove of it. [17:02:49] yeah, its dangerous :D [17:02:55] greenrosetta: You're setting up a serious DOS. [17:02:58] im going to make it semi private [17:03:04] Sql injection ftw [17:03:07] greenrosetta: And, BTW, you don't even filter against DDR [17:03:09] Taking down sql servers ftw [17:03:17] greenrosetta: Make it completely private, please. [17:04:08] You could turn on like mod_sec or some WAF and it would block that totally hah... though WAFs are lame and tend to miss stuff, generate false positives and only make you feel safe [17:04:32] greenrosetta: Seriously, man, you point that thing at the replicas and you loose your account. That's so far beyond bad idea territory it ended in the middle of justifiable homicide by sysadmin territory. :-) [17:05:01] :D [17:05:14] * Coren illustrates why. [17:05:20] whts DDR? [17:05:46] Coren: Just make 'don't be evil' a tools rule :P [17:06:01] greenrosetta: It's the thing that just allowed me to just drop your Country table. [17:06:16] ah, youre the bastard [17:06:31] was wondering why that stopped... and I was trying to get into mysql to see why [17:06:33] heh [17:06:57] though techinally that's a database role [17:07:00] I bet if the tool accounts where ever allowed access to more than 1 db, you could jump betwean them too... which is fun [17:07:08] Coren: I would count DOS against the local database as homicidable as well :-). [17:07:49] how are you going to handle privs on the wiki db's? [17:07:52] greenrosetta: Long story short: your tool is bad and you should feel bad. :-) [17:08:02] its not and I dont. its awesome [17:08:11] :D [17:08:28] You're letting random people do random shit; including things like full scan cross-joins on enwiki.revision = database crunches to a halt for hours. [17:08:38] yeah, i know there are security flaws [17:08:56] greenrosetta: It doesn't have security flaws. It *is* a security flaw. [17:09:20] i like knives, sue me [17:09:37] s/sue me/stab me to death./ [17:09:43] i was more interested in getting the csv part running [17:10:02] sql -> cvs is easy, both are column/row based [17:10:26] greenrosetta: You can offer knives at your *own* site anytime, at Labs you need to be social. [17:10:55] scfc_de: hey, take this apple and blindfold [17:11:41] which brings me to my latest question... are there authentication modules on labs? [17:12:05] Coren: are you fixing the mysql part? [17:12:10] greenrosetta: I'm serious dude. My normal procedure in a case like this would be (a) delete your public_html outright and (b) close your account if you even think about trying to putting it back. Make it private, quadruple check your permissions, and never ever access it without SSL. That's *IF* you absolutely /must/ have it. [17:12:52] Coren: I wouldnt dream of making that public on the wiki db [17:13:16] The only reason I'm giving you advance warning is because the replicas aren't yet live. If they were, I'd have deleted it /then/ warned you. [17:13:31] it IS pointing to my local db btw [17:14:09] greenrosetta: You have no security. I'm betting 10:1 I can point it at whatever I wish. [17:14:14] Coren: And you'd also stab him, after spending an hour tracking down which tool was breaking the sql servers? [17:14:17] greenrosetta: And indeed I can. [17:14:57] you cant change the database [17:15:19] that's coming from the protected cnf files [17:15:44] select * from `db`.`table`? [17:16:01] its on a local DB [17:16:25] You can access anything the user has access to [17:16:57] * Damianz goes to track down wth he saved the fixer to so he can watch it [17:17:58] greenrosetta: Please close this to the public now. [17:18:13] just delete it for me [17:18:19] ive got a copy [17:18:49] but i still need mysql, whcih isnt working on any project at the moment [17:19:24] greenrosetta: Moronic update to the puppet config; I'm fixing now. [17:21:20] So the DB replicas are working now? [17:21:22] so speaking of authentication, how could I add authentication so that a user would have to be logged into wikitech first? [17:21:54] I don't suppose anyone would object to having an authetnicated group of users have access [17:21:59] openid magic [17:22:04] Krenair: I wish :( [17:22:10] * Damianz looks a Coren [17:22:18] Damianz, greenrosetta: OpenID isn't enabled on wikitech at the moment. [17:22:27] greenrosetta: We'll have openid shortly, but just being a wikitech user wouldn't be *nearly* enough for access to a database breaker like this. [17:22:43] if someone can get an account on tools, they can run the same queries in shell that you could from the web ui [17:22:53] scfc_de: Yeah - openid/oauth is on the map somewhere though IIRC [17:23:06] hm [17:23:09] greenrosetta: Then let them run the queries themselves. [17:23:11] greenrosetta: Yes, but then I would know who to beat up and kick off. [17:23:32] well when it starts working will it be accessible from any project? or just tools? [17:23:41] * greenrosetta fucking with sysadmins since 1983 [17:24:16] All I think - but just tools is fine for me to start, simple to port my script since it's on toolserver currently anyway [17:24:21] * Damianz hates toolserver this month [17:24:38] greenrosetta: I've been a sysadmin for about that long, so I'm quite adept at switching to BOFH mode if I need to. [17:25:19] Coren is old [17:25:24] heh.. "lusers" [17:25:40] thats awesome [17:27:03] hey [17:27:10] I am back :D [17:27:14] what is broken? :P [17:27:23] everything [17:27:25] puppet [17:27:32] wm-bot [17:27:32] Krinkle|detached ping [17:27:36] !ping [17:27:36] pong [17:27:40] Damianz it works! [17:27:50] it's allways broken somehow :P [17:27:56] !say Damianz: I am feeling well [17:27:56] Damianz: I am feeling well [17:27:59] Nah, it's just that the base cases use ensure => latest for mysql-client, so it trampled all over mariadb-client. Placing the package on hold now. [17:28:19] Coren puppet is definitely breaking maria [17:28:31] I know, that's why I'm placing a hold [17:28:35] Coren I know on -dev everytime I run puppet maria is removed [17:28:39] What do you do with a problem like Maria? [17:28:47] use Percona [17:28:48] ok my irc is lagging like hell :D [17:29:09] greenrosetta problem like a maria? :D [17:29:12] ll [17:29:13] lol [17:29:22] maria <3 [17:29:25] Frank Zappa would kick the von trapp famliy singers ass [17:29:29] asses [17:29:49] There, the client package is held now so puppet can't touch it anymore. [17:29:58] no idea what you talk about but I still like maria :) [17:30:40] I like idea of puppet, I don't like implementation it has [17:31:03] with combination with gerrit and git-review it's pain in ass [17:31:15] * Coren goes back to DB replication [17:32:25] * Damianz gives Coren a cookie [17:32:42] * petan gives Damianz puppet [17:32:50] * Damianz has puppet already [17:33:12] Puppet 3 with puppetdb is pretty awesome [17:33:29] Tempted to try chef though... since the puppet dsl is kinda restrictive [17:44:09] * greenrosetta gives Coren a cookie.. mysql working again [19:44:52] Yow! [19:44:56] That actually works. [19:46:01] Splitting personalities? :-) [19:46:12] zhwp has an IRC gadget! [19:47:03] Ryan_Lane: I hate the mediawiki schema! [19:48:05] And how do you spell IRC in Chinese? [19:48:35] Okay, they use Latin, too. [19:48:37] "IRC" strangely enough. http://zh.wikipedia.org/wiki/Wikipedia:IRC%E8%81%8A%E5%A4%A9%E9%A2%91%E9%81%93/IRC?withJS=MediaWiki:Gadget-irc.js [19:49:26] And ... [19:49:38] I prefer ERC, though :-). [19:49:53] Yeah, but this actually works from mediawiki. [19:51:04] I had thought that MediaWiki was very locked down to include foreign content. Hmmm. [19:51:24] That's because the client is actually implemenet in javascript. :-) [19:51:33] implemented* [19:56:38] Coren: :D [21:08:56] any developers around ? [21:11:49] of what? [21:11:51] :D [21:11:54] WikiJunkie: What for? [21:17:39] select af_pattern from enwiki.abuse_filter where af_deleted limit 1; [21:17:43] * Coren grumbles. [21:37:10] Coren: abuse_filter isn't available on Toolserver, so don't let grumbling mess up your schedule :-). [21:38:01] Oh? Well, 1-0 for TL. :-) [21:52:55] Warning: There is 1 user waiting for shell: Ralokt (waiting 0 minutes)