[RadiusNT Digest]

radiusnt-digest-request@iea-software.com
Sat, 20 Jun 1998 00:00:46 -0700

Message 1: Re: Can RadiusNT do IP pooling ?
from Dale Reed <daler@iea-software.com>

Message 2: Re: radius errors
from rabaut <rabaut@hcc.cc.fl.us>

Message 3: Calls not updating (SQL error)
from "Mauro J. Jaskelioff" <mauro@citynet.net.ar>

Message 4: Re: Time-banking not functioning *again*
from "Paul Rensel" <paul@ixs.nl>

Message 5: help needed
from "Michael Abrams" <mike@solutions2000.net>

Message 6: RadiusNt will not run as a service
from "Richard Pedersen" <rich@cybernet1.com>

Message 7: undefined NASport's inserted into Calls .. OK?
from Steve Rich <smrich@wans.net>

Message 8: Re: disconnects
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 9: Re: Calls not updating (SQL error)
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: Re: undefined NASport's inserted into Calls .. OK?
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 11: Re: Time-banking not functioning *again*
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 12:
from "Majordomo@essex1.com" <majordomo@essex1.com>

Message 13: Re:
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 14: Does not revert to Text Backup when ODBC times out
from "Rudy Komsic" <rudyk@cyberglobe.net>

Message 15: Re: Does not revert to Text Backup when ODBC times out
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 16: Problems with upgrade!
from "webmaster" <webmaster@skyquest.net>

Message 17: RadiusNT v2.5 and MS SQL
from postman@cp-tel.net (Postman Account)

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Can RadiusNT do IP pooling ?
From: Dale Reed <daler@iea-software.com>
Date: Fri, 19 Jun 1998 01:59:29 -0700

radiusnt.iea-software@mailpost.terabit.net wrote:
>
> Can RadiusNT do IP pooling ?
> Like StillBelt Radius from Funk Software.
> I need to be able to assign IP addresses from different subnets
> depending on user name.

Currently, its can't. IMHO, its best for the NAS to
handle IP Allocation, since you can run into some intersting
technical issues with RADIUS server side IP allocation.

-- 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 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: radius errorsFrom: rabaut <rabaut@hcc.cc.fl.us>Date: Fri, 19 Jun 1998 07:01:24 -0400

Dale

I believe that I have setup RadiusNT correctly. I can create user accountsand when I use the radlogin -x15 from the dos prompt, it responds well. Icreated a dump of the parameter settings from the Bay RAC and tried todetermine which one's I need to change. some of the one's I found were...

pref_secure1_host which I set to the ip address of the radiusNT serverenable_protocol set to radiusradius_secret set to the same secret on the radiusNT clients filesmade sure that the auth_port and the acct_port were set correctly.

Are there any others that I need to concern myself with??

When I reboot the Bay RAC, I see a response from radiusNT server (doswindow). When I try to login using a username/password valid or not, itstill allows me access ... It seems to be ignoring the user database.

I assume that the server file contains the ip address of the radiusNTserver with the secret same as set in the clients file and on the RAC.

I guess I would like to see generic (basic) settings so I can get itworking and auth names.

thanks for the help

Mike

At 09:00 PM 6/18/98 -0700, you wrote:>rabaut wrote:>> >> Does anybody have any experience with the configuration of the Bay Networks>> RAC with RadiusNT??>>Are you running into any specific problems, or just looking for generic>setup questions?>>-- >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>>

rabaut@hcc.cc.fl.usHillsborough Community CollegeP.O. Box 5096Tampa, Florida 33675-5096

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Calls not updating (SQL error)From: "Mauro J. Jaskelioff" <mauro@citynet.net.ar>Date: Fri, 19 Jun 1998 10:32:04

I=B4m using RadiusNT2.5 and SQL Server. I've created the tables using theradiusnt.sql script that's in IEA Software FTP server.The Calls table is not being updated.When i Run radius -x15

I see the following error:

