We are trying to migrate from Communigate Pro to Postfix+dbmail+MySQL. When I was testing dbmail it was originaly with only one domain, eveything worked great. I ran into a snag when I added a second domain because I could no longer just put in only the username without the domain; otherwise the username could not be repeated i.e. [EMAIL PROTECTED] and [EMAIL PROTECTED] would just be sales (how would it know which was which was for which domain?). I want users from mydomainA.com to be able to login using only their username OR their [EMAIL PROTECTED] I want users from mydomainB.com (and any future domains) to be able to login only as [EMAIL PROTECTED] (or whatever the new domain name is). I also need the ability for them to use a % instead of an @ (stupid Communigate Pro limitation but 10K+ people already have it in their outlook settings so it would be nice to have). It seems that the dbmail's IMAP and POP servers don't support the concept of a default domain if one is not specified in the login username and I can't figure out a way around this... Any help would be greatly appreciated.
Here is a quick dump of my users table: +-----------+-------------------------+----------+-------------+------------ --+-----------------+---------------------+ | user_idnr | userid | passwd | client_idnr | maxmail_size | encryption_type | last_login | +-----------+-------------------------+----------+-------------+------------ --+-----------------+---------------------+ | 1 | [EMAIL PROTECTED] | password | 0 | 0 | | 2003-05-15 21:50:13 | | 2 | [EMAIL PROTECTED] | password | 0 | 0 | | 2003-05-15 21:49:56 | +-----------+-------------------------+----------+-------------+------------ --+-----------------+---------------------+ And my aliases table: +------------+--------------------------+------------+-------------+ | alias_idnr | alias | deliver_to | client_idnr | +------------+--------------------------+------------+-------------+ | 1 | [EMAIL PROTECTED] | 1 | 0 | | 2 | [EMAIL PROTECTED] | 1 | 0 | | 3 | [EMAIL PROTECTED] | 1 | 0 | | 4 | [EMAIL PROTECTED] | 2 | 0 | +------------+--------------------------+------------+-------------+ Thanks in advance! PS: SMTP deliver seems to work with the above tables. ---------------------------------------- Michael Shuler
