Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000)

Dale E. Reed Jr. ( (no email) )
Thu, 23 Jul 1998 23:56:10 -0700

Mike Miller wrote:
>
> Has anyone had any Y2K problems with Radius 2.2? I notice Dale says Radius
> is year 2000 compliant, but have had a problem in testing it internally.
> Our problem is this: If we set up a MasterAccount with a maExpireDate
> greater than 12-31-1999, the user will always get rejected from
> authenticating with the message in Radius Debug -x15 saying that thier
> account is expired. Our platform is as follows:
>
> RadiusNT 2.2 using ODBC for both accounting and authentication
> MS SQL 6.5 sp 4 Database
>
> The column in our database is set up properly to handle long dates. Please
> help.

RadiusNT 2.2 and higher works fine for Year 2000 dates. I justed
tested this again with the Emerald 2.2 database structure and it was
fine:

Login maExpireDate
-------- --------------------
test5 Feb 10 2001 12:00AM

This is 2.2.41 in full debug for this user:

> radrecv: Request from host 7f000001 code=1, id=17, length=57
> User-Name = "test5"
> NAS-Identifier = 127.0.0.1
> NAS-Port = 0
> Password = ")b\005\262\377\235\030\300\306\036+\220\276\335gl"
> rad_authenticate_ODBC()
> Password = ")b\005\262\377\235\030\300\306\036+\220\276\335gl"
>
> SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue), maExpireDate),
> DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Passw
> ord, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login=
> 'test5' or sa.Shell='test5') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 an
> d ma.Active<>0
>
> Decrypted Password: test5
> Database Password: test5
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
> s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
> D=5
>
> Loading radius defaults for this type...
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
> igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
> ntType='PPP'
>
> User-Service = 2 (2)
> Framed-Protocol = 1 (1)
> Sending Ack of id 17 to 7f000001 (localhost)
> User-Service = Framed-User
> Framed-Protocol = PPP
>
> Resp Time: 361 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com