| 00:00.19 | Juggie | asteriskdocs is up for me |
| 00:00.38 | blitzrage | ya... it's up |
| 00:00.45 | blitzrage | but I can't login anymore -- and people can't create accounts anymore |
| 00:00.47 | blitzrage | and I have no idea why |
| 00:00.51 | blitzrage | and the site is super outdated |
| 00:00.59 | blitzrage | and I hate the CMS it uses now... :) |
| 00:01.06 | blitzrage | and.. |
| 00:01.06 | blitzrage | and.... |
| 00:01.21 | file | and... you're coming out of the closet? |
| 00:02.22 | blitzrage | sorry.... no such luck file |
| 00:05.48 | Juggie | i have super cheap reliable hosting somewhere |
| 00:05.55 | Juggie | it was like 50$ for a year |
| 00:07.42 | Juggie | www.webhostingbuzz.com |
| 00:16.53 | file | oh hell |
| 00:17.07 | file | latest CentOS 5 updates have broken res_speech_lumenvox too |
| 00:17.21 | blitzrage | oh yay updates day! |
| 00:17.27 | blitzrage | lots of stuff got broke :) |
| 00:17.30 | blitzrage | (apparently) |
| 00:30.44 | blitzrage | ctooley: is it you who drinks wine? |
| 00:52.34 | jsmith | file: It never worked on CentOS 5 |
| 00:53.08 | file | jsmith: what did it do? |
| 00:53.29 | jsmith | Well, CentOS is RHEL |
| 00:53.48 | jsmith | Installing on RHEL 5 would complain about the SSL libraries, but you could force it with a symlink or two. |
| 00:53.53 | jsmith | But then it would just hang |
| 00:54.13 | file | k |
| 00:54.24 | file | I Will have a beta build that should fix that tomorrow |
| 00:56.49 | jsmith | w00t! |
| 00:58.38 | file | jsmith: how do I reconfigure networking under FC7 from console? |
| 01:00.39 | jsmith | file: system-config-network |
| 01:00.47 | file | thx |
| 01:00.48 | jsmith | file: (or "netconfig" might do it) |
| 01:01.04 | jsmith | file: Or edit /etc/sysconfig/network-scripts/ifcfg-ethX (where X is 0, 1, 2, etc.) |
| 01:01.12 | jsmith | file: What specifically are you trying to modify? |
| 01:01.58 | file | it was just the IP address |
| 01:02.01 | file | and gateway |
| 01:02.03 | file | already done :D |
| 01:03.36 | file | this VM is isolated from the Digium network... and we changed it around a bit, so needed to reconfigure it's networking |
| 01:09.13 | jsmith | I see. |
| 01:09.19 | jsmith | OK, I'm going to bed... g'night y'all |
| 01:09.22 | file | ttyl |
| 01:45.35 | jsmith-away | file: Yes? |
| 01:45.44 | file | just checking |
| 01:45.59 | file | :( |
| 01:48.57 | jsmith-away | No big deal, I'll go read the second edition of my book... that'll put me to sleep! |
| 01:55.37 | jsmith | file: What about you... don't you ever sleep? |
| 01:55.52 | file | sometimes |
| 01:56.06 | jsmith | OK, I'm outta here... |
| 02:21.29 | *** join/#asterisk-doc wyoming (n=steve_mu@216.166.159.235) |
| 02:46.14 | blitzrage | I'm gone too |
| 02:46.15 | blitzrage | night all |
| 03:24.36 | Juggie | best linux vpn client? |
| 03:26.10 | snuff-work | mm.. dont both kde/gnome have their own interfaces for one.. |
| 03:30.11 | Juggie | hmmm |
| 03:30.18 | Juggie | fc8 b1 has 480 updates |
| 03:58.49 | snuff-work | lol |
| 04:02.25 | Juggie | heh... soo many updates |
| 04:02.28 | Juggie | still downloading |
| 04:02.41 | Juggie | funny, i installed from a livecd, 700megs |
| 04:02.47 | Juggie | and there are 550megs of updates |
| 04:17.17 | snuff-work | gotta make you wonder why they include soo many updates.. why not skip a few versions inbetween saving more time :) |
| 04:17.54 | Juggie | heh |
| 04:17.56 | Juggie | well it is a beta |
| 04:17.57 | Juggie | so |
| 04:18.09 | Juggie | only 100 updates to go to download |
| 04:18.12 | Juggie | then it will install |
| 04:18.17 | Juggie | that will probally take a long time |
| 04:18.37 | Juggie | however, suspend is working properly |
| 04:18.48 | Juggie | now, will it work after all these updates, that is the question |
| 04:21.04 | Juggie | i'm expecting no less then 1000 actions for yum |
| 04:55.01 | *** join/#asterisk-doc ChanServ (ChanServ@services.) |
| 04:55.01 | *** join/#asterisk-doc snuff-work (n=na@61.29.30.137) [NETSPLIT VICTIM] |
| 04:55.02 | *** join/#asterisk-doc snuff-away (i=snuff@220-253-41-30.VIC.netspace.net.au) [NETSPLIT VICTIM] |
| 04:55.02 | *** join/#asterisk-doc bkruse (i=bkruse@nat/digium/x-a02a52c0611d0f88) [NETSPLIT VICTIM] |
| 04:55.02 | *** join/#asterisk-doc MuffinMan (n=muffins@neutrino.joshua-colp.com) [NETSPLIT VICTIM] |
| 04:55.02 | *** mode/#asterisk-doc [+o ChanServ] by irc.freenode.net |
| 07:07.12 | *** join/#asterisk-doc codefreeze (n=steve_mu@216.166.159.235) |
| 10:16.51 | *** join/#asterisk-doc LuKino (n=luca@gw.abanet.it) |
| 10:20.44 | LuKino | hi all, any experiences in grandstream gxw4008 FXS gateway with AST? |
| 10:26.41 | *** join/#asterisk-doc LuKino (n=luca@gw.abanet.it) |
| 10:28.31 | *** join/#asterisk-doc LuKino (n=luca@gw.abanet.it) |
| 10:28.36 | *** part/#asterisk-doc LuKino (n=luca@gw.abanet.it) |
| 13:00.00 | file | oh direct deposit, you make me happppppppppy |
| 13:06.04 | jsmith | Good morning, file... |
| 13:27.03 | ctooley | Direct deposit would be better if my HR department didn't keep putting it in the wrong account. |
| 13:36.46 | wwalker | did it get straight today? Or worse yet? |
| 13:38.50 | *** join/#asterisk-doc fakhir (n=Fakhir@unaffiliated/fakhir) |
| 13:48.56 | Juggie | jsmith, FC8 w/ all the latest patches (except the kernel) works great. |
| 13:49.13 | Juggie | the kernel i had problems with because mkinitrd was broken |
| 13:49.40 | Juggie | but i got a new build of that, so i got a newer kernel built, but then it didnt seem to want to sleep... not sure if something had just crashed that boot, so i will test it more later |
| 13:49.54 | jsmith | Juggie: OK |
| 13:50.23 | Juggie | (when you install a new kernel it uses mkinitrd to build the initrd file customized to your system) |
| 13:50.38 | jsmith | Yup |
| 13:50.50 | Juggie | TFOT? |
| 13:50.54 | file | or order. |
| 13:51.58 | Juggie | what does that stand for? |
| 13:52.17 | file | the future of telephony |
| 13:52.23 | Juggie | ah |
| 13:52.26 | file | the book. |
| 13:52.39 | Juggie | will they give out free books @ *-con again this year? |
| 13:55.45 | jsmith | Juggie: I'm not sure... I kind of doubt it, but I'll ask. |
| 13:57.26 | *** join/#asterisk-doc Alric (n=nbowyer@masq.hyperusa.com) |
| 13:57.26 | ctooley | wwalker, worse |
| 13:57.35 | Juggie | jsmith, or at least sell some copies there. |
| 13:57.47 | Alric | Selling? Selling? |
| 13:59.02 | Juggie | jsmith, your decent w/ sql... what are my chances of finding a SQL function to convert a UTC/GMT date to localtime. |
| 13:59.10 | Juggie | assuming its a field in a database |
| 13:59.14 | Juggie | and it has to care about DST |
| 13:59.32 | ctooley | Juggie, which database? |
| 13:59.36 | Juggie | mssql |
| 13:59.44 | ctooley | oh. good luck |
| 14:00.14 | Alric | A pre-emptive measure for when you kill the database with your bare hands. |
| 14:00.39 | jsmith | Juggie: Gimme a second... |
| 14:00.48 | Juggie | i found a stored procedure someone wrote |
| 14:00.51 | Juggie | let me pastebin it. |
| 14:01.11 | Juggie | i only care about amercain timezones |
| 14:02.32 | Juggie | http://www.pastebin.ca/676878 |
| 14:02.34 | Juggie | this might work |
| 14:03.37 | Alric | There are other timezonesS? |
| 14:04.23 | Juggie | NST as well :) |
| 14:04.53 | Juggie | i believe this function has a high probability of working |
| 14:04.55 | Juggie | the code is ok |
| 14:05.07 | jsmith | Looks fine to me |
| 14:05.09 | Juggie | and i know you can detect DST in sql, i've done that before |
| 14:05.16 | Juggie | i mean via math. |
| 14:05.45 | jsmith | There should be conversion routines for it as well |
| 14:06.38 | Juggie | sql2005 is a decent improvement |
| 14:06.57 | Juggie | i'm running sql2005 64bit and it is a suprising improvement |
| 14:07.00 | jsmith | Juggie: That's what I've heard... only a friend of mine can't seem to figure out why his transaction logs are growing out of control |
| 14:07.18 | jsmith | Juggie: He just spent 5 hours on hold yesterday with Microsoft, and they couldn't figure it out either |
| 14:07.25 | Juggie | odd |
| 14:07.32 | Juggie | you'd think i would notice the problem |
| 14:07.37 | Juggie | my db does have 300 million rows |
| 14:07.44 | Alric | Its MSFT. When have they ever done something right? |
| 14:07.55 | jsmith | Yeah... it seems to be something isolated to his environment, but they can't figure it out |
| 14:08.06 | Juggie | Alric, love it or hate it, they do hav elike 90% of the desk top market |
| 14:08.10 | jsmith | (and blowing away the transaction log only made things worse... luckily he had a backup) |
| 14:08.10 | Juggie | i'd consider that doing something right |
| 14:08.21 | Alric | Juggie: They copy OS X :) |
| 14:08.30 | jsmith | Alric: As MSFT products go, SQL Server is one of the better ones |
| 14:08.44 | Alric | Juggie: So getting the UI right isn't terribly hard when you have such an awesome starting point... |
| 14:09.11 | Juggie | ya, they started w/ OS/2 :) |
| 14:09.12 | Alric | "No, we didn't copy spotlight! Our search is in the bottom left corner!" |
| 14:09.28 | Juggie | jsmith, did the cook book have anything better? |
| 14:09.48 | jsmith | Juggie: Let me go check... gotta run upstairs |
| 14:11.47 | jsmith | Juggie: Nothing I can find from a quick scan of the index |
| 14:13.35 | Juggie | this code sure would be alot more readable if it was tabbed |
| 14:13.45 | Juggie | and tabbing SQL code is a royal pain, damn BEGIN/END |
| 14:20.47 | Juggie | that function seems to work fine |
| 14:20.55 | Juggie | but has one small bug, it seems to convert to DST even when you pass 0. |
| 14:20.56 | jsmith | w00t! |
| 14:21.02 | jsmith | Doh! |
| 14:21.17 | Juggie | which i need it not to do because canada has one timezone which doesnt do DST |
| 14:22.02 | Alric | US has three states like that too |
| 14:22.08 | jsmith | Yup... |
| 14:22.09 | Alric | Hawaii being one of them. |
| 14:22.13 | jsmith | Shouldn't be that hard to fix |
| 14:22.15 | Juggie | its a minor fix |
| 14:22.16 | jsmith | Alric: Arizona too. |
| 14:22.19 | Juggie | just one extra condition here |
| 14:22.21 | Alric | Seems like one of those northern states like Michigan... |
| 14:22.31 | Alric | Didn't Arizona defect recently? |
| 14:22.39 | jsmith | Alric: I thought it was *half* of Indiana |
| 14:23.16 | Alric | India defected. |
| 14:23.20 | Alric | err |
| 14:23.23 | Alric | Indiana defected. |
| 14:23.31 | Alric | In 2005 |
| 14:25.00 | Alric | Arizona and Hawaii are the only two left. |
| 14:25.54 | Juggie | woot |
| 14:26.01 | Juggie | this makes my life so much easier |
| 14:26.10 | file | hotels near the Metro in Montreal make me happy |
| 14:26.11 | Juggie | i thought i was going to have to do a serious overhaul of my stats generation |
| 14:26.29 | Juggie | what area of montreal is the training in? |
| 14:27.23 | file | I don't exactly remember, I Just know it's 1 block from the Bonaventure stop on the orange line |
| 14:28.12 | Juggie | your going? |
| 14:28.20 | file | pondering it |
| 14:29.02 | Juggie | ever been to montreal before? |
| 14:29.04 | file | yes |
| 14:29.23 | Juggie | jsmith, montreal is the most english city in quebec |
| 14:29.25 | file | which is why I'm looking for hotels around metro stops |
| 14:29.36 | file | so I can grab a week pass |
| 14:29.49 | Juggie | montreal subway is awesome |
| 14:29.56 | file | yes, yes it is |
| 14:29.58 | Juggie | except for when it almost colapses, i wonder if that still is a problem |
| 14:30.04 | Alric | :D |
| 14:30.04 | Juggie | you should make sure you wont be affected by that |
| 14:38.27 | Juggie | is there anyway to do something in your select say SELECT MAX(blah) as moo and then use moo in the rest of your sql statement |
| 14:38.35 | Juggie | eg, do like where moo = whatever |
| 14:38.44 | Juggie | or do i have to do the MAX(blah) every time |
| 14:38.55 | jsmith | Juggie: Learn about the HAVING clause :-) |
| 14:39.13 | jsmith | SELECT MAX(blah) as moo HAVING moo > 5; |
| 14:39.42 | jsmith | Of course, your DB may force you to write it as SELECT MAX(blah) as moo HAVING MAX(blah) > 5 |
| 14:39.51 | jsmith | It may not allow you to use aliases in the HAVING clause |
| 14:40.35 | Juggie | whats the point of having then |
| 14:40.38 | Juggie | i can just do it in the where. |
| 14:40.50 | jsmith | Because it doesn't go and run the MAX() thing again... |
| 14:40.53 | Juggie | having should allow me to use alias's |
| 14:40.55 | Juggie | right. |
| 14:40.57 | Juggie | ok let me try. |
| 14:41.04 | jsmith | Things in a WHERE clause get evaluated |
| 14:41.13 | jsmith | Things in a HAVING clause *have already* been evaluated |
| 14:41.23 | jsmith | HAVING is a good thing |
| 14:42.44 | Juggie | right, but what if it has to be evalulated for every record |
| 14:42.48 | Juggie | can you still do it in having |
| 14:42.54 | Juggie | or is it something thats only evaluated once |
| 14:43.08 | jsmith | It's something that's already been evaluated as part of *this* query. |
| 14:43.39 | Juggie | right but lets say i'm doing a select converttolocaltime(thetime, -5, 1) as adjusted_time |
| 14:43.42 | Juggie | can i then do |
| 14:43.51 | Juggie | HAVING adjusted_time > somedate |
| 14:43.58 | jsmith | Yes, you should be able to. |
| 14:44.00 | Juggie | k |
| 14:44.23 | jsmith | Even if it won't let you use the alias adjusted_time, you should be able to do: |
| 14:44.52 | jsmith | SELECT converttolocaltime(thetime, -5,1) HAVING converttolocaltime(thetime,-5,1) > somedate; |
| 14:45.01 | jsmith | And it shouldn't call the stored procedure twice. |
| 14:46.40 | Juggie | its SELECT, HAVING, then FROM right? |
| 14:47.14 | jsmith | No, I think it's SELECT foo FROM bar HAVING baz; |
| 15:03.53 | Juggie | jsmith, not possible |
| 15:04.06 | Juggie | as i thought, values have to come from a group by or aggragate |
| 15:04.30 | Juggie | was worth a try though |
| 15:04.35 | Juggie | only other option would likely be a sub select |
| 15:05.06 | jsmith | Interesting... |
| 15:08.24 | Juggie | hmm sub select |
| 15:08.53 | jsmith | Why do a sub-select when you can do a self-join? (Just being crazy... that's MySQL's answer for not supporting sub-selects for many years) |
| 15:10.17 | Juggie | well i just want to only calculate those valus once |
| 15:10.33 | Juggie | so i thought i would do a select then sub select the results from that |
| 15:11.14 | Juggie | like i only want to run the timezone convert once |
| 15:11.20 | Juggie | not 5 times |
| 15:11.23 | jsmith | Right... |
| 15:11.34 | jsmith | Or do a useless group by :-) |
| 15:11.39 | Juggie | but i dont think its possible |
| 15:11.45 | Juggie | because if i do a sub select |
| 15:11.50 | jsmith | GROUP BY adjusted_time |
| 15:11.52 | Juggie | i'll be querying the entire tb |
| 15:11.54 | Juggie | *db |
| 15:11.59 | Juggie | and convert every time in it |
| 15:12.01 | jsmith | Ah... yeah... |
| 15:12.02 | Juggie | then selecting the ones i want |
| 15:12.19 | Juggie | which would be almost as bad as converting multiple times |
| 15:12.25 | Juggie | or worse |
| 15:12.28 | Juggie | given the size of the table |
| 16:48.32 | *** join/#asterisk-doc jsmith (n=jsmith@000-143-916.area3.spcsdns.net) |
| 16:48.33 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 16:48.55 | file | jsmith: those 30 minutes without you were scary |
| 16:49.26 | jsmith | file: Ah, whatever... just had to reboot, and then I forgot to fire up my IRC client |
| 16:57.07 | Juggie | jsmith, any idea on hardware which would do a branch to branch vpn |
| 16:57.21 | Juggie | eg give me a network cable on each end which joined a remote network w/ the network in our building in one big happy family |
| 16:58.47 | jsmith | Netgear has some stuff like that. |
| 16:59.20 | jsmith | Or you could use OpenVPN client on OpenWRT |
| 17:00.56 | Juggie | nah no wrt |
| 19:20.49 | *** join/#asterisk-doc fakhir (n=Fakhir@unaffiliated/fakhir) |
| 20:22.21 | *** join/#asterisk-doc fakhir (n=Fakhir@unaffiliated/fakhir) |
| 20:40.09 | *** join/#asterisk-doc ctooley (n=ctooley@209.33.104.36) |
| 21:03.18 | *** join/#asterisk-doc ctooley_ (n=ctooley@209.33.109.249) |
| 21:33.05 | Alric | m6119 |
| 21:33.06 | MuffinMan | [assigned] [Asterisk] Applications/app_queue 0006119: [branch] Polycom SoundPoint IP ACD agent feature integration reported by bweschke http://bugs.digium.com/view.php?id=6119 |
| 21:33.12 | Alric | Found it |
| 23:35.54 | *** join/#asterisk-doc h0 (n=Fakhir@unaffiliated/fakhir) |
| 23:54.05 | *** join/#asterisk-doc blitzrage (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 23:54.05 | *** mode/#asterisk-doc [+o blitzrage] by ChanServ |