Category: Uncategorized

  • My Never-Ending Basement Plumbing Project

    I’ve got this plumbing project in my basement, that I’ve been working at for what seems like about a year now.

    It started with my wife finding a leaky pipe. The leak was (is) at a copper tee, where a 3/4″ line branches out to 2 1/2″ lines. It was (is) leaking at a rate of a drop every 5 minutes or so. I put a bucket under it. This was last spring or so. The bucket is still there.

    One of the 1/2″ branches goes to an outside sillcock. The original sillcock was unoperational (frozen up, clogged, whatever). So I decided, well, I need to take this all apart anyhow, so I might as well replace the sillcock. So I cut the branch, capped it near the tee, and took out the sillcock and all the old plumbing going to it. Then I routed new copper pipe back to the tee. That was last summer. Over the next couple months, I sweated most of the fittings along the new line. I’m not what you would call an expert at sweating copper, particularly where it comes to valves. Now, I’m at the point where I need to test my new branch for leaks, replace the tee, and connect everything back up. I’m not looking forward to it, so I’m putting it off.

    I’m thinking about pressure testing the new branch to find leaks. Here’s the current plan.

    1. Take a short length of pipe, and sweat a female adapter onto one end
    2. Screw a quick-connect air coupling into the adapter
    3. Attach the other end to my branch using a compression coupling
    4. Attach air compressor, close all valves, crank up to 30PSI or so
    5. Leave it that way for awhile and see if it holds the pressure.

    I figure if I use a compression fitting, that will allow me to reuse this contraption on other projects.

    Once I’m satisfied the branch is leak-free, I can hook it up to the live plumbing, which is what I’m really not looking forward to. For some reason, I find plumbing projects like this infinitely more daunting than electrical projects. See, with an electrical project, if I hit a snag I can usually get away with leaving a branch circuit off for a day or two. Just plug stuff into different outlets, run some extension cords, whatever. This is not the case with plumbing. There is absolutely no way I’m getting away with leaving the water shut off for a day or two. If I screw up, I’m really screwed, so to speak. No, the job needs to get done right, the first time. And anyone who’s ever done plumbing knows that there are always “gotchas” lurking around the corner, waiting to spring on you after you’ve shut off the main and cut all the pipes apart. Then, when you get everything back together, you have to hope that you got everything right and nothing leaks. To me, plumbing has always seemed like more of a crap-shoot than electrical work. This is improving somewhat as I get more experience, but I’m still dreadding this project.

    More (maybe a couple years) later when I get back to this project..

  • Wiring’s done!

    Subject says it all! I finished the wiring up today, installed the fan control, and replaced an outlet while I was at it. All my extra wiring turned out to be worth the effort — there’s absolutely no way I would have gotten the fan control in the wall box with all the extra wires there. It’s enough of a challenge just getting these controls in the box with only one wire. Which brings me to my obligatory gripe of the day. These fan controls (Lutron Skylark model) are great. They seem well-made and reliable. But I hate installing them. They’re so deep that they barely fit in a standard-depth wall box. And on top of that, they have pigtails, and you have to fit three wirenuts (four if you’re attaching the ground) in the box, in addition to the control. This makes them very bad for retrofit work, particularly in older houses where the boxes tend to be smaller. If there’s more than one cable going into your wall box, you can pretty much forget it. It’d be much nicer if these controls could be backwired (stick wire in hole, tighten screw), to eliminate the need for wirenut splices. Maybe Lutron will eventually figure this out. Unfortunately it’ll be too late to help me out.

    Anyhow, the only thing left now is to remount the fan and clean up all the plaster chunks, insulation and other crap that fell out of the hole in the ceiling. I’d say we can pretty much stick a fork in this project.

  • Quality time in the attic

    I spent the afternoon in the attic today, and got the lion’s share of the wiring done for the fan project. Last week I fished the wire from the basement to the attic. It was pretty straightforward. Some medium-duty nylon rope was the ticket. I dropped it down into the stud cavity from the attic, went into the basement, poked up a hooked piece of stiff wire, snagged the rope, and pulled it through. Then I used the rope to pull the romex up from the basement into the attic. The two keys to doing this successfully are:

    1. Electrical tape; and
    2. A helper.

    Just tape the romex to the end of the rope with plenty of electrical tape, go up to the attic, and have your helper feed the cable up from the basement while you pull it up. This can be done by yourself, but you’ll get lots of exercise running upstairs and downstairs to unkink the romex.

    The first job today was to get the old box and brace out of the ceiling to make room for the new fan-approved brace and box. Every time I do this, I’m reminded of how much I hate those metal ceiling box braces that nail to the underside of the joists. There’s no way to get them all the way out without tearing up the ceiling. Plus, the weight of the fixture tends to pull the nails loose over time, which is not good news for the ceiling, or for the person standing under the fixture when it eventually comes crashing down.

    The trick to getting these out is to cut them, removing the center part and leaving the ends nailed to the joists. I’ve found that the best tool for this is a Dremel rotary tool with a cutoff wheel. I’ve used a hacksaw, and it’s laborious (the bars are actually pretty thick metal) and the sawing action can damage the ceiling (and your knuckles). The Dremel is not perfect (if you breathe wrong on the cutoff wheels, they break), but believe me, it is far superior to sawing.

    This bar came out easier than others I’ve done. Once I cut one side, the other side just swung out of the way (because, of course, the nails had pulled loose).

    The actual wiring was complicated but straightforward. There were a lot of wires in the old box (it fed two different downstream branches). Rather than put everything back into the fixture box, I mounted a second junction box, wired everything up to that, and ran a single 12/3 cable to the fixture box carrying two switched hots (lights and fan) and neutral. This makes for a neater job and lets me use a larger box for all of my splices.

    Just a couple parting tips for doing this kind of work:

    1. Invest in a pair of knee pads (or “kneelers”). Your knees will thank you for it.
    2. If your house has lots of BX wiring like mine, invest $25 or so for a good quality rotary BX cutter. It’s absolutely worth its weight in gold, which you’ll appreciate if you’ve ever tried to cut BX with a hacksaw.

    Almost done now, just need to wire up the fan control, route the wire in the basement, and remount the fan.

  • Drilled my holes

    I got kinda lazy yesterday, and didn’t get too much done on the bedroom fan wiring project. But, I did get one step closer to running a new wire from the basement to the attic. I got holes drilled in the top and bottom plates, and verified that both holes hit the same stud cavity. Fishing the wire should be pretty easy at this point.

    Rules of thumb for anyone who wants to attempt this…

    1. Ensure that you own a ranch house. 🙂
    2. Tools of the trade: tape measure, stud finder, drill, 1/8″ x 12″ feeler bit, 5/8″ spade bit, flashlight.
    3. Find reference points in the basement and attic so that you can (somewhat accurately) pinpoint where to drill. Examples are: pipe penetrations, wire penetrations, ducts, etc.
    4. Locate the wall studs, and pick your drilling spots so that you don’t hit the top (or bottom) of a vertical wall stud.
    5. Measure, measure, measure! Can’t stress this enough.
    6. Drill a pilot hole first to make sure you hit an open stud cavity. I use a 1/8″ x 12″ bit for this. After drilling, leave the bit in the hole. Then go upstairs/downstairs and make sure the bit is not sticking through the ceiling/floor!
    7. Assuming everything looks good, use a 5/8″ spade bit to enlarge the hole. When drilling downwards from the attic, make sure the bit is TIGHT in the chuck.
    8. Once you have drilled both holes, put a flashlight over the hole in the attic. Adjust the light for a focused (not diffuse) beam. Go down to the basement. Turn the lights off, look up into the hole, and make sure you can see the beam.

    Next: Let’s fish some wire..

  • Wiring fun

    So, I’m doing a bit of rewiring in our spare bedroom, soon to become my 3-year-old’s new room. The previous owners put up a ceiling fan. Problem is, they didn’t bother to install an approved box. It’s one of those lovely nail-to-the-underside-of-the-studs metal bar jobbies. Rather than sit around twiddling my thumbs until the fan comes crashing down, I’m putting a new box in with a proper brace. Along the way, I’m replacing the wall switch, a fan/light control that has (putting it nicely) seen better days.

    Well, nothing is ever that easy. The new fan control is slightly deeper than the old one. The power feeds through the wall box. There are 3 cables coming into the box: A 14-2 BX feed, a 14-3 BX carrying switched, unswitched and neutral to the ceiling box, and a 14-2 romex that someone added at a later date, to carry switched power to the fan (separate from the lights). So, we’ve got 3 cables and a grand total of 5 wirenuts (3 for the switch, 1 for neutral, and 1 to cap off the unused wire in the romex cable). Short story: I can’t fit everything in the box with the deeper switch.

    I want to use this switch. I’ve got 2 other identical ones elsewhere in the house. So, looks like I need to do some rewiring.

    I suppose I could replace the box. Nothing I haven’t done before. But, these boxes are holy hell to get out of the wall, without destroying the wall (plaster over gypsum board, or “rock lath” as it was called back in the day). No, I think I’ll rewire things and take the wall box out of the circuit, and make it a simple switch loop. Then I can cut it down to a single 14/3 cable going to the box, with a hot and two switched lines, 1 for the fan and 1 for the lights. Then it’ll fit.

    So, I’ll just find a wire in the attic that’s ahead of the switch box in the circuit, cut it, and route it directly to the ceiling box, right? Sure, in theory. Problem is, there are no wires in the attic that are ahead of the switch box. The switch box IS the feed from the basement to the attic. Time for plan B. Looks like I’ll need to run a new wire from the basement to the attic. This will require me to break out my wire fishing skills. Now, having wired my own security system, I’ve done my share of fishing. However I’ve never run a wire straight from the basement, through a stud cavity, and into the attic (this is a rancher, BTW. Unfinished attic on top, drop-ceiling basement on bottom. If you’re into wiring, ranchers rock). Seems like it should be easy in theory. I guess I’ll find out. This should be fun! More later.

  • Oracle Calendar API Revisited

    Well.. I’ve managed to track down the Oracle Calendar SDK libraries for Linux. They’re included with the Oracle Collaboration Suite distribution, which I had originally thought only included libraries for the Mac. I did a little more digging and found this post on Oracle’s Calendar SDK message board. It turns out I need to run the installer and let it do an “official” install of the stuff. A bit convoluted given that all I need is a couple libraries and include files, but if it works…

    Here’s what I did:

    1. Downloaded the Oracle Collaboration Suite distribution (version 10g) from Oracle’s web site. It came as a 3.8-gig multipart compressed tar archive (thank God for Internet2)! After running the script to assemble the parts, I ended up with a file called OCS_101200.tar.gz.
    2. I’m not interested in everything in the tar file, just the calendar stuff. This is all in a directory called calendar_standalone. So, I untarred just that directory: tar xzvf OCS_101200.tar.gz calendar_standalone.
    3. I ran the installation script, runInstaller -ignoreSysPrereqs. The option tells the installer to keep running even though I’m not running one of Oracle’s pre-approved flavors of Linux.
    4. Walk through the menus, select the SDK, and follow the directions.

    After doing this, I ended up with the SDK (along with 300 megs of other kruft) installed in my home directory under a directory called product.

    Haven’t played around with it yet, but hopefully I can write something to do a simple event extract. If that works, I can write an automated script that extracts the data, massages it, and posts it as an iCal subscription. Stick it in cron to run nightly, and I’ve got my ultimate solution for Oracle Calendar integration. Wish me luck!

  • Missing Sync

    Well, as promised, I sprung $40 for The Missing Sync for Palm OS. I’ve installed it, set up sync with iCal and Address Book, and tried out the internet connection sharing feature. My initial impressions are good. Setup was painless. The iCal sync seems to work very well. The initial sync resulted in some duplicate calendar entries, but I think that’s because it was also pulling in my data from Palm Desktop. Once I deleted the duplicate data and got rid of the old Palm Desktop conduits, it worked great. As for the internet connection sharing, I doubt I’ll get much use out of it, but it works without a hitch.

    Missing Sync also includes an app that allows you to mount the SD card on the Mac desktop as an external volume. As I don’t yet have an SD card, I haven’t been able to try this out. I’m curious as to how it works. The documentation does not reveal many details. I’m hoping it emulates the USB storage standard, which would let me mount it on my Linux boxes as well. I’d like to be able to use the Palm as sort of a “poor man’s jump drive.” Again, I may not end up using it much, but I can try it out and see if it’s useful to me, or if I’d be better served with a “dedicated” USB jump drive.

    If it turns out that it doesn’t emulate USB storage, I can try out a product called Card Export II which advertises this functionality. It’s only $15 and I can download a fully functional trial version. But I’m hoping Missing Sync will do it for me.

    Next up.. I think I’m going to rework my Oracle Calendar intergration a bit. I’m going to write a Perl script to take the exported Oracle Calendar data (in vCal format), tweak it a bit for all-day events and holidays, and write it out in iCalendar format. Then I can just post the resulting iCalendar file on my web site, and subscribe to it with iCal. That way I don’t have to import it into iCal, which is a cumbersome process. We’ll see how it goes.

  • More on publishing and sharing calendars

    I did some more research on calendar sharing over the long weekend. The first thing I tried was using iCal to publish a calendar to my new WebDAV server. It worked without a hitch. However, all this does is upload the .ics file to the web directory. I can then subscribe to the calendar with another iCalendar-capable client, but there’s no built-in facility to view the calendar with a web browser, as I had originally thought (apparently this is a feature of Apple’s .mac subscription service).

    A little bit more searching turned up a nifty app called PHP iCalendar. This does exactly what I was looking for: install it, point it at a directory with iCalendar files, and it displays everything on my web browser. Installation was as easy as putting mod_php4 on my web server, untarring the distribution, and editing the config file. It works great and the interface is nice. So, with that I now have read-only access to my calendar from anywhere on the net.

    I also wondered if there was a full-featured iCalendar-compatible calendar app out there for Linux. I found the Mozilla Calendar and Sunbird Project. Mozilla Calendar is a plugin for Firefox or Thunderbird, while Sunbird is a standalone app. Both share the same codebase, features and bugs. This is alpha pre-release software, but it’s being actively developed and appears to be the most promising solution. It works with Windows, Mac and Linux, meaning I could hypothetically use it on all three platforms (although on the Mac, I currently need iCal for Palm synchronization). I’ve downloaded this and verified that it seems to work, but I haven’t played with it extensively.

    All this gives rise to the question: Could I keep the “official” version of my calendar on my web server, access it with Sunbird, iCal and/or PHP iCalendar, and have all my changes automatically sync up with the web copy? That is definitely the question, and if it’s doable, I think it’s the optimum solution. If I can track down a working version of the Oracle Calendar SDK for Linux, I could even automate the integration with Oracle Calendar.

    I know I can configure iCal to automatically publish to the web whenever I make a change to it (although I’ve never tried it so I’m not sure how it works in practice). I think Sunbird has a similar capability. Again, it remains to be seen how well this will actually work. I don’t have the Mac with me today, so I’ll play around with Sunbird on my Linux box, and see what it can do.

  • Can’t forget the Palm

    The final piece of the puzzle is the Palm. I need to get the Palm syncing up with iCal. Apple provides an app called iSync which can do this. However, I tried it and was not impressed. iSync is an intriguing application, but it seems mainly geared towards cell phone type devices. Its support for the Palm seems to be kind of an afterthought. It works, but it doesn’t support a lot of the features on the Palm, particularly with the address book

    A more promising looking solution is a commercial product called The Missing Sync. This is a total replacement for Palm Desktop/HotSync that is specifically geared to the Mac. It reportedly integrates very well with iCal and the Mac’s address book. It also includes a lot of nifty extras (internet connection sharing, expansion card mounting, etc).

    Missing Sync costs $40, but based on what I read, it’s worth the price. There are two things about it that I would consider negatives:

    1. No trial/demo version available I’m willing to look beyond this because of the overwhelmingly positive reviews I’ve read about the product. A lot of people, myself included, like try-before-you-buy, particularly with software. They could probably sell more copies of this if they had a demo version. Let people try it, wonder how they got along without it, and they’ll buy it.
    2. Can only be installed on 2 macs Not an issue for me now, as I have only 1 mac, but who knows how many I’ll accumulate over the years? I really hate it when companies cripple their products like this. Still, I’ll live with this despite my philosophical problem with it. If it ever becomes an issue for me, I’ll complain loudly.

    Issues aside, it looks like a high quality product, and unless I change my mind about using iCal, I’ll probably give this a go.