[RadiusNT Digest]

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

Message 1: Re: User id length
from Dale Reed <daler@iea-software.com>

Message 2:
from Gab <gaby@inco.com.lb>

Message 3: getting a route up through radius with 3com Hiper Arc.
from Support Technique <Support@concepta.com>

Message 4: Having problems authenticating with v2.5
from Mike Noel <noel@integrityonline.com>

Message 5: The Incredible Expanding Database
from "Jason Chimney" <jason@cnx.net>

Message 6: Re: The Incredible Expanding Database
from John Lange <radadmin@palacenet.net>

Message 7: Re: The Incredible Expanding Database
from postman@cp-tel.net (Postman Account)

Message 8: Re: The Incredible Expanding Database
from Dale Reed <daler@iea-software.com>

Message 9: Re:
from Dale Reed <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: User id length
From: Dale Reed <daler@iea-software.com>
Date: Fri, 26 Jun 1998 00:04:08 -0700

Beverly Wise wrote:
>
> I have been using the text version of 2.2 RadiusNT for a while now. I have
> put in a few user names longer than 8 characters and it has worked.
>
> Can this cause problems down the line?

Names up to 128 characters are supported (although not recommended).

-- 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: From: Gab <gaby@inco.com.lb>Date: Fri, 26 Jun 1998 12:36:51 +0200

Anyone have any idea whats the maximum amount of SubAccounts one cancreate under a master account in a RadiusNT 2.5.124 SQL database?

Is it unadvisable to create a large amount of subaccounts (4000 or so) underone masteraccount?

Thanx.Gab.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: getting a route up through radius with 3com Hiper Arc.From: Support Technique <Support@concepta.com>Date: Fri, 26 Jun 1998 09:56:24 -0400

We currently have a problem with our Hiper total control hub in setting upa route when a users log's in. We have contacted 3com about this anddidn't get the problem fixed yet. I was wondering if any of you had thisproblem.

Here is the entry of our user in radius user file

loginname Password =3D "*******" =20 User-Service =3D Framed-User, Framed-Route =3D "204.191.73.64/27", Framed-Protocol =3D PPP, Framed-Address =3D 206.116.71.4, Framed-Netmask =3D 255.255.255.255, Framed-Routing =3D None, Framed-Compression =3D Van-Jacobsen-TCP-IP

The user can login fine, get's the right ip but the route doesn't show upin the hiper arc route table so we can't reach his network. If he connect'sto our computone power rack everything is fine (using the same radiusserver).

Any Idea?

Patrice BoucherAdministrateur de r=E9seauSupport@concepta.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Having problems authenticating with v2.5From: Mike Noel <noel@integrityonline.com>Date: Fri, 26 Jun 1998 08:29:03 -0700

I used to have RadiusNT v2.2 set up and working in ODBC mode with SQLServer. But then I decided to upgrade to v2.5. I installed the v2.5software without a problem. The problem seems to be with the database.

I didn't have any real users in the database with v2.2 so I thought thebest bet would be to simply start with the radius97.mdb access database,upsize it to SQL Server, insert my specific data (servers and licensestables) then it would work. Right?

