Variable Login Limits

Dale E. Reed Jr. ( (no email) )
Wed, 02 Apr 1997 00:50:53 -0800

Several people have been reporting problems with Variable login limits.
I am using SQL Server/Emerald for testing and setup a quick scenario.

In RadiusNT admin, I had only ODBC, Concurrency Control, and Variable
Login
Limits checked.

I started RadiusNT as "radius -x15". The first time I had the login
limit set
to three, and I was shown as logged in three times in the calls online
view.
Here is the results:

----------------------------------------------------------
radrecv: Request from host 7f000001 code=1, id=1, length=0
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "..."
Password = "..."
rad_authenticate_ODBC()
Password = "..."
Decrypted Password: ...
Allocating Statement...

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

Database Password: WINNT
(WINNT) User:... Domain: Password:...
Freeing SQL Statement...
Checking for duplicate logins.
Allocating Statement...

SQL Statement: Select Count(*) from CallsOnline Where (UserName='...'
or UserN
ame='') and AcctStatusType=1

... found on-line 3 time(s).
Freeing SQL Statement...
LOG: User: ... already logged onto system 3 time(s).

User: ... already logged onto system 3 time(s).
Sending Reject of id 1 to 7f000001 (localhost)

Response Time: 1853
----------------------------------------------------------

Now, I uped the login limit for my user to 4 and tried again:

----------------------------------------------------------
radrecv: Request from host 7f000001 code=1, id=1, length=0
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "...."
Password = "..."
rad_authenticate_ODBC()
Password = "..."
Decrypted Password: ...
Allocating Statement...

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

Database Password: WINNT
(WINNT) User:... Domain: Password:...
Freeing SQL Statement...
Checking for duplicate logins.
Allocating Statement...

SQL Statement: Select Count(*) from CallsOnline Where (UserName='...'
or UserN
ame='') and AcctStatusType=1

... found on-line 3 time(s).
Freeing SQL Statement...
Allocating Statement...

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

User-Service = Framed-User (2)
Framed-Protocol = PPP (1)
Framed-Address = 255.255.255.254 (1)
Framed-Compression = Van-Jacobsen-TCP-IP (1)
Freeing SQL Statement...
Sending Ack of id 1 to 7f000001 (localhost)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 255.255.255.254
Framed-Compression = Van-Jacobsen-TCP-IP

Response Time: 1993
----------------------------------------------------------

This is with version 1.17.5, using NT SAM authentication, but the
variable login limit code is the same. I also tried this with RadiusNT
1.16.60 and got the same results as 1.17.5.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com