[RadiusNT Digest]

radiusnt-digest-request@iea-software.com
Fri, 17 Jul 1998 00:00:56 -0700

Message 1: Unsubscribe
from sysop@city-online.com (David Baxter)

Message 2: RE: Concurency Control
from "Greg Lowthian" <greg@isat.com>

Message 3: Re: Concurency Control
from "Majordomo@essex1.com" <majordomo@essex1.com>

Message 4: Upgrade to V.90
from "tech" <tech@gsig-net.qc.ca>

Message 5: Re: Concurency Control
from "Reid Sutherland" <reid@isys.ca>

Message 6: Users and ODBC
from "Reid Sutherland" <reid@isys.ca>

Message 7: Re: Upgrade to V.90
from "Reid Sutherland" <reid@isys.ca>

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

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

Message 10: RE: Concurency Control
from "Greg Lowthian" <greg@isat.com>

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

Message 12: Re: Unsubscribe
from "Allen Mallari" <allen@fiax.net>

Message 13: RE: Concurency Control
from "greg Lowthian" <greg@isat.com>

Message 14: Re: Upgrade to V.90
from "Josh Hillman" <admin-maillist@talstar.com>

Message 15: SQL Error
from "greg Lowthian" <greg@isat.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Unsubscribe
From: sysop@city-online.com (David Baxter)
Date: Thu, 16 Jul 1998 08:47:33 -0400

Unsubscribe

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Concurency Control
From: "Greg Lowthian" <greg@isat.com>
Date: Thu, 16 Jul 1998 07:14:54 -0700

It stopped working on mine when I upgraded to 2.5.124.

> Hiyas,
>
> Radius 2.5 ,Emerald,NT.
> I have spent too many hours trying to get concurrncy
> control working,no
> luck yet :/
>
> Below is an excerpt form the radius manual.
>
> *******************************************************
> *************************************
>
> Preventing a single user from logging in multiple
> times simultaneously
> is called concurrency control. RadiusNT uses the
> RADIUS Accounting
> records to maintain a list of who is currently
> on-line. To achieve
> this, you must add records into the ServerPorts table
> that match the
> ServerID from the Servers table, and the Port column
> which matches the
> NAS-Port attribute in the accounting packet. You can
> run RadiusNT in
> -x15 debug mode to see examples of the NAS-Port
> numbers. RadiusNT will
> only update the records of the ServerPorts table, and
> will not create
> them.
>
> The CallsOnline view contains columns from both the Servers and
> ServerPorts table. It is simply a convenient way to
> read and manipulate
> data based on both of those tables. This view is used
> mainly for
> checking and updating the callsonline list, as noted below.
>
> When RadiusNT receives an authentication request and
> concurrency control
> is enabled, it will look at the number of entries in
> the CallsOnline
> view which match the username. If you do not have
> variable login limits
> enabled, then RadiusNT will default to only allowing
> the user to login
> one time. If you do have variable login limits
> enabled, then RadiusNT
> will only allow the user to login the number of times
> specified in the
> LoginLimit field. All other requests will be rejected.
> *******************************************************
> ***************************************
>
> It says :
>
> "To achieve this, you must add records into the
> ServerPorts table that
> match the ServerID from the Servers table, and the
> Port column which
> matches the NAS-Port attribute in the accounting packet"
>
> Add records ? what records ?
> Whats the server ID from the call table ?
> Port column which matches the NAS-Port attribute ?
>
> I dont see how i can match those,the NAS-Port
> attribute for each call is
> simply the port number on which thatcall is being made ?
>
> Any help with this would be greatly appreciated as I
> have recently
> introducedan Unlimited Plan,and a few clients are
> trying to share one
> account.
>
> --
> ~GolSyd~
> ~GamesOnline Sydney~
> ~ Internet Service Provider & Online Gaming ~
> "SPEED DOES MATTER"
> http://www.golsyd.net.au
> ftp://ftp.golsyd.net.au/
> admin@golsyd.net.au .
>
>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Concurency Control
From: "Majordomo@essex1.com" <majordomo@essex1.com>
Date: Thu, 16 Jul 1998 10:21:50 -0500

Howdy;
In the Servers table there is a ServerId number for each Portmaster. Put
this Id number in the ServerPorts table with the port number for each port
on your Portmaster. If you have thirty ports on your #1 Portmaster you
should have thirty records with ServerID '1' with port numbers 0-29. Leave
the rest of the table with it's defaults and RadiusNt should fill in the
rest dynamically as needed. Make sure you use the correct Id number from
your Servers table. If you're using Access I think there is a query you
need to add as well.

Server Ports Table
ServerId Port#
1 0
1 1
: :
1 29
2 0
2 1
2 2 ... etc.

Good Luck :)