It hasn't worked so far. Through trial and error I've discovered that Ineed to add saExpireDate and Extension to the SubAccounts table and OverDueto the MasterAccounts table. (why weren't these already in Radius97.mdb?)At this point I'm still not able to authenticate. Here is the output I getfrom -x15 on the command line. Why is is not authenticating this user? Isthere an error? I have checked to make sure that the password and usernameare in the SubAcounts table.

Thanks for any info.

-Mike Noel

radrecv: Request from host cdee120f code=1, id=250, length=75 User-Name = "test" Challenge-Response = "\001\037\027\015+\366\013\322\323\026\365zO\365V\217\211" NAS-Identifier = 205.238.18.15 NAS-Port = 26 NAS-Port-Type = Async User-Service = Framed-User Framed-Protocol = PPPrad_authenticate_ODBC() Challenge-Response = "\001\037\027\015+\366\013\322\323\026\365zO\365V\217\211"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccountssa Where (sa.Login='test' or sa.Shell='test' or sa.Email='test') ANDma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

SQL Statement: RadGetConfigs 1

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs 'PPP'

Framed-Protocol = PPP (1) User-Service = Framed-User (2) Session-Timeout = 7200 (7200) Framed-Netmask = 255.255.255.254 (0) Framed-MTU = 255.255.255.254 (2400) Framed-Compression = Van-Jacobsen-TCP-IP (2400)Sending Ack of id 250 to cdee120f (pm7.pdx.integrityonline.com) Framed-Protocol = PPP User-Service = Framed-User Session-Timeout = 7200 Framed-Netmask = 255.255.255.254 Framed-MTU = 2400 Framed-Compression = 2400

Resp Time: 110 Auth: 11/0 -> 11 Acct: 0/1/0 -> 1

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: The Incredible Expanding DatabaseFrom: "Jason Chimney" <jason@cnx.net>Date: Fri, 26 Jun 1998 09:05:37 -0700

Hi, we are using RadiusNT to authenticate against an MSAccess database. Ihave noticed that after about 24hours of running this database has grownfrom about 7MB to over 100MB in size. I have needed to stop the RadiusNTservice (not good) and compact/repair the database to return it to a moremanageable size.

Anybody have an idea what I am doing wrong?

Thanks,

Jason

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: John Lange <radadmin@palacenet.net>Date: Fri, 26 Jun 1998 11:45:15 -0500

HI

In the RadiusNT Admin only turn on User & General Debug. Leave ODBC & Fileoff. That should help.

JOhn :}

At 09:05 AM 6/26/1998 -0700, you wrote:>Hi, we are using RadiusNT to authenticate against an MSAccess database. I>have noticed that after about 24hours of running this database has grown>from about 7MB to over 100MB in size. I have needed to stop the RadiusNT>service (not good) and compact/repair the database to return it to a more>manageable size.>>Anybody have an idea what I am doing wrong?>>Thanks,>>Jason>>>

John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html

--- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: postman@cp-tel.net (Postman Account)Date: Fri, 26 Jun 1998 12:16:23 -0500

Unfortunately, I think this is the nature of RadiusNT v2.5 when using Access97.... it explodes in size... constantly... not sure if this is a bug.

Our RadiusNT v2.5 database grows very rapidly and has to be compacted at least once a day... it doubles... and triples in size... every 24 hours... debugging is off.

Although, we never had this problem under RadiusNT v1.6.

Usually, it'll be recommended for you to buy MS SQL server... and run it with RadiusNT.

At 09:05 AM 6/26/98 -0700, you wrote:>Hi, we are using RadiusNT to authenticate against an MSAccess database. I>have noticed that after about 24hours of running this database has grown>from about 7MB to over 100MB in size. I have needed to stop the RadiusNT>service (not good) and compact/repair the database to return it to a more>manageable size.>>Anybody have an idea what I am doing wrong?>>Thanks,>>Jason>>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: Dale Reed <daler@iea-software.com>Date: Fri, 26 Jun 1998 12:33:03 -0700

John Lange wrote:> > In the RadiusNT Admin only turn on User & General Debug. Leave ODBC & File> off. That should help.

Good thought, but the debug mode doesn't have anything to do with thedatabase size. :(

> JOhn :}> > At 09:05 AM 6/26/1998 -0700, you wrote:> >Hi, we are using RadiusNT to authenticate against an MSAccess database. I> >have noticed that after about 24hours of running this database has grown> >from about 7MB to over 100MB in size. I have needed to stop the RadiusNT> >service (not good) and compact/repair the database to return it to a more> >manageable size.> >> >Anybody have an idea what I am doing wrong?> >> >Thanks,> >> >Jason> >> >> >> > John C. Lange, Sr. PALACE dot NET, INC.> microjl@palacenet.net MICRO-TECH Computers, Inc.> 608.742.1601 & 6980 2800 New Pinery Road> http://www.palacenet.net/ Portage, WI 53901> Visit our online store @ http://www.microt.com/> Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html> > --- __o> --- _-\<,_ Fastest Service in Town> --- (_)/ (_)

-- 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:From: Dale Reed <daler@iea-software.com>Date: Fri, 26 Jun 1998 15:39:20 -0700

Gab wrote:> > Anyone have any idea whats the maximum amount of SubAccounts one can> create under a master account in a RadiusNT 2.5.124 SQL database?> > Is it unadvisable to create a large amount of subaccounts (4000 or so) under> one masteraccount?

There isn't a basic limit. RadiusNT doesn't care about the numberof master or subacccounts, just that there is a relationship betweenthe two.

-- 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