Re: All accounts run return expired

Thomas Spaulding ( (no email) )
Fri, 12 Dec 1997 17:32:09 -0500

set for 1/1/99 and they won't be expired.

-----Original Message-----
From: Thomas Suiter <tsuiter@midusa.net>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Friday, December 12, 1997 4:58 PM
Subject: All accounts run return expired

>Trying to allow run with NO date expiration on accounts, all ODBC logins
>return that the account has expired. I've ran an update query setting
>the ma.ExpireDate & sa.ExpireDate to NULL which is supposed to make it
>ignore any expiration, but it still does the same. I've ran the the
>same select query that RadiusNt does in -x15 mode to see if I could fine
>anything weird.
>
><SQL Query I ran>
>
>Select
>DateAdd(Day, (ma.extension + ma.overdue), maExpireDate),
>DateAdd(Day, sa.extension, saExpireDate),
>sa.AccountID,
>sa.AccountType,
>sa.Password,
>sa.Login,
>sa.Shell
>From MasterAccounts ma, SubAccounts sa
>Where
>(sa.Login='holiday' or sa.Shell='holiday') AND
>ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
>
><OUTPUT FROM QUERY>
>
> AccountID AccountType Password Login Shell
>------- -------- --------- ------------- ---------
>-------- -------
>(null) (null) 9270 PPP XXXXXXX holiday
>(null)
>
>
>Anybody got any ideas??
>
>Thanks
> Thomas
>
>
>--
>___________________________________________________________________________
_
>
> Thomas P. Suiter | Systems Administrator
> tsuiter@midusa.net | NetSpace Internet Service
> Fax: (785) 825-5873 | (785) 823-3565
>___________________________________________________________________________
_
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>