GCW moves to a new box

If you’re reading this, then NfGCW has successfully returned to the web after being moved (along with all the other sites) from my trusty ol’ G5 PowerMac to a brand new MacMini. Overall, the Mini is awesome; with the exception of 3D gaming (which I never do on my server box) it’s faster than the … Continue reading “GCW moves to a new box”

If you’re reading this, then NfGCW has successfully returned to the web after being moved (along with all the other sites) from my trusty ol’ G5 PowerMac to a brand new MacMini. Overall, the Mini is awesome; with the exception of 3D gaming (which I never do on my server box) it’s faster than the G5 at everything I’ve thrown at it. I suspect that’s being helped by the increased RAM in the Mini — 4Gig, up from 1.5 in the G5.

I’m also running Snow Leopard now, which meant that once again I had to go through the dance of getting the AMP (Apache/MySQL/PHP) configured properly. Highlights for 10.6 include:

  • I installed the latest x86_64 version of MySQL. For my traffic level, I doubt that will make a significant performance difference, but you never know.
  • The PHP that comes with SL is actually current and includes the PDO drivers for MySQL. That’s great because it’s one less thing to install/configure versus previous upgrades, but there is still some work to do:
    • edit /etc/apache2/httpd.conf to uncomment the LoadModule for php5_module
    • copy the /etc/php.ini.default file to /etc/php.ini, then edit php.ini and modify (at least) the lines that contain “default_socket” to point at /tmp/mysql.sock, and lines that contain “default_port” to 3306.
  • At this point, php and mysql both worked (as evinced by the fact that phpmyadmin would run, and tell me useful stuff), but the blogs were still failing. It turns out that everyone (i.e. php and mysql), were now finally agreeing that I needed to use the “new” password format, so with a touch of…

    SET PASSWORD FOR 'wpuser'@'%' =
    PASSWORD('not really my password');

    …we were good to go.

Of course, I still have all the other sites to work through. Sheep’s Ahoy is fine. Both the wiki(s) and the gallery seem to be working, but the genealogy site is completely busted. Unfortunately, that’s going to take more effort to get going again, since it has several dependencies on php4. I may have to rethink that one; one possibility is just to suck the content out of it, and then switch to a Mac based genealogy program that can publish to the web. The good news is that the G5 box is still around, so that can wait until I have some free time.

Anyway, let me know if you see anything weird happening.

What do you mean mysql can’t find my wp database?

Well, that was more excitement than I was expecting. Tonight, Deb wandered into my downstairs office and said, “Are you playing with the server? I can’t get to my blog”. I naturally assumed it was the normal problem of my dynamic dns address changing and the associated delay before mikew.ca catches up. So I tried … Continue reading “What do you mean mysql can’t find my wp database?”

Well, that was more excitement than I was expecting.

Tonight, Deb wandered into my downstairs office and said, “Are you playing with the server? I can’t get to my blog”. I naturally assumed it was the normal problem of my dynamic dns address changing and the associated delay before mikew.ca catches up. So I tried connecting to my blog and what did I see: “WordPress can’t find your database”. What!!! That would be bad; very very bad.

Well, after about an hour of messing around, I realized it wasn’t quite that bad. MySQL and all my data really were still there, but it turns out they had been masked by some misguided hacking I had been doing with MacPorts.

Whew!

Well, in honour of the near miss, I promptly did a full backup of my entire website (as apposed to the incremental nightlies) and the mysql database, and then upgraded to WordPress 2.5.

So far, everything looks good. The upgrade went painlessly, as it has for me since I started using WP. Man, I wish all software was that easy to deal with.

Minor site news (v2)

iPhone friendly theme I have added a plug-in that reformats the site to make it more readable on an iPhone. Unfortunately, it throws out most of the sidebar content, which reduces the usability to some extent. Anyway, Give it a try (if you have an iPhone or iPod Touch) and let me know what you … Continue reading “Minor site news (v2)”

iPhone friendly theme
I have added a plug-in that reformats the site to make it more readable on an iPhone. Unfortunately, it throws out most of the sidebar content, which reduces the usability to some extent. Anyway, Give it a try (if you have an iPhone or iPod Touch) and let me know what you think.

Minor site news

WordPress version upgrade I have upgraded the site to run on the latest WordPress. One of the features this version provides is tagging, and I have dutifully added a tag cloud widget to the side bar. I doubt I’ll go back and tag all the old articles, but you never know. Another nice feature is … Continue reading “Minor site news”

WordPress version upgrade
I have upgraded the site to run on the latest WordPress. One of the features this version provides is tagging, and I have dutifully added a tag cloud widget to the side bar. I doubt I’ll go back and tag all the old articles, but you never know. Another nice feature is the automatic version checking for plug-ins. There were newer versions of several of the plug-ins I use.
Treo shots have returned
I finally got around to picking up the latest version of the Photo Sidebar Widget, and hacking it to display VOX images. So now I can go back to taking pictures with my Treo. Yay!