SQL Statement: INSERT INTO Calls(CallDate,NASIdentifier,NASPort,UserName,AcctStatusType,AcctSessionId,AcctDelayTime) VALUES (GetDate(),'200.32.15.238',3,'mauro',1,'00000089',20)

ODBC Error:23000:2627: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEYconstraint 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.

There is another (older) entry in the Database with the same AcctSessionId.

************************* Mauro J. Jaskelioff ** mauro@citynet.net.ar ** Depto T=E9cnico ** Citynet S.A. *************************

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time-banking not functioning *again*From: "Paul Rensel" <paul@ixs.nl>Date: Fri, 19 Jun 1998 15:42:23 +0200

Dale,

i'm not too happy about the fact that you've changed the timeleft fromseconds to minutes.

I don't know when this has happened but using seconds is the only thing weshould use.

When calculating with minutes, our ISDN users will not be very happy becauseeach call, regardless how long (and with ISDN 20 seconds for checking mailis normal) is charged as one minute.Because we sell access by the hour, these users can only login 60 times forevery hour they've bought.

Please reconsider seriously about changing the Timeleft from minutes toseconds again.

Shouldn't be too hard and actually more logically because AscendMaxtime andMaxSessiontime are already in seconds, this is done (at least by Ascend)especially for the ISDN users.

Best Regards,

Paul Rensel

-----Original Message-----From: Dale Reed <daler@iea-software.com>To: Paul Rensel <paul@ixs.nl>Cc: IEA Software Support <support@iea-software.com>Date: vrijdag 19 juni 1998 12:26Subject: Re: Time-banking not functioning *again*

>Paul Rensel wrote:>>>> What about 'small-time users', say 15 seconds, will those be correctly>> calculated against the Timeleft field ??>>Yes. The formula is (AST/60)+1. They will always be subtracted atleast>one minute for each call (assuming the call was fully authenticated>and accounted for).>>> what will be the value of timeleft when i have initally 5 in timeleft and>> somebody calls in for 15 seconds,>> will the value in timeleft be 4,75 ???>>No. It will be 4. The field in an integer and does not hold decimal>values.>>-->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: help neededFrom: "Michael Abrams" <mike@solutions2000.net>Date: Fri, 19 Jun 1998 09:39:42 -0300

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01BD9B66.2FCD6000Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

Hi folks,

I've now gotten my odbc functioning and it's working good. I would now =like to enable concurrency control. I still am not quite clear on how =the table structures interact to enable this function.Could you guys please give me some help on this, you could reply =directly to=20mike@solutions2000.netif you like.

Thanks

------=_NextPart_000_0010_01BD9B66.2FCD6000Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

Hi folks,
 
I've now gotten my odbc functioning =and it's=20working good.  I would now like to enable concurrency control. I =still am=20not quite clear on how the table structures interact to enable this=20function.
Could you guys please give me some =help on this,=20you could reply directly to
mike@solutions2000.net<=/DIV>
if you like.
 
