| 00:00.27 | mecworks | VoidByte: that's why there are separate books for the two subjects. |
| 00:01.20 | mecworks | http://oreilly.com/catalog/9780596002978/ |
| 00:02.39 | mecworks | VoidByte: Essential System Administration may cover all you're looking for in one book though: http://oreilly.com/catalog/9780596003432/ |
| 00:17.17 | *** join/#utah redbeard2 (~jphall@techhat.dsl.xmission.com) |
| 00:47.47 | *** join/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 00:48.37 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 00:48.38 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 01:03.31 | *** join/#utah Demo (~Demo@c-174-52-33-117.hsd1.ut.comcast.net) |
| 01:03.59 | *** part/#utah Demo (~Demo@c-174-52-33-117.hsd1.ut.comcast.net) |
| 01:05.22 | *** join/#utah toofer (~toofer@kjordan.securesites.net) |
| 01:06.07 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 01:06.07 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 01:13.21 | *** join/#utah blendmaster1O24 (~blendmast@unaffiliated/blendmaster1024) |
| 01:17.29 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 01:17.29 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 01:31.23 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 01:31.53 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 01:48.13 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 01:48.14 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 02:28.07 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 02:28.08 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 02:39.48 | *** part/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 02:50.50 | *** join/#utah toofer (~toofer@kjordan.securesites.net) |
| 02:53.58 | *** join/#utah SunSparc (~sparky@71-32-239-91.slkc.qwest.net) |
| 03:03.14 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 03:03.15 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 03:12.19 | *** join/#utah tiwula (~lane@63.225.228.210) |
| 03:13.59 | *** join/#utah brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 03:17.01 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 03:17.02 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 03:17.56 | *** join/#utah brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 03:17.58 | *** join/#utah wps (~wps@208.53.57.58) |
| 03:19.03 | Jayce^ | ~whaleslap wps |
| 03:19.04 | ibot | ACTION beats wps upside and over the head with a freakishly huge killer whale named Hugh |
| 03:19.21 | wps | hey, Jayce^ |
| 03:19.26 | wps | the site is launching this friday |
| 03:19.30 | wps | rolls eyes |
| 03:19.44 | Jayce^ | ROFL :) |
| 03:19.46 | wps | maybe I'll be done then |
| 03:19.57 | Jayce^ | how'd you know i'd ask about *that* |
| 03:20.10 | wps | because you slapped me with a whale |
| 03:20.16 | Jayce^ | true, true |
| 03:20.26 | Jayce^ | you need anything from me for it? |
| 03:25.01 | *** join/#utah sojourner (~Richard@afgw.movenetworks.com) |
| 03:27.49 | *** join/#utah wps (~wps@208.53.57.58) |
| 03:28.10 | Jayce^ | trying to hide, eh? |
| 03:28.16 | Jayce^ | so, you need anything from me? |
| 03:37.51 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 03:37.51 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 03:48.29 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 03:48.31 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 03:55.53 | *** join/#utah carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 03:56.35 | Sargun_Screen | I wonder when my face is gunna heal |
| 04:00.26 | *** join/#utah sojourner (~Richard@fidelis.dsl.xmission.com) |
| 04:03.09 | maquis | Sargun_Screen: what happened? |
| 04:04.23 | Sargun_Screen | http://www.flickr.com/photos/83461477@N00/4478286508/in/photostream?edited=1 |
| 04:05.12 | Sargun_Screen | That. |
| 04:05.15 | Sargun_Screen | :-) |
| 04:05.30 | Sargun_Screen | Actually more like :o) |
| 04:05.37 | Sargun_Screen | or :o*) |
| 04:05.47 | Sargun_Screen | however you would represent a busted up lip. |
| 04:15.24 | *** join/#utah carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 04:39.42 | *** join/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 05:12.17 | *** join/#utah badonaway (~q@166-70-80-198.ip.xmission.com) |
| 05:12.17 | *** join/#utah badonaway (~q@pdpc/supporter/active/badon) |
| 05:18.30 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 05:18.30 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 05:27.56 | *** join/#utah blendmaster1024 (~blendmast@unaffiliated/blendmaster1024) |
| 05:38.29 | *** join/#utah elg (~fugalh@c-24-7-49-213.hsd1.ca.comcast.net) |
| 05:38.29 | *** mode/#utah [+v elg] by ChanServ |
| 05:43.20 | *** join/#utah neybar (~jalance@static-71-103-252-251.lsanca.dsl-w.verizon.net) |
| 05:50.25 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 05:50.25 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 05:59.43 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 05:59.43 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 06:06.01 | *** join/#utah carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 06:11.05 | *** join/#utah toofer (~toofer@kjordan.securesites.net) |
| 06:36.16 | *** join/#utah Sargun (~Sargun@atarack/Staff/Sargun) |
| 06:52.21 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 06:52.21 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 07:03.19 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 07:03.20 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 07:26.32 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 07:26.33 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 08:06.09 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 08:06.10 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 08:17.16 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 08:17.16 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 08:18.19 | *** part/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 09:52.57 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 09:52.58 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 10:26.49 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 10:26.49 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 10:38.11 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 10:38.11 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 11:06.54 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 11:06.55 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 12:55.28 | *** join/#utah redbeard_work (~jphall@fw.oremut02.us.wh.verio.net) |
| 13:00.14 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 13:00.14 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 13:01.56 | *** join/#utah emcnabb (~emcnabb@cpe-071-065-252-161.nc.res.rr.com) |
| 13:01.56 | *** mode/#utah [+v emcnabb] by ChanServ |
| 13:05.42 | *** join/#utah badonaway (~q@166-70-80-198.ip.xmission.com) |
| 13:05.43 | *** join/#utah badonaway (~q@pdpc/supporter/active/badon) |
| 13:10.10 | *** join/#utah neybar (~jalance@static-71-103-252-251.lsanca.dsl-w.verizon.net) |
| 13:28.27 | *** join/#utah WoodsDog (~woodsdog@nat/redhat/x-zqrxtmdneyqgghyc) |
| 13:44.16 | *** join/#utah sshaw (~decriptor@137.65.229.109) |
| 13:54.32 | *** join/#utah WoodsDog (~woodsdog@nat/redhat/x-lzkqllcwuhxgweyb) |
| 13:57.08 | *** join/#utah WoodsDog (~woodsdog@nat/redhat/x-fjvyokvcjzcqbtes) |
| 14:04.35 | *** join/#utah Woodsdogg (~woodsdog@nat/redhat/x-jqkxsygurtxolxvz) |
| 14:05.04 | *** join/#utah Woodsdogg (~woodsdog@nat/redhat/x-tmjxswsqnihgoikt) |
| 14:18.41 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 14:18.41 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 14:20.20 | *** join/#utah Woodsdogg (~woodsdog@nat/redhat/x-mpaxzlcmmlsrvplo) |
| 14:21.28 | *** join/#utah mwoodson (~woodsdog@nat/redhat/x-ybaehujbtyvwdllc) |
| 14:21.55 | *** join/#utah tensai (~tensai@joanna.zmonkey.org) |
| 14:23.34 | *** join/#utah thaddeusq (~thaddeusq@216.49.181.128) |
| 14:36.05 | *** join/#utah SunSparc (~sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 14:52.15 | *** join/#utah elg (~fugalh@c-24-7-49-213.hsd1.ca.comcast.net) |
| 14:52.15 | *** mode/#utah [+v elg] by ChanServ |
| 15:02.42 | tensai | anybody use google mail for their domain and want to comment on it? |
| 15:16.41 | *** join/#utah carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 15:24.18 | goozbach | tensai: I do |
| 15:24.20 | goozbach | love it |
| 15:24.45 | *** join/#utah zzzirk_away (~zzzirk@173-10-29-145-BusName-utah.ut.hfc.comcastbusiness.net) |
| 15:25.05 | goozbach | I use it as a front end, I then pull it down to my linode using fetchmail so that I can have all the email stored on a server under my control |
| 15:27.13 | tensai | goozbach: I assume you moved hosting from another server. how did that go? |
| 15:27.52 | goozbach | moved hosting? |
| 15:28.03 | goozbach | I was doing my own SMTP on that server |
| 15:28.22 | tensai | moved your MX from oldserver.goozbach.com to google |
| 15:28.23 | goozbach | all I changed was to point my MX record to Gmail |
| 15:28.32 | tensai | ah, I see |
| 15:28.37 | goozbach | then pulled the email back via IMAP |
| 15:28.46 | goozbach | turned off the firewall port 25 |
| 15:34.37 | *** join/#utah fcodiaz (~fcodiaz@70.102.172.126) |
| 15:49.05 | *** join/#utah fungus (~olsonl@bromine.sosstaffing.com) |
| 15:51.23 | cedwards | I have google mail for a few domains. It's been perfectly reliable for years. |
| 15:52.27 | *** join/#utah sinuhe (~sinuhe@hq-nat2.gurulabs.com) |
| 15:53.28 | *** join/#utah bonez2046 (~bonez@173-14-239-229-Utah.hfc.comcastbusiness.net) |
| 15:53.44 | bonez2046 | any OO Calc gurus here today ? |
| 15:54.04 | bonez2046 | I want to enter this text "HSA" into Calc. and once I have entered it, it automatically changes the text to "has".. What is it that tells Calc to automatically, AGAINST MY WILL to change this? |
| 15:58.16 | goozbach | bonez2046: I usually hit ctrl-z to undo an autocomplete/autocorrect |
| 15:58.29 | goozbach | I think those are the terms if you want to search the help |
| 15:59.32 | bonez2046 | ok.. |
| 15:59.34 | bonez2046 | thanks |
| 16:01.12 | bonez2046 | goozbach: That halted it.. thanks!!! |
| 16:02.30 | *** join/#utah zzzirk_away (~zzzirk@173-10-29-145-BusName-utah.ut.hfc.comcastbusiness.net) |
| 16:07.55 | *** join/#utah toofer (~toofer@kjordan.securesites.net) |
| 16:15.58 | Jayce^ | tensai: been using it too for a few domains, nice an easy |
| 16:23.04 | tensai | Jayce^, goozbach: are you using the free version? are there any limits to it? |
| 16:23.18 | *** join/#utah elg (~fugalh@out1-1601fw.corp.tfbnw.net) |
| 16:23.18 | *** mode/#utah [+v elg] by ChanServ |
| 16:27.52 | Jayce^ | yes I am.. 100 accounts |
| 16:28.14 | Jayce^ | and I think a "smaller" storage amount.. still some number of gb per account |
| 16:30.01 | goozbach | yes the free version |
| 16:30.10 | goozbach | I doubt I'll ever hit the limit |
| 16:30.54 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 16:30.54 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 16:39.03 | *** join/#utah sjansen (~sjansen@75-169-130-179.slkc.qwest.net) |
| 16:40.35 | *** join/#utah Sargun (~Sargun@atarack/Staff/Sargun) |
| 16:42.13 | *** join/#utah tiwula (~lane@75-148-99-197-Utah.hfc.comcastbusiness.net) |
| 16:54.44 | bonez2046 | just curious what 'it' is.. this storage medium |
| 16:55.41 | *** join/#utah blendmaster1024 (~blendmast@unaffiliated/blendmaster1024) |
| 16:55.55 | *** join/#utah zzzirk_away (~zzzirk@173-10-29-145-BusName-utah.ut.hfc.comcastbusiness.net) |
| 16:56.25 | TodPunk | bonez2046: he means Google Apps for Your Domain |
| 16:57.55 | toofer | anyone know the best location on Debian to put a script to load my firewall rules? |
| 16:58.33 | TodPunk | just puts his in /etc |
| 16:58.47 | TodPunk | Probably /usr/local or /opt though |
| 16:59.29 | bonez2046 | ah.. thanks TodPunk |
| 16:59.48 | toofer | huh? I was thinking either a script in /etc/init.d or there also appears to be /etc/network |
| 17:01.08 | toofer | TodPunk: so do you just load yours manually every reboot? |
| 17:06.24 | TodPunk | toofer: no, it's in an rc.local, but I only started this practice because of openwrt. |
| 17:06.59 | TodPunk | If you have the patience to write a proper init.d script, go for it. I don't usually do so for trivial things I want to load regardless of runleve. |
| 17:07.00 | TodPunk | l |
| 17:07.07 | TodPunk | goes to program |
| 17:07.15 | *** join/#utah undertakingyou (~will@undertakingyou.dsl.xmission.com) |
| 17:24.43 | *** join/#utah Demo (~Demo@c-174-52-33-117.hsd1.ut.comcast.net) |
| 17:28.24 | *** join/#utah wps (~wps@208.53.57.58) |
| 17:31.29 | elg | toofer: I think you could (ab)use /etc/rc.local |
| 17:34.12 | toofer | elg: thanks for the suggestion |
| 17:37.23 | tensai | Jayce^: over the years I've set up a lot of aliases so I can keep track of who starts spamming me. will that be easy to continue? |
| 17:40.36 | Jayce^ | yeah, though I think auto-importing is a non-free feature... no seeems like you can upload a csv.. |
| 17:40.42 | Jayce^ | not quite as easy |
| 17:40.49 | Jayce^ | but you can do aliases |
| 17:40.58 | Jayce^ | and you can do the + separator, which I do a lot |
| 17:41.04 | Jayce^ | forget the real name for that |
| 17:41.29 | TodPunk | tensai: I have the catch-all for my domain go to my box, then I just sign up for sites with something like "domain.com@mydomain.com" |
| 17:41.35 | TodPunk | works just fint. |
| 17:41.37 | TodPunk | *fine |
| 17:42.48 | tensai | catchalls are a magnet for spam |
| 17:43.05 | TodPunk | when something starts spamming me, I filter it out. Problem solved. |
| 17:43.33 | tensai | Jayce^: that was my other question. I guess I could use + going forward. I only have 60 aliases. |
| 17:43.36 | TodPunk | Otherwise, you CAN literally setup aliases for each and every thing you have, but that seems like a lot of work, comparatively. |
| 17:46.27 | *** join/#utah wps (~wps@208.53.57.58) |
| 17:46.43 | stderr | http://www.newser.com/story/84798/marriage-hutaree-style.html |
| 17:48.45 | *** join/#utah elg (~fugalh@out1-1601fw.corp.tfbnw.net) |
| 17:48.45 | *** mode/#utah [+v elg] by ChanServ |
| 17:49.54 | *** join/#utah elg (~fugalh@out1-1601fw.corp.tfbnw.net) |
| 17:49.54 | *** mode/#utah [+v elg] by ChanServ |
| 17:51.40 | sjansen | Wow, this Mana song sounds like Sting is singing. |
| 18:09.19 | sjansen | While using + might work when you don't expect much intelligence on the other end, I prefer creating completely unique aliases because it reveals less about my real address. |
| 18:11.14 | sjansen | I currently have 54 active aliases. I've killed about 5 aliases because companies started spamming me. |
| 18:12.35 | elg | tries to imagine some of those aliases |
| 18:12.46 | elg | stuartkingoftheworld@buscaluz.com |
| 18:13.03 | elg | mana always sounds like a sting knockoff |
| 18:13.26 | elg | which isn't to say they always sound like sting singing |
| 18:16.46 | sjansen | Actually, turbotax@buscaluz.org or woot@buscaluz.org. (Both of which I'm about to delete because I don't do business with them anymore.) |
| 18:21.39 | elg | how boring |
| 18:27.06 | *** join/#utah ti`ocpi (~washi@c-76-27-121-193.hsd1.ut.comcast.net) |
| 18:35.40 | JoshH | why don't you do business with woot? |
| 18:37.58 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 18:37.58 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 18:38.20 | *** join/#utah carmony_ (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 18:49.05 | goozbach | why don't you do business with turbotax? |
| 18:49.35 | elg | why don't you do business with the king of the world? |
| 18:54.43 | JoshH | turbotax can be explained easily enough |
| 18:54.52 | JoshH | but woot is awesome |
| 18:56.07 | goozbach | JoshH: I don't understand |
| 18:56.13 | goozbach | turbotax is awesome! |
| 18:56.32 | JoshH | i used taxactonline.com this year, and was very pleased with it |
| 18:56.43 | goozbach | don't have to purchase software, runs just fine on firefox under Linux |
| 18:57.39 | goozbach | that looks much cheaper than turbotax... |
| 18:57.41 | goozbach | interesting |
| 18:57.49 | goozbach | I wish I would have known about it |
| 18:58.35 | JoshH | ya, the IRS site said to use it, that's how i learned of it |
| 18:59.58 | JoshH | the interface was excellent and worked perfectly in firefox too |
| 19:00.15 | JoshH | didn't seem like a browser app at all |
| 19:01.49 | goozbach | nice |
| 19:03.51 | unum | I've been using taxact for a few years |
| 19:04.02 | unum | JoshH: same here |
| 19:19.41 | TehLaser | I'm wary of online tax prep. |
| 19:20.18 | unum | why? |
| 19:20.23 | TehLaser | There's very little preventing the people running them from using all that juicy data about you. |
| 19:21.41 | TehLaser | and possibly s/using/selling/ too. |
| 19:22.08 | unum | actually I think there are some pretty strong laws about that |
| 19:22.13 | unum | just like an accounting firm |
| 19:22.48 | JoshH | their privacy policy looks solid |
| 19:23.30 | TehLaser | There might be some legal fuzziness if there are no actual humans doing the accounting. And the fact that your return is still legally "self prepared". |
| 19:23.45 | TehLaser | But mostly I'm probably just being paranoid. |
| 19:25.15 | TehLaser | used H&R Block's online app for his '09 return, so he's mostly just "viewing with alarm" here. |
| 19:25.29 | *** join/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 19:28.17 | JoshH | nothing wrong with paranoia |
| 20:01.19 | *** part/#utah Demo (~Demo@c-174-52-33-117.hsd1.ut.comcast.net) |
| 20:08.14 | unum | so let's say you're comparing two strings in perl and you want to know if one has spaces where the other has something else |
| 20:08.20 | unum | how would you do that? |
| 20:08.41 | unum | so basically I need to inspect each character in the string |
| 20:09.12 | sjansen | is pretty sure that JoshH is trying to steal and eat his brain |
| 20:09.51 | sjansen | unum: Sounds like you should compare original and processed strings. |
| 20:10.33 | sjansen | if ($str1 -ne $str2) { |
| 20:11.02 | sjansen | my $tmp1 = $str1 =~ s/\s+/ /; |
| 20:11.11 | sjansen | my $tmp2 = $str2 =~ s/\s+/ /; |
| 20:11.33 | sjansen | print 'Only whitespace is different' if $tmp1 -eq $tmp2; |
| 20:11.34 | sjansen | } |
| 20:11.53 | sjansen | My perl's a little rusty, but that should be very close to actually working. |
| 20:17.57 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 20:17.57 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 20:23.54 | unum | sjansen: that's a nice way to do that,thanks |
| 20:26.11 | *** topic/#utah by sjansen -> logs @ http://ibot.rikers.org/#utah | http://planet.utos.org/ | Porque nunca sabes lo que tienes hasta que lo pierdes - Juanes |
| 20:27.34 | *** part/#utah redbeard_work (~jphall@fw.oremut02.us.wh.verio.net) |
| 20:27.43 | *** join/#utah redbeard_work (~jphall@fw.oremut02.us.wh.verio.net) |
| 20:31.31 | maquis | Jayce^: that sltrib article seems kinda biased toward sco, from my reading... |
| 20:33.05 | *** join/#utah badon (~q@166-70-80-198.ip.xmission.com) |
| 20:33.06 | *** join/#utah badon (~q@pdpc/supporter/active/badon) |
| 20:40.34 | *** part/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 20:41.22 | *** join/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 20:44.48 | *** part/#utah keldwud (~keldwud@c-67-161-214-101.hsd1.ut.comcast.net) |
| 20:55.40 | *** join/#utah TimRiker (~timr@bzflag/projectlead/TimRiker) |
| 20:55.40 | *** mode/#utah [+o TimRiker] by ChanServ |
| 21:16.25 | tensai | I'm stumped on a sql query |
| 21:16.55 | tensai | I have a table which is (timestamp, value). every minute I record a status value into the table. |
| 21:17.17 | tensai | I want to find the max value for each day and what time that occurred |
| 21:17.29 | tensai | the max is easy, but I can't figure out the latter |
| 21:19.02 | sjansen | Can your DB group by the result of an expression? |
| 21:19.35 | tensai | yes |
| 21:19.44 | sjansen | Well then there you go. |
| 21:19.45 | tensai | it's mysql |
| 21:20.14 | sjansen | select max(value), truncated(date) from table group by truncated(date); |
| 21:20.49 | tensai | that's what I've got. but I want to know what time during the day that occurred |
| 21:21.11 | tensai | for example (2010-03-31, 100, 2010-03-31 15:21:00) |
| 21:21.16 | sjansen | Ah. |
| 21:22.14 | sjansen | The first problem that occurs to me is that the value may occur multiple times within the truncated date range. |
| 21:22.45 | tensai | yes, it most likely will |
| 21:23.07 | tensai | I tried it with a subquery and a limit 1, but mysql yelled at me because I was referencing the group result |
| 21:27.10 | *** join/#utah brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 21:27.26 | sjansen | Huh, the following works in sqlite: |
| 21:27.37 | sjansen | select max(v), date(d), d from test group by date(d); |
| 21:28.18 | tensai | hmm |
| 21:28.38 | sjansen | However, it only returns one occurence if the value shows up multiple times. |
| 21:30.01 | sjansen | If you want multiple values, I think you're going to have to join the table against itself. |
| 21:30.23 | tensai | it completes in mysql, but the result is just the first timestamp from that day, regardless of the max |
| 21:30.56 | tensai | ~poke eggyknap |
| 21:30.57 | ibot | ACTION cuts down a small tree, sneaks up behind eggyknap, pokes eggyknap repeatedly, hilarity ensues. |
| 21:31.14 | *** join/#utah elg (~fugalh@out1-1601fw.corp.tfbnw.net) |
| 21:31.14 | *** mode/#utah [+v elg] by ChanServ |
| 21:31.17 | eggyknap | rolls over and resumes drooling on his keyboard |
| 21:31.40 | tensai | ~poke elg for good measure |
| 21:31.41 | ibot | ACTION cuts down a small tree, sneaks up behind elg for good measure, pokes elg for good measure repeatedly, hilarity ensues. |
| 21:32.06 | tensai | eggyknap: any idea of my sql query? is it even possible? |
| 21:32.39 | eggyknap | the best way is using window functions, which you can do in postgresql 8.4 and above, and some other databases (which ones precisely I don't know for sure, honestly). |
| 21:32.44 | levi | So, has anyone else listened to the new Byrne/Fatboy Slim album? |
| 21:32.57 | sjansen | I think you're best off creating a temporary table and selecting the max values into it, then joining that table against the originall table to get all occurrences. |
| 21:33.09 | eggyknap | Another option is postgresql's DISTINCT ON, ordering by v |
| 21:33.21 | eggyknap | You don't really need a temp table - just do a self-join. |
| 21:33.21 | sjansen | But I bow to eggyknap's superior sql-fu. |
| 21:33.22 | tensai | sjansen: I was starting to think of reversing it and using a subquery. I think that's the same general idea. |
| 21:33.57 | tensai | self join, eh? hmmm |
| 21:34.19 | eggyknap | Does the table have a primary key? |
| 21:34.28 | eggyknap | Actually, never mind... that doesn't matter. |
| 21:34.32 | JoshH | i just realized i've seen no new plug email in a month and a half, what's up with it? |
| 21:34.36 | levi | It's like a big-beat latin disco musical. |
| 21:34.44 | sjansen | I've been trying to get a self join working, but doing it efficiently requires more than my limited skills. |
| 21:35.15 | sjansen | JoshH: Spam filter? |
| 21:35.46 | levi | I consider myself fortunate to not need to do much in the way of database work. |
| 21:36.03 | eggyknap | So something like this: |
| 21:36.05 | eggyknap | SELECT max_v, date(d) FROM foo |
| 21:36.05 | eggyknap | JOIN (SELECT max(v) AS max_v, date(d) AS my_day FROM foo GROUP BY my_day) bar |
| 21:36.05 | eggyknap | ON foo.v = max_v AND date(foo.d) = my_day |
| 21:36.09 | eggyknap | <PROTECTED> |
| 21:36.13 | sjansen | levi: You're not much of a fan of technology in general, are you? |
| 21:36.43 | eggyknap | If the maximum measurement for a day gets measured twice in that day, you'll get two rows returned for that day. |
| 21:37.18 | tensai | I just clarified what the requester wants and he does want multiple results if they occurred |
| 21:37.33 | levi | sjansen: Sure I am. I think database stuff is pretty cool, but definitely not what's in my brain right now. |
| 21:37.52 | eggyknap | OBTW, window functions FTW in this case (though I admit I couldn't write the query with windows functions without looking at the docs first) |
| 21:37.53 | tensai | sjansen: databases are for sissies. real men use Excel. |
| 21:38.37 | tensai | eggyknap: those do look pretty handy |
| 21:39.34 | JoshH | sjansen, i haven't touched my filters on my list account in forever |
| 21:39.38 | sjansen | eggyknap: Sweet. Even makes sense to me. |
| 21:39.44 | JoshH | last message was on 02/09, the rapidwave thread |
| 21:39.45 | eggyknap | sjansen: well, I try :) |
| 21:45.38 | Jayce^ | http://connect2utah.com/content/news/story?cid=82122 |
| 21:45.38 | JoshH | sjansen, do you have list admin access? i clicked password reminder, and got nothing, nothing in my mail log either. wonder if i got unsubscribed somehow |
| 21:45.53 | Jayce^ | the story about my neighbors, causing the fun the other day |
| 21:46.04 | *** join/#utah GvzEvxre (~timr@bzflag/projectlead/TimRiker) |
| 21:46.04 | *** mode/#utah [+o GvzEvxre] by ChanServ |
| 21:46.21 | Jayce^ | the cops loved that I could help provide details on how the company was running the scam |
| 22:01.57 | JoshH | apparently i was indeed unsubscribed |
| 22:02.04 | JoshH | just subscribed again |
| 22:05.36 | JoshH | looks like i got auto unsubscribed on 03/06 according to this message from plug-bounces that i never noticed before |
| 22:12.59 | tensai | Jayce^: because you were the straight man of the operation? |
| 22:13.12 | Jayce^ | :) |
| 22:13.40 | Jayce^ | was funny, since she had to come to my house to get online.. |
| 22:14.05 | JoshH | you should have shot them |
| 22:14.06 | Jayce^ | the detective needed some kind of proof that they were fraud before he could arrast |
| 22:14.08 | Jayce^ | arrest |
| 22:14.34 | Jayce^ | I could only sit for a little bit as she tried to describe her emails that looked legit.. |
| 22:14.55 | Jayce^ | JoshH: neighbors property... and then the cops were there |
| 22:15.08 | Jayce^ | thought technically I could wield because it was a felony :) |
| 22:15.59 | Jayce^ | before I got there, when she was calling the cops they were trying to bail.. she stood in front of the truck so they wouldn't leave.. |
| 22:16.03 | Jayce^ | kinda crazy |
| 22:16.30 | Jayce^ | the funniest part is the loser ex-husband giving the interview.. he wasnt' around for any of it |
| 22:16.47 | JoshH | sounds like the criminals were pretty dumb |
| 22:17.01 | Jayce^ | low guys on the totem pole |
| 22:17.06 | Jayce^ | just the end workers in the scam |
| 22:17.35 | JoshH | i'm wondering when the cops will solve the payson prof murder |
| 22:17.55 | Jayce^ | that night, the neighbor started getting calls from the fake company "have you seen them?" |
| 22:18.19 | Jayce^ | JoshH: who knows with that one, lots of questions they have no answers to there.. |
| 22:18.48 | JoshH | apparently the guy's kids were in on it though |
| 22:18.53 | JoshH | shouldn't be too hard to make them crack |
| 22:18.55 | stderr | whatever happened to the Susan Powell case? |
| 22:19.05 | JoshH | nothing new |
| 22:19.21 | sjansen | Jayce^ was helping scammers run a fake moving company? |
| 22:19.25 | Jayce^ | yeah, I'm not so sure about that, they were quick to point (and I've met the dude, he is odd) but doesn't smell right |
| 22:19.48 | JoshH | talking about powell or the prof? |
| 22:20.06 | stderr | smells to high heaven |
| 22:20.09 | Jayce^ | <PROTECTED> |
| 22:20.12 | Jayce^ | <PROTECTED> |
| 22:21.59 | JoshH | this article really makes it seem fishy |
| 22:22.02 | JoshH | http://www.ksl.com/?nid=148&sid=9462667 |
| 22:22.45 | *** join/#utah ljenkins (~ljenkins@137.190.80.249) |
| 22:23.10 | sjansen | <PROTECTED> |
| 22:23.18 | JoshH | the guy sure did have quite a gun collection |
| 22:23.27 | JoshH | http://www.ksl.com/?nid=148&sid=9894386 |
| 22:23.42 | Jayce^ | JoshH: yeah, most of it was overrated, I've seen a few of them.. |
| 22:23.55 | Jayce^ | <PROTECTED> |
| 22:25.45 | Jayce^ | the guy was a friend of a friend (of a friend), had heard of an met him before |
| 22:26.35 | JoshH | my guess is the kids decided to kill him for the value of the guns, but that's not something you simply take down to a pawnshop |
| 22:27.10 | sjansen | Being calm shouldn't be incriminating. People react differently. |
| 22:27.11 | Jayce^ | dont' think so, son couldn't own any firearms.. |
| 22:27.36 | JoshH | ya but there are problems with their story too |
| 22:27.46 | JoshH | and usually girls on 911 calls sound hysterical |
| 22:28.15 | Jayce^ | from my friend, he thinks it's more likely certain past "business" dealings that were kinda fishy |
| 22:28.28 | sjansen | Like not providing a description? I can think of several reasons for doing that. |
| 22:28.29 | Jayce^ | <PROTECTED> |
| 22:28.46 | JoshH | maybe he should tell the detectives what he knows about that |
| 22:29.03 | sjansen | Some people get hysterical. Others shut down emotionally. Why should only the first get our sympathy? |
| 22:29.17 | Jayce^ | he has.. was written down, given a thank you, etc.. |
| 22:29.25 | Jayce^ | so who knows |
| 22:29.28 | JoshH | i know what you mean sjansen, i'm just not giving them the benefit of the doubt in this case |
| 22:31.44 | JoshH | i was giving josh powell the benefit of the doubt at first, but then when the camping story was basically debunked, and some other weird things he did, i decided he's probably guilty |
| 22:32.10 | JoshH | the camping story didn't make any sense in teh first place |
| 22:38.47 | TodPunk | I'm not expressing an opinion on the matter, but some food for thought: The police never, EVER have your best interests at heart if you're being asked questions. It's counter to their goals to try to prove your innocence. Everything becomes evidence against you unless it's a logical proof counter to that. |
| 22:42.07 | TodPunk | My law school friend's favorite video on the subject: http://www.youtube.com/watch?v=6wXkI4t7nuc |
| 22:48.41 | tensai | eggyknap, sjansen: I think it's working. needs a little tweaking. for example, some days have all zeros, which of course is the max and thus every entry shows up. |
| 22:48.47 | *** join/#utah GvzEvxre (~timr@bzflag/projectlead/TimRiker) |
| 22:48.48 | *** mode/#utah [+o GvzEvxre] by ChanServ |
| 22:49.22 | eggyknap | tensai: complain, complain! That's all I ever hear from you... |
| 22:49.25 | eggyknap | :) |
| 22:50.12 | tensai | eggyknap: well if I'm going to complain, might as well ask how the organ podcast is going? |
| 22:50.16 | sjansen | SELECT spam_folder INTO tensai's_inbox WHEN max(v) <= 0; |
| 22:50.28 | eggyknap | Yeah, um... well... |
| 22:50.30 | eggyknap | :) |
| 22:50.40 | eggyknap | Haven't listened much lately. Hrm. |
| 22:51.09 | sjansen | SLASH tensai's tires WHERE he won't notice; |
| 22:51.25 | eggyknap | Careful... that's a tough transaction to roll back... |
| 22:51.29 | tensai | I've been playing the simplified hymns but haven't listened to a new podcast for a while |
| 22:52.09 | tensai | sweet, it's working! |
| 22:52.12 | tensai | ~sjansen++ |
| 22:52.18 | tensai | ~eggyknap++ |
| 22:53.23 | eggyknap | w00t. |
| 22:53.38 | *** join/#utah Supaplex (~supaplex@166.70.62.193) |
| 22:58.48 | sjansen | o/~ Son tantas cosas las que yo quisiera que tú fueras ~/o |
| 23:13.32 | *** join/#utah TimRiker (~timr@bzflag/projectlead/TimRiker) |
| 23:13.32 | *** mode/#utah [+o TimRiker] by ChanServ |
| 23:51.42 | *** join/#utah blendmaster1024 (~blendmast@unaffiliated/blendmaster1024) |