asiel’s scratchpad

After trying to get the mysql gem working on my new macbook in Leopard, I realized that although I can get the gem to compile correctly it still doesn’t work with the mysql 64-bit version. This realization mostly came from searching and finding this useful blog post.

I reinstalled the 32 bit version of mysql and then recompiled the mysql gem. Then magically things started working the way I needed them to. Hopefully this can get fixed in a future version of Ruby.

Here is the command I had to use to finally install the gem properly.


sudo env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config --with-mysql-lib=/usr/local/mysql/lib --with-mysql-dir=/usr/local/mysql --with-mysql-include=/usr/local/mysql/include


Notice the i386 arch. I was previously using x86_64 as the arch which compiled properly and appeared to work until you actually tried to use the gem in ruby and got a stack trace.

I have had a macbook pro for about 2.5 years now since the first intel based macs were introduced. Last week I decided to get a faster machine with more ram and hard drive space. So I went to a macbook. Yes, I have a smaller screen and not quite as good of video. However, I was able to upgrade the RAM to 4GB and HD to 320GB in about 15min and both are working great. I’ve been very happy with the machine so far.

Tonight I decided to try out the Migration Assistant. For some unknown reason I’ve never used it in the past when I’ve upgraded my mac. After using it though, all I can say is wow! Why haven’t I used this tool before? What is so amazing to me in contrast to Windows machines is how well it works and how easy it is to use. Also as far as I can tell so far it appears to have transfered everything just the way I told it to. This includes all my files, custom settings, and even applications. Although it technically should be possible to transfer appliations between Windows machines, in most cases it isn’t even an option. Whenever I have moved from one Windows machine to another I end up having to reinstall all the applications. The only thing that really moves well on Windows is files such as documents and other application data. The applications themselves though don’t like to be moved.

With Migration Assistant, the fact that applications can be moved is huge for me since reinstalling all my applications usually takes at least an entire day if not more. Whats more, its really something that isn’t fun and frankly shouldn’t be necessary to redo every time I move to a new computer.

So far I’m completely sold on Migration Assistant. It has definitely made this the least painful upgrade I’ve ever experienced. I’ll have to see if I’m still as impressed after making sure everything really does work over the next week or two.

For some reason Windows Vista enables IPv6 by default. Why? I wasn’t aware of this so I ended up troubleshooting a non-problem with PHPUnit. I have unit tests that connect to the web server to test a web service. The URL my tests were using was “localhost”. Because vista was resolving localhost to ::1 the tests couldn’t make a socket connection.

All I had to do to fix the problem was disable IPv6 and comment out the localhost ::1 line in my hosts file. This took a significant amount of troubleshooting to figure out though. I thought there was some type of problem with PHPUnit or php itself. Luckily I was finally able to solve the problem.

It seems like a really bad idea for Microsoft to enable IPv6 by default and additionally put it higher in the resolution order than IPv4 addresses. Based on the number of active IPv6 networks this can’t be a good default decision. Supporting IPv6 is a good idea, but it shouldn’t be the default method of resolving addresses. Windows should have knowledge that you are connected to an IPv4 network and disable or lower the priority of IPv6 accordingly.

I decided to take the plunge to try out Vista. Because the system I’m using has 4GB of memory I also decided to use the 64 bit version to take full advantage of the hardware I’m using. Everything has worked pretty well so far. The main problem I’ve ran into is the lack of a Cisco VPN client for the 64 bit version of Windows Vista and the 32 bit version won’t even install. This is unfortunate that a huge company making billions of dollars can’t dedicate resources to let their existing customers use an updated operating system. This is especially true when it is likely the majority of customers who use this type of VPN system have service contracts with them. Just goes to show that commercial software doesn’t really mean better support.

The closest I came to any type of solution was by following the discussion at Bill Evjen’s Blog. Even after tinkering though the best pseudo solution I came up with was running XP inside of a VM. It isn’t really a solution, but it gets me by for the few things I absolutely need the VPN for. Hopefully these types of issues will get resolved over time. Unfortunately, I’m pretty certain this isn’t the last issue I’ll run into with 64 bit Vista.

Last week I was trying to play one of my favorite games Starcraft over Hamachi with some friends. Starcraft is not the newest game, so unlike many newer games it doesn’t give you the option to pick your network interface.

While we were logged into our Hamachi network we were able to ping each other and followed all the troubleshooting instructions given by the Hamachi site. This was despite the fact that starcraft is one of the games that is supposed to “just work” with Hamachi. None of us were able to see games that anyone else created. After tinkering around with this for probably about a half-hour my friend orb360 found a solution. The steps to get Starcraft and probably many other older applications working with Hamachi are below. These instructions are Windows specific. Although the method should probably work on other platforms.

The main tip is to make Hamachi the first network interface that Windows tries to use. On other platformsthe goal would be the same. Only the way you accomplish it would be different.

1. Go into control panel then click on “network connections”

2. Click the “advanced” link in the menu

3. Click “advanced settings”

4. Change the order so it looks something like this

5. Reboot Windows

After taking these steps Hamachi and Starcraft played nice together.

I have been using skype as my sole landline-type telephone service for a couple months now. I have been highly impressed overall. It has been unfortunate to be having problems today. It seems like the worst part about it is that everything except for login/authentication is working properly. From the users perspective though if login doesn’t work nothing works. Hopefully they’ll be able to get this fixed soon since so many people including myself rely on skype every day.

I’m always learning new neat commands on Linux.

Sometimes I’ve been logged into a machine and wondered what distro and/or version of a distro is running.

The command I found that does the trick is

lsb_release -a

This should work on most recent distros such as ubuntu, redhat, or suse.

Today I had one of the top 5 worst customer service experiences I’ve ever had with any company (Vonage). I had a good experience with them up until this experience which makes this even more unfortunate. One of the most customer unfriendly practices of many new businesses is to make signing up for services extremely easy but canceling extremely difficult. Vonage is definitely in this group.

(more…)

My Tip of the day…

I finally found out how to use Svn auto-props today. These are very nice. You can set a given property based on a files extension or filename pattern. This allows for doing things like:

[auto-props]
*.py = svn:keywords=Author Date Id Revision

This means I don’t have to keep adding svn keywords on every file I add. It just gets turned on for all python files I add to svn. These properties are set in the svn config file on the client, so every client can have their own settings. Very handy.

I recently did a presentation on PEAR. This presentation mainly goes over basic PEAR usage and installing PEAR on windows. If you have any suggestions for improvement let me know.