Darren Clissold
Datafast, http://www.datafast.net.au
darren@datafast.net.au
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, March 31, 1999 1:18 AM
Subject: Re: [Emerald] Changing password via mailsite web console
>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
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html