Message 2: Re: Users Online Inaccurate?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: Re: [data] RadiusNT 2.5 problem
from "Zak Wolfinger" <zak@cyberlink.com>
Message 4: Re: NASIdentifier not written to calls table
from "Mohammed Ersan" <ersan@first.net.jo>
Message 5: Re: [data] RadiusNT 2.5 problem
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: static IP and Cisco AS5200
from Christian Simard <simardc@netc.net>
Message 7: radius nt as a service
from Christian Simard <simardc@netc.net>
Message 8: radius upgrade
from eric@valleynetworking.com (Eric Cowperthwaite)
Message 9: Accounting Errors
from "John Rickabaugh" <johnr@ccois.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: how to sync 2 radius servers?
From: Thomas Kernen <tkernen@deckpoint.ch>
Date: Thu, 28 May 1998 09:24:21 +0200
Hello,
what's the best solution to keep in sync 2 radius serveurs? The main one
is running the data from the SQL server and the 2nd (backup) is using
the text file.
Thomas
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Users Online Inaccurate?
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Thu, 28 May 1998 01:49:23 -0700
Lawrence Watkins Work wrote:
>
> I looked for the trigger and was not able to find it.
> Perhaps you could post the location to d/l it at.
See Below:
if exists (select * from sysobjects where id = object_id('dbo.calls_insert') and
sysstat & 0xf = 8)
drop trigger dbo.calls_insert
GO
CREATE TRIGGER calls_insert ON dbo.Calls
FOR INSERT
AS
UPDATE ServerPorts
Set sp.UserName = i.UserName,
sp.AcctStatusType = i.AcctStatusType,
sp.CallDate = DateAdd(Second, 0-i.AcctDelayTime, i.CallDate),
sp.FramedAddress = i.FramedAddress
FROM Servers s, ServerPorts sp, inserted i
WHERE s.IPAddress = i.NASIdentifier AND
s.ServerID = sp.ServerID AND
sp.Port = i.NASPort AND
(DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) >= sp.CallDate OR
sp.CallDate IS NULL)
UPDATE SubAccounts
Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 + 1)
FROM SubAccounts sa, inserted i
WHERE sa.login = i.UserName
and sa.TimeLeft <> NULL
and i.AcctStatusType = 2
GO
-- 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: Re: [data] RadiusNT 2.5 problemFrom: "Zak Wolfinger" <zak@cyberlink.com>Date: Thu, 28 May 1998 05:22:10 -0500
Hmmm...thought I had grabbed the latest version. Is Radius_25_110.exethe correct (latest) version to download?
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Cc: brian@net-shopper.co.uk <brian@net-shopper.co.uk> IEA SoftwareSupport <support@iea-software.com>Date: Thursday, May 28, 1998 12:12 AMSubject: Re: [data] RadiusNT 2.5 problem
|This problem was corrected in 2.5.101, as per the changes.txt file:||V2.5.101 4/24/98|---------------||* Corrected problem with Server Port Access and MS Access.||* Updated radius97.mdb to include the ServerAccess table.|||--|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 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NASIdentifier not written to calls tableFrom: "Mohammed Ersan" <ersan@first.net.jo>Date: Thu, 28 May 1998 16:14:03 +0300
does the cisco(IOS 11.x) supports this feature or not
At 03:32 PM 05/26/98 -0400, you wrote:
>Very simple. Framed-Address is not being sent by the NAS. Check with the
>hardware vendor to see if it is possible to enable it.
<flushright>M. Ersan
ersan@first.net.jo
firstnet</flushright>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: [data] RadiusNT 2.5 problemFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 28 May 1998 10:02:46 -0700
Zak Wolfinger wrote:> > Hmmm...thought I had grabbed the latest version. Is Radius_25_110.exe> the correct (latest) version to download?
The full distribution for RadiusNT 2.5.115 is in the /radiusntdirectory now. RadiusNT 2.2 has been moved to the /radiusnt/olddirectory. There should be an annoucement about this shortly.
-- 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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: static IP and Cisco AS5200From: Christian Simard <simardc@netc.net>Date: Thu, 28 May 1998 16:16:14 -0400
Hi!
I have two kind of access servers: USR Netserver/16 and Cisco AS5200.When I setup a static IP address in the Radconfigs table for a user,everythings works fine when he connects to the USR, but withthe cisco AS5200, the user get disconnected immediatly when I see"Framed-Address" in my radius debug screen. When no staticIP is assigned to the user, no problems with the cisco.
thank you for your help!
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: radius nt as a serviceFrom: Christian Simard <simardc@netc.net>Date: Thu, 28 May 1998 16:32:20 -0400
Hi!
I've just installed radius Nt as a service with "radius.exe -install"the problem is that when I boot windows NT, the service does not start automatically (yes, it is checked automatic in services).When the machine has finished booted, i can start it manuallywithout problems!!!
thanks!
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: radius upgradeFrom: eric@valleynetworking.com (Eric Cowperthwaite)Date: Thu, 28 May 1998 14:00:26 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01BD8A40.F82BC500Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bit
What steps do I need to take to upgrade from Radius 2.2 to Radius 2.5?
I am using Radius as a standalone product. I have a completely and correctlyconfigured MS Access 97 database in place, and I use Radius for bothauthentication and accounting. Radius runs in ODBC mode, as a service, andcontrols concurrency as well.
Thanks,
Eric W. CowperthwaiteSystem EngineerValleyNetworking, Inc.(916)857-7100eric@valleynetworking.com
------=_NextPart_000_0001_01BD8A40.F82BC500Content-Type: application/ms-tnef; name="winmail.dat"Content-Transfer-Encoding: base64Content-Disposition: attachment; filename="winmail.dat"
eJ8+IhwVAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAAM4HBQAcAA4AAAAAAAQACAEBA5AGADQGAAAnAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAADwAAAHJhZGl1cyB1cGdyYWRlAAACAXEAAQAAABYAAAABvYp7o01oAoNI9hsR0YgvAKDJsBg7AAACAR0MAQAAAB8AAABTTVRQOkVSSUNAVkFMTEVZTkVUV09SS0lORy5DT00AAAsAAQ4AAAAAQAAGDgCItZN7ir0BAgEKDgEAAAAYAAAAAAAAABh54oAE99ARgIhERVNUAADCgAAAAwAUDgEAAAALAB8OAQAAAAMABhAlIzx6AwAHEGMBAAAeAAgQAQAAAGUAAABXSEFUU1RFUFNET0lORUVEVE9UQUtFVE9VUEdSQURFRlJPTVJBRElVUzIyVE9SQURJVVMyNT9JQU1VU0lOR1JBRElVU0FTQVNUQU5EQUxPTkVQUk9EVUNUSUhBVkVBQ09NUExFAAAAAAIBCRABAAAA8QEAAO0BAAB7AgAATFpGdYfailgDAAoAcmNwZzEyNRYyAPgLYG4OEDAzM50B9yACpAPjAgBjaArAYHNldDAgBxMCgH0ZCoF1YwBQCwN1bG5lAiBlC6YgVxEABUBzCHRlcAQgZG8gSWYgEwAJgCB0FHABkGtKZRTydQ4AcmEBACAnA1IH8BXwaXUEIDIu5jIU8haHNT8K4wqECoBdFJBhFmAWwAuAZxZ2YTcZ4RPxAHBkB0AS8SBwZQNgZBIwdC4UgREAdjcVYBowBaBtC1ARQGVs7nkY8BqAHBFyCXAbUBygwxgkBaBuZmlnCHAU0TEF4UFjYweQBCA5N/8UUBPQAaAaABVgC4Aa8Atg/R8ALBzDFJAWwBVgFoUCEJMFwAbgdGgYFWF1IiDtCfB0DeAT0GkCIBzDANC9BaB1IwEPIBtwFoVyJCCDBCAgEU9EQkMgBGJ3IJEaEwSQdg3gIIQdp3TtA2BsBCAeAWMIcAlwKGBLHLEEIHcckGwuGCpUYREAbmtzLBgqCvMgOkUFEGMToBtwCFB3cPsEkCIgdwtwFBAYJAawFAFdFmBFDyALgAngchgkVksHQBxgeQfAdHcFsGsbGVEgkEkoYCl1KDkxgDYpODU3LTcPQMcBQBgzBnFjQHYu4xMAvS9WLhwhKxkYJBHxADSgAAAAAwAQEAAAAAADABEQAAAAAAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAFgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAPATAAAeAAaACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjUAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALABCACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAEYAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwASgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADABWACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeACaACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAngAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsALIALIAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAACwAugAsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAAALANaACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAIB+A8BAAAAEAAAABh54oAE99ARgIhERVNUAAACAfoPAQAAABAAAAAYeeKABPfQEYCIREVTVAAAAgH7DwEAAABJAAAAAAAAADihuxAF5RAaobsIACsqVsIAAG1zcHN0LmRsbAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5ET1dTXG1haWwucHN0AAAAAAMA/g8FAAAAAwANNP03AAACAX8AAQAAADEAAAAwMDAwMDAwMDE4NzlFMjgwMDRGN0QwMTE4MDg4NDQ0NTUzNTQwMDAwMjQyODMyMDAAAAAAUS0=
------=_NextPart_000_0001_01BD8A40.F82BC500--
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Accounting ErrorsFrom: "John Rickabaugh" <johnr@ccois.net>Date: Thu, 28 May 1998 21:22:30 -0600
Dale,
Ever since the last beta, currently running the full zip downloaded todayfrom the ftp site, I have been unable to get the calls online to update.Here is a snip from the accounting debug log:
radrecv: Request from host cea89302 code=4, id=57, length=58
Acct-Status-Type = Start Acct-Session-Id = "1919" User-Name = "info4you" NAS-Port = 2 NAS-Identifier = "DU" Framed-Protocol = PPP
SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)VALUES (Now(),1,'1919','info4you',2,'DU')
SQL Statement: UPDATE CallsOnline SetUsername='info4you',AcctStatusType=1, CallDate=Now(), FramedAddress=NULLWHERE NASIdentifier='DU' and NASPort=2 AND (DateAdd('s',0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)
ODBC Error:07001:-3010: [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected2.
Sending Accounting Ack of id 57 to cea89302 (DU)
Resp Time: 47 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1radrecv: Request from host cea89302 code=4, id=58, length=58
Acct-Status-Type = Stop Acct-Session-Id = "1919" User-Name = "info4you" NAS-Port = 2 NAS-Identifier = "DU" Framed-Protocol = PPP
SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)VALUES (Now(),2,'1919','info4you',2,'DU')
SQL Statement: UPDATE CallsOnline SetUsername='info4you',AcctStatusType=2, CallDate=Now(), FramedAddress=NULLWHERE NASIdentifier='DU' and NASPort=2 AND (DateAdd('s',0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)
ODBC Error:07001:-3010: [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected2.
Sending Accounting Ack of id 58 to cea89302 (DU)
Resp Time: 16 Auth: 1/0 -> 1 Acct: 2/0/0 -> 2radrecv: Request from host cea89302 code=4, id=60, length=58
Acct-Status-Type = Start Acct-Session-Id = "1920" User-Name = "info4you" NAS-Port = 2 NAS-Identifier = "DU" Framed-Protocol = PPP
SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)VALUES (Now(),1,'1920','info4you',2,'DU')
SQL Statement: UPDATE CallsOnline SetUsername='info4you',AcctStatusType=1, CallDate=Now(), FramedAddress=NULLWHERE NASIdentifier='DU' and NASPort=2 AND (DateAdd('s',0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)
ODBC Error:07001:-3010: [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected2.
Sending Accounting Ack of id 60 to cea89302 (DU)
Resp Time: 31 Auth: 2/0 -> 2 Acct: 3/0/0 -> 3radrecv: Request from host cea89302 code=4, id=61, length=58
Acct-Status-Type = Stop Acct-Session-Id = "1920" User-Name = "info4you" NAS-Port = 2 NAS-Identifier = "DU" Framed-Protocol = PPP
SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)VALUES (Now(),2,'1920','info4you',2,'DU')
SQL Statement: UPDATE CallsOnline SetUsername='info4you',AcctStatusType=2, CallDate=Now(), FramedAddress=NULLWHERE NASIdentifier='DU' and NASPort=2 AND (DateAdd('s',0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)
ODBC Error:07001:-3010: [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected2.
Sending Accounting Ack of id 61 to cea89302 (DU)
Resp Time: 31 Auth: 2/0 -> 2 Acct: 4/0/0 -> 4radrecv: Request from host cea89302 code=4, id=63, length=58
Acct-Status-Type = Start Acct-Session-Id = "1921" User-Name = "info4you" NAS-Port = 2 NAS-Identifier = "DU" Framed-Protocol = PPP
SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)VALUES (Now(),1,'1921','info4you',2,'DU')
SQL Statement: UPDATE CallsOnline SetUsername='info4you',AcctStatusType=1, CallDate=Now(), FramedAddress=NULLWHERE NASIdentifier='DU' and NASPort=2 AND (DateAdd('s',0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)
ODBC Error:07001:-3010: [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected2.
Sending Accounting Ack of id 63 to cea89302 (DU)
Resp Time: 31 Auth: 3/0 -> 3 Acct: 5/0/0 -> 5
What do I need to do to correct this. The calls table is updatingcorrectly.
John