[10:43:03] <grrrit-wm>	 (PS1) Gilles: Fix wrong tsv url for image performance map [analytics/multimedia/config] - https://gerrit.wikimedia.org/r/131039
[14:57:46] <halfak>	 Hey ottomata.  Do you know if there is a good reason why I might suddenly get an auth error when trying to connect to stat1003 from bast1001?
[14:57:50] <halfak>	 Was working yesterday.
[14:57:56] <halfak>	 SSHing to bast1001 is just fine.
[14:59:01] <halfak>	 I forgot to mention that I'm using ssh-agent when manually logging into bast1001 first and I also have the problem when using ProxyCommand.
[15:00:37] <ottomata>	 andrewbogott is changing production uids
[15:00:38] <ottomata>	 could be related
[15:00:40] <ottomata>	 ping him in #ops
[15:00:43] <halfak>	 Will do.
[15:00:45] <halfak>	 Thanks
[18:00:49] <terrrydactyl>	 i’m having a problem when running my tests. getting this error: OperationalError: (OperationalError) (1044, "Access denied for user 'wikimetrics'@'localhost' to database 'wiki2_testing'") None None
[18:00:54] <terrrydactyl>	 anyone have an idea of how to fix it?
[18:04:48] <grrrit-wm>	 (PS1) QChris: Temporary use 'analytics-store' as s1 slave [analytics/geowiki] - https://gerrit.wikimedia.org/r/131092
[18:05:22] <qchris>	 terrrydactyl: most people are preparing to travel.
[18:05:40] <qchris>	 You could just grant the user access to wiki2_tesing.
[18:05:49] <qchris>	 Have you tried that?
[18:06:22] <terrrydactyl>	 qchris: i think i’ve tried it last time this error came up, but messed up the granting
[18:06:55] <terrrydactyl>	 let me try it again.
[18:06:57] <qchris>	 Ok. Did you switch to wiki2_testing on purpose, or is that a new thing in wikimetrics?
[18:07:03] <qchris>	 Let me check ...
[18:07:25] <terrrydactyl>	 i think it’s a new database that they added to fix the username in csv problem. and also for project level cohorts later.
[18:07:41] <qchris>	 Oh yes.
[18:07:43] <qchris>	 Right
[18:08:03] <qchris>	 scripts/01_create_wiki_db (within your local wikimetrics checkout)
[18:08:08] <qchris>	 has the commands you need to run.
[18:08:24] <terrrydactyl>	 okay great
[18:08:25] <terrrydactyl>	 thanks
[18:08:34] <qchris>	 grant ALL on wiki2_testing.* TO wikimetrics@'localhost';
[18:08:34] <qchris>	 grant ALL on wiki2_testing.* TO wikimetrics@'%';
[18:08:59] <qchris>	 (Not sure if the last line is needed, but the script uses it)
[18:09:33] <terrrydactyl>	 okay. i’ll make a note to check the scripts next time if i get this error again
[18:09:35] <terrrydactyl>	 thanks qchris
[18:09:36] <terrrydactyl>	 :)
[18:09:47] <qchris>	 yw :-)
[18:10:14] <terrrydactyl>	 it’s gonna be lonely in here when you all are in zurich. :)
[18:10:50] <qchris>	 Mhmmm... join us :-)
[18:11:10] <grrrit-wm>	 (CR) Ottomata: [C: 2 V: 2] Temporary use 'analytics-store' as s1 slave [analytics/geowiki] - https://gerrit.wikimedia.org/r/131092 (owner: QChris)
[18:11:13] <terrrydactyl>	 hahaha, can’t afford it!
[18:11:22] <terrrydactyl>	 i did apply for a scholarship, but i didn’t get it.
[18:11:50] <qchris>	 You didn't get a scholarship :-((
[18:12:24] <terrrydactyl>	 no, but it’s okay. i’m sure it went to someone worthy. :)
[18:13:15] <qchris>	 :-P
[18:13:23] <qchris>	 You'd deserve it too.
[18:13:50] <terrrydactyl>	 maybe next year. :)
[18:14:11] <qchris>	 Wohoo \o/
[18:14:46] <terrrydactyl>	 are you excited for the hackathon?
[18:14:51] <terrrydactyl>	 is it literally a hackathon? haha
[18:15:04] <qchris>	 We'll have an offsite before the hackathon.
[18:15:12] <qchris>	 But hackathons are typically great.
[18:15:28] <terrrydactyl>	 an offisite?
[18:15:42] <qchris>	 Analytics team meeting before the hackathon.
[18:15:49] <qchris>	 It'll start on Monday.
[18:16:20] <terrrydactyl>	 ah cool!
[18:16:35] <qchris>	 Btw ... did the test2_wiki granting work?
[18:16:46] <qchris>	 s/test2_wiki/wiki2_testing/
[18:16:48] <terrrydactyl>	 checking now
[18:16:56] <qchris>	 ok.
[18:17:27] <terrrydactyl>	 hmm
[18:17:35] <terrrydactyl>	 looks like i’m getting this now: OperationalError: (OperationalError) (1049, "Unknown database 'wiki2_testing'") None None
[18:17:40] <terrrydactyl>	 guess i didn’t make the database yet
[18:17:41] <terrrydactyl>	 hold on
[18:18:29] <qchris>	 create database IF NOT EXISTS wiki2_testing;
[18:18:33] <terrrydactyl>	 yeah
[18:18:37] <qchris>	 terrrydactyl: ^ should fix it.
[18:18:40] <terrrydactyl>	 maybe i should just run that script
[18:18:59] <qchris>	 :-)
[18:19:28] <terrrydactyl>	 oh well, that script only has wikimetrics_testing not wiki2_testing
[18:19:42] <terrrydactyl>	 would this cause problems when setting up a new instance?
[18:20:46] <qchris>	 Mhmmm. For me, scripts/01_create_wiki_db covers wiki, wiki_testing, wiki2_testing.
[18:21:08] <qchris>	 For each of them, it create the database and grants access.
[18:21:57] <terrrydactyl>	 http://paste.ofcode.org/hBp5ZNmLat5NDET2jyN23E
[18:22:01] <terrrydactyl>	 mine just looks like that.
[18:22:09] <terrrydactyl>	 ohhh
[18:22:13] <terrrydactyl>	 i’m looking at the wrong one
[18:22:15] <terrrydactyl>	 silly me
[18:23:00] <terrrydactyl>	 was looking at 00 instead of 01
[18:23:04] <qchris>	 https://git.wikimedia.org/blob/analytics%2Fwikimetrics/7370d8467ccd194f726a1726a25396432d71c4b4/scripts%2F01_create_wiki_db
[18:23:12] <qchris>	 Ah. Ok.
[18:23:30] <terrrydactyl>	 looks like the tests work
[18:23:32] <terrrydactyl>	 thanks qchris
[18:23:35] <qchris>	 yw.
[18:23:44] <qchris>	 Ok. Then I'll head to town.
[18:23:53] <qchris>	 Have fun and enjoy your weekend.
[18:24:14] <terrrydactyl>	 thanks! have fun
[18:58:29] <ori>	 heyo
[18:59:32] <ori>	 where can i find the password for 'research' on analytics-store.eqiad.wmnet?
[19:14:24] <ori>	 DarTar, halfak, ottomata ^ ?
[19:14:32] <ori>	 or milimetric?
[19:14:38] <DarTar>	 it’s on fenari
[19:14:42] <DarTar>	 hang on
[19:28:29] <grrrit-wm>	 (CR) Jdlrobson: [C: 2] "can revert later as you point out :)" [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/130833 (owner: Milimetric)
[20:26:24] <grrrit-wm>	 (PS1) Ottomata: Moving old oozie files into oozie/archive directory [analytics/kraken] - https://gerrit.wikimedia.org/r/131207
[20:26:26] <grrrit-wm>	 (PS1) Ottomata: Adding oozie files to control addition and deletion of webrequest table partitions [analytics/kraken] - https://gerrit.wikimedia.org/r/131208
[20:27:12] <grrrit-wm>	 (CR) Ottomata: "Yes, I know we could just remove these files and still have them in git history, but for now I'd like to leave them in HEAD. This will a" [analytics/kraken] - https://gerrit.wikimedia.org/r/131207 (owner: Ottomata)
[20:27:32] <ori>	 ottomata: wowow, awesome -- just so your patches to move more puppet modules to git submodules
[20:28:50] <ottomata>	 ori, you mean the 6 patches from earlier today?
[20:28:56] <ori>	 yes
[20:28:59] <ottomata>	 yup :)
[20:29:34] <YuviPanda>	 halfak: Ironholds i left a detailed comment on the trello board.
[20:30:15] <Ironholds>	 I saw; thanks :)
[20:30:21] <Ironholds>	 dear god, people do terrible things to their useragent
[20:30:30] <Ironholds>	 there's one guy I'm tempted to ask Ops to actively block.
[20:30:52] <YuviPanda>	 Ironholds: :)
[20:31:57] <grrrit-wm>	 (PS2) Ottomata: Adding oozie files to control addition and deletion of webrequest table partitions [analytics/kraken] - https://gerrit.wikimedia.org/r/131208
[20:40:34] <andrewbogott>	 Ironholds: I emailed you earlier in the week about your labs vs. production username.  Any thoughts?
[20:41:15] <Ironholds>	 andrewbogott, I'll switch my labs account
[20:41:25] <Ironholds>	 don't think I've ever used labs for anything, minus a few gerrit commits
[20:41:35] <andrewbogott>	 Ironholds: ok, thanks.  Just let me know when you're set up and I'll switch your UID to match.
[20:41:39] <Ironholds>	 shall do :)
[20:41:44] <Ironholds>	 sorry, this week has been...ruinous
[22:46:25] <grrrit-wm>	 (PS1) Terrrydactyl: Fixes problem with deleting empty cohorts. [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/131232 (https://bugzilla.wikimedia.org/64724)
[23:53:25] <grrrit-wm>	 (CR) MarkTraceur: [C: 2 V: 2] Fix wrong tsv url for image performance map [analytics/multimedia/config] - https://gerrit.wikimedia.org/r/131039 (owner: Gilles)