[RadiusNT Digest]

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

Message 1: Can't find users?
from "David Sovereen" <support@tm.net>

Message 2: Problems with calls table
from "James B. Hrdy" <jhrdy@greensoft.com>

Message 3: Re: Can't find users?
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 4: RadLogs Ascend
from postman@cp-tel.net (Postman Account)

Message 5: Re: Problems with calls table
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 6: Re: 1605 Errors
from "James B. Hrdy" <jhrdy@greensoft.com>

Message 7: Re: 1605 Errors
from "Youssef A. Rhaman" <yrahman@alexcomm.net>

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

Message 9: unsubscribe
from Mike Cowan <mikec@accnorwalk.com>

Message 10: subscribe
from "Michael Abrams" <mike@solutions2000.net>

Message 11: Calls table not functioning, Calls online not functioning
from "James B. Hrdy" <jhrdy@greensoft.com>

Message 12: RadiusNT Version 2.5x
from "James B. Hrdy" <jhrdy@greensoft.com>

Message 13: ServerAccess
from "Ciro Vera" <cirovera@interaccess.cl>

Message 14: Radius Setup
from rabaut <rabaut@hcc.cc.fl.us>

Message 15: Re: Radius Setup
from Dale Reed <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Can't find users?
From: "David Sovereen" <support@tm.net>
Date: Tue, 23 Jun 1998 09:53:17 -0400

We're getting the following in our logfile:

Mon Jun 22 19:00:23 1998: User: bcroz Not found
Mon Jun 22 19:00:32 1998: User: bcroz Not found
Mon Jun 22 20:08:20 1998: User: jovarner Not found
Mon Jun 22 20:09:17 1998: User: oberdorf Not found
Mon Jun 22 20:09:24 1998: User: oberdorf Not found
Mon Jun 22 20:09:32 1998: User: oberdorf Not found
Mon Jun 22 20:09:34 1998: User: oberdorf Not found
Mon Jun 22 20:10:52 1998: User: zzz Not found
Mon Jun 22 20:10:59 1998: User: zzz Not found
Mon Jun 22 20:11:08 1998: User: zzz Not found
Mon Jun 22 20:11:12 1998: User: oberdorf Not found
Mon Jun 22 20:11:19 1998: User: oberdorf Not found
Mon Jun 22 20:11:30 1998: User: oberdorf Not found
Mon Jun 22 20:11:41 1998: User: oberdorf Not found
Mon Jun 22 20:12:45 1998: User: zzz Not found
Mon Jun 22 20:13:04 1998: User: zzz Not found
Mon Jun 22 20:13:07 1998: User: zzz Not found
Mon Jun 22 20:13:08 1998: User: zzz Not found
Mon Jun 22 20:13:10 1998: User: zzz Not found
Mon Jun 22 20:13:17 1998: User: zzz Not found

They tend to happen for short periods of time. Notice that most of these
were in a 4 minute window of time. I received a call from oberdorf saying
she could not get online. We'll get a few screenfuls of these each day, and
the timestamps tend to show pockets of time where RadiusNT cannot find
people. These are infrequent, but puzzling, and problematic. They'll stop
for up to many hours and then a few will show up again. Any ideas?

We're running RadiusNT 2.2 with an Access97 database on a well loaded P-166,
128MB RAM.

Dave

=====================================================
I N T E R N E T F O R B U S I N E S S
Mercury Network http://www.tm.net/
314 W Wackerly St, Ste 400 Voice: 517/837-3790
Midland, MI 48640-2766 Fax: 517/837-3780
=====================================================

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Problems with calls table
From: "James B. Hrdy" <jhrdy@greensoft.com>
Date: Tue, 23 Jun 1998 09:07:58 +0000

Hi, I am re-submitting this problem with an additional question. Could this be from a
accountid problem. Anyone on the list know what an ascend needs in radat info area ?

Running RadiusNT with the latest update.
Ascend 4048 with latest software update.
Ascend Database
Allowmalformed packets checked
Concurrency and manual calls update checked

Problem: Calls table is inaccurate and causing the concurrency to not work correctly.
RadiusNT thinks the user is still logged in.

Any hints from anyone ?

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Session-Timeout = 7200 (7200)
Sending Ack of id 157 to d01a1663 (route-1)
Framed-Protocol = PPP
User-Service = Framed-User
Session-Timeout = 7200

