Matthew's Weblog

OK, so I’ve been fighting comment spam here for the last 2 days… 7981 comments deleted and a number of options tried – but hey, I found that three people actually submitted real comments and I didn’t know it! Worse, it’s frustrating my wife (3800 spams on hers). I didn’t want to use a captcha because I find them annoying. However, I will resort to that if necessary and these next steps don’t work. So now it’s time for the heavy artillery.

Enter Bad Behaviour (plus the addon add-on log reader). I’m hoping this will resolve it, but if you have any trouble, let me know. If you don’t know how to get me, guess! Odds are you’re smart enough to figure out my email.

Even if this works, then I have to figure out the trackback issue. Pesky Vikings…

# Copy the base files
/usr/share# cp -R wordpress/ wordpress2/
/etc# cp -R wordpress/ wordpress2/

# edit /etc/apache2/sites-available/default to include the second site setup
Alias /blog2 /usr/share/wordpress2
<directory /usr/share/wordpress2&rt;
Options FollowSymLinks
AllowOverride Limit Options FileInfo
DirectoryIndex index.php
</directory&rt;

# Re-link the configs found in /etc/wordpress2
cd /usr/share/wordpress2
rm wp-config.php
ln -s /etc/wordpress2/wp-config.php
rm wp-layout.css
ln -s /etc/wordpress2/wp-layout.css
rm index.php
ln -s /etc/wordpress2/index.php
rm print.css
ln -s /etc/wordpress2/print.css

# set the permissions for /etc/wordpress2/wp-config.php
chgrp www-data wp-config.php

# Edit the configs for the new install in /etc/wordpress2/wp-config.php to appropriate values
# 1) table prefix
# 2) ABSPATH

# Copy tables for permissions and such?
# See my later post!

Rock on!

#debconf php4-mysql

All better!