So I’m still working on getting the new deadsquid server up and running to my satisfaction. It’s now using recent software, and I think the upgrade went well. It still works, and I admit I am afraid to reboot it until someone else looks at it and says “looks good to me”. That’ll happen sometime in the next couple weeks when Walt comes up for air.
The last obstacle is an up-to-date mail system, complete with a MySQL backend, user manageable preferences, and decent spam controls. I have been fighting with the MTA for almost a week, and have finally conquered it.
Long story short, it wouldn’t authenticate against the MySQL 4.1.7 database installed on the server, so couldn’t do any kind of lookups. This makes it difficult to use a database as a back-end. Had I read the documentation, I would have come across this section, and saved myself about two days of effort.
If you’re using Debian with your own build (or an unstable build) of MySQL 4.1.x, and a package you are installing makes use of debian MySQL client libraries that use 4.0 or less (essentially libclientmysql1x), make sure you set the database user account password using the OLD_PASSWORD directive.
It will save you a lot of pain. Trust me on this one.
SET PASSWORD FOR ‘user’@’host’ = OLD_PASSWORD(‘yourpassword’);
Ah well, the things we learn.