A few days ago I had my server sending mail quite happily. At the moment I am still testing the various services. At some stage over the past few days sending email using Outlook Express has stopped working. It keeps asking for my password. I can send mail using SquirrelMail. The system log contains these entries: saslauthd[4912]: do_auth : auth failure: [service=smtp] [realm=mydomain.co.uk] [mech=shadow] [reason=Unknown] (domain changed for security) I've been chasing round in circles for a few hours trying to sort this out. Any help would be gratefully received!
You must have changd something in the Linux auth scheme. Your system is now authenticating against linux system users in /etc/shadow but ispconfig uses virtual users. Download the latest ispconfig and run the update.php script and select to reconfigure services during update.
Thanks Till. Unfortunately having followed your advice, when I ran upgrade it had a problem restoring all the data to the data base. I have had to recreate various fields in the database: Code: alter table client add `limit_mailaliasdomain` int(11) NOT NULL default '-1' after `limit_mailalias` alter table client add `limit_web_quota` int(11) NOT NULL default '-1' after `limit_web_domain` alter table client add `limit_traffic_quota` int(11) NOT NULL default '-1' after `limit_cron_frequency` ALTER TABLE `mail_user` ADD COLUMN `autoresponder_start_date` DATETIME NOT NULL DEFAULT '0000-00-00' AFTER `autoresponder` ALTER TABLE `mail_user` ADD COLUMN `autoresponder_end_date` DATETIME NOT NULL DEFAULT '0000-00-00' AFTER `autoresponder_start_date` I also got a " Table 'dbispconfig.mail_relay_recipient' doesn't exist" so I just commented out the line in the database dump file before restoring manually.
Then you ither have modified something in the ispconfig database manually e.g. added a field or table or you installed a update that was older then the version thatw as installed on your system. You have to undo all manual modifications that you did in the database and then install the latest update (ISPConfig 3.0.2.1).
It's extremely strange. I've checked back in ispconfig3_install/install/sql/ispconfig3.sql and the create table statements include the various fields that are missing. So for some bizarre reason, MySQL has failed to add all the neccessary columns when creating the tables during the 'update'. I guess my best option is to retry the upgrade. ---- edit: I found the reason. I accidentally used version 3.0.1.6 (copied and pasted from http://www.howtoforge.com/perfect-server-centos-5.4-x86_64-ispconfig-3-p6) will now retry with the correct version and manually restore the database! So a big foul up by me!! (but would be nice if you could edit the Perfect server pages to reference the latest version so idiots like me don't get it wrong!) Having redone with the correct version, all is well and the mail problem has been solved. After running update I used MySQL to truncate all tables and then manually reinstalled the data backup from the first upgrade attempt Thank-you!