At 03:15 PM 7/16/98 +1000, you wrote:
>Hiyas,
>
>Radius 2.5 ,Emerald,NT.
>I have spent too many hours trying to get concurrncy control working,no
>luck yet :/
>
>
>Add records ? what records ?
>Whats the server ID from the call table ?
>Port column which matches the NAS-Port attribute ?
>
>I dont see how i can match those,the NAS-Port attribute for each call is
>simply the port number on which thatcall is being made ?
>
>Any help with this would be greatly appreciated as I have recently
>introducedan Unlimited Plan,and a few clients are trying to share one
>account.
>
>--
> ~GolSyd~
> ~GamesOnline Sydney~
>~ Internet Service Provider & Online Gaming ~
> "SPEED DOES MATTER"
> http://www.golsyd.net.au
> ftp://ftp.golsyd.net.au/
> admin@golsyd.net.au .
>
>
>
R. Laughlin
Majordomo@essex1.com
Essex Internet
Sterling, IL 61081
(815) 625-8893

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Upgrade to V.90
From: "tech" <tech@gsig-net.qc.ca>
Date: Thu, 16 Jul 1998 11:45:46 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0020_01BDB0AF.45397240
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I, When I upgrade with maxlink pro my Max 4048, with telnet and tsave, =
it said "save failed, cause request time out"

What can I do for upgrade my Max.

Tech@gsig-net.qc.ca

------=_NextPart_000_0020_01BDB0AF.45397240
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

I, When I upgrade with maxlink pro =my Max 4048,=20with telnet and tsave, it said "save failed, cause request time=20out"
 
What can I do for upgrade my =Max.
 
Tech@gsig-net.qc.ca
 
------=_NextPart_000_0020_01BDB0AF.45397240--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Concurency ControlFrom: "Reid Sutherland" Date: Thu, 16 Jul 1998 13:14:55 -0400What if you did that, and it still doesn't fill it in.Reid SutherlandNetwork AdministratorISYS Technology Inc.http://www.isys.caFingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64-----Original Message-----From: Majordomo@essex1.com To: radiusnt@iea-software.com Date: Thursday, July 16, 1998 11:23 AMSubject: Re: Concurency Control>Howdy;> In the Servers table there is a ServerId number for each Portmaster. Put>this Id number in the ServerPorts table with the port number for each port>on your Portmaster. If you have thirty ports on your #1 Portmaster you>should have thirty records with ServerID '1' with port numbers 0-29. Leave>the rest of the table with it's defaults and RadiusNt should fill in the>rest dynamically as needed. Make sure you use the correct Id number from>your Servers table. If you're using Access I think there is a query you>need to add as well.>> Server Ports Table> ServerId Port#> 1 0> 1 1> : :> 1 29> 2 0> 2 1> 2 2 ... etc.>>> Good Luck :)> >>At 03:15 PM 7/16/98 +1000, you wrote:>>Hiyas,>>>>Radius 2.5 ,Emerald,NT.>>I have spent too many hours trying to get concurrncy control working,no>>luck yet :/>>>>>>Add records ? what records ?>>Whats the server ID from the call table ?>>Port column which matches the NAS-Port attribute ?>>>>I dont see how i can match those,the NAS-Port attribute for each call is>>simply the port number on which thatcall is being made ?>>>>Any help with this would be greatly appreciated as I have recently>>introducedan Unlimited Plan,and a few clients are trying to share one>>account.>>>>-->> ~GolSyd~>> ~GamesOnline Sydney~>>~ Internet Service Provider & Online Gaming ~>> "SPEED DOES MATTER">> http://www.golsyd.net.au>> ftp://ftp.golsyd.net.au/>> admin@golsyd.net.au .>>>>>>> R. Laughlin> Majordomo@essex1.com> Essex Internet> Sterling, IL 61081> (815) 625-8893..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Users and ODBCFrom: "Reid Sutherland" Date: Thu, 16 Jul 1998 13:17:39 -0400I still have problems with users and ODBC. I fill in the Subaccounts ->Login and Password tables with the info, but Radius still can't find theusers. I can send a sample of what my db looks like. But thing is, it'spicture perfect according to the docs and the other example dbs supplied. Noidea what's going on.Thanks.Reid SutherlandNetwork AdministratorISYS Technology Inc.http://www.isys.caFingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Upgrade to V.90From: "Reid Sutherland" Date: Thu, 16 Jul 1998 13:20:21 -0400This is a multi-part message in MIME format.------=_NextPart_000_0025_01BDB0BC.7C0F9C60Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableI don't think this is the appropriate list to be asking about your =Ascend Max modem rack. Please consult your documentation or call Ascend.Reid SutherlandNetwork AdministratorISYS Technology Inc.http://www.isys.caFingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64 -----Original Message----- From: tech To: radiusnt@iea-software.com Date: Thursday, July 16, 1998 12:03 PM Subject: Upgrade to V.90 =20 =20 I, When I upgrade with maxlink pro my Max 4048, with telnet and =tsave, it said "save failed, cause request time out" =20 What can I do for upgrade my Max. =20 Tech@gsig-net.qc.ca =20------=_NextPart_000_0025_01BDB0BC.7C0F9C60Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
I don't think this is the =appropriate list to be=20asking about your Ascend Max modem rack. Please consult your =documentation or=20call Ascend.
 
 
Reid Sutherland
Network =Administrator
ISYS=20Technology Inc.
http://www.isys.ca
Fingerprint: 6552 =6469 5320=207475 6568 6c72 6e61 0a64
-----Original =Message-----
From:=20 tech <tech@gsig-net.qc.ca>
To:==20 radiusnt@iea-software.com=20 <radiusnt@iea-software.com&g=t;
Date:=20 Thursday, July 16, 1998 12:03 PM
Subject: Upgrade to=20 V.90

