On Mon, 2004-03-01 at 04:38, Paul J Stevens wrote: > Chris Nolan wrote: > > Hi all! > > > > I'm looking to migrate the dodgy setup from hell to DBMail. Here's the > > problem: > > > > * The current setup is: > > > > Postfix 1.x + UW-IMAP (ugh...) + SASL + PWCheck > > > > I want to move this across to: > > > > Postfix 2.x + DBMail > > > > Migrating existing mail isn't a problem, but migrating existing > > usernames and passwords is. All users currently have UNIX system accounts. > > > > The main problems are: > > > > 1. Obviously, all passwords are encrypted. It seems that getting this to > > work with SMTP AUTH can be problematic > > Inserting users from /etc/passwd and friends is no great challenge. > dbmail-adduser is perfectly suited to this task. Indeed! Thankfully, I've got no problems there. > > And SMTP AUTH with users in dbmail only, will work if you use pam-mysql. > Of course if 2.0 will do ldap that will work even better performance wise. > Admittedly, I want to get as far away from SASL as I can. I've used Cyrus stuff before and although it's quite good, the lack of documentation is quite a concern. For this reason, I'm considering moving to qmail (and using it's checkpasswd interface) > > > 2. All mail accounts have usernames that are not the same as their mail > > addresses (for instance, [EMAIL PROTECTED] has the UNIX username lisasd). > > So? Where is the challenge in that ? Seem pretty straightforward to me. > All tutorials and howtos I've read on the subject of using Postfix with an SQL database have had usernames and email addresses the same. Finding an example where this isn't the case is proving slightly difficult. > > > Does anyone have any insights, advice or pointers to offer? > > Perhaps some more details would allow me to be more helpful. Basically, the actual setup at the moment is:
* Every user is a normal UNIX user * All passwords are stored in /etc/shadow * All mail stores are boring old mbox spools * All aliases are in the virtual postfix table * SMTP auth is done with SASL and pwcheck * Due to some users, we also have POP-before-SMTP setup We want to change everything so that: * No user has a UNIX account * All authentication happens against the DBMail database * All usernames and passwords are the same as they are now (not too hard to migrate the information) * Bounces are still handled by the MTA Regards, Chris
