I was all ready to drive out to the gucci Lowe’s in Columbia last night to write a big fat check for nine replacement windows. I had my clipboard, I had my measuring tape, I had my wife with me and we were going to make a side trip to try out the Parsa Kabob near the store. MMMM, yummy lamb kabobs. It was at the front door, ready to leave, that I remembered something: I wanted to see if there were any coupons or discounts I might find online that could save us a few bucks.
When we first moved into the Estate here, I got a packet in the mail from Lowe’s for 10% off purchases of $5,000 or more as a “welcome to the neighborhood” sort of thing. They obviously check county records each week to see who’s recently purchased land and then send out a blanket mailing. After moving in, I let the coupon lapse because there wasn’t anything I needed to buy that would make a 10% discount worthwhile—the house needed elbow grease more than it needed raw materials.
After a quick search online I found the moving section of their website and plugged in my spamcatcher email address; the page says 3-7 days to fulfill via postal mail or email, which is plenty of time for me to continue insulating, running wire, and cleaning the space. 10% off a thousand bucks’ worth of windows is nothing to sneeze at, in my book.
Update: Yeah, bitches!
It’s been quiet around here lately. I don’t have anything really exciting to tell you about, so I’ll show some pictures.
This is a thrilling picture of our side lawn. Notice the patch of slightly darker grass near the garden planter? That’s where our ghetto sidewalk used to be. Jen gave me the all-clear to knock it apart and pull the concrete up a few weeks ago, and we were just now able to find some sod to drop in its place. Who knew sod was hard to find? Apparently it gets delivered right before the weekend and sells out almost immediately. We bought a bunch on a cold Thursday night, and I put it in on a rainy Sunday morning, just in time for a week of cold rain to help it grow.
This is a picture of the new wiring in the shared bathroom wall. I spent a good portion of Sunday running up and down the basement stairs, elbow-deep in insulation, trying to fish wire through small holes in the floor. After a half-hour of false starts, I realized that Ma Bell had already blazed a clear trail for me, and replaced two thick Eisenhower-era cable runs with new copper. I was actually able to get two cable and two data lines run before I ran out, which means there’s 800+ feet of ethernet wire fished throughout this house.
Looking at the picture above, you’d think I would have used the handcart Dave left for me in the Big Red Truck to move the sink and radiator out of the bathroom and into the garage. That would have been the smart thing to do. I’m not so smart, so there they sit. Thanks anyway, Dave!
Behind all that heavy porcelain is the exam room, which is now finally devoid of blown fiberglas insulation, a task I was avoiding until I realized it was eventually going to get hot again, and if there’s anything worse than bagging up loose fiberglas insulation, it’s bagging insulation in 90° heat. (I’ve done it, and don’t care to ever do it again.)
I then installed a bunch of insulation in the east wall after the cable went in. Finally, I disassembled one of the beautiful jalousie windows on the front of the house to see how difficult their removal will be; after ten minutes with a flathead screwdriver, I had one ready to push out onto the front lawn. In the next few days, I’m going to order six new windows for the front of the house and get things ready for installation.
From the New York Times: Doctors Say ‘I’m Sorry’ Before ‘See You in Court’. Apparently admitting a mistake actually decreases the chance a malpractice suit will be filed. Go figure.
Onsite again, attempting to migrate a MySQL database to a new version of OS X Server. I’ve got the machine live on the internets, but now I have to move the database, get a Perl script to talk with it, upgrade passwords, and get a table of users to be able to log in.
Update: MySQL is installed differently on OS X Server, from what I can tell, and so does not work the same way as with plain old OS X.
Laptop travel security Apparently, some brainless judge decided it was OK to allow broad, warrantless searches of laptops upon entering and exiting the U.S. Here are some tips for safer, private travel.
I’ve lately been scouring back issues of Consumer Reports, reading on different cars, determined to find the one that will provide the best balance of mileage, protection, space, and value. Reliability is key, because if we actually do buy a car, it’s going to need to last the three of us a good long time. I started with the Honda Fit, thinking small and nimble meant gas-frugal. When my neighbor found out what I was looking at, he told me to consider an Accord, which he claimed had comparable gas mileage and offered more protection. Consumer Reports put that myth to bed, but I then looked at a Civic, which isn’t that much more expensive than a Fit but offers plenty of room and similar efficiency.
For comparable cars, I’m adding in the Scion Xd due to the mileage and reliability ratings, as well as the Nissan Versa and the Toyota Matrix. Even though Jen’s 10-year-old Saturn coupe gets 40mpg, modern Saturns are out due to reliability issues and lousy gas mileage, and I’m ruling out any other American brands for the same reason. Subarus are out due to thirsty AWD, as is the Mazda3. I refuse to buy a Hyundai, Kia or Suzuki because I already own enough plastic toys.
Note: I also looked at hybrids but I’m not impressed with the available space: if I need to cart baby, luggage, and X-mas presents around, interior room will already be at a premium. I also looked at VW’s TDI offerings, but their cumulative reliability ratings leave me shivering with fear.
To level the playing field, I’m trying to stick with the same basic setup in each car. As much as I hate the idea of a 4-cylinder for durability, it’s the best mileage option. A stick shift is a no-brainer; we both prefer them, they’re cheaper, and they get better mileage. Crash ratings are important to us, obviously, but I understand I can’t own an Excursion and expect to afford the gas, so I’m going with the offense-is-the-best-defense strategy. Each of these cars have standard front and side curtain airbags and ABS brakes.
| Honda Fit Sport | Honda Civic | Honda Accord | Nissan Versa SL | Scion Xd | Toyota Matrix | |
| Price | $15,765 | $18,260 | $23,515 | $14,452 | $13,822 | $14,973 |
| Engine (4cyl) | 1.5L 109hp | 1.8L 113hp | 2.4L 177hp | 1.8L 122hp | 1.8L 128hp | 1.8L 132hp |
| Transmission | 5-spd man. | 6-spd man. | 5-spd man. | |||
| MPG (avg) | 34 | 31 | 24 | 29 | 29 | 27 |
| City/Highway | 33/38 | 22/40 | 22/31 | n/a | n/a | n/a |
| IIHS offset | Good | Good | Good | Good | Acceptable | N/A |
(All statistics courtesy of Consumer Reports)
So what’s the deal with the Civic getting 22 city and 40 highway? That seems like an awful big spread to me. If I lived in a more rural area, I’d say Civic all the way, but I’m in one of the more congested corridors of the East Coast. I’ll take 33mpg in the city, thank you. I like the idea of a hatchback, and I intend on putting a good-quality roof rack on whatever we buy, as well as a hitch (if I can).
We also have two glowing reviews from Fit owners vs. one from a former Accord owner. My ex used to have a Civic, and I enjoyed that car well enough to consider one of my own. Much of the final decision will involve a test drive.
To be continued…
XBMC Turns Your Mac into the Ultimate Media Center. Hm, this looks really interesting…
It was great to go up and visit with your Pop-Pop in the hospital this past week, but it’s good to be back home with you and your mother. She surprised me by re-arranging our entire bedroom while I was gone (do you remember all that bumping and clanging?) so it was like coming back home to a comfortable alternate-universe house where the cats don’t have funny goatees that mean they’re evil. That was a great surprise. Your mother also dragged a room-size carpet down from the attic into the yellow room, which brightens the whole thing right up. You seemed pretty happy to have me back, because you were kicking up a storm last night!
Your Grandpa, circa 1968
Pop-Pop is doing much better now that he has a tracheotomy tube instead of being fully intubated, and he’s looking and feeling like himself again. Except for the fact that they shaved his face, which is weird. See, grandpa has had a beard since 1981, when we took a summer vacation and he ‘forgot’ his razor, and his chin has been missing somewhere in the pine forests of New Jersey ever since. For a few days, he closely resembled his brother Rich, who has a moustache and a Californian devil-may-care attitude, but then they shaved that off on Saturday, and the fact that he has no lips make him the spitting image of his brother Neil, the thought of which keeps your Grandmother awake at night. I sat up with him for two nights in the hospital, helping him get through the initial struggle to clear his lungs, and once he got through the first night things got much easier for him. Grandma’s report from this morning says he’s going to start physical therapy soon, which means he’s well on his way. He liked your latest pictures too. I just hope you’re born with lips.
Because we’re expecting soon, I’m looking at inexpensive camcorders—not for the delivery room, but for the wonderful days afterwards. The Panasonic PV-GS320 is MiniDV-based, has 3CCDs, a Leica F/1.8 lens with 10x optical zoom, 1/25-1/8000 shutter speeds, and optical image stabilization. All that for under $400.
I’m on bedside watch this evening with my pops, who is dealing with fluid drain and a tracheotomy tube, so I decided to find something light to occupy my downtime: Installing MySQL and PHP on my laptop and setting up a development environment. Because what could be more easy and fun than wading through pages and pages of forums to try to install and talk to an open-source database?
Disclaimer: I’m not a grey-haired wizard, so these instructions are what worked for me, but not the One True Way. I’m including them here to maybe help someone else save some time. I’m running 10.4.11 on an Intel MacBook Pro, and I’ve never installed or started MySQL, Apache, or PHP on it. So here goes.
First, I checked to see if MySQL was installed on my machine with this terminal command (which should return a tidy list of applications):
ps -axc
If it’s installed and running, there should be something in the list called “mysqld”. It wasn’t there for me. I also searched for any files called MySQL, and didn’t find anything that looked like it was a running module. So I downloaded an Intel installer package from the MySQL site, ran the installer, and installed the Preference Pane.
After wondering stupidly for a few minutes why I couldn’t get anything to come up at http://localhost/ in Safari, I remembered to turn on Personal Web Sharing in the Preferences, which starts Apache. This is why they call me the Idiot.
Next, I looked to see if PHP was running on this machine by writing the following file and saving it as php_test.php inside /Library/WebServer/Documents:
<html>
<p>This is an html line</p>
<?php
echo “this is a php line”;
phpinfo();
?>
</html></span>
Opening up Safari, I pointed to it here: http://localhost/php_test.php
Safari dutifully printed the code without parsing the PHP, so I knew it wasn’t working. I do know that PHP is preinstalled on OS X but not configured to run out of the box, so I did some looking.
Following directions here, I opened the http.conf file in Pico (I’m a dork, yes)
sudo pico /etc/httpd/httpd.conf
and uncommented (remove the #) the following lines:
# LoadModule php4_module libexec/httpd/libphp4.so
# AddModule mod_php4.c
I went back to the Preferences, turned off Personal Web Sharing, and turned it back on (thereby restarting Apache without having to resort to 5 minutes of Google searching and arcane Terminal commands). If all was done correctly, Apache should now be loaded with the PHP modules on.
Reloading the php_test.php file in Safari, I got a happy PHP config page (you’ll know it when you see it).
OK, so next I have to see if I can talk to MySQL with PHP. I’m coming clean here and admitting I’m using a copy of PHP & MySQL for Dummies, which doesn’t really get into the issue of passwords and root users until Chapter 5, and then it sort of glosses over things. A simple fact it took a while to find is that MySQL starts up with a superuser of “root” and a blank password. (I think I already knew this, but then forgot it). Anyway, I used a script found here, and changed the following lines from
$host=”hostname”;
$user=”mysqlaccount”;
$password=”mysqlpassword”;
to
$host=”localhost”;
$user=”root”;
$password=””;
All this page will do is talk to MySQL and return a list of variables, thereby confirming that it’s running and available to connect.
When I loaded the page in Safari, I got the dreaded “Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock'” error. As much as the Idiot here can figure out, this is some issue with the OS X install of MySQL and the pathways it uses.
Looking around the web, I found this page in Apple’s forums which seems to fix the issue. In a nutshell, I followed the instructions at the bottom of the page to create a symbolic link to the lock file, like so:
cd /var
ls
If there’s no directory in there named “mysql”, then do this:
sudo mkdir mysql
cd mysql
sudo ln -s /private/tmp/mysql.sock mysql.sock
Then, I reloaded the mysql_up.php file I’d made earlier, and I got the result I was looking for: A table with a bunch of numbers that made no sense (variables). but the important thing was that there were no errors, which meant that PHP was talking to MySQL.
Now, I just need to learn how to program so I can use this shit.