Message 2: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000)
produces login failures
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: Has any one figured it out yet?
from Gaby <gaby@inco.com.lb>
Message 4: Re: Has any one figured it out yet?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: Re: Has any one figured it out yet?
from Gaby <gaby@inco.com.lb>
Message 6: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000)
produces login failures
from Mike Miller <michael@abraxis.com>
Message 7: Suggestions for query on calls table??
from Mike Miller <michael@abraxis.com>
Message 8: unsubscribe
from asmaayni@cybernet.net.ma
Message 9: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000)
produces login failures
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000) produces login failures
from "Mike Stankavich" <mike@ethergate.com>
Message 11: Is RadiusNT 1.16.60 Y2k compliant ?
from "Danny Sinang" <danny@uplink.com.ph>
Message 12: Re: Is RadiusNT 1.16.60 Y2k compliant ?
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: unsubscribe
From: "Juergen W. Dobler" <juergen.dobler@meritmalta.com>
Date: Fri, 24 Jul 1998 07:36:36 +0200
unsubscribe
Juergen W. Dobler
I.T. Co-ordinator
juergen.dobler@meritmalta.com
http://www.meritmalta.com
http://www.meritmalta.com/juergen
Tel. (356) 484184
Fax (356) 446679
Merit-Malta Methode Ltd.
Mriehel Industrial Estate
Mriehel QRM 09
MALTA
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000)
produces login failures
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Has any one figured it out yet?From: Gaby <gaby@inco.com.lb>Date: Fri, 24 Jul 1998 11:16:09 +0200
I know someone else has ran into this problem any ideas why this happens?
The TimeLeft field will not subtract the time used even though it shows ithappeningin the -x15 mode output.
I am using....MS-SQL 6.5 sp4RadiusNT 2.5.124The standard SQL database that comes with RadiusNT 2.5.124And I have manual calls & service updates turned on.
Everything else is working fine.
Thanx.Gaby.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Has any one figured it out yet?From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 24 Jul 1998 01:27:33 -0700
Gaby wrote:> > I know someone else has ran into this problem any ideas why this happens?> > The TimeLeft field will not subtract the time used even though it shows it> happening> in the -x15 mode output.> > I am using....> MS-SQL 6.5 sp4> RadiusNT 2.5.124> The standard SQL database that comes with RadiusNT 2.5.124> And I have manual calls & service updates turned on.> > Everything else is working fine.
I have tested this on many different installs of SQL Server w/out aproblem. Could this be a language install problem? What version of SQL Server, service packs, and language support do you have forSQL Server and the Client RadiusNT is running on?
-- 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Has any one figured it out yet?From: Gaby <gaby@inco.com.lb>Date: Fri, 24 Jul 1998 15:41:35 +0200
>I have tested this on many different installs of SQL Server w/out a>problem. Could this be a language install problem? What version >of SQL Server, service packs, and language support do you have for>SQL Server and the Client RadiusNT is running on?>>-- >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
I am running the Standard MSSQL 6.5 sp4 english underNT 4.0 Server with sp3. RadiusNT is running on the same server,and this problem occurs when I use RADLOGIN and when I actuallygo in through my NAS. The funny thing is though, that when I use radiusagainst a MSAccess DB it workx fine, it only stoops under SQL.
Thanx.Gab.
P.S. - Could it be because I am using the 10 user non-resale version of SQL?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000) produces login failuresFrom: Mike Miller <michael@abraxis.com>Date: Fri, 24 Jul 1998 10:10:46 -0400
My apologies,
Radius 2.2 is y2k compliant. In our testing yesterday we were using a dateof 1-1-2050 (randomly picked.. no special reason). I tried the test againtoday, except this time with a date of 1-1-2010. It appears RadiusNT 2.2will handle 2010 completely fine. I doubt RadiusNT 2.2 will ever use adate larger than 2010 (like 2050), unless of course by some wierd miracle acustomer decides to pay 50 years Internet access in advance (yeah right!).I am content with a successful test.
--
==================================================== /\ Mike A. Miller == /--\ \/ Abraxis Networks ==/ \ B R A /\ I S == / == N E T W O R K S michael@abraxis.com====================================================
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Suggestions for query on calls table??From: Mike Miller <michael@abraxis.com>Date: Fri, 24 Jul 1998 11:54:57 -0400
We are running RadiusNT 2.2 with ODBC & SQL 6.5. One of our old NAS's thatwe plan on getting rid of in the near future (this is not critical)occasionally reports an invalid AcctSessionTime to Radius. In particular,the NAS is a USRobotics Netserver 16I running V.90 code (not sure exactlywhat version number at the moment). The Netserver will from time to timereport a negative number for a users AcctSessionTime in the accounting stoprecord. This negative number gets inserted into our calls table by Radius. I plan on writing a trigger on the calls table to block these negativevalues from getting entered, but I still need to cleanup the ones alreadyin our calls table since it is causing our reports to be incorrect. Itried running a simple query with iSQLw:
UPDATE CallsSET AcctSessionTime=0WHERE AcctSessionTime<0
We keep two months accounting data (consolidated nightly) in a 500MB SQLdatabase. The above query does not work because it takes a long time toprocess during which time the calls table gets locked and causes Radius tofreeze since it can not record the accounting requests. Is there a betterquery to write to accomplish this task of altering negative AcctSessionTimerecords to set them to 0? Also, out of curiosity, has anyone else ever hada Netserver start doing this? Ours started after the V.90 code load.While it is only about 3 records per month that are corrupt, it still makesfor troublesome reporting.
--==================================================== /\ Mike A. Miller == /--\ \/ Abraxis Networks ==/ \ B R A /\ I S == / == N E T W O R K S michael@abraxis.com====================================================
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribeFrom: asmaayni@cybernet.net.maDate: Thu, 23 Jul 1998 16:28:25 +0100
unsubscribe ============================================== * Moncef ZRIKEM * * Directeur * * Cybernet - 04 Multimedia * * Internet Provider * * Adresse: 14, Bd. Yacoub El Mansour, Gueliz,* * Marrakech * * Tel: (212 (4) 43 91 17 - 43 84 04/05 * * Fax: (212 (4) 43 84 11 * * E-mail: info@cybernet.net.ma * * http://www.cybernet.net.ma * * http://www.marrakesh-on-line.com * ==============================================
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000) produces login failuresFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 24 Jul 1998 16:42:45 -0700
Mike Miller wrote:> > Radius 2.2 is y2k compliant. In our testing yesterday we were using a date> of 1-1-2050 (randomly picked.. no special reason). I tried the test again> today, except this time with a date of 1-1-2010. It appears RadiusNT 2.2> will handle 2010 completely fine. I doubt RadiusNT 2.2 will ever use a> date larger than 2010 (like 2050), unless of course by some wierd miracle a> customer decides to pay 50 years Internet access in advance (yeah right!).> I am content with a successful test.
I'm guessing the issue resolves around the year 2017 (If I rememberright).RadiusNT 2.5 should be able to handle the years higher than 2017. 2.2(which parses the dates) may have problems with it.
-- 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000) produces login failuresFrom: "Mike Stankavich" <mike@ethergate.com>Date: Fri, 24 Jul 1998 17:00:51 -0700
What about the SQL Server default behavior of converting 2-digit yearsbetween 00 and 49 to 2000-2049 and 50-99 to 1950-1999? That would explainwhy 2050 didn't work...
Mike Stankavich, CTO
NorFab/ISP, Inc.921 SW Washington StPortland OR 97205
email: mike@ethergate.comwww - business: http://www.ethergate.comwww - personal: http://users.ethergate.com/mike
(503) 972-2822 direct(503) 972-2810 office(503) 972-2823 fax
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Friday, July 24, 1998 4:35 PMSubject: Re: Y2K and Radius: maExpireDate above 12-31-1999 (year 2000)produces login failures
Mike Miller wrote:>> Radius 2.2 is y2k compliant. In our testing yesterday we were using adate> of 1-1-2050 (randomly picked.. no special reason). I tried the test again> today, except this time with a date of 1-1-2010. It appears RadiusNT 2.2> will handle 2010 completely fine. I doubt RadiusNT 2.2 will ever use a> date larger than 2010 (like 2050), unless of course by some wierd miraclea> customer decides to pay 50 years Internet access in advance (yeah right!).> I am content with a successful test.
I'm guessing the issue resolves around the year 2017 (If I rememberright).RadiusNT 2.5 should be able to handle the years higher than 2017. 2.2(which parses the dates) may have problems with it.
--Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQsInternet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Is RadiusNT 1.16.60 Y2k compliant ?From: "Danny Sinang" <danny@uplink.com.ph>Date: Sat, 25 Jul 1998 08:51:30 +0800
Hello.
Is RadiusNT 1.16.60 Y2k compliant ?
If not fully, then at what year will it have problems ?
- Danny Sinang
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Is RadiusNT 1.16.60 Y2k compliant ?From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 24 Jul 1998 20:22:05 -0700
Danny Sinang wrote:> > Is RadiusNT 1.16.60 Y2k compliant ?
RadiusNT 1.16.20? Whats that?
> If not fully, then at what year will it have problems ?
I would guess that its prone to the same issues 2.2 is, but Icouldn't honestly tell you. I don't think I even have a copy ofit around here (no thanks, I don't really want a copy of it either).
-- 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