Resp Time: 4066 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host d01a1663 code=4, id=48, length=112
User-Name = &quotUser-Name"
NAS-Identifier = 10.0.0.1
NAS-Port = 20201
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = &quot266236811"
Acct-Authentic = RADIUS
Caller-Id = &quotxxxxx"
NAS-Port-DNIS = &quotxxxx"
Framed-Protocol = PPP
Framed-Address = xxxxx

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,
AcctSessionId,CallerId,FramedAddress) VALUES
(Now(),'hannibal','correctip',20201,0,1,0,'26623681','correctid','correctaddress')

ODBC Error:23000:-1605:
[Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table
were not successful because they would create duplicate values in the index, primary key,
or relationship. Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again.

Sending Accounting Ack of id 48 to d01a1663 (route-1)

Resp Time: 1862 Auth: 1/0 -> 1 Acct: 1/0/1 -> 2
radrecv: Request from host d01a1663 code=4, id=49, length=89
NAS-Identifier = NAS-Identifier
NAS-Port = 20202
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = &quot266236812"
Acct-Authentic = Local
Caller-Id = &quotCaller-Id"
NAS-Port-DNIS = &quotDNIS"

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,AcctSessi
onId,CallerId, UserName) VALUES (Now(),'ipaddr',20202,0,1,0,'26623681','callerid','NULL')

Incomplete accounting record. CallsOnline not updated
Sending Accounting Ack of id 49 to d01a1663 (route-1)

Resp Time: 3084 Auth: 1/0 -> 1 Acct: 2/0/1 -> 3
radrecv: Request from host d01a1663 code=4, id=50, length=185
NAS-Identifier = NAS-Identifier
NAS-Port = 20202
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = &quot266236812"
Acct-Authentic = Local
Acct-Session-Time = 28
Acct-Input-Octets = 435
Acct-Output-Octets = 474
Acct-Input-Packets = 0
Acct-Output-Packets = 0
Ascend-Disconnect-Cause = 11
Ascend-Connect-Progress = 40
Ascend-Xmit-Rate = 33600
Ascend-Data-Rate = 26400
Ascend-PreSession-Time = 20
Ascend-Pre-Input-Octets = 0
Ascend-Pre-Output-Octets = 0
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-Modem-PortNo = 15
Ascend-Modem-SlotNo = 4
Caller-Id = &quotCaller-Id"
NAS-Port-DNIS = &quot3221896"

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,AcctSessi
onId,AcctSessionTime,AcctInputOctets,AcctOutputOctets,CallerId, UserName) VALUES
(Now(),'ipaddr',20202,0,2,0,'26623681',28,435,474,'callerid','NULL')

Incomplete accounting record. CallsOnline not updated
Sending Accounting Ack of id 50 to d01a1663 (route-1)

Resp Time: 591 Auth: 1/0 -> 1 Acct: 3/0/1 -> 4
radrecv: Request from host d01a1663 code=1, id=158, length=104
User-Name = &quotgregchris"
Password = &quotpassword"
NAS-Identifier = NAS-Identifier
NAS-Port = 20202
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
Caller-Id = &quotCallerId"
NAS-Port-DNIS = &quot3221896"
Acct-Session-Id = &quot266236813"
rad_authenticate_ODBC()
Password = &quotpassword"

SQL Statement: Select DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)),
DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)), sa.AccountID,
sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma,
SubAccounts sa Where (sa.Login='gregchris' or sa.Shell='gregchris') AND
ma.CustomerID=sa.CustomerID and sa.Active<&gt0 and ma.Active<&gt0

Decrypted Password: correct
Database Password: correct
Checking for duplicate logins.

SQL Statement: Select Count(Username) From ServerPorts Where Username='gregchris'
and AcctStatusType=1

gregchris found on-line 0 time(s).

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID,
rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes ra Where
ra.RadAttributeID=rc.RadAttributeID AND rc.AccountID=71

James B. Hrdy
email: jhrdy@greensoft.com
web: http://www.greensoft.com/billing
GreenSoft Solutions, Inc.
Voice: 785.843.8683 ext 203
2317 Ponderosa Drive
Fax: 785.840.0055
Lawrence, Ks.
United States of America

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Can't find users?
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Tue, 23 Jun 1998 07:30:07 -0700