I, When I upgrade with maxlink =pro my Max=20 4048, with telnet and tsave, it said "save failed, cause =request time=20 out"
 
What can I do for upgrade my=20 Max.
 
Tech@gsig-net.qc.ca
 
------=_NextPart_000_0025_01BDB0BC.7C0F9C60--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Users and ODBCFrom: "Dale E. Reed Jr." Date: Thu, 16 Jul 1998 11:10:08 -0700Reid Sutherland wrote:> > I still have problems with users and ODBC. I fill in the Subaccounts ->> Login and Password tables with the info, but Radius still can't find the> users. I can send a sample of what my db looks like. But thing is, it's> picture perfect according to the docs and the other example dbs supplied. No> idea what's going on.If RadiusNT is displaying the Error:0000 (which menas there wasn't an error)after the user search, that means there were no users matching the criteriaof the query. This could be because the service or MBR is not active, thereisn't a relationship between them, or some other reason. What I would do iscapture the select query from RadiusNT in -x15 debug mode and look at thewhere clause. Check to make sure each of them are valid for the entry youare looking for. YOu can also paste that query into your database (usingeither MS Access' SQL option on a query or isql_w in sql server) and seewhat parts of the where clause are causing the query to return no results.-- 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: Concurency ControlFrom: "Dale E. Reed Jr." Date: Thu, 16 Jul 1998 11:12:02 -0700Reid Sutherland wrote:> > What if you did that, and it still doesn't fill it in.Make sure you have Manual Calls Update enabled if you arerunning in MS Access mode as well.-- 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: Concurency ControlFrom: "Greg Lowthian" Date: Thu, 16 Jul 1998 11:22:50 -0700It was working fine in 2.2 ODBC/SQL/EmeraldIt quit when I upgrwaded to 2.5.124Is there something I need to change or add.> > Reid Sutherland wrote:> > > > What if you did that, and it still doesn't fill it in.> > Make sure you have Manual Calls Update enabled if you are> running in MS Access mode as well.> > -- > 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: Concurency ControlFrom: "Dale E. Reed Jr." Date: Thu, 16 Jul 1998 11:58:15 -0700Greg Lowthian wrote:> > It was working fine in 2.2 ODBC/SQL/Emerald> It quit when I upgrwaded to 2.5.124> Is there something I need to change or add.Actually, that response was to Reid, rather than to yourself. I would guessthat the upgrade probably messed up your trigger. In isql_w, execute this:Drop Trigger calls_insertGoThen load the rad25_up.sql, highlght the lines from create trigger tothe next go, and execute it. That will put the correct trigger back in.What options do you have enabled for RadiusNT?-- 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: Re: UnsubscribeFrom: "Allen Mallari" Date: Thu, 16 Jul 1998 13:47:21 -0700*********** REPLY SEPARATOR ***********On 7/16/98, at 8:47 AM, sysop@city-online.com wrote: >Unsubscribe..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Concurency ControlFrom: "greg Lowthian" Date: Thu, 16 Jul 1998 14:43:47 -0700> Greg Lowthian wrote:> > > > It was working fine in 2.2 ODBC/SQL/Emerald> > It quit when I upgrwaded to 2.5.124> > Is there something I need to change or add.> > Actually, that response was to Reid, rather than to yourself. I > would guess> that the upgrade probably messed up your trigger. In isql_w, > execute this:> > Drop Trigger calls_insert> Go> > Then load the rad25_up.sql, highlght the lines from create trigger to> the next go, and execute it. That will put the correct trigger back in.> > What options do you have enabled for RadiusNT?Both Concurrency Control and Variable Login Limit are selectedThere is no reference to Trigger in rad25_up.sql of 6/12/98..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Upgrade to V.90From: "Josh Hillman" Date: Thu, 16 Jul 1998 18:05:52 -0400From: tech I, When I upgrade with maxlink pro my Max 4048, with telnet and tsave, itsaid "save failed, cause request time out"What can I do for upgrade my Max.It partly depends on what version OS you currently have in the Max. Take alook at the "Ugrading system software" section of the following file:ftp://ftp.ascend.com/pub/Software-Releases/Max/Release-6.1.X/6.1.0/doc/m61rn.pdfThe best way to do it is via a direct console connection. The TFTP servercan be anywhere and so can the OS files, so long as they're accessible viathe net without much traffic).I'm using 6.1.0 on my 3 Maxes and haven't run into any problems. I'veheard that 6.1.3 may have a couple problems, but I can't speak fromexperience.Josh Hillmanhillman@talstar.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL ErrorFrom: "greg Lowthian" Date: Thu, 16 Jul 1998 18:08:20 -0700Dale when I try to clear a call from Emerald's On-Line view I get an [SQL Error: Couldn't Clear Call]Any Ideas