[RadiusNT Digest]

radiusnt-digest-request@iea-software.com
Wed, 17 Jun 1998 00:00:38 -0700

Message 1: Framed Address
from "Paul W. Wilcox" <paulw@surfthe.net.au>

Message 2: Emerald documentation
from Glen Harvy <glen@aquarius.com.au>

Message 3: Re: Framed Address
from "Rudy Komsic" <rudyk@cyberglobe.net>

Message 4: unsubscribe
from stoy@lifegate.net

Message 5: Dedicated IP, Connection
from <jason@cnx.net>

Message 6: Re: Radlogs and ASCEND Max 4004
from "Josh Hillman" <admin-maillist@talstar.com>

Message 7: Convert Access 97 to Microsoft SQL Server
from postman@cp-tel.net (Postman Account)

Message 8:
from "Doris Dean" <doris@bc-alter.net>

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

Message 10: Re: Dedicated IP, Connection
from "Dale E. Reed Jr." <daler@iea-software.com>

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

Message 12: Re: RadiusNT 2.5.124 startup problem
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 13: Re: RadiusNT 2.5.124 startup problem
from "2Day Internet" <peter@2day.net.nz>

Message 14: disconnects
from "Richard Pedersen" <rich@cybernet1.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Framed Address
From: "Paul W. Wilcox" <paulw@surfthe.net.au>
Date: Tue, 16 Jun 1998 17:14:18 +1000

I know this question has been asked plenty of times, but I can't seem to get
it to work, I need to give a permanently connected user a fixed IP address.
I have gone into radconfig and set-up the account id, attribute (8), and ip
address, and when I do a radlogin it comes back with the right IP address
(203.22.207.252). However when the actual dial-in happens I get the
following;

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadConfig
rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND
rc.AccountI
=768

User-Service = Framed User (2)
Framed-Protocol = PPP (1)
Framed-Address = 203.22.207.252 (1)
Framed-Compression = Framed Compression (1)
ending Ack of id 157 to cb16cf04 (malibu)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 203.22.207.252
Framed-Compression = Van-Jacobsen-TCP-IP

