Re: TimeBank and USR NetServer

Einstein Oliveira ( einstein@yawl.com.br )
Sun, 19 Jul 1998 17:17:55 -0300

Hi Dale,

This is the output of RadiusNT running in -x15 mode:
------------------------------------------------------------
C:\radius>radius -x15

RadiusNT 2.2.41 7/27/97 Copyright (c) 1996-1997 IEA Software, Inc.
All Rights Reserved, Worldwide

Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.

0) EncryptPasswords: 0
1) IgnoreCase: 0
2) ReqAcctAuth: 0
3) Mode: 1
4) Options: 69
5) Debug: 0
6) ODBCDatasource: RadiusNT
7) DataDirectory:
8) AcctDirectory:
9) UsersFile: Users
10) Username: xxxxx
11) Password: xxxxx
12) CompanyName:
13) License:

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'RadiusNT'...
Making ODBC Connection...
Licensed MBRs: 200
Allocating 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

SQL Statement: Select Server, IPAddress, Secret From Servers

6 Clients Loaded
12 Accounting Columns Loaded

Radius NT is ready to receive requests!
radrecv: Request from host xxxxxxxx code=1, id=1, length=0
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "foo"
Password = "\032n^\015\234\322Sm\252s\211\034pg\226\265"
rad_authenticate_ODBC()
Password = "\032n^\015\234\322Sm\252s\211\034pg\226\265"

SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue), maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.Password, sa.Login, sa.Shell, sa.TimeLeft, sa.LoginLimit From MasterAccounts
ma, SubAccounts sa Where (sa.Login='foo' or sa.Shell='foo') AND
ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

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

SQL Statement: Select Count(*) from CallsOnline Where UserName='foo' and
AcctStatusType=1

foo found on-line 0 time(s).

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

Loading radius defaults for this type...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadATConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND
rc.AccountType='PPP'

User-Service = 2 (2)
Framed-Protocol = 1 (1)
Framed-Address = 255.255.255.254 (1)
Framed-Compression = 1 (1)
Sending Ack of id 1 to xxxxxxxx (XXXXXX)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 255.255.255.254
Framed-Compression = Van-Jacobsen-TCP-IP

Resp Time: 90 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0
------------------------------------------------------------

and this is the output of radlogin when I try to log a user with 60 in his
timeleft column and TimeBank Checked in RadiusNT Administrator:

------------------------------------------------------------
C:\radius>radlogin foo foo

Checking Radius user foo:
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 255.255.255.254
Framed-Compression = Van-Jacobsen-TCP-IP
0: Time: 130 Auth: Good
1 Good 0 Bad 130 Avg
------------------------------------------------------------

am I wrong or this is where the Session-Timeout Attribute should appear as
response to NAS ? I'm just setting the TimeLeft field for the account. Do I need
to do something else ?

Einstein Oliveira

Dale E. Reed Jr. wrote:
>
> Einstein Oliveira wrote:
> >
> > We're having problems to put time-banking feature of RadiusNT working with USR
> > NetServers. The problem is that the NAS doesn't hang up a call when the time
> > left is over, resulting in values like -xxx in the TimeLeft column of
> > SubAccounts table.
>
> For time banking to fully work, the NAS must support the Session-Timeut
> attribute. RadiusNT will include this attriute when it returns the set
> of atriutes for the user if the user is configured for time banking.
> It is possible for the final calculation to be a couple of minuites
> negative, but it shouldn't be much more than that.
>
> --
> 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