| 00:17.16 | jsmith | Try number three... |
| 00:17.20 | jsmith | blitzrage: I'm getting close |
| 00:17.35 | blitzrage | jeebuz, you're still at it?! |
| 00:17.41 | blitzrage | I thought you had family coming over? |
| 00:18.30 | jsmith | Well, there's a giant argument over religion going on downstairs, so I snuck upstairs to keep working on it |
| 00:21.29 | blitzrage | haha |
| 00:21.36 | blitzrage | good call |
| 00:21.42 | blitzrage | isn't there a rule about not talking about politics and religion at the dinner table? |
| 00:24.48 | jsmith | Well, to put it bluntly, my great-aunt (who we're living with) decided that tonight was the night to convince us all that we're wrong in our beliefs |
| 00:25.01 | blitzrage | oh nice |
| 00:25.02 | jsmith | So it's been interesting |
| 00:25.05 | blitzrage | totally |
| 00:25.29 | jsmith | So, I'm periodically walking up here to check on the RPM when it gets hot downstairs |
| 00:25.48 | jsmith | (I'd rather not get kicked out tonight -- I've still got a couple of months until my house is done) |
| 00:25.59 | blitzrage | heh, true |
| 00:26.09 | blitzrage | what is her position? |
| 00:26.25 | blitzrage | are you not radical enough, or are you too radical for her? |
| 00:26.47 | jsmith | Her position is that Mormonism is wrong, because her mom couldn't go to her nephew's wedding. |
| 00:27.24 | jsmith | Now, obviously, there's more to it than that. |
| 00:27.34 | jsmith | But that's the point she's trying to prove. |
| 00:28.14 | jsmith | And since my parents are here, and my grandparents... she figured she'd spring this on us all at once :-) |
| 00:29.48 | blitzrage | well handy.... |
| 00:30.03 | blitzrage | and why couldn't her mom go to her nephew's wedding? |
| 00:56.59 | Juggie | ooo leafs game |
| 01:07.43 | blitzrage | w00t! |
| 01:07.49 | blitzrage | should be starting here any minute!!! |
| 01:22.39 | Juggie | woot |
| 01:22.45 | Juggie | i finally finished setting up my speakers |
| 01:22.50 | blitzrage | lol |
| 01:22.51 | Juggie | now i just need wire molds |
| 01:22.59 | Juggie | hehe, i ran out of speaker wirecable |
| 01:23.03 | Juggie | er, -cable |
| 01:23.13 | Juggie | so i ordered more, got it last week, just set it up. |
| 01:23.15 | Juggie | 6.1 woot. |
| 01:23.29 | Juggie | of course that doesnt really help for sports net leafs hockey |
| 01:23.31 | Juggie | but what can you do. |
| 01:32.15 | blitzrage | lol |
| 01:32.17 | blitzrage | true |
| 01:32.25 | blitzrage | I hate that sportsnet rarely broadcasts HD |
| 01:32.32 | blitzrage | all they show is fuckin poker |
| 01:39.42 | Juggie | sportsnet doesnt have a national hockey license this year |
| 01:39.45 | Juggie | which is why no hd. |
| 01:40.19 | Juggie | tsn would hapily do it all in hd |
| 01:40.34 | Juggie | but, they dont have a second hd channel to sub over the first one when they block out all but the GTA for hockey |
| 01:40.42 | Juggie | but, they have applied for a license for another. |
| 01:40.46 | Juggie | so, soon, i hope. |
| 01:59.30 | jsmith | blitzrage: How's the hockey game? |
| 01:59.56 | blitzrage | jsmith: going good -- 1st intermission, Leafs up 1-0 |
| 02:00.19 | jsmith | Well, hopefully they won't leaf this one up to chance... |
| 02:00.19 | blitzrage | Juggie: oooooh ok -- thanks for that. That helps make some more sense of it. |
| 02:00.45 | blitzrage | hopefully :) This would be 5 wins in a row for the Leafs. Both the Raptors and Leafs are on a winning tear lately |
| 02:06.27 | Juggie | blitzrage, SN has the same problem |
| 02:06.36 | Juggie | if they would just do like sports net west HD and east HD |
| 02:06.46 | Juggie | they could do games in HD because they would have a feed to replace |
| 02:06.48 | blitzrage | yah, I find the whole blackout area thing really annoying anyways |
| 02:06.59 | Juggie | like right nowif i tuned to sports net |
| 02:07.02 | Juggie | it would be sports net east |
| 02:07.09 | Juggie | even thought i should have sports net ontario |
| 02:07.56 | Juggie | yes it is |
| 02:08.02 | Juggie | even more annoying when your a leafs fan in ottawa :) |
| 02:09.01 | Juggie | woot |
| 02:09.07 | Juggie | my home theatre is all rewired with good cable |
| 02:09.28 | Juggie | when i was talking to you i'd done one speaker, then i redid the front 3 which were on the crappy cable that came with the receiver |
| 02:10.12 | Juggie | i have exactally 200feet of speaker wire in use :) |
| 02:23.00 | jsmith | blitzrage: OK... one last build, and hopefully we're golden |
| 02:23.19 | blitzrage | nice! |
| 02:24.45 | Juggie | grrrr blitzrage! grrr... |
| 02:24.51 | blitzrage | no kidding |
| 02:25.06 | blitzrage | I thought Raycroft was gonna get that |
| 02:29.05 | Juggie | grrr... |
| 02:29.10 | Juggie | i hate backing up and organizing files. |
| 02:29.36 | Juggie | blitzrage, guess what i did last night... |
| 02:29.43 | Juggie | killed king koopa in super mario 3 :) |
| 02:29.46 | blitzrage | lol |
| 02:29.52 | Juggie | i played it from level 1-8 no warping :P |
| 02:29.53 | blitzrage | nice :) |
| 02:30.01 | Juggie | over the last week |
| 02:30.04 | Juggie | didnt do it all in one night |
| 02:33.34 | Juggie | wooot |
| 02:33.48 | Juggie | he worked his ass off for that |
| 02:35.44 | blitzrage | YES!!! |
| 02:35.59 | blitzrage | I think I'm stil a few seconds delayed on the PVR |
| 02:36.04 | blitzrage | good for Stajan |
| 02:36.15 | Juggie | hah |
| 02:36.16 | Juggie | you nub |
| 02:36.32 | Juggie | it was steen |
| 02:36.32 | blitzrage | oops |
| 02:36.32 | blitzrage | 10 |
| 02:36.32 | blitzrage | heh |
| 02:36.33 | blitzrage | <-- nub |
| 02:37.09 | Juggie | blitzrage, hows the new and improved rebuilt network. |
| 02:38.25 | blitzrage | it's great. Everything goes through a linux server, so when I have some time, I can setup load balancing |
| 02:38.55 | Juggie | you mean linux does your nat? |
| 02:40.23 | blitzrage | yep |
| 02:41.17 | blitzrage | Rogers and DSL go into my desktop, then the LAN port goes to a switch. A cable runs to the back of the room from the switch to my phones (which are daisy chained together), and the wifi plugs into the switch for the laptops (I don't mind if the laptops are double NAT'd) |
| 02:41.59 | Juggie | daisy chained with poe in between |
| 02:42.01 | Juggie | ewwwwww |
| 02:42.47 | Juggie | why not everything into one switch, dont have one thats big enough? |
| 02:42.59 | Juggie | clearly you need a 3750 24port poe :) |
| 02:43.15 | blitzrage | I don't have PoE |
| 02:43.27 | blitzrage | I have a PoE injector with a pass through port |
| 02:43.39 | blitzrage | I just use the internal switching of the phones and plug short cables between them |
| 02:43.48 | blitzrage | the switch is only 5 ports, and on the other side of the room |
| 02:43.59 | Juggie | yah.. i guess :) |
| 02:44.02 | Juggie | why the double nat though :P |
| 02:46.44 | Juggie | i know i dont have to tell you, you can just turn off the dhcp server on the wifi router, and cross over one of the lan ports into your switch, because thats how it was setup at *-con. |
| 02:46.47 | jsmith | blitzrage: /home/rpmbuild/rpmbuild/RPMS/i386/ on .10 |
| 02:46.58 | blitzrage | w00t! |
| 02:47.12 | jsmith | You owe me ;-) |
| 02:47.13 | Juggie | i386?! |
| 02:47.27 | jsmith | Yeah, I know... there's a SRPM there for other architectures too |
| 02:47.41 | Juggie | what is it? |
| 02:47.59 | blitzrage | Juggie: yah.... hrmmm... I should probably do that, lol |
| 02:48.17 | Juggie | blitzrage: might be a good idea :) |
| 02:48.37 | blitzrage | now I gotta find a crossover cable :) |
| 02:48.45 | blitzrage | I think I have one kicking around here somewhere |
| 02:48.53 | blitzrage | will have to look into doing that tomorrow |
| 02:48.55 | Juggie | surgery man surgery |
| 02:49.04 | Juggie | open up the cable, cross it over, twist wires, duct tape. |
| 02:51.15 | blitzrage | dirty |
| 02:51.22 | jsmith | G'night! |
| 02:51.35 | blitzrage | night! |
| 02:53.09 | Juggie | blitzrage, i know you like it dirty. |
| 02:53.30 | blitzrage | of course |
| 02:59.26 | Juggie | woot, what save |
| 03:02.42 | blitzrage | that save was REDICULOUS |
| 03:04.53 | blitzrage | grrrrr Stajan |
| 04:28.48 | *** join/#asterisk-doc bkruse_home (n=kruz@69.73.127.92) |
| 04:35.08 | *** join/#asterisk-doc Juggie (n=Juggie@CPE00c049d9f271-CM000a73a18a20.cpe.net.cable.rogers.com) |
| 09:20.24 | *** join/#asterisk-doc MatsK (n=mats@me-0-8-2-ac-d1-b6.2.cust.bredband2.com) |
| 13:45.16 | *** join/#asterisk-doc jsmith (n=jsmith@h460562e8.area3.spcsdns.net) |
| 13:45.17 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 14:42.55 | *** join/#asterisk-doc blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) |
| 14:42.55 | *** mode/#asterisk-doc [+o blitzrage] by ChanServ |
| 14:44.56 | *** topic/#asterisk-doc by blitzrage -> Welcome to the Asterisk Documentation Project! GO LEAFS GO! |
| 14:45.57 | jsmith | morning blitzrage |
| 14:46.02 | jsmith | How'd the RPMs work out? |
| 14:46.22 | jsmith | We having a conf. call this morning? |
| 14:46.26 | blitzrage | I think so |
| 14:46.29 | blitzrage | I just woke up :) |
| 14:46.38 | jsmith | Good for you! |
| 14:46.42 | blitzrage | I realized that you built on FC6 right? |
| 14:46.50 | blitzrage | nice, I'm in my PJs |
| 14:46.54 | jsmith | Yes, I built on FC6 |
| 14:47.03 | jsmith | But you should be able to rebuild the SRPM on CentOS just fine |
| 14:47.08 | blitzrage | gotcha |
| 14:47.14 | jsmith | rpmbuild --rebuild foo.SRPM |
| 14:47.46 | blitzrage | Leafs game was on last night, so I didn't get to the RPMs. Ended up building against the standard postgresql just to get something up last night. |
| 14:47.54 | blitzrage | but will rebuild today |
| 14:47.58 | jsmith | Ah... |
| 14:48.00 | jsmith | OK. |
| 14:48.05 | jsmith | Did the Leafs win? |
| 14:48.23 | blitzrage | I had to learn how to build the RPMs, so I modified the .spec file until it built |
| 14:48.29 | blitzrage | basically had to removed everything to do with Radius |
| 14:48.37 | blitzrage | yeppers! 2-1. That's 5 games in a row now. |
| 14:48.43 | blitzrage | They are undefeated since the all-star break |
| 14:48.52 | *** topic/#asterisk-doc by blitzrage -> Welcome to the Asterisk Documentation Project! Official documentation project of the Toronto Maple Leafs :) |
| 14:54.05 | blitzrage | I'm trying to figure out why my rule on this view updates the entire column even though I have a WHERE clause... |
| 14:54.34 | blitzrage | well, at least I will be once I reconnect to the DB in a minute |
| 15:01.27 | jsmith | Time for a quick snowball fight... back in a few |
| 15:03.06 | blitzrage | coo |
| 15:09.56 | jsmith | Whew... that was fun |
| 15:15.33 | blitzrage | jsmith: if I have data passed to me as lmadsen#lmentinc, how do I split that with pgsql? |
| 15:15.54 | blitzrage | I need to split on the # and do WHERE user_name = 'lmadsen' AND pbx = 'lmentinc' |
| 15:16.14 | jsmith | Hold please |
| 15:16.18 | blitzrage | holding! |
| 15:18.36 | jsmith | SELECT split_part('lmadsen#lmentinc','#',1) as user_name, split_part('lmadsen#lmentinc','#',2) as pbx; |
| 15:18.52 | blitzrage | great, thanks! |
| 15:19.04 | jsmith | Whew! That was from memory, and it worked! |
| 15:19.12 | blitzrage | nice |
| 15:21.13 | Juggie | argh. |
| 15:21.24 | Juggie | i go to use the fax machine and someone has a 20 page fax queued up ahead of me |
| 15:22.36 | blitzrage | CREATE OR REPLACE RULE sip_realtime_update AS |
| 15:22.36 | blitzrage | ON UPDATE TO sip_realtime DO INSTEAD |
| 15:22.36 | blitzrage | UPDATE ast_user SET rt_ipaddr = new.ipaddr, rt_port = new.port, rt_regseconds = new.regseconds |
| 15:22.36 | blitzrage | WHERE user_name = 'lmadsen' |
| 15:22.41 | blitzrage | <PROTECTED> |
| 15:22.57 | blitzrage | that is the rule I am creating... how is the 'lmadsen' part passed to the rule? |
| 15:23.18 | blitzrage | i.e. where is it stored..... NEW.username or something? |
| 15:23.47 | blitzrage | but it wouldn't know about a column name... so it seems like it needs like an ARG1 variable |
| 15:23.54 | jsmith | OLD.username? |
| 15:24.14 | jsmith | A rule only gets things from the OLD row and the NEW row, as I recall |
| 15:24.20 | jsmith | You don't pass arguments to a RULE |
| 15:25.17 | blitzrage | well, say I'm doing something like "UPDATE my_view SET ipaddr = '5.5.5.5' WHERE userpbx = 'lmadsen#lmentinc' would the value be stored in OLD.userpbx or something? |
| 15:25.28 | blitzrage | I'm confused how it would know what column you're taking about? |
| 15:25.33 | blitzrage | or would that be NEW.userpbx ? |
| 15:25.58 | blitzrage | seems like it might be NEW.userpbx to me.... ? |
| 15:26.44 | jsmith | Yes. |
| 15:26.56 | jsmith | Both OLD.userpbx and NEW.userpbx should be the same |
| 15:29.13 | blitzrage | maybe something like this... ? |
| 15:29.15 | blitzrage | CREATE OR REPLACE RULE sip_realtime_update AS |
| 15:29.15 | blitzrage | ON UPDATE TO sip_realtime DO INSTEAD |
| 15:29.15 | blitzrage | UPDATE ast_user SET rt_ipaddr = new.ipaddr, rt_port = new.port, rt_regseconds = new.regseconds |
| 15:29.15 | blitzrage | WHERE OLD.user_name = split_part(NEW.name, '#', 1) AND OLD.pbx = split_part(NEW.name, '#', 2) |
| 15:29.52 | blitzrage | actually. I don't think I need the OLD stuff in there |
| 15:31.22 | blitzrage | w00t!!!! it worked! |
| 15:31.31 | blitzrage | jsmith: thanks so much! |
| 15:43.44 | jsmith | blitzrage: No problem... I'm glad to help out |
| 15:46.16 | blitzrage | I can't believe my rule worked the first time I tried it, lol |
| 15:46.19 | blitzrage | always nice |
| 15:46.25 | jsmith | Yup ;-) |
| 16:27.38 | jsmith | Any idea when we're going to have our conf. call? |
| 16:29.00 | blitzrage | trying to find out if we can get a hold of Terry for today I think |
| 16:48.38 | blitzrage | jsmith: sounds like around 3pm EST |
| 16:56.17 | jsmith | OK |
| 16:56.23 | jsmith | I'll be back by then |
| 16:56.26 | jsmith | Time to go sledding |
| 16:57.33 | blitzrage | have fun! |
| 18:34.58 | Juggie | sigh, my first mortgage payment comes out tomorow |
| 18:35.00 | Juggie | that scares me. |
| 18:35.21 | Juggie | its about 300$ shy of being two weeks pay. |
| 18:35.23 | Juggie | :( |
| 18:36.04 | blitzrage | eeesh |
| 18:36.22 | Juggie | to each his own. |
| 18:36.43 | Juggie | at least i will get all this money back someday |
| 18:36.43 | blitzrage | unless you die first :) |
| 18:36.43 | Juggie | hah |
| 18:36.43 | blitzrage | or the housing market explodes... |
| 18:36.44 | Juggie | well, someone will get it. |
| 18:36.51 | Juggie | the ottawa housing market isnt going anywhere. |
| 18:38.22 | Juggie | yah money is definitally tight this payweek |
| 18:38.48 | blitzrage | just don't order any strippers :) |
| 18:38.50 | Juggie | but then the following week its not, so balances out i guess :) |
| 18:38.57 | Juggie | now if only rogers would give me my friggen bill |
| 18:39.14 | blitzrage | ok, off to shower and such, back in a bit |
| 19:15.44 | Alric-Ofce | 234 days uptime, not bad. |
| 19:15.59 | Alric-Ofce | for being a dell server in the broom closet of a manufacturing plant stored right next to the mop thing full of water... |
| 20:24.40 | blitzrage | jsmith: you missed the meeting! |
| 20:24.58 | blitzrage | (but it's ok, I got my questions answered from Terry :)) |
| 20:31.23 | Alric-Ofce | CentOS 5! |
| 20:31.48 | jsmith | blitzrage: Sorry... I just got back |
| 20:34.30 | blitzrage | jsmith: not a problem. Don't think you missed much |
| 20:34.50 | jsmith | Whew... |
| 20:35.07 | jsmith | (ended up going out to eat, and it took longer than I wanted it to) |
| 20:35.09 | blitzrage | not a problem |
| 20:35.12 | blitzrage | Alric-Ofce: eh? |
| 20:35.23 | jsmith | Alric-Ofce: What about CentOS 5? |
| 20:35.35 | Alric-Ofce | I'm reading about how CentOS 5 should be "Real Soon Now" |
| 20:35.50 | jsmith | Sure... a couple of weeks after RHEL 5 is out. |
| 20:35.53 | blitzrage | yep |
| 20:35.58 | jsmith | I've got RHEL5 Beta 2 somewhere here. |
| 20:36.08 | Alric-Ofce | But that was in January. I'm starting to feel like 1.4 in July :) |
| 20:36.09 | blitzrage | heh |
| 20:36.20 | blitzrage | 1.4 SVN seems to work for me |
| 20:36.37 | Alric-Ofce | I mean 1.4 on 7/1/2006 |
| 20:36.52 | Alric-Ofce | (Any day now... when any day = 12/23/2006) |
| 20:37.44 | blitzrage | ahhhh |
| 20:38.00 | blitzrage | eh? |
| 20:38.19 | blitzrage | oh, you mean someone said any day now in July, but released in Dec. |
| 20:38.21 | Alric-Ofce | Still not getting it? |
| 20:38.24 | Alric-Ofce | Yeah. |
| 20:38.41 | blitzrage | I can't believe I spent the time to really care :D |
| 20:39.21 | Alric-Ofce | I hope CentOS 5 has PHP5 |
| 20:39.47 | Alric-Ofce | Else Debian will end up being more "advanced"... and then the world will end ;) |
| 20:40.27 | jsmith | Alric-Ofce: It will... in fact, you can get PHP5 for CentOS 4 from the CentOS-Plus repo |
| 20:40.44 | blitzrage | heh, I was just gonna say that :) |
| 20:40.57 | Alric-Ofce | I thought one of you would chime in with that. |
| 20:41.01 | jsmith | But I beat you to it ;-) |
| 20:41.05 | Alric-Ofce | With some useful tidbit of information. |
| 20:41.08 | blitzrage | yum --enablerepo=centosplus install php I think |
| 20:42.31 | blitzrage | weeeee.... off to SER enable my Asterisk stuff :) |
| 20:42.55 | jsmith | w00t! |
| 20:48.18 | Juggie | :) |
| 20:48.22 | Juggie | centos is king |
| 20:52.20 | jsmith | Well, RHEL is king, and CentOS is a free replacement, but yeah.... |
| 20:53.27 | Juggie | either way :) |
| 21:19.33 | jsmith | blitzrage: Were you able to rebuild that SRPM? Did it do the trick? |
| 21:19.51 | blitzrage | jsmith: sorry, haven't gotten that far yet today |
| 21:19.59 | blitzrage | creating all the DB stuff for SER right now |
| 21:21.33 | jsmith | Ah, fun. |
| 21:47.11 | Juggie | hmmmmm |
| 21:47.17 | Juggie | blitzrage, 4:45, looks like quittnig time. |
| 21:47.42 | Juggie | :> |
| 21:47.51 | Juggie | man i cant type lately. |
| 21:47.55 | Juggie | *quitting |
| 21:48.44 | Juggie | i'm gonna go buy some sneakers, a copy of delirious and go to the gym. |
| 21:51.43 | Alric-Ofce | Lazy Government types. |
| 22:28.17 | jsmith | http://beta.zooomr.com/photos/33360@Z01/717163 |
| 22:28.37 | jsmith | Took that picture on my way back from Mississippi ... still want to know what's at the state park... pancakes and bacon maybe? |
| 22:47.21 | Alric-Ofce | you know the SQL command LIMIT <number> ? |
| 22:47.37 | Alric-Ofce | like select mailbox from voicemail_users limit 1? Access can't do that. |
| 22:49.04 | blitzrage | yes |
| 22:49.07 | blitzrage | Access sucks |
| 22:49.10 | blitzrage | don't use it |
| 22:50.20 | Alric-Ofce | I try not to. |
| 22:50.29 | Alric-Ofce | But my Accounting Information Systems class requires it. |
| 22:52.17 | blitzrage | ahhhh, school |
| 22:52.23 | blitzrage | I haven't been in school for 2 years now |
| 22:55.34 | Alric-Ofce | Yeah yeah./ |
| 23:00.31 | jsmith | Alric-Ofce: SELECT TOP 1 foo FROM bar; |
| 23:00.45 | jsmith | Alric-Ofce: It's the same syntax as SQL Server |
| 23:03.17 | Alric-Ofce | on Access? |
| 23:03.26 | jsmith | Should work |
| 23:07.20 | Alric-Ofce | Argh. |
| 23:07.28 | Alric-Ofce | Someone called me with a problem yesterday. |
| 23:07.38 | Alric-Ofce | Can't for the life of me remember what it was though. I wrote it down... |
| 23:14.07 | Alric-Ofce | Oh, here's an interesting problem: |
| 23:14.41 | Alric-Ofce | So I have these pagers connected to ATAs. They have no timeout (they'll never hangup on their own), and they wait for the CPC disconnect signal from the ATA to tell them to hang up. |
| 23:14.57 | Alric-Ofce | Under normal circumstances, that would have been fine. But the PBX locked up and had to be rebooted. |
| 23:16.05 | Alric-Ofce | Now, those pagers never got their CPC disconnect signal and are still active, even though the ATAs spontaneously lost the connection. So, any idea how to dial up an ATA that is reporting back BUSY and tell it to hang up? :) |
| 23:17.03 | jsmith | Unplug the device. |
| 23:17.08 | jsmith | Wait three seconds |
| 23:17.09 | jsmith | Plug it back in |
| 23:23.55 | Alric-Ofce | Yes, but then I have to drive out to two different locations to do so. |
| 23:24.03 | Alric-Ofce | And one of the devices requires a 40 ft ladder to get to. |
| 23:25.12 | jsmith | Sorry :-( |
| 23:29.19 | Alric-Ofce | Yeah, I have to run out there to work on a ring program anyway. |
| 23:38.34 | *** join/#asterisk-doc MatsK (n=mats@me-0-8-2-ac-d1-b6.2.cust.bredband2.com) |