Re: [Emerald] Changing password via mailsite web console

Dale E. Reed Jr. ( (no email) )
Tue, 30 Mar 1999 07:16:03 -0800

Darren Clissold wrote:
>
> Yes the procedure is there, doesn't seem to work though.

Ok. I haven't actually tried it myself. However, I will
not that I found a issue with the proc last night when I
posted this one. The one that comes with Emerald 2.5 has
an incorrect line in it:

> >CREATE PROCEDURE ChangeMailUserPassword @login varchar(64), @domain
> >varchar(64), @password varchar(16), @esid integer AS
> >
> >Update sa
> >Set Password = @password
> >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 (
> > ( (sa.Login = @login or sa.Shell = @login) AND d.MailDomain = @domain)

In the above live, the inner set of () where missing. I'm not positive
about the order or AND/OR, but checked your proc and see if there is
a set of () around the sa.login to @login section.

> > OR
> > (sa.Email = @login + '@' + @domain)
> > )

-- 

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