| 00:12.16 | *** join/#uphpu beandog (n=sdibb@c-24-10-189-221.hsd1.ut.comcast.net) |
| 00:12.19 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 00:59.36 | *** join/#uphpu carmony_ (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 01:12.10 | *** join/#uphpu mastergunns (n=mastergu@c-71-199-7-162.hsd1.ut.comcast.net) |
| 01:23.57 | Lone_Wanderer | Anyone still here? |
| 01:27.29 | *** join/#uphpu utahcon (n=utahcon@bromine.sosstaffing.com) |
| 01:39.39 | supernovia | I'm still here |
| 01:39.44 | supernovia | not sure what time you said that though :) |
| 01:39.52 | supernovia | how's your workout going Lone_Wanderer? |
| 01:52.14 | supernovia | er. |
| 02:16.05 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 02:16.05 | *** mode/#UPHPU [+o wps] by ChanServ |
| 03:01.40 | herlo | Lone_Wanderer: consider not using mirc, it sux0rz |
| 03:01.41 | herlo | :) |
| 03:08.50 | *** join/#uphpu toofer1 (n=toofer@kjordan.securesites.net) |
| 03:11.16 | *** join/#uphpu supernovia (n=Velda@c-67-164-250-20.hsd1.ut.comcast.net) |
| 03:14.10 | wps | herlo? |
| 03:16.11 | wps | anyone have a minute to help me fix a MySQL query? |
| 03:16.38 | wps | I am grouping it but need it to give me a different record than the one that it's collapsing to |
| 03:16.57 | wps | I've tried sorting both directions and it doesn't change the outcome |
| 03:19.56 | herlo | wps: what? |
| 03:21.11 | wps | is there anyway to have MySQL not order by the column you group by? |
| 03:22.59 | supernovia | what are you trying to order by? |
| 03:23.14 | herlo | wps: yes, just add an order by statment |
| 03:23.27 | supernovia | me too |
| 03:23.34 | herlo | :-D |
| 03:23.35 | wps | it seems to be ignoring my order by statement |
| 03:23.39 | supernovia | well, anytime I'm messing around in mysql anyway |
| 03:23.51 | supernovia | makes me wonder what you're trying to order by .. |
| 03:24.12 | herlo | wps: probably because you are ordering somethign that really can't be sorted or you've got some sort of strange query |
| 03:24.14 | wps | I'm trying to order by a value that's i've joined |
| 03:24.46 | supernovia | what kind of data? |
| 03:27.31 | supernovia | anyway it -should- work.. |
| 03:27.55 | wps | here's my query: http://rafb.net/p/BvvgVG10.html |
| 03:28.35 | wps | each entry in prodir_prototypes has multiple entries in prodir_prototypes_versions |
| 03:28.53 | wps | I only want the latest (that is active) |
| 03:28.59 | wps | it may not be possible with a single query |
| 03:29.43 | wps | so I join to prodir_prototypes_versions to get the prototype's versions and then join to prodir_versions to get the version names and statuses |
| 03:34.17 | supernovia | not sure if there's a better way to do it (since I'm not so familiar with the structure) |
| 03:34.40 | supernovia | where's your group by? |
| 03:34.50 | wps | yeahâ¦Â really hard to help over IRC |
| 03:35.20 | wps | oopsâ¦Â sorryâ¦Â had it commented out |
| 03:35.57 | wps | here: http://rafb.net/p/oMCDmt56.html |
| 03:36.15 | supernovia | again I can't tell without the database but were you grouping because you were getting duped data? |
| 03:36.24 | wps | yes |
| 03:36.36 | wps | here's an example: |
| 03:36.40 | wps | (or the output) |
| 03:36.45 | wps | s/or/of/ |
| 03:37.02 | supernovia | might try a left join instead (or a right join, depending on the db) |
| 03:37.18 | wps | http://rafb.net/p/rmYFjb91.html |
| 03:37.45 | wps | note lines 4 and 5 |
| 03:37.56 | wps | when I GROUP, I get 4 |
| 03:37.58 | wps | I want 5 |
| 03:38.00 | supernovia | yeah - probably better not do an inner join |
| 03:40.43 | supernovia | try a right join I think (I'm no sql guru) |
| 03:46.27 | *** join/#uphpu mgeary (n=mgeary@69.169.142.45.provo.static.broadweave.net) |
| 03:46.27 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 03:47.11 | mindjuju | wps, did you ever get your sql query fixed? |
| 03:47.18 | wps | no :( |
| 03:47.24 | wps | it's a beast |
| 03:48.34 | wps | here's my understanding of the problem |
| 03:48.49 | wps | in addition to grouping, GROUP BY also performs a sort |
| 03:49.31 | wps | unfortunately, sorting by my GROUP BY column jacks everything up and since you have to GROUP BY before your ORDER BY, I'm screwed |
| 03:50.38 | supernovia | but you're grouping because your rows are duplicated by your joins, correct? |
| 03:51.01 | wps | correct |
| 03:51.16 | mgeary | supernovia: hey |
| 03:51.27 | supernovia | typically I can get rid of dupes with the right kind of join |
| 03:51.31 | supernovia | Hey mgeary :) |
| 03:52.02 | wps | that would be my preference |
| 03:52.25 | supernovia | tried a right join? |
| 03:52.37 | wps | on which of the joins? |
| 03:52.47 | supernovia | brb - phone |
| 03:52.50 | wps | and isn't a right the default in MySQL? ie, I'm already using one? |
| 03:54.33 | mindjuju | so this is the original query, the others are just varients trying to find one that works, right? |
| 03:54.34 | mindjuju | http://rafb.net/p/oMCDmt56.html |
| 03:55.04 | wps | yes |
| 03:56.09 | wps | I need each pt.pt_id with it's most recent, active ptve.ptve_id |
| 03:56.18 | wps | active is what makes this difficult |
| 03:56.33 | wps | pv.pv_id 's have status |
| 03:57.50 | wps | waitâ¦Â sorryâ¦Â I said that wrong |
| 03:57.58 | wps | getting the ones with a status of 2 or 6 is working fine |
| 03:58.24 | wps | the issue is that there are multiple prodir_prototypes_versions with statuses of 2 or 6â¦Â thus the dupes |
| 03:59.00 | wps | I need something that says WHERE the version is the most recent that's active |
| 03:59.27 | wps | or, I guess just "the most recent" (since have already limited the query to the ones that are active (2 or 6 is active) |
| 04:00.57 | mindjuju | err, no equation, the sql query |
| 04:01.28 | wps | here's a question: |
| 04:01.45 | wps | if your database is such and you have single A to many B⦠|
| 04:01.53 | wps | should you select from A and JOIN B |
| 04:01.59 | wps | or select from B and join A? |
| 04:02.29 | mindjuju | well, let's look at it this way wps, and you tell me what you need. Let's say A is clients and B is sku nums from purchases |
| 04:02.45 | mindjuju | are you looking for all the purchases that max made or all the people who purchased widget 2? |
| 04:03.05 | wps | here's I'll just tell you exactly what I have |
| 04:03.14 | wps | I have pages (A). |
| 04:03.23 | wps | Each page has a version logged (B) |
| 04:03.46 | wps | each version has a name and a status (C) |
| 04:04.18 | wps | versions have statuses such as (queued, archived, released) |
| 04:04.57 | wps | I want a list of the pages with their highest version that's been released |
| 04:06.12 | wps | actual tables: pages (pt), versions (ptve), and versions (pv) |
| 04:06.42 | wps | versions are releases (ie: 1.0.1, 1.0.2, 1.0.3, etc) |
| 04:07.19 | wps | dang, sorry for the typo (only adds to the confusion) |
| 04:07.40 | wps | actual tables: pages (pt), page versions (ptve), and versions (pv) |
| 04:10.57 | mindjuju | and the status should be either 2 or 6, right? |
| 04:11.09 | supernovia | hey guys, did you figure it out? |
| 04:11.09 | wps | yes |
| 04:11.23 | supernovia | classno |
| 04:11.27 | supernovia | what'd you have to do? |
| 04:11.38 | wps | so, see on this example of some of the results⦠|
| 04:11.39 | wps | http://rafb.net/p/rmYFjb91.html |
| 04:11.44 | wps | lines 4 and 5? |
| 04:12.06 | wps | exactly the same except for the version? |
| 04:12.36 | wps | when I group it, it removes the dupes, but no matter how I order it, I always get 4 |
| 04:12.42 | wps | I need 5 (the most recent release) |
| 04:14.05 | supernovia | i'd say focus on not getting dupes first |
| 04:14.34 | wps | good suggestion |
| 04:14.52 | wps | I'm not sure how to tell it which is the most recent version besides sorting |
| 04:15.49 | supernovia | well, i can never remember which one is right, left or right join |
| 04:16.01 | supernovia | but I know using the wrong one gives you dupes where you don't want them |
| 04:16.17 | wps | it's left join that does not give you dupes |
| 04:16.27 | wps | but I don't see where I could use a left |
| 04:16.45 | wps | wait⦠|
| 04:18.24 | wps | still get dupes with the left |
| 04:18.29 | wps | I need another condition |
| 04:18.36 | wps | where x=y |
| 04:20.44 | supernovia | keep playing with it :) |
| 04:23.08 | mindjuju | wps, pt.pt_id is already unique, no? |
| 04:23.38 | mindjuju | ie, the duplicity doesn't exist in that field, but in the page version |
| 04:23.46 | wps | correct |
| 04:23.59 | wps | :) |
| 04:24.03 | wps | thanks for trying to help |
| 04:24.05 | wps | I appreciate it |
| 04:29.14 | mindjuju | wps, i think i'm on home stretch, just one last question, the page status is stored in pv, yes? |
| 04:29.40 | wps | not the page status |
| 04:29.46 | wps | the pages don't have a status |
| 04:30.10 | mindjuju | oh, versions have statuses |
| 04:30.29 | wps | each of the page versions are assigned a version/releaseâ¦Â which has a status |
| 04:32.34 | mindjuju | so you want 1 listing per pt.pt_id formated as specified in your original query where the page version is the most recent and version/release status is 2 or 6 |
| 04:33.16 | wps | yes |
| 04:33.41 | mindjuju | :) coolio, let me start on conversion now that i know exactly what you want |
| 04:45.54 | mindjuju | wps - starting on line 15 - http://rafb.net/p/OEdnCd13.html ( i know it looks a little nutty, but i think it'll work, the only part i'm not sure on is if it'll let you have access to pt.* since it is part of a subquery |
| 04:45.59 | mindjuju | but i THINK it will |
| 04:47.48 | mindjuju | oh wait, ididn't limit it on the revision |
| 04:47.50 | mindjuju | grrr |
| 04:49.35 | mindjuju | wait wait, what's PM? |
| 04:49.44 | wps | that's module |
| 04:49.48 | wps | each page is assigned to a module |
| 04:50.09 | wps | I didn't bring it up because it's a simple one-to-one join and is working alright |
| 04:50.32 | wps | I've been wondering if I'd need to do a sub-select |
| 04:50.58 | mindjuju | yeah, i think so |
| 04:51.21 | mindjuju | i'm actually flipping this so that pt and ptve are in the original select and pv is the subquery |
| 04:51.29 | mindjuju | i think THAT is your best bet |
| 04:59.25 | mindjuju | wps, soemthing more like this, but it'll still need a tweak on the revision |
| 04:59.26 | mindjuju | http://rafb.net/p/Cyjt5F32.html |
| 05:00.15 | mindjuju | course, if you INNER JOIN on this line instead, it might do it, not pretty, but might work |
| 05:00.22 | wps | thank you |
| 05:00.31 | wps | I'll try adding the module in and see what results I get |
| 05:00.41 | mindjuju | INNER JOIN ixd_prodir.prodir_prototypes_versions ptve |
| 05:00.48 | mindjuju | off line 3 |
| 05:00.55 | mindjuju | :) |
| 05:01.27 | *** part/#uphpu mastergunns (n=mastergu@c-71-199-7-162.hsd1.ut.comcast.net) |
| 05:05.49 | wps | ERROR 1242 (21000): Subquery returns more than 1 row |
| 05:06.19 | wps | does it need a limit 1 in it or something? |
| 05:10.48 | wps | I think we're getting warm |
| 05:13.02 | mindjuju | sorry, was looking at some code |
| 05:13.26 | mindjuju | oh, because we say 2 or 6, duh! |
| 05:14.00 | mindjuju | ws that on the first suggested or thesecond? |
| 05:14.14 | wps | second |
| 05:28.40 | wps | I THINK I GOT IT |
| 05:32.49 | *** join/#uphpu kingsol (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net) |
| 05:32.55 | wps | it jacked up my pagination so I'm not positive yet, but it appears to be right |
| 05:32.59 | wps | kingsol! |
| 05:33.24 | wps | good evening, sir |
| 05:33.52 | wps | mindjuju: here's what I think is working: http://rafb.net/p/uyNe5x78.html |
| 05:35.15 | *** part/#uphpu kingsol (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net) |
| 05:35.29 | *** join/#uphpu kingsol (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net) |
| 05:36.37 | *** part/#uphpu kingsol (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net) |
| 05:36.53 | *** join/#uphpu kingsol (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net) |
| 05:58.59 | *** join/#uphpu thebigdog (n=thebigdo@207.135.132.13) |
| 05:58.59 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 06:00.33 | *** join/#uphpu kingsol_ (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net) |
| 06:16.57 | wps | mindjuju: thank you! |
| 06:17.34 | wps | thebigdog says that I will get better performance with a function instead of a sub-select, but you pointed me in the right direction |
| 06:17.40 | wps | I owe you man |
| 13:44.30 | *** join/#uphpu itimber (n=itimber@c-98-202-102-189.hsd1.ut.comcast.net) |
| 13:44.30 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 13:48.56 | itimber | morning all |
| 15:00.17 | *** join/#uphpu Lonnie (n=olsonl@bromine.sosstaffing.com) |
| 15:00.30 | *** join/#uphpu josephscott (n=josephsc@75-169-255-227.slkc.qwest.net) |
| 15:00.31 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:00.50 | *** join/#uphpu synic (n=squish@pdpc/supporter/student/synic) |
| 15:00.50 | *** mode/#UPHPU [+v synic] by ChanServ |
| 15:11.39 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 15:11.39 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:11.59 | *** part/#uphpu toofer1 (n=toofer@kjordan.securesites.net) |
| 15:14.13 | mgeary | ~yow |
| 15:20.28 | *** join/#uphpu toofer (n=toofer@kjordan.securesites.net) |
| 15:25.49 | utahcon | josephscott: You in? |
| 15:25.58 | josephscott | utahcon: yep, what's up? |
| 15:26.17 | utahcon | Am I just retarded or is it hard to find the changelog for my? |
| 15:26.20 | utahcon | oops...mu? |
| 15:26.51 | josephscott | beyond what donncha posts on his blog? |
| 15:27.20 | utahcon | Is that too much to ask? |
| 15:27.40 | josephscott | hehe |
| 15:28.07 | josephscott | I don't think there's an official changelog for WP either |
| 15:28.32 | utahcon | LOL - I just had some users throw up flags at me cause I updated their blogs and they want to know what changed. |
| 15:30.00 | josephscott | most of the time new WPMU versions are syncing with WPM releases |
| 15:30.23 | josephscott | and that's been made a little bit easier by moving WPMU version numbers to line up with WP releases |
| 15:30.40 | josephscott | so WPMU 2.7 is the MU equiv of WP 2.7 |
| 15:31.29 | carmony | I've thought about installing WPMU, cause I want to have 3-4 blogs on different things |
| 15:36.23 | utahcon | carmony: MU is the bomb! |
| 15:37.25 | carmony | blog.cevo.com uses MU, but its out of date...... |
| 15:38.35 | utahcon | efx2blogs.info uses MU |
| 15:38.48 | utahcon | and I am in the process of getting it on 2.7.x |
| 15:46.01 | *** join/#uphpu SunSparc (n=sparky@173.8.91.177) |
| 15:46.24 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 15:49.47 | herlo | morning, I still hate DST |
| 15:51.11 | utahcon | jbot: ~lart herlo |
| 15:51.11 | jbot | <alias> ~lart utahcon |
| 15:51.16 | utahcon | damned |
| 15:51.45 | herlo | hehe |
| 15:51.51 | herlo | ~lart utahcon |
| 15:51.51 | jbot | flings poo at utahcon |
| 15:52.12 | utahcon | see how it is |
| 15:54.44 | SunSparc | ~lart DST |
| 15:54.44 | jbot | forces DST to use Outlook Express |
| 15:59.51 | *** join/#uphpu cro (n=cro@c-67-186-219-197.hsd1.co.comcast.net) |
| 16:00.02 | cro | 'morning all |
| 16:00.39 | *** join/#uphpu redroy (n=kenner@c-71-199-5-32.hsd1.co.comcast.net) |
| 16:00.56 | cro | mindjuju: So sorry I missed the geek lunch. Hospital visit took much longer than I thought. |
| 16:00.58 | josephscott | mindjuju: what's the plan for this month's meeting? |
| 16:15.19 | *** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) |
| 16:15.19 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:20.06 | *** join/#uphpu thebigdog (n=thebigdo@70.103.91.98) |
| 16:20.06 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 16:20.39 | SunSparc | http://www.ted.com/index.php/talks/pattie_maes_demos_the_sixth_sense.html |
| 16:25.58 | mindjuju | no worries cro |
| 16:26.09 | cro | big turnout? |
| 16:26.26 | mindjuju | josephscott, this month is joint UPHPU + UDBUG meeting -- eggyknap is presenting |
| 16:26.40 | josephscott | topic? |
| 16:26.46 | mindjuju | cro, fungus, herlo and I were there |
| 16:26.47 | eggyknap | The joys of SQL :) |
| 16:26.52 | mindjuju | :) |
| 16:27.01 | cro | :-( Now I feel really bad |
| 16:27.08 | mindjuju | nah, no worries, we had fun |
| 16:27.53 | mindjuju | good eats, good times |
| 16:27.55 | utahcon | what? did I miss a meeting? |
| 16:28.06 | mindjuju | utahcon, nope, just geek lunch |
| 16:28.18 | utahcon | ah! ok |
| 16:28.22 | mindjuju | it didn't have any promo launch with it, but we had it so we could return to a normal schedule |
| 16:28.39 | mindjuju | First Friday of the month is now Geek Lunch Friday |
| 16:28.49 | mindjuju | with this next Geek Lunch going to be in Utah County |
| 16:28.50 | utahcon | ah |
| 16:28.50 | utahcon | ok |
| 16:28.57 | mindjuju | let's see if any of those yahoos show up though |
| 16:29.03 | mindjuju | :p |
| 16:30.11 | mindjuju | maybe i'll send something to the mailing list after i send promo out for this month's meet to see where people want to meet |
| 16:30.24 | mindjuju | i'm thinking Los Hermanos or maybe Octavios |
| 16:30.43 | utahcon | octavios is a heart attack waiting to happen... and I will enjoy it. |
| 16:32.47 | SunSparc | It is actually, Ottavios, and they have some awesome food. :) |
| 16:33.27 | SunSparc | Here is a Dilbert for all you Mobile Phone lovers: http://news.yahoo.com/comics/dilbert;_ylt=AlzzE8s73XUEb5S1Z.KzChW26ysC |
| 16:34.48 | mindjuju | maybe we should do it there |
| 16:35.29 | *** join/#uphpu supernovia (n=Velda@c-67-164-250-20.hsd1.ut.comcast.net) |
| 16:35.49 | utahcon | SunSparc: that is so me and my g1 |
| 16:35.57 | utahcon | G1 for the win this weekend house hunting. |
| 16:40.14 | SunSparc | utahcon: No kidding. :) |
| 16:40.31 | Utah_Dave | SunSparc: that's so awesome |
| 16:40.40 | SunSparc | mindjuju: Joe Veras stillhas the best salsa in the valley. |
| 16:40.41 | Utah_Dave | utahcon: I have a g1 too |
| 16:40.55 | mindjuju | Joe Veras? where / what is that? |
| 16:41.01 | carmony | :P |
| 16:41.03 | mindjuju | plug, diego's has some good eats |
| 16:41.07 | mindjuju | in Provo |
| 16:41.11 | mindjuju | or at least had |
| 16:41.12 | SunSparc | mindjuju: 2 blocks West of Ottavio's |
| 16:41.16 | mindjuju | haven't been there in a while |
| 16:41.28 | utahcon | Utah_Dave: Favorite app? |
| 16:41.45 | mindjuju | a super long time ago, they used to MAKE menudo, though like 2 yrs ago, i went back and i think it was the can stuff heated |
| 16:41.47 | mindjuju | :( |
| 16:44.02 | Utah_Dave | carmony: what? how'd you get a g2? |
| 16:44.22 | mindjuju | what is a G1 or a G2? |
| 16:44.28 | mindjuju | i know what a G4 is |
| 16:44.31 | SunSparc | mindjuju: Google phones |
| 16:44.35 | mindjuju | h |
| 16:44.35 | Utah_Dave | utahcon: Hmm. I use reveal reader, shazaam and all the google apps a lot |
| 16:44.36 | mindjuju | ah |
| 16:45.01 | utahcon | Found a good PDF reader? |
| 16:45.16 | utahcon | all I have tried have died before opening my PDFs |
| 16:45.26 | Utah_Dave | oh, and I just installed BeyondPod. It's awesome. Download my audio podcasts straight to the phone and plays them. |
| 16:45.35 | utahcon | nice |
| 16:45.36 | Utah_Dave | nope. nothing for pdf's yet |
| 16:45.56 | Utah_Dave | connectbot is awesome for ssh sessions, too. that has saved my behind several times |
| 16:46.05 | utahcon | I love connectbot |
| 16:46.08 | SunSparc | Quite a few good PDF readers for the iPhone... |
| 16:46.25 | utahcon | I used it the night after I downloaded it to fix code on a live server from an Arby's drive-thru! |
| 16:46.43 | utahcon | SunSparc: No worries. iPhone's have their place. |
| 16:46.44 | utahcon | :d |
| 16:46.56 | SunSparc | utahcon: That is awesome, coding on the road. |
| 16:47.11 | Utah_Dave | Oh, and I love smspopup |
| 16:47.20 | SunSparc | I have had to do some server admin from the road. So nice |
| 16:54.50 | herlo | mindjuju: where was I with cro, you and fungus? |
| 16:55.15 | cro | Either UTOSC, or Happy Sumo at Gateway |
| 16:55.31 | herlo | oh |
| 16:55.32 | herlo | okay |
| 16:55.34 | herlo | http://twitpic.com/1zaet |
| 16:55.40 | herlo | for you BSG Fans ^^ |
| 16:56.08 | supernovia | Oo, fraction. I like that one |
| 16:56.08 | SunSparc | :) |
| 17:01.07 | carmony | lol |
| 17:02.58 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 17:02.58 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 17:03.39 | SunSparc | What?! Lucky! |
| 17:03.46 | SunSparc | cro: where are you located? |
| 17:03.52 | cro | Layton |
| 17:04.05 | SunSparc | Hmm... |
| 17:04.30 | SunSparc | That is how close I am to having it. |
| 17:04.38 | SunSparc | Yet no time table for finishing it. |
| 17:05.02 | cro | Need to find a friend and setup tight-beem wireless :-D |
| 17:05.17 | cro | s/beem/beam/ |
| 17:06.14 | SunSparc | :) |
| 17:13.42 | mindjuju | i wonder when they'll get to my part of Orem |
| 17:14.11 | mindjuju | yo -- thebigdog |
| 17:14.25 | mindjuju | wps was saying you figured out what to do on that sql query, what did you do? |
| 17:17.32 | supernovia | hey yeah, what did you end up doing thebigdog? |
| 17:17.38 | herlo | http://www.engadget.com/2009/03/10/in-case-you-missed-late-night-with-jimmy-fallon-last-night/ |
| 17:19.08 | herlo | the new palm pre ^^ |
| 17:22.48 | supernovia | hehe |
| 17:32.22 | SunSparc | Hey, that is kinda cool! |
| 17:32.34 | *** join/#uphpu Dezertol (n=toph@mail.system33.com) |
| 17:32.44 | SunSparc | And that is coming from an Apple fanboy |
| 17:33.06 | Dezertol | wow.. I didn't expect this many people in here ;-) |
| 17:33.11 | Dezertol | greetings to all |
| 17:33.27 | SunSparc | Dezertol: what did you expect? |
| 17:33.29 | mgeary | Dezertol: well, there's a lot of potatoes and ham in utah |
| 17:33.37 | SunSparc | lols |
| 17:33.37 | Dezertol | lol |
| 17:33.40 | macnewbold | ~greet Dezertol |
| 17:33.41 | jbot | ACTION dumps a bucket of cold oatmeal on Dezertol |
| 17:33.41 | Dezertol | right right |
| 17:33.50 | macnewbold | hm, not what I intended |
| 17:33.55 | Dezertol | lol |
| 17:33.56 | macnewbold | ~welcome Dezertol |
| 17:33.57 | jbot | Howdy, Dezertol! |
| 17:34.01 | macnewbold | that's better |
| 17:34.11 | Dezertol | I found the group from linked in |
| 17:34.17 | Dezertol | moved here from phoenix |
| 17:34.28 | unum | when ever I try to reload a page it takes forever |
| 17:34.35 | unum | but if press stop and then reload it works |
| 17:34.45 | unum | anyone see that before |
| 17:34.49 | Dezertol | yes |
| 17:34.51 | mgeary | yeah |
| 17:34.56 | Dezertol | on a bud of mine's site |
| 17:35.04 | Dezertol | he was loading some adds that had DNS issues |
| 17:35.17 | Dezertol | so it was waiting to draw the adds.. then if you hit stop it would load |
| 17:35.17 | unum | hmm I'm afraid that's not my issue |
| 17:35.40 | SunSparc | Nice, that is cool that you found us Dezertol. Just don't expect us to talk about PHP. |
| 17:35.51 | Dezertol | no worries.. |
| 17:36.01 | jsmith | SunSparc: Or, at least... *always* talk about PHP |
| 17:36.06 | Dezertol | been using php since v3 |
| 17:36.10 | SunSparc | jsmith: Right |
| 17:36.17 | Dezertol | so i'm not exactly going to be posting questions about it |
| 17:36.34 | jsmith | Oh, and don't expect everyone to be from Utah either :-) |
| 17:36.43 | unum | this actually is a php web page of mine |
| 17:36.49 | Dezertol | what.. the internet isn't just here in utah |
| 17:36.50 | SunSparc | Well good, you can help us figure out whether we should have more gun control or not. |
| 17:36.50 | Dezertol | lol |
| 17:36.58 | dataw0lf | Utah? Where's that? |
| 17:36.59 | unum | that's all it does is query a database and writes out the results |
| 17:37.03 | jsmith | dataw0lf: Exactly! |
| 17:37.05 | unum | if I hit stop the page remains blank |
| 17:37.14 | unum | but when I hit reload everything shows up |
| 17:37.18 | Dezertol | is the query huge? |
| 17:37.19 | Dezertol | lol |
| 17:37.28 | dataw0lf | jsmith: See! Now we're agreeing that we both don't live in Utah. Remarkable! |
| 17:37.29 | dataw0lf | ;-) |
| 17:37.35 | Dezertol | and are you caching the query |
| 17:37.38 | jsmith | dataw0lf: I think it's that square state next to Wyoming... but not Colorado... the desert one... no, not Arizona either... |
| 17:37.53 | dataw0lf | hehe |
| 17:38.53 | dataw0lf | haha |
| 17:39.01 | Dezertol | any of you eq2 or wow players? |
| 17:39.31 | Dezertol | or any games.. for that matter |
| 17:39.59 | dataw0lf | WoW? Used to but then I got a new acne treatment cream. |
| 17:40.14 | Dezertol | lol |
| 17:40.39 | Dezertol | most of the guys at work play wow |
| 17:40.40 | SunSparc | dataw0lf: Sooo, yesterday? |
| 17:40.52 | Dezertol | there all 30+ |
| 17:40.53 | Dezertol | lol |
| 17:40.59 | Dezertol | most are married with kids |
| 17:40.59 | Dezertol | lol |
| 17:41.06 | dataw0lf | SunSparc: in all actuality I did play WoW yesterday |
| 17:41.10 | dataw0lf | for like, 30 minutes. |
| 17:41.18 | Dezertol | I like eq2 more but have been so busy i've not plaied since xmax |
| 17:41.21 | Dezertol | xmas |
| 17:41.27 | dataw0lf | My Xbox RROD'ed in the middle of a CoD: WaW game. |
| 17:41.28 | SunSparc | Hehe, I did too. Starting a new Pally. |
| 17:41.48 | dataw0lf | ah, I pwned a couple Warsong Gulch matches |
| 17:41.50 | Dezertol | speaking of which.. is anyone else out there crazy buzy .. I've had more contract work this year then I had all last year |
| 17:41.51 | SunSparc | My son and I started playing together over the weekend. He is liking it. |
| 17:41.59 | dataw0lf | ah very cool |
| 17:42.00 | Dezertol | and it's "down economy" |
| 17:42.33 | dataw0lf | git merge production |
| 17:42.39 | dataw0lf | blah |
| 17:42.44 | Dezertol | lol |
| 17:43.20 | SunSparc | For those who think there is no time to do what you want -> http://ping.fm/FYGub |
| 17:43.50 | dataw0lf | reminder: lunch on Friday after I fly in, 2ish. |
| 17:43.53 | unum | zeus |
| 17:44.03 | herlo | oh |
| 17:44.20 | herlo | dataw0lf: make sure to pack your snowboard as it's been snowing here |
| 17:44.34 | dataw0lf | herlo: hmmmm, not a bad idea (it's been snowing here too) |
| 17:45.04 | dataw0lf | I was actually going to bring my paintball markers for arctic warfare. |
| 17:45.28 | supernovia | thanks for that sunsparc |
| 17:45.36 | supernovia | or SunSparc rather |
| 17:45.36 | SunSparc | supernovia: np |
| 17:45.42 | SunSparc | heh |
| 17:48.34 | supernovia | "Do you think I could fit all that and still get straight As and have lots of time left over for playing World of Warcraft? No." |
| 17:48.43 | supernovia | hmmmm :) |
| 17:48.50 | SunSparc | hehe |
| 17:49.01 | mindjuju | i could sure go for some chinese food |
| 17:49.07 | SunSparc | It all depends on how much time you spend on wow versus the other stuff. |
| 17:49.14 | supernovia | you know who's got great chinese? China Isle in AF |
| 17:49.37 | supernovia | you just need to get Mrs. SunSparc to get into WoW, then you'll be set :) |
| 17:50.00 | SunSparc | lol, yeah, I have tried, she has no interest, yet. |
| 17:50.45 | supernovia | I haven't tried because I'm the sort that gets addicted, and I'm too busy making time for my incredible projects ya know. |
| 17:51.08 | mindjuju | Sunsparc, i've heard, that the wii is a gateway drug to all kinds of video-gamery |
| 17:51.14 | SunSparc | supernovia: I completely understand. |
| 17:51.25 | SunSparc | mindjuju: LOL, probably true. |
| 17:51.26 | mindjuju | also, i've heard Super Monkey Ball for the xbox has the same affects |
| 17:51.35 | supernovia | wii fit is the best :-D |
| 17:51.40 | mindjuju | err, effects i mean |
| 17:51.46 | supernovia | it's a gateway drug with health benefits :-) |
| 17:51.55 | SunSparc | Wii Fit is quite fun. |
| 17:52.12 | supernovia | my basement carpet's been torn up for a week now and I miss the wii fit dearly |
| 17:52.28 | mindjuju | do you have to use carpet? |
| 17:52.33 | SunSparc | supernovia: you can use ours while you are carpetless |
| 17:52.35 | mindjuju | will a yoga mat do |
| 17:52.54 | SunSparc | mindjuju: no and yes |
| 17:52.56 | supernovia | maybe. the bigger problem I guess is finding the space |
| 17:53.05 | supernovia | I am in a room with 4 couches right now |
| 17:53.12 | supernovia | 3 tables, a piano, and a tv |
| 17:53.14 | herlo | SunSparc: git is da bomb! :) |
| 17:53.21 | dataw0lf | SunSparc: http://www-cs-students.stanford.edu/~blynn/gitmagic/ <-- Zie Git Guide |
| 17:53.29 | SunSparc | So I continue to hear you and dataw0lf say :) |
| 17:53.39 | herlo | SunSparc: because it's true |
| 17:53.42 | dataw0lf | it's fantastic |
| 17:53.45 | dataw0lf | and github rocks |
| 17:53.47 | mindjuju | Sunsparc, if you want more info on git, dexterthedragon, dataw0lf and herlo are goto people |
| 17:53.55 | mindjuju | if you want SVN, carmony is goto |
| 17:53.59 | SunSparc | We have actually be trying it out on one project. |
| 17:54.10 | herlo | in fact, it could become anything you want it to be, it's amazing! |
| 17:54.13 | mindjuju | and tierra uses it too, iirc |
| 17:54.22 | herlo | well, except it can't become your mom |
| 17:54.37 | herlo | that's just wrong |
| 17:54.38 | dataw0lf | yea, tierra is an SVN master. |
| 17:54.40 | dataw0lf | Poor him. |
| 17:54.43 | SunSparc | Dang! You mean it won't clean my room? |
| 17:55.02 | herlo | well, your mom won't do that forever, so when she stops, it might |
| 17:55.05 | SunSparc | dataw0lf: Thanks for the link |
| 17:55.10 | supernovia | I need someone to clean my room today. Please... |
| 17:55.11 | SunSparc | herlo: lolz |
| 17:55.21 | dataw0lf | SunSparc: np, it's a great read / reference. |
| 17:55.58 | Dezertol | lol i must be to old.. i'm still using good'ol cvs |
| 17:55.59 | Dezertol | lol |
| 17:56.16 | SunSparc | CVS?! Dood... |
| 17:56.17 | herlo | Dezertol: cvs has it's place... |
| 17:56.26 | dataw0lf | herlo: where? a graveyard? |
| 17:56.40 | herlo | dataw0lf: something like that |
| 17:56.46 | Dezertol | lol it's worked great for me so far.. |
| 17:56.58 | *** join/#uphpu josephscott (n=josephsc@70-1-125-205.pools.spcsdns.net) |
| 17:57.00 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 17:57.12 | herlo | mindjuju: you are just trying to get macnewbold to participate... |
| 17:57.19 | dataw0lf | Dezertol: well you can kill people with a rock but our military has moved on. |
| 17:57.39 | Dezertol | i'm a bow and arrow type actually |
| 17:57.40 | Dezertol | lol |
| 17:58.11 | SunSparc | mindjuju: Blasphemy!!! |
| 17:58.16 | Dezertol | lol |
| 17:58.26 | mindjuju | you noticed the whole IRC channel went dead silent for like a minute |
| 17:58.39 | Dezertol | cuz everyone was in shock |
| 17:58.42 | dataw0lf | ha, well, interestingly enough, Win 3.11 network stack was just a rip of the BSD stack.... |
| 17:58.50 | Dezertol | that anyone would even suggest such a thing |
| 17:58.51 | dataw0lf | the Win 3.11* |
| 17:58.56 | SunSparc | mindjuju: Got to work every now and again... |
| 17:59.22 | mindjuju | :) |
| 17:59.34 | Dezertol | I keep thinking about upgradeing to svn |
| 17:59.42 | SunSparc | ~work |
| 17:59.43 | jbot | from memory, work is the integral of the dot product of force and displacement |
| 17:59.47 | Dezertol | but.. i've got soooo much stuff in my current cvsroot |
| 18:00.17 | Dezertol | that i'm dragging my feet on it |
| 18:00.52 | Dezertol | like 10 years of code.. (most of which im to embarrased to show anyone) but still |
| 18:01.01 | DexterTheDragon | just upgrade straight to git |
| 18:01.04 | dataw0lf | yea |
| 18:01.14 | dataw0lf | I've got 15~ years of code in git... |
| 18:01.39 | Dezertol | what's the "primary" advantage |
| 18:01.48 | Dezertol | that git offers that say cvs doesn't |
| 18:01.54 | dataw0lf | proper branching, proper merging |
| 18:01.59 | dataw0lf | git-rebase |
| 18:02.06 | Dezertol | I've never used brancing or merging |
| 18:02.12 | Dezertol | my projects don't last that long |
| 18:02.38 | dataw0lf | simpler meta file system, much smaller and less intrusive. |
| 18:02.40 | Dezertol | I get a web project.. and I'm done and paied in a couple weeks |
| 18:02.46 | DexterTheDragon | no you've never branched and merged cause its impossible in cvs |
| 18:03.09 | Dezertol | what's an example of branched.. |
| 18:03.11 | Dezertol | like.. |
| 18:03.14 | Dezertol | could I.. |
| 18:03.18 | Dezertol | load my default framework |
| 18:03.26 | Dezertol | and then create a "branch" that is a one off site |
| 18:03.36 | Dezertol | or something like that |
| 18:04.07 | dataw0lf | you'd probably actually want a separate git repo for a one-off site that has the master framework as a remote repository. |
| 18:04.25 | dataw0lf | that you pull and merge from periodically as your core framework changes. |
| 18:04.52 | Dezertol | that's what I do now |
| 18:04.57 | dataw0lf | but meh http://www-cs-students.stanford.edu/~blynn/gitmagic/ just read this guide, it's interesting. |
| 18:05.00 | Dezertol | I check out my default |
| 18:05.15 | Dezertol | then.. drop all the cvs folders and check it in again under a "project name" |
| 18:05.39 | Dezertol | i'll take a look at the guid |
| 18:05.46 | Dezertol | and see if it can help me |
| 18:15.59 | unum | it sends a 0 when it dies |
| 18:25.19 | thebigdog | mindjuju, you had a question? |
| 18:28.15 | supernovia | thebigdog, he was asking about that query you helped wps with last night I think |
| 18:28.17 | supernovia | what'd you end up doing? |
| 18:28.31 | *** join/#uphpu eggyknap (n=jtolley@c-67-172-250-124.hsd1.ut.comcast.net) |
| 18:30.49 | mindjuju | (11:14:19 AM) mindjuju: yo -- thebigdog |
| 18:30.49 | mindjuju | (11:14:33 AM) mindjuju: wps was saying you figured out what to do on that sql query, what did you do? |
| 18:31.01 | thebigdog | i told him to do the sub query as a function that he can use and optimize |
| 18:31.13 | thebigdog | the i told him to optimize the outer query too |
| 18:31.15 | mindjuju | ah |
| 18:31.50 | thebigdog | basically he is getting ids from another query (sub query) and then using them in the outer query |
| 18:32.20 | thebigdog | so i told him to create a function for that query |
| 18:32.21 | mindjuju | yeah, i wrote that one |
| 18:32.53 | mindjuju | he originally had a 4 way join with dupes |
| 18:33.04 | thebigdog | oh nice |
| 18:33.59 | mindjuju | had a huge headache and wasn't thinking clearly -- but at least point in right direction |
| 18:46.20 | *** join/#uphpu brasto (n=brasto@206.81.135.61) |
| 18:46.20 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 18:48.15 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 18:48.15 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 19:02.17 | *** part/#uphpu mindjuju (n=mindjuju@76.8.222.130) |
| 19:04.21 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 19:08.00 | *** join/#uphpu mindjuju (n=mindjuju@76.8.222.130) |
| 19:08.00 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 19:16.23 | DexterTheDragon | anybody know of any places looking for a good php developer? |
| 19:16.45 | carmony | why do you ask? |
| 19:17.02 | DexterTheDragon | looking for options |
| 19:17.43 | supernovia | me too. Only I'm sucky @ php |
| 19:18.18 | SunSparc | potato and ham developers? |
| 19:18.44 | SunSparc | DexterTheDragon: Rain is always accepting resumes. |
| 19:18.55 | SunSparc | DexterTheDragon: pm |
| 19:19.10 | beandog | stupid dst. |
| 19:19.13 | beandog | it always feels later. |
| 19:19.14 | beandog | or earlier. |
| 19:19.16 | beandog | or something. |
| 19:19.27 | supernovia | I can totally develop potatoes and ham. |
| 19:19.50 | SunSparc | supernovia: Especially with some eggs, along with some good spices. |
| 19:19.51 | supernovia | Need to fix up my resume to focus more on design stuff than hosting |
| 19:19.56 | supernovia | Indeed. |
| 19:20.37 | supernovia | I actually need to get faster / better @ php too |
| 19:21.26 | supernovia | beandog, agreed. 1:21 now and it hardly feels like breakfast is digested |
| 19:22.53 | beandog | supernovia, is really weird. |
| 19:23.05 | beandog | it feels like 3p.m. or so. |
| 19:23.07 | beandog | oh well. |
| 19:23.07 | supernovia | DST is really weird or I am? |
| 19:23.12 | beandog | DST |
| 19:23.19 | SunSparc | Well... |
| 19:23.23 | SunSparc | ;) |
| 19:24.11 | SunSparc | supernovia: You are in good company |
| 19:24.45 | supernovia | thanks ;-) |
| 19:31.07 | macnewbold | ~lart mindjuju, now that he's not looking, |
| 19:31.07 | jbot | crushes mindjuju, now that he's not looking, with a full height scsi disk |
| 19:33.10 | supernovia | hehe |
| 19:40.00 | *** join/#uphpu cycokilr (n=cycokilr@216.112.116.6.ptr.us.xo.net) |
| 19:40.15 | Dezertol | obama? |
| 19:44.53 | dataw0lf | it's a Army of Darkness quote. |
| 19:45.34 | supernovia | the Hail to the King thing? |
| 19:46.10 | dataw0lf | yes. |
| 19:46.12 | Dezertol | ah.. |
| 19:46.13 | Dezertol | ok |
| 19:47.25 | SunSparc | Classic movie. |
| 19:47.39 | dataw0lf | Don't touch that please, your primitive intellect wouldn't understand alloys and compositions and things with... molecular structures. |
| 19:48.19 | dataw0lf | Good. Bad. I'm the guy with the gun. |
| 19:48.36 | SunSparc | Campbell is quite humorous. |
| 19:48.58 | dataw0lf | Campbell + Raimi == comic genius. |
| 19:49.16 | SunSparc | Agreed |
| 19:49.30 | SunSparc | Even Zena was humorous |
| 19:49.32 | *** part/#uphpu toofer (n=toofer@kjordan.securesites.net) |
| 19:50.12 | dataw0lf | Xena wasn't too bad |
| 19:50.13 | SunSparc | I like that they did the Spiderman movies |
| 19:51.19 | dataw0lf | yup, I was pretty stoked when I found out Raimi had been attached to the Spiderman movies. |
| 19:55.55 | unum | last friday I watched a video with campbell where he said it was nice having people walk up to him and say "your that guy from burn notice"(instead of "your that guy from evil dead" |
| 19:55.59 | unum | ) |
| 19:56.10 | dataw0lf | hahaha |
| 19:56.31 | SunSparc | I bet |
| 20:23.00 | brasto | anyone know how I can determine why MySQL has been running some query for 43.2 hours (though it's fortunately not using any cpu...) |
| 20:23.56 | DexterTheDragon | explain |
| 20:26.10 | brasto | DexterTheDragon: top, sorted by time: |
| 20:26.17 | brasto | <PROTECTED> |
| 20:26.18 | brasto | 46589 mysql 5 20 0 93384K 78524K kserel 0 43.2H 0.00% mysqld |
| 20:26.52 | Dezertol | that just means that the deamon is running |
| 20:26.58 | DexterTheDragon | thats how long the daemon has been running (in simple terms) |
| 20:29.28 | DexterTheDragon | that time is actually the total cpu time the process has used |
| 20:29.33 | fungus | Use "mysqladmin processlist" to get a "top" for MySQL |
| 20:30.46 | fungus | or query "SHOW PROCESSLIST;" |
| 20:30.48 | brasto | i'll run that next fungus. If it reflected how long the mysql server has been running, then is should be about as long as the server's uptime at 53 days. |
| 20:31.01 | DexterTheDragon | nope |
| 20:31.17 | DexterTheDragon | its the total cpu time, not the uptime |
| 20:31.56 | brasto | ah |
| 20:32.58 | brasto | so maybe wtime isn't really an indicator of a problem for any process? |
| 20:33.32 | brasto | it's just an indicator of how often programs are using the cpu? |
| 20:34.15 | fungus | exactly |
| 20:34.35 | fungus | Now if that number matches your uptime, it's a serious problem. :P |
| 20:34.57 | brasto | lol |
| 20:35.04 | brasto | yep |
| 20:35.31 | utahcon | So my blog community that was dumped in my lap seems to have grown legs and want to move to a new domain, server, and developer... yay! |
| 20:35.32 | mgeary | mindjuju: ping |
| 20:35.42 | utahcon | partly sad too |
| 20:35.47 | brasto | I thought it was some MySQL script that had been running for 43 hours, which would have been a problem. |
| 20:36.38 | brasto | I guess I always thought wtime indicated the length of time something had been running without interruption. |
| 20:37.04 | fungus | http://mtop.sourceforge.net/mtop.html |
| 20:39.19 | brasto | found mtop in ports/databases |
| 20:39.49 | mgeary | ~seen mindjuju |
| 20:39.51 | jbot | mindjuju is currently on #utos (1h 31m 51s) #uphpu (1h 31m 51s) #ubuntu-us-ut (1h 31m 51s), last said: 'had a huge headache and wasn't thinking clearly -- but at least point in right direction'. |
| 20:41.29 | brasto | I'm trying to figure out why I can't connect from my Linux laptop to a Sonicwall Sonicpoint 802.3af wireless router. Does anyone know if this router is well supported? |
| 20:41.44 | brasto | I connected last week after several attempts, but this week I'm not even putting an entry in the logs when I attempt to connect. |
| 20:45.08 | *** join/#uphpu SunSparc (n=sparky@173.8.91.177) |
| 20:45.27 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 20:45.49 | mindjuju | man! what kind of world do we live in where a man can't go eat chinese food without getting lart'd! -->macnewbold ! |
| 20:45.52 | mindjuju | sup mgeary |
| 20:53.36 | *** join/#uphpu josephscott (n=josephsc@75-169-255-227.slkc.qwest.net) |
| 20:53.36 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 20:54.04 | unum | if anyone knows someone looking to learn some basic html I'm teaching my class again tomorrow |
| 20:54.32 | unum | I'll be teaching again in april in the evening |
| 20:55.06 | utahcon | unum: where and when? |
| 20:55.11 | unum | last time I managed not to kill anyone with boredom, herlo will vouch for that |
| 20:55.11 | utahcon | So I can pass it along. |
| 20:55.12 | utahcon | Cost? |
| 20:55.14 | unum | I think it was him |
| 20:55.28 | unum | it's at the slcity library main branch at 2pm and it's free |
| 20:59.30 | mindjuju | how to REALLY optimize government into an effective, efficient and abled group - http://www.funnyordie.com/videos/2cf63ca10a/kid-uses-fart-machine-during-city-council-meeting |
| 21:01.09 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 21:01.09 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 21:01.33 | mindjuju | beandog - how to REALLY optimize government into an effective, efficient and abled group - http://www.funnyordie.com/videos/2cf63ca10a/kid-uses-fart-machine-during-city-council-meeting |
| 21:15.22 | dataw0lf | Ruby + OpenOffice backend: https://rightsignature.com/ |
| 21:27.31 | *** join/#uphpu _psychic_ (n=_psychic@173.8.91.177) |
| 21:27.31 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 21:32.42 | mindjuju | anybody here work with Final Cut Pro? |
| 21:33.23 | DexterTheDragon | not recently |
| 21:53.43 | brasto | is there a freebsd command to see when all users last logged onto the system? |
| 21:54.48 | thebigdog | last |
| 21:55.23 | brasto | tried that thebigdog, but it's not showing the last login for all users. |
| 21:56.00 | dataw0lf | wtmp probably got wiped out in the interim |
| 21:56.14 | dataw0lf | there's no alternative after that if you haven't set it up yourself |
| 21:56.19 | brasto | ah, that makes some sense. |
| 21:56.39 | brasto | yea, there's only a couple weeks worth of entries in last |
| 21:58.00 | brasto | I used to like freebsd more but now that I've gotten more used to Linux with all config data in /etc and all logs in /var/log, I'm getting annoyed with freebsd. |
| 21:58.04 | brasto | where's the sudo logs? |
| 21:58.12 | thebigdog | finger `sort /etc/passwd | cut -f1 -d":"` | grep -i log | more |
| 21:58.26 | thebigdog | try that brasto |
| 21:59.14 | thebigdog | there is also lastb too which might given you some info for bad login attempts too |
| 21:59.53 | thebigdog | and brasto there is also lastlog - lastlog | more |
| 22:00.03 | brasto | i also used lastlog |
| 22:00.21 | brasto | lastb must not be installed |
| 22:01.05 | brasto | I like that finger command thebigdog |
| 22:01.13 | thebigdog | ty |
| 22:01.31 | thebigdog | yeah lastb might not be there |
| 22:01.40 | thebigdog | finger may or may not be installed either |
| 22:02.18 | thebigdog | sudo logs usually go to the main syslog entry |
| 22:02.37 | thebigdog | cant remember which one that is on freebsd though |
| 22:04.37 | brasto | thebigdog: would that be determined by an entry in /etc/syslog.conf? |
| 22:04.58 | thebigdog | it might |
| 22:05.12 | *** join/#uphpu carmony_ (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 22:05.12 | thebigdog | sometimes they are logged under security...but i cant tell you for sure with freebsd |
| 22:05.22 | brasto | there are no instances of the word 'sudo' in /etc/syslog.conf |
| 22:05.39 | thebigdog | it would be under the sudo configuration |
| 22:08.03 | brasto | I don't see a directive for it in /usr/local/etc/sudoers |
| 22:10.28 | thebigdog | brasto, man sudoers |
| 22:10.40 | brasto | that's what i'm looking at now |
| 22:10.41 | thebigdog | there are logging values that can be set there |
| 22:10.53 | fungus | brasto: sudo uses the "auth" facility for syslog |
| 22:11.30 | fungus | see /var/log/auth.log |
| 22:13.34 | fungus | brasto: re: FreeBSD's separation of base and ports. |
| 22:13.51 | fungus | The purpose is to keep the base system separate from any other crap you install on it. |
| 22:14.07 | fungus | all ports live in /usr/local |
| 22:14.25 | fungus | This makes updating the system simpler. |
| 22:14.25 | brasto | that makes some sense |
| 22:14.35 | josephscott | http://www.youtube.com/watch?v=I9TtDecveCE&eurl=http://blog.screentoaster.com |
| 22:14.38 | brasto | I'll have to remember that one. |
| 22:15.09 | fungus | Linux requires the use of very smart package managers to handle it. The FreeBSD way means the updating can be much dumber. |
| 22:15.48 | fungus | Both methods have drawbacks and benefits. |
| 22:18.06 | SunSparc | Wow, that was pretty impressive. |
| 22:20.10 | brasto | thank you for the Freebsd info, fungus! |
| 22:20.22 | brasto | good link josephscott |
| 22:20.44 | brasto | someone had a lot of time on their hands to make all those transparencies. |
| 22:20.59 | josephscott | don't want to know how long it took to put that together, but still darn cool |
| 22:21.22 | brasto | leaving for the day |
| 22:21.25 | brasto | bye y'all |
| 22:21.33 | *** part/#uphpu brasto (n=brasto@206.81.135.61) |
| 22:22.30 | fungus | The internet is a daily reminder that humans have a natural tendency to waste time with unproductive activities. |
| 22:23.10 | *** join/#uphpu brasto (n=brasto@206.81.135.61) |
| 22:23.10 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 22:24.00 | brasto | thebigdog and fungus: sudo logs the commands each user sends in /var/log messages |
| 22:24.30 | brasto | now, I'm going for real... had to check back in to say that before I forgot. |
| 22:24.40 | thebigdog | k |
| 22:37.21 | *** join/#uphpu cro (n=cro@nmd.sbx10760.clintut.wayport.net) |
| 23:08.52 | SunSparc | Night all. |
| 23:43.43 | *** join/#uphpu utahcon1 (n=utahcon@71-32-199-79.slkc.qwest.net) |