tools

Seriously, the last screwdriver bit set you will ever need. I’ve been looking for one of these for a long time. Besides all your standard philips, hex, Torx, and square head bits (in every imaginable size from tiny to huge) it also includes a whole ton of “security” bits, including those for secure hex, secure Torx, those crazy one-way philips-head screws you see in public bathrooms, and a few others I’ve never even seen before.

With this kit, I can take apart just about any piece of electronic hardware (or public bathroom urinal) I’m likely to encounter. And it was only $16 at Fry’s. Definitely a must-have.

So, I thought I was really bright a few days ago at Fred Meyer, picking up supplies to fix stuff around my apartment. A flapper valve for my running toilet, some gaskets for a dripping faucet, and a can of “Plumb Away” to clear out a slow-running bathroom sink.

Little did I know what I was getting myself into…

Of course I followed the instructions. I filled the sink with water, covered the backup drain with a wet rag, and pushed downwards on the can as if it were a plunger to force my pesky plug out of my plumbing.

And then my world exploded.

I live in an older apartment building. Older as in probably about 60-70 years old. Which means I have about 50-60 years of crud built up in my plumbing. All that crud, with the exception of the crud actually clogging the sink, chose exactly that moment to leave my plumbing. And exit promptly all over my bathroom.

As it seems, the extra large backup drain of my sink also provided an extra large exit for said crud, all of which promptly forced its way out past my carefully placed rag, and all over my bathroom. Covering my sink, my shower, my walls, and even myself. No innocent bystanders were spared.

The results? I was left with:

• A bathroom covered in crap that was older than me
• A sink fully of lemony fresh fizzy water
• A drain that is still completely plugged

And, while wiser for the experience, I’m still $9 poorer, and I still don’t have a completely working sink.

Every time I set up a new system I have to figure out how to do this again, so I decided to post instructions for my benefit and for the benefit of those who might also be having problems with this.

Debian’s “Social Contract” forbids it from distributing “non-free” code as official packages. Thus, Sun’s version of Java is not in any of the official mirrors. You can sometimes find third-party packages from Blackdown and other groups, but they are often out of date and annoying. I prefer to get my Java directly from Sun.

I install my JDKs into /opt and use “dummy packages” to let Debian know that I really do have Java installed. That way I can install Debian packages requiring Java to be installed and everything will go smoothly.

This mini-HowTo assumes that you’re running Debian Unstable (Sid), but it should also work if you’re using Testing or even Ubuntu. It also assumes you’re doing all these steps as root.

Read the rest of this entry »

Apparently I’m a productivity guru now:

“I really need to spend a day sitting down doing the Chris Metcalf lifehacks thing, and organizing all my projects into folders and such…” - A friend of a friend in a forwarded email.

Whenever people take an interest in the nerdy little hacks I post, I’m quite surprised and flattered. So I’ve decided to start posting more Lifehacks. If this kind of stuff interests you, please leave me a comment and let me know how you feel.

So stay tuned for more fun hacks.

Update: By the way, I’m not the only desperate, productivity-challenged geek out there doing this stuff. By no means did I start this, I’m just another hipster with a stack of 3×5 cards. There are lots of other great resources for Lifehacks and Lifehacks-compatible ideas:

• 43folders - Merlin didn’t start it all, but he sure has done a good job of bringing lots of good ideas together. The site is a bit Mac-bigoted, but then again everybody is these days. Also home to a great wiki where a lot of folks have posted great ideas.
• Lifehacker - Way too many ads, but the RSS feed leaves those out. Lifehacker tends to aggregate ideas from a lot of other sites so its a good one to watch for ideas.
• Working Smart - A great productivity blog for managers or wanna-be-managers.
• Slacker Manager - Also with a management focus, but a little more easy-going.
• Flickr - Surprisingly, there are a lot of good tags with some great Lifehacks and GTD-compatible ideas.

Oh, and pick up a copy of David Allen’s Getting Things Done. Right now.

I’ve been bad. Until recently I haven’t been backing up my MySQL database. Bad things could have happened.

Today I finally hacked up a simple script to run from cron that will automatically dump, zip, and mail backups of my MySQL tables to an email address I specify. I set up a Gmail account to send the dumps to because they’re about 8 meg each. The dumps are also encrypted using my PGP 1024-bit public key to give me a bit of security.

Since I didn’t manage to find anything similar in my Googling, I decided to post it.

#!/bin/sh # Performs a backup of MySQL, encrypts it using PGP, and mails it to a particular user # The user to mail the backup to. Should have a public key in the above user's keyring... MAIL_TO="your-backup-account@gmail.com" MAIL_TO_KEY="Your PGP key ID" # Subject of the mail. A date stamp will be appended to it MAIL_SUBJECT="[mysqldump] MySQL Backup for ” ###################################### DATESTAMP=`date %Y-%m-%d` FILENAME=”/tmp/mysqldump-$DATESTAMP.gz” # Generate the dump mysqldump –all-databases | gzip > “$FILENAME” # Encrypt it gpg –encrypt –recipient “$MAIL_TO_KEY” “$FILENAME” # Mail it! mpack -s “$MAIL_SUBJECT $DATESTAMP” -c application/octet-stream $FILENAME.gpg” “$MAIL_TO” # Remove the backups rm -f $FILENAME $FILENAME.gpg