Pull pull pull

street photography by Markus Hartel, New York

VOTE FOR ME!! please...

Just recently my blog got hit with 300 comment spam messages a day and even though
spam lookup filtered them out perfectly, I had to clean this mess up every day. So it got
pretty annoying. A captcha is not an option, so I tested MovableType 3.34 on my local
computer with my customized templates. After a day or two with fiddling in the OS/X
terminal and googling a few installation "issues" I got it running. sweet.

Yeah, so for anybody having trouble installing the necessary DBI/DBD driver on OS/X
here's what you'll have to do if the make process shows an error "ulong not defined":

sudo pico /usr/local/mysql/include/mysql.h
At the top of the file, after the lines
#ifndef _mysql_h
#define _mysql_h

Add the line
#define ulong unsigned long
then run
sudo perl Makefile.PL --testdb=test --testuser=username --testpassword=user_password --testhost=localhost

and then run sudo make

that simple - now if your html files created by MT show up with 0KB, check if your
templates are empty - it was the case in my install. Now MT runs like a charm on my
web server (doteasy) with ZERO spam comments :P

btw... the local install will make a re-design that I had in mind for a long time now much easier

Comments (2)

Nice street work.
and sorry you to go through that much spam.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)