David Sovereen wrote:
>
> We're getting the following in our logfile:
>
> Mon Jun 22 19:00:23 1998: User: bcroz Not found
> Mon Jun 22 19:00:32 1998: User: bcroz Not found
> Mon Jun 22 20:08:20 1998: User: jovarner Not found
> Mon Jun 22 20:09:17 1998: User: oberdorf Not found
> Mon Jun 22 20:09:24 1998: User: oberdorf Not found
> Mon Jun 22 20:09:32 1998: User: oberdorf Not found
> Mon Jun 22 20:09:34 1998: User: oberdorf Not found
> Mon Jun 22 20:10:52 1998: User: zzz Not found
> Mon Jun 22 20:10:59 1998: User: zzz Not found
> Mon Jun 22 20:11:08 1998: User: zzz Not found
> Mon Jun 22 20:11:12 1998: User: oberdorf Not found
> Mon Jun 22 20:11:19 1998: User: oberdorf Not found
> Mon Jun 22 20:11:30 1998: User: oberdorf Not found
> Mon Jun 22 20:11:41 1998: User: oberdorf Not found
> Mon Jun 22 20:12:45 1998: User: zzz Not found
> Mon Jun 22 20:13:04 1998: User: zzz Not found
> Mon Jun 22 20:13:07 1998: User: zzz Not found
> Mon Jun 22 20:13:08 1998: User: zzz Not found
> Mon Jun 22 20:13:10 1998: User: zzz Not found
> Mon Jun 22 20:13:17 1998: User: zzz Not found
>
> They tend to happen for short periods of time. Notice that most of these
> were in a 4 minute window of time. I received a call from oberdorf saying
> she could not get online. We'll get a few screenfuls of these each day, and
> the timestamps tend to show pockets of time where RadiusNT cannot find
> people. These are infrequent, but puzzling, and problematic. They'll stop
> for up to many hours and then a few will show up again. Any ideas?
>
> We're running RadiusNT 2.2 with an Access97 database on a well loaded P-166,
> 128MB RAM.

Its most likely an issue with MS Access. You may want to compact your
database on a regular basis. To really find out whats going on,
define an accounting and authentication logfile and let RadiusNT
run. Then go back and search the logfile for the user until you
find the error and look what caused it (or what error you received).

-- 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: RadLogs AscendFrom: postman@cp-tel.net (Postman Account)Date: Tue, 23 Jun 1998 09:41:22 -0500

Whenever we reboot... some of our MAXs pass this to ourRadius server... others don't... any ideas/suggestions?is this normal?

RadLogMsgID LogDate Username Data10 6/21/98 12:56:45 PM initial-banner ascend10 6/21/98 12:56:44 PM bridge-Max2-1 ascend10 6/21/98 12:56:44 PM dovbs-1 ascend10 6/21/98 12:56:44 PM banner ascend10 6/21/98 12:56:44 PM route-Max2-1 ascend10 6/21/98 12:56:44 PM initial-banner-M ascend10 6/21/98 12:56:44 PM pools-Max2 ascend10 6/21/98 12:56:44 PM permconn-Max2-1 ascend10 6/21/98 12:56:44 PM ipxroute-Max2-1 ascend10 6/21/98 12:56:44 PM ipxroute-1 ascend10 6/21/98 12:56:44 PM route-1 ascend10 6/21/98 12:56:44 PM dovbs-Max2-1 ascend10 6/21/98 12:56:44 PM frdlink-Max2-1 ascend

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Problems with calls tableFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 23 Jun 1998 07:41:54 -0700

James B. Hrdy wrote:> > Problem: Calls table is inaccurate and causing the concurrency to not work correctly.> RadiusNT thinks the user is still logged in.

