There was a discussion in the past about this, and it has to do with
how Mailsite interprets things. The old proc would do what you want,
but Mailsite wasn't handling checking the domain correctly. Let me
show the new proc first:
CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain
varchar(32), @esid integer AS
Select Login, Shell, Email, d.MailDomain, Password, HomeDir
From MasterAccounts ma, SubAccounts sa, Groups g, Domains d,
AccountTypes at1
Where ma.CustomerID = sa.CustomerID
AND ma.GroupID = g.GroupID
AND g.DomainID = d.DomainID
AND at1.AccountType = sa.AccountType
AND at1.ExternalSystemID = @esid
AND d.MailDomain = @domain
AND ( ((Login=@username OR Shell=@username) AND d.MailDomain=@domain)
OR Email = @username + "@" + @domain )
AND DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate) >=
GetDate()
Because we added the "d.MailDomain = @domain" in the new proc, thats
forcing
the domain, regardless of the email field. You must remove that line to
do what you want (allowing users in one domain to have email fields in
another).
What Mailsite is NOT doing, is handling the precedence order correctly,
the
way Emerald was designed. They simply look at the login field to find
the
user's name to put the mail in. So for example if you have this
configuration:
Login: joeuser
Domain: domain1.com
Email: joeuser@domain2.com
So if you send mail to joruser@domain2.com, it fails unless you have the
line above removed. If you remove the line, mailsite delivers the mail
to joeuser@domain1.com, and ignores the email field we return of
joeuser@domain2.com.
You might be able to make a more complicated proc that would return the
login/domain if the match is to the login and the split the email into a
login/domain and return that if the match is to the email field. I'd
prefer mailsite to not ignore the email field and use that if its not
blank, as we original talked to them about doing when developing the
Emerald ODBC connection and stored procs. Our EmerAuth.DLL *DOES*
correctly handle the multiple domains this way with NTMail and IMail.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html