In order for RADUSERS to create a file that gives the customer the same
"expire" date as would Emerald the RU_RATC stored procedure is missing one
item.... ma.OverDue
The one listed below works.....
=============
if exists (select * from sysobjects where id = object_id('dbo.RU_RATC') and
sysstat & 0xf = 4)
drop procedure dbo.RU_RATC
GO
CREATE PROCEDURE RU_RATC AS
SELECT sa.Login, sa.Password, sa.AccountType, MasterExpire=DateAdd(Day,
(ma.Extension + ma.OverDue), maExpireDate),
SubExpire=DateAdd(Day, sa.Extension, saExpireDate)
From MasterAccounts ma, SubAccounts sa
Where ma.CustomerID = sa.CustomerID
AND DateAdd(Day, (ma.Extension + ma.OverDue), maExpireDate) >= GetDate()
AND sa.Login is not null
AND ma.Active = 1 AND sa.Active = 1
AND NOT EXISTS (
Select * From RadConfigs rc where sa.AccountID = rc.AccountID
)
AND EXISTS (
Select * From RadATConfigs rat where sa.AccountType = rat.AccountType
)
GO
GRANT EXECUTE ON dbo.RU_RATC TO EmeraldApps
GO
=======================
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Monday, May 10, 1999 3:26 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] 2.5.xxx feature request
>
>
> "Ronnie D. Franklin" wrote:
> >
> > > If you use radusers to do the export, it uses a stored proc for the
> > > information that you can modify to include those (actually, I think
> > > the default ones do).
> >
> > I finally had time to look at the stored proc for Radusers..
> and it appears
> > that it is trying to add the extend days to come up with a
> "real" expire,
> > but when it creates the txt file the expiration date is the actual
> > expiration date without the extenstions added in... What is it
> missing????
>
> You are looking at the wrong proc. Radusers uses the RU_ procs, not
> the RadUsers proces (Emerald uses the RadUsers proc to export out
> the list of users).
>
> > ================
> >
> > if exists (select * from sysobjects where id =
> object_id('dbo.RadUsers') and
> > sysstat & 0xf = 4)
> > drop procedure dbo.RadUsers
> > GO
> >
> > CREATE PROCEDURE RadUsers AS
> > SELECT sa.Login, sa.Password, sa.Email, d.MailDomain, sa.AccountType,
> > sa.LoginLimit, sa.TimeLeft,
> > MasterExpire=DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate),
> > SubExpire=DateAdd(Day, sa.Extension, saExpireDate)
> > From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
> > Where ma.CustomerID = sa.CustomerID
> > AND ma.GroupID = g.GroupID
> > AND g.DomainID = d.DomainID
> > AND sa.Login<>' '
> > AND ma.Active = 1 AND sa.Active = 1
> >
> > GO
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart