cornerhost wiki   FAQ/MovableType UserPreferences
 
HelpContents FindPage Diffs Info Edit Subscribe XML Print View

  1. where is perl?
  2. I'm installing MT for MySQL and it wants to know the path to mysql.sock
  3. My Movable Type database isn't working!
  4. What can I do to stop comment spam?

where is perl?

/usr/bin/perl

I'm installing MT for MySQL and it wants to know the path to mysql.sock

You need to set the "DBHost" line in the mt.cfg to db.sabren.com, otherwise it'll try to connect to a local MySQL server.

My Movable Type database isn't working!

This can happen if the database gets corrupted or if you're moving from a new host.

If you don't have a shell account, you probably can't fix this yourself, so email for help. Here's how I fix it:

# to find the broken db's:
cd mt-db-directory
find . -name '*.db' -exec 'db_verify' '{}' ';'

# how to recover, assuming the broken file is comment.db
db_dump -r -f comment.data comment.db
mv comment.db comment.db.old
db_load -f comment.data comment.db
chown apache:apache comment.data
chown apache:apache comment.db
chmod 666 comment.db
db_verify comment.db
db_verify comment.db.old

What can I do to stop comment spam?

* Rename mt-comment.cgi - Some spambots look specifically for the file mt-comments.cgi. First rename mt-comments.cgi to something else. Then edit mt.cfg. Look for the line that says CommentScript, uncomment that line, and put in the new filename of your comment script. Then you have to go to your MT control panel, and rebuild the entire site.

Unfortunately, renaming mt-comment.cgi only works for a short while. Jay Allen's [WWW]Blacklist is a good tool. If you use a MySQL backend for MT, you can use [WWW]Close Comments plugin to close comments on old entries. This is probably the most effective strategy. If you cannot use the plugin, closing comments on old entries manually is highly recommended.

PythonPowered