November 08, 2003

With a big assist from Michael Croft, I finally got the Movable Type 2.64 upgrade installed, and as an extra added bonus got migrated from the BerkeleyDB to MySQL. I think I'm going to have fun playing with MySQL, which owes it to me after the (admittedly mostly self-induced) frustration that we had loading and configuring it. Here's a hint for future generations: If you can log into your MySQL database directly but MovableType keeps failing, be really sure that the mt-dbpass.cgi file you keep uploading is really called mt-dbpass.cgi and not something that looks like, but is actually not, mt-dbpass.cgi.

Somewhat amusingly, in our quest to figure out this mystery, we came across this support forum thread in which Michael was helping to troubleshoot someone else's MySQL problem. It pointed us to the MTWiki entry on MySQL, which is a good thing to have in your back pocket even if we didn't get the clue from it.

Anyway. Next up is the long-awaited MT Blacklist plugin for killing comment spams. And on we go.

Posted by Charles Kuffner on November 08, 2003 to Administrivia | TrackBack

I came home, added Mt-blacklist, hacked it with the no duplicate trackbacks and no duplicate comments hacks, added simplecomments (which threads comments and trackbacks, and switched from comments popups to a link to the individual archive. much fun.

Posted by: Michael on November 8, 2003 3:02 PM

MySQL is worlds of fun once you dive in. I think that you'll really like MT Blacklist. I know it's certainly made things a lot easier around writerrific.

Onward and upward

Posted by: UncleBob on November 8, 2003 7:57 PM

Chuck, I'd appreciate it if you'd post more on your efforts with MySQL and MT. Very interesting posts!

Posted by: B. K. Oxley (binkley) on November 9, 2003 8:55 AM

Congrats on the upgrade. I've found MT with MySQL makes for a pretty robust and powerful setup. I recently added the blacklist plugin as a preventative measure. Not that I get many comments on my site to worry; my blog is still "under the radar," so to say. :-)

Posted by: elgato on November 10, 2003 9:48 AM

Binkley, there's not much to report yet. I'm waiting for my next batch of Copious Spare Time (tm) to get under the hood of MySQL. I promise to say more when there's something interesting to be said.

ElGato, wherever you are on the radar, I can guarantee that taking proactive steps to prevent the possibility of having to delete a hundred comment spams is a Good Thing. :-)

Posted by: Charles Kuffner on November 10, 2003 10:42 AM