Check the Accounting timeout on the Ascend. Sometimes its set to low and willcause problems. It should be atleast 5. > ODBC Error:23000:-1605:> [Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table> were not successful because they would create duplicate values in the index, primary key,> or relationship. Change the data in the field or fields that contain duplicate data, remove> the index, or redefine the index to permit duplicate entries and try again.> > Sending Accounting Ack of id 48 to d01a1663 (route-1)> Resp Time: 1862 Auth: 1/0 -> 1 Acct: 1/0/1 -> 2

This just means we have already seen this request. Your response times are rather high and will most likely cause problems in busy siutations.(MS Access can vary quite a bit and can be prolematic). > radrecv: Request from host d01a1663 code=4, id=49, length=89> NAS-Identifier = NAS-Identifier> NAS-Port = 20202> NAS-Port-Type = Async> Acct-Status-Type = Start> Acct-Delay-Time = 0> Acct-Session-Id = &quot266236812"> Acct-Authentic = Local> Caller-Id = &quotCaller-Id"> NAS-Port-DNIS = &quotDNIS"> > SQL Statement: INSERT INTO Calls> (CallDate,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,AcctSessi> onId,CallerId, UserName) VALUES (Now(),'ipaddr',20202,0,1,0,'26623681','callerid','NULL')> > Incomplete accounting record. CallsOnline not updated> Sending Accounting Ack of id 49 to d01a1663 (route-1)

There is not username in this accounting packet. Although RadiusNT could enter a blank calls-online entry, its pretty useless.

-- 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: Re: 1605 ErrorsFrom: "James B. Hrdy" <jhrdy@greensoft.com>Date: Tue, 23 Jun 1998 11:54:01 +0000

I have an access database, and I too am getting errors. The ascend is set to 60 for a timeout and I have it set to 5 retrys. One of the things I see looking in the calls table is duplicated AccountSessionId 's Sometimes there may be 6 ids for 3 different logins.

James B. Hrdyemail: jhrdy@greensoft.comweb: http://www.greensoft.com/billingGreenSoft Solutions, Inc.Voice: 785.843.8683 ext 2032317 Ponderosa DriveFax: 785.840.0055Lawrence, Ks.United States of America

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: 1605 ErrorsFrom: "Youssef A. Rhaman" <yrahman@alexcomm.net>Date: Tue, 23 Jun 1998 20:18:24 +0300

Check to see how many digits are in the AccountSessionId column, I had the same problem and wasable to solve it by increasing the number of the digits from 8 to 10 as the Ascend generates a10 digits Id, there for the last 2 digits are neglected by the data base. That will most likelysolve the problem.

Youssef A. RahmanExecutive ManagerAlexComm, Internet Service Provicer

James B. Hrdy wrote:

> I have an access database, and I too am getting errors. The ascend is set to 60 for a> timeout and I have it set to 5 retrys. One of the things I see looking in the calls table is> duplicated AccountSessionId 's Sometimes there may be 6 ids for 3 different logins.>> James B. Hrdy> email: jhrdy@greensoft.com> web: http://www.greensoft.com/billing> GreenSoft Solutions, Inc.> Voice: 785.843.8683 ext 203> 2317 Ponderosa Drive> Fax: 785.840.0055> Lawrence, Ks.> United States of America

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: 1605 ErrorsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 23 Jun 1998 10:58:47 -0700

James B. Hrdy wrote:> > I have an access database, and I too am getting errors. The ascend is set to 60 for a> timeout and I have it set to 5 retrys. One of the things I see looking in the calls table is> duplicated AccountSessionId 's Sometimes there may be 6 ids for 3 different logins.

Acct-Session-ID is required by the RFC to be unique during a nominalamount of time (something longer than a month) per sesion. If themax is sending the same Acct-Session-ID for multiple sessions,then thats a serious bug and Ascend should be notified.

-- 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: unsubscribeFrom: Mike Cowan <mikec@accnorwalk.com>Date: Tue, 23 Jun 1998 14:06:59 -0400

unsubscribe

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: subscribeFrom: "Michael Abrams" <mike@solutions2000.net>Date: Tue, 23 Jun 1998 14:43:26 -0300

This is a multi-part message in MIME format.

------=_NextPart_000_001A_01BD9EB5.47EFA9C0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

subscribe

------=_NextPart_000_001A_01BD9EB5.47EFA9C0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

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

subscribe

------=_NextPart_000_001A_01BD9EB5.47EFA9C0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Calls table not functioning, Calls online not functioningFrom: "James B. Hrdy" Date: Tue, 23 Jun 1998 16:32:20 +0000Here is the debug info from a different install of RadiusNT, but with asimilar problem. The calls online isnt working. NAS here is a USRTotal Control rack0) IgnoreCase: 01) TrimName: 00) IgnoreCase: 01) TrimName: 02) AuthPort: 16453) ReqAcctAuth: 04) AllowMalformed: 05) AcctPort: 16466) Mode: 17) Proxy: 08) Options: 39) Debug: 010) LogFile: 11) AcctLogFile: 12) ODBCDatasource: radius13) Username: 14) Password: 15) AcctODBCDatasource: 16) AcctUsername: 17) AcctPassword: 18) DataDirectory: 19) AcctDirectory: 20) UsersFile: Users21) CompanyName: XXXXXXXXXXXXXXXXXXXXX22) License: XXXXXXXXXXXXXXXXXXXXXXXXXX23) IPAddress: XXXXXXXXXXXXXXXXXXParam: Debug Level: 15Initializing Winsock...ODBC Datasource: 'radius'...Making ODBC Connection...MS Access Mode EnabledODBC Datasource: 'radius'...Making ODBC Connection...MS Access Mode EnabledLicensed MBRs: 3000Allocating Statement... SQL Statement: Select Name, RadAttributeID, Type From RadAttributes SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, RadAttributes ra Where rv.RadAttributeID = ra.RadAttributeID 118 Dictionary Attributes Loaded... SQL Statement: Select Server, IPAddress, Secret From Servers 2 Clients LoadedAccounting Column 0 (16): 'NASIdentifier'Accounting Column 1 (4): 'NASPort'Accounting Column 2 (8): 'AcctSessionId'Accounting Column 3 (2): 'AcctStatusType'Accounting Column 4 (16): 'CallDate'Accounting Column 5 (12): 'UserName'Accounting Column 6 (4): 'AcctDelayTime'Accounting Column 7 (4): 'AcctSessionTime'Accounting Column 8 (16): 'FramedAddress'Accounting Column 9 (4): 'AcctInputOctets'Accounting Column 10 (4): 'AcctOutputOctets'Accounting Column 11 (2): 'NASPortType'Accounting Column 12 (10): 'ClientPortDNIS'Accounting Column 13 (16): 'CallerID'Accounting Column 14 (32): 'ConnectInfo' 15 Accounting Columns Loaded Enterprise features enabled.RadiusNT (Emerald Standard) Initialized...radrecv: Request from host 97c95a15 code=4, id=148, length=246 User-Name = "xxxxxxxx" NAS-Identifier = 000.000.000.000 Acct-Status-Type = Start Acct-Session-Id = "4b020e00" Acct-Delay-Time = 0 Acct-Authentic = RADIUS User-Service = Framed-User NAS-Port = 28 Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Caller-Id = "1.123.123.1234" NAS-Port-DNIS = "7286981" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Framed-Protocol = PPP Framed-Address = xxxxxxxxxx Vendor-Specific = ""Received unknown attribute 51Received unknown attribute 50 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,CallerId,FramedAddress) VALUES (Now(),'xxxxxxxx','000.000.000.000',1,'4b020e00',0,28,'1.123.123.1234','xxxxxxxxxx')ODBC Error:23000:-1605: [Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.Sending Accounting Ack of id 148 to 97c95a15 (USRTc)Resp Time: 20 Auth: 2/0 -> 2 Acct: 1/0/1 -> 2radrecv: Request from host 97c95a15 code=4, id=149, length=282 User-Name = "xxxxxxxx" NAS-Identifier = 000.000.000.000 Acct-Status-Type = Stop Acct-Session-Id = "4b020e00" Acct-Delay-Time = 0 Acct-Authentic = RADIUS User-Service = Framed-User NAS-Port = 28 Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Caller-Id = "1.123.123.1234" NAS-Port-DNIS = "7286981" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Framed-Protocol = PPP Framed-Address = xxxxxxxxxx Vendor-Specific = ""Received unknown attribute 51Received unknown attribute 50 Acct-Session-Time = 16 Acct-Terminate-Cause = User-Request Acct-Input-Octets = 776 Acct-Output-Octets = 1252 Acct-Input-Packets = 20 Acct-Output-Packets = 21 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,CallerId,FramedAddress,AcctSessionTime,AcctInputOctets,AcctOutputOctets) VALUES (Now(),'xxxxxxxx','000.000.000.000',2,'4b020e00',0,28,'1.123.123.1234','xxxxxxxxxx',16,776,1252) SQL Statement: UPDATE CallsOnline Set Username='xxxxxxxx',AcctStatusType=2, CallDate=Now, FramedAddress='xxxxxxxxxx' WHERE NASIdentifier='000.000.000.000' and NASPort=28 AND (DateAdd('s', 0-2, Now) >= CallDate OR CallDate IS NULL)Sending Accounting Ack of id 149 to 97c95a15 (USRTc)Resp Time: 30 Auth: 2/0 -> 2 Acct: 2/0/1 -> 3radrecv: Request from host 97c95a15 code=4, id=149, length=282 User-Name = "xxxxxxxx" NAS-Identifier = 000.000.000.000 Acct-Status-Type = Stop Acct-Session-Id = "4b020e00" Acct-Delay-Time = 0 Acct-Authentic = RADIUS User-Service = Framed-User NAS-Port = 28 Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Caller-Id = "1.123.123.1234" NAS-Port-DNIS = "7286981" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Framed-Protocol = PPP Framed-Address = xxxxxxxxxx Vendor-Specific = ""Received unknown attribute 51Received unknown attribute 50 Acct-Session-Time = 16 Acct-Terminate-Cause = User-Request Acct-Input-Octets = 776 Acct-Output-Octets = 1252 Acct-Input-Packets = 20 Acct-Output-Packets = 21 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,CallerId,FramedAddress,AcctSessionTime,AcctInputOctets,AcctOutputOctets) VALUES (Now(),'xxxxxxxx','000.000.000.000',2,'4b020e00',0,28,'1.123.123.1234','xxxxxxxxxx',16,776,1252)ODBC Error:23000:-1605: [Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.Sending Accounting Ack of id 149 to 97c95a15 (USRTc)Resp Time: 20 Auth: 2/0 -> 2 Acct: 2/0/2 -> 4radrecv: Request from host 97c95a15 code=1, id=31, length=142 User-Name = "xxxxxxxx" Challenge-Response = "\003\272\234\010\344\215K\250\014\340\320Z\253\326[.\327" Framed-Protocol = PPP NAS-Identifier = 000.000.000.000 NAS-Port = 28 User-Service = Framed-User Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" NAS-Port-DNIS = "7286981" Caller-Id = "1.123.123.1234" NAS-Port-Type = Asyncrad_authenticate_ODBC() Challenge-Response = "\003\272\234\010\344\215K\250\014\340\320Z\253\326[.\327" SQL Statement: Select DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)), DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='xxxxxxxx' or sa.Shell='xxxxxxxx' or sa.Email='xxxxxxxx') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0Checking for duplicate logins. SQL Statement: Select Count(Username) From ServerPorts Where Username='xxxxxxxx' and AcctStatusType=1 xxxxxxxx found on-line 0 time(s). SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountID=3448Loading radius defaults for this type... SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadATConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountType='PPP' Framed-Protocol = PPP (1) User-Service = Framed-User (2) Session-Timeout = 7200 (7200)Sending Ack of id 31 to 97c95a15 (USRTc) Framed-Protocol = PPP User-Service = Framed-User Session-Timeout = 7200Resp Time: 100 Auth: 3/0 -> 3 Acct: 2/0/2 -> 4radrecv: Request from host 97c95a15 code=4, id=150, length=246 User-Name = "xxxxxxxx" NAS-Identifier = 000.000.000.000 Acct-Status-Type = Start Acct-Session-Id = "4c020e00" Acct-Delay-Time = 0 Acct-Authentic = RADIUS User-Service = Framed-User NAS-Port = 28 Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Caller-Id = "1.123.123.1234" NAS-Port-DNIS = "7286981" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Framed-Protocol = PPP Framed-Address = Vendor-Specific = ""Received unknown attribute 51Received unknown attribute 50 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,CallerId,FramedAddress) VALUES (Now(),'xxxxxxxx','000.000.000.000',1,'4c020e00',0,28,'1.123.123.1234','')ODBC Error:23000:-1605: [Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.Sending Accounting Ack of id 150 to 97c95a15 (USRTc)Resp Time: 20 Auth: 4/0 -> 4 Acct: 3/0/3 -> 6radrecv: Request from host 97c95a15 code=4, id=151, length=282 User-Name = "xxxxxxxx" NAS-Identifier = 000.000.000.000 Acct-Status-Type = Stop Acct-Session-Id = "4c020e00" Acct-Delay-Time = 0 Acct-Authentic = RADIUS User-Service = Framed-User NAS-Port = 28 Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Caller-Id = "1.123.123.1234" NAS-Port-DNIS = "7286981" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Framed-Protocol = PPP Framed-Address = Vendor-Specific = ""Received unknown attribute 51Received unknown attribute 50 Acct-Session-Time = 13 Acct-Terminate-Cause = User-Request Acct-Input-Octets = 387 Acct-Output-Octets = 362 Acct-Input-Packets = 15 Acct-Output-Packets = 13 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,CallerId,FramedAddress,AcctSessionTime,AcctInputOctets,AcctOutputOctets) VALUES (Now(),'xxxxxxxx','000.000.000.000',2,'4c020e00',0,28,'1.123.123.1234','',13,387,362) SQL Statement: UPDATE CallsOnline Set Username='xxxxxxxx',AcctStatusType=2, CallDate=Now, FramedAddress='' WHERE NASIdentifier='000.000.000.000' and NASPort=28 AND (DateAdd('s', 0-2, Now) >= CallDate OR CallDate IS NULL)Sending Accounting Ack of id 151 to 97c95a15 (USRTc)Resp Time: 30 Auth: 4/0 -> 4 Acct: 4/0/3 -> 7radrecv: Request from host 97c95a15 code=4, id=151, length=282 User-Name = "xxxxxxxx" NAS-Identifier = 000.000.000.000 Acct-Status-Type = Stop Acct-Session-Id = "4c020e00" Acct-Delay-Time = 0 Acct-Authentic = RADIUS User-Service = Framed-User NAS-Port = 28 Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Caller-Id = "1.123.123.1234" NAS-Port-DNIS = "7286981" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Vendor-Specific = "" Framed-Protocol = PPP Framed-Address = Vendor-Specific = ""Received unknown attribute 51Received unknown attribute 50 Acct-Session-Time = 13 Acct-Terminate-Cause = User-Request Acct-Input-Octets = 387 Acct-Output-Octets = 362 Acct-Input-Packets = 15 Acct-Output-Packets = 13 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,CallerId,FramedAddress,AcctSessionTime,AcctInputOctets,AcctOutputOctets) VALUES (Now(),'xxxxxxxx','000.000.000.000',2,'4c020e00',0,28,'1.123.123.1234','',13,387,362)ODBC Error:23000:-1605:James B. Hrdyemail: jhrdy@greensoft.comweb: http://www.greensoft.com/billingGreenSoft Solutions, Inc.Voice: 785.843.8683 ext 2032317 Ponderosa DriveFax: 785.840.0055Lawrence, Ks.United States of America..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNT Version 2.5xFrom: "James B. Hrdy" Date: Tue, 23 Jun 1998 17:00:46 +0000Does anyone have the 2.5x version running successfully with an access database and either a usrtotal control rack or an ascend 40XX box ?James B. Hrdyemail: jhrdy@greensoft.comweb: http://www.greensoft.com/billingGreenSoft Solutions, Inc.Voice: 785.843.8683 ext 2032317 Ponderosa DriveFax: 785.840.0055Lawrence, Ks.United States of America..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: ServerAccessFrom: "Ciro Vera" Date: Tue, 23 Jun 1998 17:59:44 -0000This is a multi-part message in MIME format.------=_NextPart_000_01BD9ED0.B3E530D0Content-Type: text/plain; charset=ISO-8859-1Content-Transfer-Encoding: 8bitHi' Dale, AllI'm testing Server Access in Radius NT 2.5.124, and look that StartTime andStopTimefield of Serveraccess table not work correctly. Current time is 1045 (minutes past midnight ), and StartTime=0,StopTime=100 thenI think that a PPP user is allowed to login only between Starttime andStoptime, but at current Time the authentification is done and PPP users is allowedto login :(The following thing I have done, 1 CREATE PROCEDURE RadCheckPort as say in Radius NT 2.5 documentation2 Insert register in ServerAccess Table for AccountType=PPPServerID Port AccountType StartTime StopTime MaxSessionLength ----------- ---------- --------------- ----------- ----------- ---------------- 12 (null) PPP 0 100 100 3 run radlogin cirovera xxxxx and .....radrecv: Request from host ce308e04 code=1, id=239, length=60 NAS-Identifier = 127.0.0.1 NAS-Port = 0 User-Name = "cirovera" Password = "\230+\244~r\351>K\032\333\2756b+_3"rad_authenticate_ODBC() Password = "\230+\244~r\351>K\032\333\2756b+_3" 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, sa.TimeLeft, sa.LoginLimit FromMasterAccounts ma, SubAccounts sa Where (sa.Login='cirovera' orsa.Shell='cirovera') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 andma.Active<>0 Decrypted Password:xxxxx Database Password: xxxxxChecking for duplicate logins. SQL Statement: RadCheckOnline 'cirovera' cirovera found on-line 0 time(s).Checking for port access. SQL Statement: RadCheckPort '127.0.0.1', 0, 'PPP' SQL Statement: RadGetConfigs 1 User-Service = 2 (2) Framed-Protocol = 1 (1) Framed-Routing = 0 (0) Ascend-Assign-IP-Pool = 5 (5) Ascend-Idle-Limit = 0 (0)Sending Ack of id 239 to ce308e04 (lobo.interaccess.cl) User-Service = Framed-User Framed-Protocol = PPP Framed-Routing = None Ascend-Assign-IP-Pool = 5 Ascend-Idle-Limit = 0Thank'sciro------=_NextPart_000_01BD9ED0.B3E530D0Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: quoted-printable

Hi' Dale, All

I'm testing Server =Access in Radius NT 2.5.124, and look that StartTime and =StopTime
field of Serveraccess table not work correctly. =

Current time is 1045 (minutes past midnight ), and =StartTime=3D0, StopTime=3D100 then
I think that a PPP user is allowed =to login only between Starttime and Stoptime,
but at current Time = the authentification is done and PPP users is allowed to login =:(



The following thing  I have done,
1=B0 CREATE =PROCEDURE RadCheckPort as say in Radius NT 2.5 documentation

2=B0 =Insert register in ServerAccess Table for =AccountType=3DPPP

ServerID Port AccountType StartTi=me StopTime MaxSessionLength =
----------- ---------- --------------- = ----------- ----------- ---------------- =
12 (null) PPP 0 100 =100 =            &=nbsp;



3=B0  run radlogin cirovera xxxxx and = .....

radrecv: Request from host ce308e04 code=3D1, =id=3D239, length=3D60
   NAS-Identifier =3D =127.0.0.1
   NAS-Port =3D 0
=   User-Name =3D "cirovera"
=   Password =3D ="\230+\244~r\351>K\032\333\2756b+_3"
rad_authenticate_ODB=C()
   Password =3D ="\230+\244~r\351>K\032\333\2756b+_3"

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, sa.TimeLeft, =sa.LoginLimit From MasterAccounts ma, SubAccounts sa  Where =(sa.Login=3D'cirovera' or sa.Shell=3D'cirovera') AND =ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 and =ma.Active<>0

Decrypted Password:xxxxx
Database =Password: xxxxx
Checking for duplicate logins.

SQL Statement: =RadCheckOnline 'cirovera'

     cirovera =found on-line 0 time(s).
Checking for port access.

SQL =Statement: RadCheckPort '127.0.0.1', 0, 'PPP'


SQL =Statement: RadGetConfigs 1

=     User-Service =3D 2 (2)
=     Framed-Protocol =3D 1 (1)
=     Framed-Routing =3D 0 (0)
=     Ascend-Assign-IP-Pool =3D 5 (5)
=     Ascend-Idle-Limit =3D 0 (0)
Sending Ack =of id 239 to ce308e04 (lobo.interaccess.cl)
=   User-Service =3D Framed-User
=   Framed-Protocol =3D PPP
=   Framed-Routing =3D None
=   Ascend-Assign-IP-Pool =3D 5
=   Ascend-Idle-Limit =3D =0



Thank's
ciro

------=_NextPart_000_01BD9ED0.B3E530D0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radius SetupFrom: rabaut Date: Tue, 23 Jun 1998 20:28:35 -0400HiI got the BAayNetworks RAC working with the RadiusNT Server. There weresome configurations that needed to be set in the Bay RAC. When I get thisthing up and running, I will put together some notes on how it was done.That should help some of the users of the RadiusNT software.I would like to know more about the settings used in the user file before Itake on using the Access database.I have been looking over the ODBC database Schema. Can you use the fieldsin the various tables as entries in the userfiles? Such as StartTime=??and StopTime =??? from the ServerAccess table?? How do I know what theinterger value should be? I keep feeling I am missing a reference forthese things.I appreciate the help...ThanksMikerabaut@hcc.cc.fl.usHillsborough Community CollegeP.O. Box 5096Tampa, Florida 33675-5096..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius SetupFrom: Dale Reed Date: Tue, 23 Jun 1998 20:49:29 -0700rabaut wrote:> > I have been looking over the ODBC database Schema. Can you use the fields> in the various tables as entries in the userfiles? Such as StartTime=??> and StopTime =??? from the ServerAccess table?? How do I know what the> interger value should be? I keep feeling I am missing a reference for> these things.No you can't. RadiusNT in ODBC mode has a lot of functionality thatyou can't have in text mode. A lot of it has to do with configurationand flexibility.-- 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