esp Time: 221 Auth: 27/20 -> 47 Acct: 35/0/0 -> 35
adrecv: Request from host cb16cf04 code=4, id=110, length=192
User-Name = "paulw"
NAS-Identifier = 203.22.207.4
Framed-Protocol = PPP
Framed-Address = 203.22.207.248
Unknown = "0080d380d600"
User-Service = Framed-User
Acct-Status-Type = Start
Acct-Session-Id = "00000a8c35869c5ac18744b6"
NAS-Port-Type = Async
NAS-Port = 20102
NAS-Port-DNIS = "94349999"
Acct-Authentic = RADIUS
eceived unknown attribute 77
Acct-Multi-Session-Id = "2791"
Acct-Link-Count = 1
Unknown = ""
Vendor-Specific = ""

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,FramedProtoco
,FramedAddress,AcctStatusType,AcctSessionId,NASPort,AcctAuthentic) VALUES
(Now(
,'paulw','203.22.207.4',1,'203.22.207.248',1,'00000a8c35869c5ac18744b6',2010
2,1

This leaves the connection with an IP address out of our dial-in pool of
203.22.207.xxx

Am I missing something obvious here?

___________________________

Paul W. Wilcox
Director - Sales and Marketing
Surf The Net Australia
Email: paulw@surfthe.net.au
Web: http://www.surfthe.net.au
Ph: 02 9439 9830
___________________________

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Emerald documentation
From: Glen Harvy <glen@aquarius.com.au>
Date: Tue, 16 Jun 1998 19:04:18 +1000

Hi Dale,

I'm about to transfer the licence of Emerald and will shortly be updating
from the beta RadiusNT that I have been using successfully for yonks :-)

What I need to know now is what is the latest documentation for Emerald as
well as RadiusNT. I think I have them however the Emerald docs have several
sections "Under Construction". Have these sections been completed and
available only for registered licence holders?

Without bothering you to much via this forum, I would like the most
complete and up-to-date documentation and installation text files to work
from.

BTW: Is there a Emerald listserve?

Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
voice(02)9907-9295<>fax(02)9948-1998<>bbs(02)9948-9122<>3:714/930
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Framed Address
From: "Rudy Komsic" <rudyk@cyberglobe.net>
Date: Tue, 16 Jun 1998 07:32:26 -0400

You forgot to mention the Framed-Mask that you would like for that connection.
If it is a Point to Point, set it to 255.255.255.255, if it is a subnet of
that address, add that in.

Hope this helps.

-----Original Message-----
From: Paul W. Wilcox <paulw@surfthe.net.au>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: June 16, 1998 3:25 AM
Subject: Framed Address

>I know this question has been asked plenty of times, but I can't seem to get
>it to work, I need to give a permanently connected user a fixed IP address.
>I have gone into radconfig and set-up the account id, attribute (8), and ip
>address, and when I do a radlogin it comes back with the right IP address
>(203.22.207.252). However when the actual dial-in happens I get the
>following;
>
>SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
>RadConfig
>rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND
>rc.AccountI
>=768
>
> User-Service = Framed User (2)
> Framed-Protocol = PPP (1)
> Framed-Address = 203.22.207.252 (1)
> Framed-Compression = Framed Compression (1)
>ending Ack of id 157 to cb16cf04 (malibu)
> User-Service = Framed-User
> Framed-Protocol = PPP
> Framed-Address = 203.22.207.252
> Framed-Compression = Van-Jacobsen-TCP-IP
>
>esp Time: 221 Auth: 27/20 -> 47 Acct: 35/0/0 -> 35
>adrecv: Request from host cb16cf04 code=4, id=110, length=192
> User-Name = "paulw"
> NAS-Identifier = 203.22.207.4
> Framed-Protocol = PPP
> Framed-Address = 203.22.207.248
> Unknown = "0080d380d600"
> User-Service = Framed-User
> Acct-Status-Type = Start
> Acct-Session-Id = "00000a8c35869c5ac18744b6"
> NAS-Port-Type = Async
> NAS-Port = 20102
> NAS-Port-DNIS = "94349999"
> Acct-Authentic = RADIUS
>eceived unknown attribute 77
> Acct-Multi-Session-Id = "2791"
> Acct-Link-Count = 1
> Unknown = ""
> Vendor-Specific = ""
>
>SQL Statement: INSERT INTO Calls
>(CallDate,UserName,NASIdentifier,FramedProtoco
>,FramedAddress,AcctStatusType,AcctSessionId,NASPort,AcctAuthentic) VALUES
>(Now(
>,'paulw','203.22.207.4',1,'203.22.207.248',1,'00000a8c35869c5ac18744b6',2010
>2,1
>
>
>This leaves the connection with an IP address out of our dial-in pool of
>203.22.207.xxx
>
>Am I missing something obvious here?
>
>___________________________
>
>Paul W. Wilcox
>Director - Sales and Marketing
>Surf The Net Australia
>Email: paulw@surfthe.net.au
>Web: http://www.surfthe.net.au
>Ph: 02 9439 9830
>___________________________
>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: unsubscribe
From: stoy@lifegate.net
Date: Tue, 16 Jun 1998 08:05:21 -0500

unsubscribe

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Dedicated IP, Connection
From: <jason@cnx.net>
Date: Tue, 16 Jun 1998 08:45:30 -0700

Hi, for those of you that have this figured out, I know this must be
annoying, but here it goes:

We have a customer, currently connecting through a LINUX box successfully,
his entry in the users file looks like:

oce Password = "xxxxxx"
User-Service = Framed-User, Framed-Protocol = PPP,
Framed-MTU = 1500,
Framed-Routing = Broadcast-Listen,
Ascend-Send-Auth = Send-Auth-PAP,
Framed-Address = 206.87.114.243,
Framed-Netmask = 255.255.255.0,
Ascend-Idle-Limit = 0,
Framed-Compression = Van-Jacobsen-TCP-IP

I have been told to try to duplicate this entry in the radconfigs table, so
here is what I have in the radconfigs now:

RadConfigID AccountID RadAttributeID Data Value
11 2610 6 Framed-User
12 2610 7 PPP
13 2610 8 206.87.114.243
14 2610 9 255.255.255.0
15 2610 10 Broadcast-Listen
16 2610 12 1500
17 2610 13 Van-Jacobsen-TCP-IP
18 2610 231 Send-Auth-PAP
19 2610 244 0

Does this look right? I am looking for a little confirmation before I put
this guy through another morning with now connectivity.

I have nothing in the value field for any of the records!

Anyway, as always, your help is much appreciated.

Jason Chimney
jason@cnx.net

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Radlogs and ASCEND Max 4004
From: "Josh Hillman" <admin-maillist@talstar.com>
Date: Tue, 16 Jun 1998 12:12:11 -0400

Pat,

The problem you're running into is a bug in the Max OS (talked to Ascend
about this one). Someone else here had a similar problem recently and I
replied with the steps to fix it. I attatched it below...
As for the V.90, on our Max 4004 and 4048, we're using 6.1.0 and have had
no problems at all with it. So far, I think the highest speed that I've
seen connect to us is 50666 or 50667 (something like that). Our 4002 is is
only V.34 and gets hit only if the other two Maxes are full--that still has
6.0.4 on it.

Anyway, here's the fix for your Max:
Check the following:
Ethernet --> Mod Config --> WAN options
Make sure that you have as many IPs in your pool(s) as you have
modems.

Go into your Max and change the following setting:
Ethernet --> Mod Config --> Auth
Auth Pool =
Change it to "No"

You will have to reset the Max after this or you'll never free up the IPs.
After setting and saving the above option:
Hit ^d then d (diagnostics)
Type in:
fsave
fclear
nvr (this resets the max)

Josh Hillman
hillman@talstar.com

> From: Pat Augustine <pata@ilnk.com>
> We've recently installed RadiusNT 2.5 on our backup Radius server, still
> running 2.2 on the primary. Users are signing on (mostly) ok.
> Checking Radlogs (and populating RadLogMsg per your previous message), I
> get the occasional user error. However, the table is also getting 1 entry
> per minute from each of our Maxes that basically says the Max itself
tried
> to login and failed (user not found). The Radlog entry looks like this:
>
> 10 Jun 15 1998 7:57PM pools-Max2.ilnk.com
> ascend (null)
(null)
> (null)
>
> Max2.ilnk.com is the name of the 4004. I see them go by in -x15 mode, as
> well, but I don't know what's causing it. We've upgraded the Max to
6.1.0+
> recently and have been advised by Ascend that it has an IP Pool leak that
> they hope to fix soon, but I don't know if that's related or not.
> Does this make any sense to you at all? Any known issues with Ascend
6.1.0+
> (the first release with v.90)?
>
> In addition, I seem to get little bubbles of unsuccessful logins. During
> the day, suddenly for about 15 minutes it seems everybody is getting a
LAN
> SECURITY ERROR and being rejected and then 15 minutes later, everybody
gets
> in just fine with no changes anywhere. Most of the rejects don't show up
in
> the Radius Logs (either the logfile on disk or the Radlogs table in
Emerald)
> at all, so the Max may just be rejecting them outright, but I don't know
why
> it would do that (I've got excess IP Pools allocated so that the Max
> shouldn't be out of IP addresses and did a Show Pool to verify that I had
at
> least SOME available IP addresses).

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 7 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Convert Access 97 to Microsoft SQL Server
From: postman@cp-tel.net (Postman Account)
Date: Tue, 16 Jun 1998 12:19:55 -0500

Here is a link that might prove useful for someone
wanting to upsize their MS Access 97 database to=20
MS SQL Server...

Convert Access 97 to Microsoft SQL Server
http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm

Microsoft=AE Access Upsizing Tools allows you to create=20
your solution in Microsoft Access and upsize it by moving=20
your database to Microsoft SQL server.

----

Anyone know how well this works for RadiusNT v2.5's
Access97 database? ...any experiences or tips to share?=20

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 8 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Doris Dean" <doris@bc-alter.net>
Date: Tue, 16 Jun 1998 10:17:48 -0700

Dale, I'm getting this message again ... it looks like stopping and starting radius didn't
correct the problem ... so long as I don't turn on ODBC in the radius administrator all of
our clients get authenticated. As soon as the ODBC is turned on they get a dialogue box
asking for a password and radius sends out the message below .... Radius has been working
fine for about a year .. the version we are running is 1.16.6 ... the version of radius
administrator is 1.1

Allocating Statement...

SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate), DateAdd(Day,
sa.extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell