/srv/irclogs.ubuntu.com/2011/08/26/#launchpad-yellow.txt

gary_posterdanilos, oops :-P11:31
gary_postersorry and thanks11:31
danilosgary_poster, does the change look good? I wasn't sure if I was just not seeing something11:37
gary_posterdanilos, actually...that's not quite what I want, but what I want may not work for make harness.11:38
gary_posterlemme actually merge your branch11:38
danilosgary_poster, sure... I just re-introduced the two lines that were there previously at roughly the same spot11:38
gary_posterright danilos; my intent was to move them down into success/failure; that means that you get start and stop times like you do with the OOPS report, which I found nice.11:39
gary_posterthat may not be make-harness-friendly though11:39
gary_posterdanilos, no, what you've done effectively doubles what I've done, as I feared.  We may need to rip out one of the changes I made (an improvement, IMO, so that's too bad) to make it work as you want11:43
gary_posterdanilos, take a look at lines 685-687 in the file in your branch11:43
benjiyay! sweet, sweet Internet11:44
gary_posterbenji, hiya!  So, another quake yesterday evening?  I got your mail.  What was the Richter scale number?11:44
benjigary_poster: heh, no, different natural disaster this time, major thunderstorm11:45
gary_posteroh, ok benji11:45
danilosgary_poster, oh, indeed11:45
benjitrees blocking the road, power lines down11:45
gary_posteroof11:45
danilosgary_poster, I also had trouble with scripts (where I noticed it first)11:45
benjion my ride this morning it looked like we were hit with a huricane, but no, that's tomorrow11:45
gary_posterdanilos, that really seems odd, doesn't it?11:45
gary_posteryeah, benji :-(  I hope that's not as bad as it might be11:46
gary_posterfor the whole east coast11:46
benjiif the rivers turn into blood I won't be working for a few days11:46
danilosgary_poster, well, I think it's quite obvious, action is None in there, perhaps we can just log the SQL statement if action is None?11:47
danilosgary_poster, of course, ideally, the tracer would be installed for the script layer as well11:48
gary_posterdanilos, right, but how could action be None?  and presumably the tracer must be installed for the script layer if it worked before11:49
gary_posterdanilos, notice that the previous stderr.write that you reinstated in your branch is in the tracer11:49
gary_posterbut before the SQL is called11:49
danilosgary_poster, yeah11:49
gary_posterand I simply have it in the same tracer, after the SQL is called11:50
gary_posterand the code before the SQL is called stashes the action on the connection in all cases11:50
danilosgary_poster,         if request_starttime is None:11:50
danilos            return11:50
danilosgary_poster, that could be the culprit11:50
gary_posterdanilos, ah, duh, of course11:50
gary_posterdanilos, http://pastebin.ubuntu.com/675182/?11:52
gary_posterdanilos, except we want the return too :-P11:52
danilosgary_poster, yeah :)11:52
gary_posterhttp://pastebin.ubuntu.com/675183/11:53
danilosgary_poster, btw, would it perhaps be possible to record the start time as well or do we really need a request?11:53
danilosgary_poster, (really need a request to be able to use the same code path: it'd be nice to get timings for running scripts as well)11:53
danilosgary_poster, otherwise, r=me :)11:54
danilosgary_poster, fwiw, if you don't want to be bothered creating a branch with this, I've pushed the suggested change up, you can ack it so we can land it, but if you want to fix it in a better way, you can still do it :)11:57
gary_poster:-) danilos, "record the start time": we could get a duration easily enough, I guess, by scribbling the current time and the statement_to_log on the connection when we don't have an action; or we could do mildly tricky things with the transaction module so that a commit or an abort resets a connection scribble of start time, and "0" is always guesstimated as the first SQL request of the transaction.12:01
gary_posterI don't want to do the second idea; the trickiness is non-trivial (relatively easy and fun to code, but things could go wrong in potentially serious ways so I'd want tests and stuff).12:02
gary_posterThe first idea would be ok.  looking around for a sec...12:02
gary_posterdanilos, I have another related branch to fix another sqlprofiler issue that I was unable to land because of some ec2 image problems I had last night.  I can just combine and land them.12:02
danilosgary_poster, ok, sure, I'll scrap my branch then12:09
danilosgary_poster, I hope it's not the versioninfo thing, that was supposed to be fixed by now :/12:10
gary_posterdanilos, you mean my ec2 problems?  I think it was just because I was using a version of ec2 test from before StevenK blessed himself as an image provider, so I got an earlier revision12:11
gary_posterIf not, I'll be surprised12:11
danilosgary_poster, oh, ok12:11
benjigary_poster: oh, Bella is going on a play date today, she's being picked up around 8:30 so I may disappear from the call12:16
gary_posterok benji.  as long as that doesn't involve you disappearing down into the crevice of an earthquake's fault line, or up into a hurricaine's sky, I'm OK with it.12:17
benjiheh12:18
benjiI expect locusts at any moment.12:18
gary_poster:-)12:19
gary_posterbac benji danilos gmb, call in 112:31
gary_posterdanilos, http://pastebin.ubuntu.com/675206/12:33
danilosgary_poster, looks nice, albeit 0-something for every query is a bit dull, but good enough for me :)12:40
benjibac: screen sharing is easy if both users have ssh access to the same host, is that the case?12:46
danilosgary_poster, oh, btw, I hope you'll be able to re-land your change using getMergeProposals() today, but the same caveat holds for you: you might need to pass in visible_by_user to get the private branches as well12:46
danilosgary_poster, (my branch is in ec2 with the private branches fix, basically just adding a test and that parameter to the call)12:47
gary_posterdanilos, 0-something: you want me to put in an XXX?  I agree that it would be nicer, but not enough to do what I can see would fix it.12:48
gmbJS question: If I load some HTML containing JS via an async request, that JS won't automatically be executed, will it? (e.g. pulling in another page via Y.io won't load that page's JSON object cache, will it?)12:49
danilosgary_poster, I don't even care about the XXX12:49
danilosgmb, nope, it'd have to get "rendered" first, what you pull up is just text12:49
danilosgmb, if it is json, some of our own methods will parse it though12:49
danilosgmb, lp_client.named_get or something like that12:50
gary_posterdanilos, ok cool. :-) re-land my change: ok I'll take a look, thanks.  I suspect that for my case I won't need to because I'm already passing in branches that have been filtered in that way12:50
bacbenji: i guess it can be the case, if we're willing to grant access to each other12:50
danilosgary_poster, right, if the call was already getMergeProposals() before, you should be good12:50
bacbenji: so one just creates a screen and the other connects to it?12:51
benjibac: basically.  you have to turn multiuser on and grant the other user access, let me see what I can find on the net...12:51
bacbenji: that's ok, i'm still looking12:52
benjibac: here's a good description: http://stackoverflow.com/questions/471354/sharing-a-gnu-screen-session/1896576#189657612:52
gary_posterdanilos, cool12:53
gmbdanilos: Thanks.13:00
gary_posterbenji, bac, my concern is that I believe we want ssh tunnels involved too, and I don't think that's what is going on in the stackoverflow answer (and I think that's the interesting part of what the LOSAs know how to do).  I suspect it is easy...ah.13:32
gary_posterhttps://wiki.canonical.com/InformationInfrastructure/OSA/ScreenSharingWithDevs FWIW13:32
benjigary_poster: other than using ssh to connect the terminal session, what tunneling do you mean?13:33
gary_posterthat's all I mean, benji--what that page describes is what I was hoping for--actually, more paranoid, as you'd expect13:34
gary_poster(the "more paranoid" part is that I'd expect we'd just let the other person act as us.  Maybe we ought to include that paranoia too, though.)13:35
bacgary_poster: benji and i are working on tunneling now13:36
gary_posteryay, cool13:36
bacgary_poster: in that wiki page i don't understand the step: "Have the dev login as the user directly"13:40
gary_posterbac, like, as the pgsql user or the mongo user or what have you13:44
gary_posterIOW something specific to how deployment machines are usually set up13:44
gary_posterSome of that happens on dev machines, but we pretty much do everything as us13:45
* gary_poster going to do some CHR, since I've not had a good week for it.13:50
gmbIT WORKS, LET's MERGE IT.13:57
gary_posterAnybody ever heard of Launchpad Results?13:58
gmbI mean... oh, that's nice.13:58
danilosall, I am off, and I forgot to mention that I am off on Monday: enjoy the weekend all :)13:59
gmbgary_poster: Never heard of it until now.14:00
gmbgary_poster: looking at the code, it seems to do a lot of reinventing the wheel...14:01
gmbAh, maybe that's because they want to represent LP stuff in a non-LP webapp/microsite/somethign.14:02
gary_posterbye danils14:19
gary_posterdanilo_ that is14:19
bachi benji, i got disconnected14:36
benjiI figured. :)14:36
bacbenji: you should be able to get in now, right?14:36
benjiit worked!  I had to specify the user name, like so: ssh guest@spoetzl.net -p 220014:36
baccool14:47
bacthanks for the help benji.  i'll write this up14:49
benjimy pleasure14:49
bacgary_poster: did you get my question earilier about the wiki instructions?14:50
gary_posterbac, you mean "gary_poster: in that wiki page i don't understand the step: "Have the dev login as the user directly""?14:50
bacgary_poster: yeah.  sorry, my connection dropped and i lost irc history14:50
gary_posterbac, np.  This was my reply:14:51
gary_posterbac, like, as the pgsql user or the mongo user or what have you14:51
gary_posterIOW something specific to how deployment machines are usually set up14:51
gary_posterSome of that happens on dev machines, but we pretty much do everything as us14:51
gary_posterbac, make sense?  I'm about to run out to an early lunch14:52
bacgary_poster: no14:52
bacgary_poster: we can chat after lunch14:52
gary_posterbac, admins run processes as different users14:52
gary_posterso there will be an apache user14:52
gary_postera lp user14:52
gary_postera postgres user14:52
gary_posterand so on14:52
bacgary_poster: right, i understand that14:52
gary_posterso the dev should log in as the user that they need access to14:53
gary_posterthat's what I understand14:53
bacgary_poster: so do the losas give you an account and passwd for, say, the apache user?14:53
bacgary_poster: again, no rush.  enjoy your lunch.14:54
gary_posterno, bac, not an account.  they put the dev's key in the user's authorized keys.  See step 2 on that page14:55
gary_poster"[...] to (as example) marang:/etc/ssh/user-authorized-keys/couchdb"14:55
gary_posterso the dev key is now a temporarily authorized key for the couchdb user in that case14:56
* gary_poster goes now bac. :-)14:56
gary_postertalk to you in a bit14:56
bachey benji, try logging in as guest@spoetzl.net again.  this time it should ask for your SSH credentials15:02
benjibac: it's prompting me for a password (and not accepting the one that worked before)15:04
bacbenji: try your ssh credentials password15:04
bacor is it wanting a unix password?15:04
benjiit's wanting guest's password15:04
benji(unix)15:04
bacbenji: i tried using the steps here https://wiki.canonical.com/InformationInfrastructure/OSA/ScreenSharingWithDevs15:04
bacand entered your ssh key from LP for guest15:05
baci wonder if there is sshd config needed to allow user-authorized-keys15:05
* bac re-googles15:05
benjibac: when you get a second, will you look at https://code.launchpad.net/~benji/launchpad/bug-820055/+merge/73064 for me?15:19
bacbenji: sure15:19
benjiI'm going to lunch now.15:19
benjithanks15:19
gary_posterbac, I'm back, but it sounds like you're now past what we were talking about16:10
bacgary_poster: yes, thanks.17:04
gary_postercool17:05
* gary_poster tried to pay penance for his poor-CHR ways this week, but is now finished.17:31
bacgary_poster: work in progress https://dev.launchpad.net/yellow/UsingScreen17:38
gary_posterbac, nice.  I'm still trying to understand all of it.17:43
bacgary_poster: it's still sort of hacky.  don't like having to pass around passwords17:43
bacand the command limit is nice.  but it doesn't work atm17:43
gary_posterbac, passing around passwords: I take it that getting the key from Bob and putting it in authorized keys didn't work?  That's what I would have expected to be the answer17:45
gary_posterI've seen the command limit work, of course, but I'lve never set it up myself17:45
bacgary_poster: yeah, that'll probably work if i remove the 'command=' part17:45
gary_posterhuh17:45
bacright now it reports "no screen to connect to"17:45
gary_posterfwiw, the combination (both command and authorized keys) is how, for instance, Zope.org svn was and probably still is set up17:46
gary_posterso "it ought to work" but I know that's not particularly helpful17:46
benjinot yet, but I may when my current ec2 run is done17:51
gary_posterbenji, I suspect that's a follow-on to my ec2 woes in #launchpad-dev?18:08
benjiheh, yeah18:08
* benji resets the "It's been 14 days since an IRC channel accedent" sign.18:09
gary_poster:-)18:25
benjisomeone alert MC Hammer, it's OCR time!19:00
benjithat didn't take long19:07
bacchrs20:05
bacchr done20:16
bachad a paying customer complaining about openid and private email list archives https://bugs.launchpad.net/launchpad/+bug/66392320:17
_mup_Bug #663923: Cannot view list archive of private team <mailing-lists> <ml-archive-sucks> <regression> <Launchpad itself:In Progress by mars> < https://launchpad.net/bugs/663923 >20:17
bacgary_poster: have you stocked up on milk and D batteries?20:26
gary_posterbac, milk, yes, D batteries, not so sure, but hopefully.  That remonds me, we were going to plug the iPad in to make sure it had juice to amuse the kiddies in the dark. :-) how about you, bac?20:27
bacgillam's parents and brother from nags head showed up yesterday with three coolers of food20:27
bacso we won't starve20:28
gary_posterheh20:28
gary_postercool20:28
bacmight go crazy and kill some people, though20:28
gary_posterstay away from us when you feel that way, then!20:28
bac:)20:28
bacjojo is very stressed and won't leave my side20:28
gary_posteroh, benji, bac, I'm going to go to the clojure conj (http://clojure-conj.org/) in Raleigh, using my conference days.  I'm seeing if I can use training money to defray the registration cost--I need to check with Sarah about that.  ClojureScript (Clojure plus Google Closure) is a potentially big enough deal that it is moderately arguable for me to spend the time, and I just wanted to anyway, and Francis was ok with i20:31
gary_posterthat was intended as an invitation ;-)20:31
gary_posterbenji, I expect you need to be home20:31
gary_posterbut if you wanted to stay here for the conference, you certainly could20:31
gary_posterbac, poor jojo20:31
gary_posterbrb20:32
bacgary_poster: i'll be away those days in california20:32
gary_posteroh right20:32
benjigary_poster: I'd love to go.  I somewhat doubt I can swing being away from home though.  Let me think about it and I'll get back to you on Monday.20:33
gary_postercool benji20:39
bacy'all have a nice weekend.  stay dry.20:57
benjibac: same to you21:01

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!