IRC log for #uphpu on 20101022

00:00.35mindjujusorry, i haven't
00:01.09mindjujutry #ubuntu-us-ut
00:02.28mgearyactually, it looks like it's something else
00:02.37mgearywhat would make httpd think that a file is a directory, and try to look for an .htaccess file in it? I'm getting errors like this: Permission denied: /path/to/some/domain/file.css/.htaccess pcfg_openfile
00:04.15mindjujuis this on a virtual server or a hosted account or is this a server you run?
00:04.41mgearya physical ubuntu machine
00:05.44mindjujucuriously, in some instances, this can happen with front page extensions, but i doubt that is the case here
00:12.51mgearyfound the problem
00:12.51mgearyit was just that the files didn't have +x perms
00:12.54mgearyi thought they just needed +r
00:13.02mindjujuah
00:13.04mindjujugood to know
00:20.24*** join/#uphpu TodPunk (~todpunk@host-210.pl1071511.fiber.net)
00:30.08*** part/#uphpu mgeary (~mgeary@166.70.44.49)
00:35.00*** join/#uphpu macnewbold (~macnewbol@wifi.codegreene.com)
00:35.00*** mode/#UPHPU [+o macnewbold] by ChanServ
00:54.40*** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com)
01:04.39*** join/#uphpu carmony (~justin@wifi.codegreene.com)
01:04.39*** mode/#UPHPU [+v carmony] by ChanServ
01:58.23*** join/#uphpu jsmith-away (~jsmith@fedora/jsmith)
01:58.23*** mode/#UPHPU [+v jsmith-away] by ChanServ
02:42.03*** join/#uphpu brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net)
04:16.56*** topic/#UPHPU by wps -> Utah PHP Users Group | uphpu.org
04:50.24*** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net)
04:50.24*** mode/#UPHPU [+v mgeary] by ChanServ
05:30.58*** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net)
05:30.58*** mode/#UPHPU [+v carmony] by ChanServ
07:13.52*** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos)
07:13.52*** mode/#UPHPU [+v DexterTheDragon] by ChanServ
07:47.16mindjujui hope your not up Dtd
08:10.20carmonyI am mindjuju
08:10.21carmony!
08:10.22carmony:D
13:25.59*** join/#uphpu BlackBishop (~d3xt3r@mail.d3xt3r01.tk)
13:26.04*** part/#uphpu BlackBishop (~d3xt3r@mail.d3xt3r01.tk)
14:30.38herlogoo morning!
14:58.23*** join/#uphpu mgeary (~mgeary@166.70.44.49)
14:58.23*** mode/#UPHPU [+v mgeary] by ChanServ
15:29.04*** join/#uphpu josephscott (~josephsco@74.200.246.169)
15:29.09*** mode/#UPHPU [+v josephscott] by ChanServ
15:50.06mindjujucarmony, there can be only 1
15:52.02HeartsbaneProblem solved... Carmony you are all clear
15:52.14mindjujutoo funny hearts
15:57.53Heartsbane:)
15:59.56josephscott~rlart
15:59.56ibotdoes a little 'renice 20 -u jnbek_'
16:02.43*** join/#uphpu SunSparc (~sparky@24-104-129.146.hfc.mediarain.com)
16:02.43*** mode/#UPHPU [+v SunSparc] by ChanServ
16:03.27*** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net)
16:09.32mgeary~rlart
16:09.32ibotinstalls a bad bootloader on herlo and turns herlo into a brick
16:36.11carmonylol
16:41.10herlommmmm
16:41.13herlohhmmmpp
16:44.42*** join/#uphpu thebigdog (~thebigdog@dsl093-228-015.slc1.dsl.speakeasy.net)
16:44.42*** mode/#UPHPU [+o thebigdog] by ChanServ
17:25.23*** join/#uphpu iammerrick (~Merrick@75-148-97-50-Utah.hfc.comcastbusiness.net)
17:25.42iammerrickI know this is more of a sql question, but I'm at a loss here.
17:25.43iammerrickIf I want to do a sub order from a limited result set would I use a sub query? http://pastie.org/1241167
17:29.00mindjujuiammerrick, i'm guessing this is mysql?
17:29.10iammerrickmindjuju yes
17:29.11iammerrick:)
17:30.00mindjujuif i'm not mistaken, you can say
17:30.09mindjujuORDER BY RAND();
17:30.32iammerrickbut I need it ordered by rating first
17:30.41iammerrickthen randomized
17:30.44iammerrickso I only get a random
17:30.48iammerrickof the top 20
17:31.50iammerrickminjuju
17:31.59iammerrickso I want to grab the top twenty photos based on their ratings
17:32.06iammerrickthen I want to grab 5 randomly from that 20
17:32.09iammerrickall in sql
17:32.26DexterTheDragonah ORBER BY RAND(), my favorite way to lock a database
17:33.21mindjuju@DtD -- touche
17:34.10mindjujuas far as i know, you can't use a subquery in this manner
17:34.14DexterTheDragoniammerrick: SELECT * FROM (SELECT name, id FROM photos ORDER BY id asc limit 20) as mytable ORDER BY RAND() LIMIT 5;
17:34.30iammerrickDexterTheDragon you are a saint
17:34.35iammerrickyou too mindjuju
17:34.36iammerrickthanks dudes
17:34.46mindjujufull points to DtD, that was art
17:34.56mindjuju~DextertheDragon++
17:35.11iammerrickDexterTheDragon: This is bad from performance wise?
17:35.57DexterTheDragoniammerrick: order by rand() is, this isn't too huge an issue here cause the limit 20 means your only rand-ing 20 rows
17:36.02orsonjI'd think not as the rand only applies to the results of the subquery
17:36.20iammerrickDTD, orsonj: We'll see when we do testing. thanks guys
17:36.27iammerrickUPHPU just one upped mysql
17:36.27iammerrickha
17:36.42iammerrickThe channel that is
17:37.19mindjujuUPHPU rocks in that regard, we have specialists from many tech disciplines
18:03.27*** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com)
18:16.31*** join/#uphpu macnewbold (~macnewbol@66.60.115.30)
18:16.31*** mode/#UPHPU [+o macnewbold] by ChanServ
18:18.32carmonyawwww, I missed a fun mysql query question
18:18.49mindjujuyou could offer your solution for us to marvel at
18:19.09carmony$x->Awesomefy();
18:19.10mindjuju...life of a CTO
18:19.22carmonylol, no :P
18:19.24mindjujuhow was golf this morning?
18:19.27carmonyhahah
18:19.32carmonyI went to bed at 2 am
18:19.37carmonyand was up and working by 8 am
18:23.04carmonyalso, randomly ordering your wife flowers "just because" is an awesome, awesome way to earn brownie points :)
18:23.17mindjujutrue that
18:23.26mindjujuhow is her ankle?
18:48.16macnewboldcarmony: be careful with the random flowers - i know some women suspect that "just because" is an apology in advance for something they don't know about yet...
18:48.45carmonyhaha, yeah, my wife asked me like 3-4 times "Ok, what are these really for?"
18:48.54carmonyher ankle is good now
18:50.19mindjujuthe way to get around that is to give her a wink
18:53.06mindjujugrrls like winks
19:11.18*** join/#uphpu PoeticIntensity (~jason@76.8.222.23)
19:11.18*** mode/#UPHPU [+v PoeticIntensity] by ChanServ
19:25.06*** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net)
19:39.05*** join/#uphpu mgeary (~mgeary@166.70.44.49)
19:39.10*** mode/#UPHPU [+v mgeary] by ChanServ
20:04.40*** part/#uphpu iammerrick (~Merrick@75-148-97-50-Utah.hfc.comcastbusiness.net)
20:16.48*** join/#uphpu josephscott (~josephsco@74.200.246.169)
20:16.49*** mode/#UPHPU [+v josephscott] by ChanServ
20:20.46josephscott~lart small airplanes
20:20.46ibotdumps 42 tons of dirt, manure, and fish heads on small airplanes
20:22.11mindjujuare you in arid-zona now?
20:32.17josephscottheading to las vegas in a few minutes
20:32.28josephscottfor WordCamp Las Vegas on Saturday
20:36.27carmonylol
20:36.34carmony~lart josephscott
20:36.34ibot--purges josephscott
20:36.37carmony/wince
20:36.45josephscott~lart carmony
20:36.45ibotsend killer squirrels to attack carmony
20:37.20carmonyhehe
20:50.08mindjujuah, it was las vegas, for some reason i remembered it as arizona
21:00.29mindjuju~seen fungus
21:00.34ibotfungus <~olsonl@bromine.sosstaffing.com> was last seen on IRC in channel #uphpu, 6d 21h 51m 42s ago, saying: 'well ibot doesn't'.
21:00.49mindjujui've wondered where he was
21:04.39*** join/#uphpu utahcon (~utahcon@li51-147.members.linode.com)
21:04.39*** mode/#UPHPU [+v utahcon] by ChanServ
21:16.18mindjujuanybody here work with ssh keys
21:16.28mindjujuheartsbane ^^ you around?
21:53.19utahconmindjuju: what do you need to know?
21:55.29mindjujuto see if this is still valid
21:55.30mindjujuhttp://pkeck.myweb.uga.edu/ssh/
21:57.35utahconyes and no
21:58.03utahconmost machines what you want to do is on your local machine you create your keys with ssh-keygen
21:58.17utahconman ssh-keygen for the most detail on how to use it :D
21:58.27utahconbut then once you have your key generated you simply use
21:58.32utahconssh-copy-id server.com
21:58.45utahconthat will prompt you for your password
21:58.55utahcononce it is complete you simply ssh server.com and it will log you in automatically :D
21:59.28utahconI have never done the ssh-agent thing
22:56.01Heartsbanemindjuju: yes do what utahcon suggested
22:56.08Heartsbaneor port knock it
22:56.39mindjujui knew that was going to come up
22:56.53mindjuju~fartknock heartsbane
22:59.09*** join/#uphpu supernovia (~supernovi@76.8.222.23)
23:01.10HeartsbaneI am going to keep bringing it up as long as you do, you started it at UTOS ... going through a bastion host is better than knocking
23:01.21supernoviahey mgeary
23:04.34mindjujuwho mentioned anything about knocking?
23:04.43mindjujuall i said was ssh with key
23:04.56Heartsbaneoh my bad
23:43.31carmonyany ssl experts here? :P
23:45.44*** join/#uphpu mgeary (~mgeary@166.70.44.49)
23:45.44*** mode/#UPHPU [+v mgeary] by ChanServ
23:46.32supernoviacarmony, I wouldn't call myself an expert but I have installed a few hundred certs
23:46.37supernoviawhat's up?
23:47.34carmonygrrrr.... it was my client
23:47.38carmonymixed http and https content
23:47.52supernoviaah
23:47.59supernoviabeen there. :-(

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.