Thanks
------=_NextPart_000_0010_01BD9B66.2FCD6000--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNt will not run as a serviceFrom: "Richard Pedersen" Date: Sun, 19 Oct 1997 09:02:57 -0600After upgrading to 2.5 Radiusnt runs fine from the command line withthe -x15 switchHowever when run as a service it does not work.Any suggestions?Using AccessIn radius admin the configuration checked areMode odbcdebug odbcthe odbc dsn checks properlyunder options the items checked areconcurrencymanual calls updatethank-you for any suggestionsRich..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: undefined NASport's inserted into Calls .. OK?From: Steve Rich Date: Fri, 19 Jun 1998 10:30:25 -0500I'm using SQL Server 6.5 and Radius 2.2. My calls table has thestandard 4-part primary key, and no other constraints. I thought thatthe NASports had to be defined in table serverports in order for theRadius to insert into Calls, but I've been receiving records into Callswith NASport's much greater than those defined (3Com HyperARC card onUSR TotalControl). Do I need to define the NASports if I'm not going touse serverports? Are there any other problems with Radius and insertingaccounting records if I were to define the Server recrd but leave only asingle record in serverports as NASport = 0?..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: disconnectsFrom: "Dale E. Reed Jr." Date: Fri, 19 Jun 1998 11:09:24 -0700You need to check the clock on your computer. :(Richard Pedersen wrote:> > I think I have the problem solved> > In the RadAtConfigs table RadAttribureId 27 had data and value of 7200> I assumed the value figure should be 1 and the data should be the amount of> time youi want assigned however changing the value to 1 set the session> time to 1 second I changed both valued to 21600 and It appears to be working> properlyData is ignored. Only value is used for that attribute (a type ofint). -- 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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls not updating (SQL error)From: "Dale E. Reed Jr." Date: Fri, 19 Jun 1998 11:47:51 -0700Mauro J. Jaskelioff wrote:> > Im using RadiusNT2.5 and SQL Server. I've created the tables using the> radiusnt.sql script that's in IEA Software FTP server.> The Calls table is not being updated.> When i Run radius -x15> > I see the following error:> > SQL Statement: INSERT INTO Calls> (CallDate,NASIdentifier,NASPort,UserName,AcctStatusType,AcctSessionId,AcctDe> layTime) VALUES (GetDate(),'200.32.15.238',3,'mauro',1,'00000089',20)> > ODBC Error:23000:2627:> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY> constraint 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.> > There is another (older) entry in the Database with the same AcctSessionId.The AcctSessionID must be unique over a normal amount of time forRadiusNTto work. If you are using a Computone PowerRack, it resets the ASIDeachreboot. In order to correct the problem, you need to install supportforan NTP server and change the size of the AcctSessionID field in thecalldtable. You should be able to find ample talks about this in thelist archives (search from our web page).-- 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: undefined NASport's inserted into Calls .. OK?From: "Dale E. Reed Jr." Date: Fri, 19 Jun 1998 12:12:28 -0700Steve Rich wrote:> > I'm using SQL Server 6.5 and Radius 2.2. My calls table has the> standard 4-part primary key, and no other constraints. I thought that> the NASports had to be defined in table serverports in order for the> Radius to insert into Calls, but I've been receiving records into Calls> with NASport's much greater than those defined (3Com HyperARC card on> USR TotalControl). Do I need to define the NASports if I'm not going to> use serverports? Are there any other problems with Radius and inserting> accounting records if I were to define the Server recrd but leave only a> single record in serverports as NASport = 0?Inserting accounting records has now constraints or relationshipsoutside of the calls table. Therefore, its irrelevant what theServerPortstable contains for storing accounting. However, the ServerPorts tableis required to be populated correctly for things like concurrencycontrol.-- 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 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time-banking not functioning *again*From: "Dale E. Reed Jr." Date: Fri, 19 Jun 1998 12:31:10 -0700Paul Rensel wrote:> > i'm not too happy about the fact that you've changed the timeleft from> seconds to minutes.Its always been in minutes. The bug fix was because the manual calls update was inccorect.> When calculating with minutes, our ISDN users will not be very happy because> each call, regardless how long (and with ISDN 20 seconds for checking mail> is normal) is charged as one minute.> Because we sell access by the hour, these users can only login 60 times for> every hour they've bought.> > Please reconsider seriously about changing the Timeleft from minutes to> seconds again.I'll look into it and see about a change.-- 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 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "Majordomo@essex1.com" Date: Fri, 19 Jun 1998 15:06:17 -0500Hello Again; I have recently converted over from access to SQL and have noticed thiserror showing up in our log. It doesn't seem to cause any problems withRadius but I would like to know what is causing this. Do you have any ideas? SQL Statement: UPDATE CallsOnline SetUsername='username',AcctStatusType=1, CallDate=GetDate(),FramedAddress='206.31.15.154' WHERE NASIdentifier='206.31.15.12' andNASPort=12 AND (DateAdd(Second, 0-delay, GetDate()) >= CallDate ORCallDate IS NULL)ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'delay'.Radius is running great! Much better then with Access97. Thanks :) R. Laughlin Majordomo@essex1.com Essex Internet Sterling, IL 61081 (815) 625-8893..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re:From: "Dale E. Reed Jr." Date: Fri, 19 Jun 1998 14:36:53 -0700Majordomo@essex1.com wrote:> > Hello Again;> I have recently converted over from access to SQL and have noticed this> error showing up in our log. It doesn't seem to cause any problems with> Radius but I would like to know what is causing this. Do you have any ideas?> > SQL Statement: UPDATE CallsOnline Set> Username='username',AcctStatusType=1, CallDate=GetDate(),> FramedAddress='206.31.15.154' WHERE NASIdentifier='206.31.15.12' and> NASPort=12 AND (DateAdd(Second, 0-delay, GetDate()) >= CallDate OR> CallDate IS NULL)> > ODBC Error:S0022:207:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'delay'.You should install the trigger (redownload the radiusnt.sql script) andturn off manual calls update (and manual service update). This problem was fixed in RadiusNT 2.5.126, also. > Radius is running great! Much better then with Access97.Yeah, probably like night and day. Its interesting to watch aproblematic install go to a problem free install by just swappingthe database out. (Not that I am saying you had a problematicinstall).-- 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 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Does not revert to Text Backup when ODBC times outFrom: "Rudy Komsic" Date: Fri, 19 Jun 1998 18:00:46 -0400Hi,I think that RadiusNT might need to be fixed up to revert to the Text Backupif the ODBC becomes Loaded up. Currently when we ran our Consolidation,RadiusNT kept saying ODBC Timeout when clients tried to login. What can bedone in this situation? Should I use Bidirectional Replication for thisinstead?Thanks...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Does not revert to Text Backup when ODBC times outFrom: "Dale E. Reed Jr." Date: Fri, 19 Jun 1998 15:12:44 -0700Rudy Komsic wrote:> > I think that RadiusNT might need to be fixed up to revert to the Text Backup> if the ODBC becomes Loaded up. Currently when we ran our Consolidation,> RadiusNT kept saying ODBC Timeout when clients tried to login. What can be> done in this situation? Should I use Bidirectional Replication for this> instead?If you have text backup enabled for ODBC mode, you probably will needto set your ODBC timeout to a smaller number. The default (I believe)is like 15 seconds. CHange that in the registry to like 5 and see ifit corrects the issue.-- 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 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Problems with upgrade!From: "webmaster" Date: Sat, 20 Jun 1998 01:26:27 -0400I have upgraded RadiusNT from v2.2 to 2.5. What is the user limit for thisversion if unregistered and running in text mode? I have read in you onlinedocumentation that the ODBC mode allows 100 logins. What happens afterthat?The system has started acting erratically, for example:We had a several users who couldn't log on. We tried several things in anattempt to get one user logged on. This included retyping his entry to makesure the spacing and tabs were in order, no success. Adding a sample user,no success. We then cut and pasted the one user at the top of the list, andhe was accepted. I went into the debug mode and noticed an error for one ofthe entries above this user. I have since then corrected this. The serverthough still will not authenticate users. We have since then moved the userlist to the MAX's internal user and password list. Is the unregisteredsoftware situation the problem, or has the upgrade changed features that Iam not use to?Also, I know to use debug, you must stop the service. Okay, after runningthe debug, the last line reads that the Radius Enterprise initialized... Isthis OK instead of "waiting for requests"? Is CTRL C the escape from thismode? If so, then can you just restart the RadiusNT service?We had no troubles with the software until the upgrade!Thanks!..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNT v2.5 and MS SQLFrom: postman@cp-tel.net (Postman Account)Date: Sat, 20 Jun 1998 01:01:26 -0500Does anyone have any suggestions/tips concerning running RadiusNT v2.5 with MS SQL? Preventative maintenance tips? Suggestions of things to watch out for? Security suggestions?a website to recommend?Also, anyone here using MS Access97 forms to updatetheir MS SQL information? I'm wanting to set thisup soon.Please reply.