More Site Changes


In the process of upgrading the back end software from Berkeley DB to PostGreSQL, I enountered a number of problems which required solving. Solutions were as follows. This describes some problems enountered when upgrading Movable Type with MT-Blacklist 1.6x which aren't covered in the upgrade document (link). I'm running redHat Linux Fedora Core 1 for x86 architecture and host the site myself on this box.

  • PostGreSQL required IDENT to match the user accounts.
  • This required modifying the pg_hba.cfg to not require IDENT, as I am sure as heck not going to expose my system passwords on a website.

  • MT complained about files not being linkable -this was a user permissions issue. The files needed to be made part of the httpd user.
  • chown username.webusers /path/to/files/files

    where 'webusers' is a user group which has write access to the websites hosted on the machine.

  • A database needed to be created by a new user
  • su - postgres

    createuser [username]

    su - [username]

    createdb [dbname]

  • YAML also needs to be installed (link to directions on

About Me


  • Unsolicited Bulk Email (spam), commercial solicitations, SEO related items, link exchange requests, and abuse are not welcome here and will result in complaints to your ISP.
  • Any email to the above address may be made public at the sole discretion of the recipient.

Other Stuff

  • Powered by Linux
  • (RedHat Linux)


Monthly Archives

About this Entry

This page contains a single entry by dave published on September 20, 2004 12:00 AM.

Election Day 2004 was the previous entry in this blog.

New Pentaxes is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.