Re: [RadiusNT] 3Com acces control server access table

Abdo Kmeid ( akmeid@dm.net.lb )
Mon, 11 Oct 1999 14:48:42 +0100

--------------2209AAF13D92A6B9DCDFE3F2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Dale E. Reed Jr. wrote:

>
> > what I meant is that the username is always 'unauthenticated' but on
> port # 1
> > the username is correct.
>
> This sounds like a bug with the NAS. RadiusNT just records what the
> NAS
> sends. What does -x15 debug look like for a user loggin onto a port
> other than 1?

this is the log and you can see when it isn't the port 1 their is no
Accounting records. ?????????!!!!!?????

RadiusNT 2.5.162 Standard Initialized...

Resp Time: 160 Auth: 17/5 -> 22 Acct: 29/0/0 -> 29
radrecv: Request from host c1e3ba02 code=1, id=88, length=92

User-Name = "kgr"
Challenge-Response =
"\003\2443\355\350\037\305\353Z\030\004w\020\355\316z\273"
Framed-Protocol = PPP
NAS-Identifier = 193.227.186.2
NAS-Port = 258
Acct-Session-Id = "16843197"
User-Service = Framed-User
Framed-Protocol = PPP
NAS-Port-DNIS = ""
NAS-Port-Type = Async
rad_authenticate_ODBC()

Challenge-Response =
"\003\2443\355\350\037\305\353Z\030\004w\020\355\316z\273"

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='kgr' AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

Checking for duplicate logins.

SQL Statement: RadCheckOnline 'kgr'

kgr found on-line 0 time(s).

SQL Statement: RadGetConfigs 5903

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs 'Global'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Framed-Routing = None (0)
Framed-MTU = Framed-MTU (1500)
Framed-Compression = Van-Jacobsen-TCP-IP (1)
Framed-Filter = intl.in (1)
Sending Ack of id 88 to c1e3ba02 ( )

Framed-Protocol = PPP
User-Service = Framed-User
Framed-Routing = None
Framed-MTU = 1500
Framed-Compression = Van-Jacobsen-TCP-IP
Framed-Filter = "intl.in"

Resp Time: 30 Auth: 19/5 -> 24 Acct: 29/0/0 -> 29
radrecv: Request from host c1e3ba02 code=4, id=244, length=105

User-Name = "kgr"
NAS-Identifier = 193.227.186.2
Acct-Status-Type = Start
Acct-Session-Id = "16843197"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port-Type = Async
NAS-Port = 1
Caller-Id = ""
NAS-Port-DNIS = ""
Framed-Protocol = PPP
Framed-Address = 193.227.186.54
Acct-Link-Count = 1
Acct-Multi-Session-Id = "1b48"

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,FramedAddress)
VALUES
(GetDate(),'kgr','193.227.186.2',1,'16843197',0,1,'193.227.186.54')

SQL Statement: UPDATE CallsOnline Set Username='kgr',AcctStatusType=1,
CallDate=GetDate(), FramedAddress='193.227.186.54' WHERE
NASIdentifier='193.227.186.2' and NASPort=1 AND (DateAdd(Second, 0-1,
GetDate()) >= CallDate OR CallDate IS NULL)

Sending Accounting Ack of id 244 to c1e3ba02 ( )
Resp Time: 40 Auth: 25/7 -> 32 Acct: 47/0/0 -> 47
radrecv: Request from host c1e3ba02 code=4, id=247, length=141

User-Name = "kgr"
NAS-Identifier = 193.227.186.2
Acct-Status-Type = Stop
Acct-Session-Id = "16843197"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port-Type = Async
NAS-Port = 1
Caller-Id = ""
NAS-Port-DNIS = ""
Framed-Protocol = PPP
Framed-Address = 193.227.186.54
Acct-Link-Count = 1
Acct-Multi-Session-Id = "1b48"
Acct-Session-Time = 43
Acct-Terminate-Cause = Lost-Carrier
Acct-Input-Octets = 1882
Acct-Output-Octets = 2945
Acct-Input-Packets = 52
Acct-Output-Packets = 37
SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,FramedAddress,AcctSessionTime,AcctTerminateCause)
VALUES
(GetDate(),'kgr','193.227.186.2',2,'16843197',0,1,'193.227.186.54',43,2)

SQL Statement: UPDATE CallsOnline Set Username='kgr',AcctStatusType=2,
CallDate=GetDate(), FramedAddress='193.227.186.54' WHERE
NASIdentifier='193.227.186.2' and NASPort=1 AND (DateAdd(Second, 0-2,
GetDate()) >= CallDate OR CallDate IS NULL)

SQL Statement: UPDATE SubAccounts Set TimeLeft=TimeLeft-1 Where
TimeLeft<>Null And TimeLeft<>-9999 And Login='kgr'

>
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

--------------2209AAF13D92A6B9DCDFE3F2
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

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

Dale E. Reed Jr. wrote:

 
> what I meant is that the username is always 'unauthenticated' buton port # 1
> the username is correct.

This sounds like a bug with the NAS.  RadiusNT just records whatthe NAS
sends.  What does -x15 debug look like for a user loggin ontoa port
other than 1?

this is the log and you can see when it isn't the port 1 their is no Accountingrecords. ?????????!!!!!?????

RadiusNT 2.5.162 Standard Initialized...

Resp Time: 160   Auth: 17/5 -> 22  Acct: 29/0/0 -> 29
radrecv: Request from host c1e3ba02 code=1, id=88, length=92

    User-Name = "kgr"
    Challenge-Response = "\003\2443\355\350\037\305\353Z\030\004w\020\355\316z\273"
    Framed-Protocol = PPP
    NAS-Identifier = 193.227.186.2
    NAS-Port = 258
    Acct-Session-Id = "16843197"
    User-Service = Framed-User
    Framed-Protocol = PPP
    NAS-Port-DNIS = ""
    NAS-Port-Type = Async
rad_authenticate_ODBC()

    Challenge-Response = "\003\2443\355\350\037\305\353Z\030\004w\020\355\316z\273"

 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 MasterAccountsma, SubAccounts sa  Where sa.Login='kgr'  AND ma.CustomerID=sa.CustomerIDand sa.Active<>0 and ma.Active<>0

Checking for duplicate logins.

 SQL Statement: RadCheckOnline 'kgr'

      kgr found on-line 0 time(s).

 SQL Statement: RadGetConfigs 5903

Loading radius defaults for this type...

 SQL Statement: RadGetATConfigs 'Global'

      Framed-Protocol = PPP (1)
      User-Service = Framed-User (2)
      Framed-Routing = None (0)
      Framed-MTU = Framed-MTU (1500)
      Framed-Compression = Van-Jacobsen-TCP-IP(1)
      Framed-Filter = intl.in (1)
Sending Ack of id 88 to c1e3ba02 ( )

    Framed-Protocol = PPP
    User-Service = Framed-User
    Framed-Routing = None
    Framed-MTU = 1500
    Framed-Compression = Van-Jacobsen-TCP-IP
    Framed-Filter = "intl.in"

Resp Time: 30   Auth: 19/5 -> 24  Acct: 29/0/0 -> 29
radrecv: Request from host c1e3ba02 code=4, id=244, length=105

    User-Name = "kgr"
    NAS-Identifier = 193.227.186.2
    Acct-Status-Type = Start
    Acct-Session-Id = "16843197"
    Acct-Delay-Time = 0
    Acct-Authentic = RADIUS
    User-Service = Framed-User
    NAS-Port-Type = Async
    NAS-Port = 1
    Caller-Id = ""
    NAS-Port-DNIS = ""
    Framed-Protocol = PPP
    Framed-Address = 193.227.186.54
    Acct-Link-Count = 1
    Acct-Multi-Session-Id = "1b48"

 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,FramedAddress)VALUES (GetDate(),'kgr','193.227.186.2',1,'16843197',0,1,'193.227.186.54')
 

 SQL Statement: UPDATE CallsOnline  Set Username='kgr',AcctStatusType=1,CallDate=GetDate(), FramedAddress='193.227.186.54' WHERE NASIdentifier='193.227.186.2'and NASPort=1   AND (DateAdd(Second, 0-1, GetDate()) >= CallDateOR        CallDate IS NULL)

Sending Accounting Ack of id 244 to c1e3ba02 ( )
Resp Time: 40   Auth: 25/7 -> 32  Acct: 47/0/0 -> 47
radrecv: Request from host c1e3ba02 code=4, id=247, length=141

    User-Name = "kgr"
    NAS-Identifier = 193.227.186.2
    Acct-Status-Type = Stop
    Acct-Session-Id = "16843197"
    Acct-Delay-Time = 0
    Acct-Authentic = RADIUS
    User-Service = Framed-User
    NAS-Port-Type = Async
    NAS-Port = 1
    Caller-Id = ""
    NAS-Port-DNIS = ""
    Framed-Protocol = PPP
    Framed-Address = 193.227.186.54
    Acct-Link-Count = 1
    Acct-Multi-Session-Id = "1b48"
    Acct-Session-Time = 43
    Acct-Terminate-Cause = Lost-Carrier
    Acct-Input-Octets = 1882
    Acct-Output-Octets = 2945
    Acct-Input-Packets = 52
    Acct-Output-Packets = 37
 SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPort,FramedAddress,AcctSessionTime,AcctTerminateCause)VALUES (GetDate(),'kgr','193.227.186.2',2,'16843197',0,1,'193.227.186.54',43,2)

 SQL Statement: UPDATE CallsOnline  Set Username='kgr',AcctStatusType=2,CallDate=GetDate(), FramedAddress='193.227.186.54' WHERE NASIdentifier='193.227.186.2'and NASPort=1   AND (DateAdd(Second, 0-2, GetDate()) >= CallDateOR        CallDate IS NULL)

 SQL Statement: UPDATE SubAccounts Set TimeLeft=TimeLeft-1 WhereTimeLeft<>Null And TimeLeft<>-9999 And Login='kgr'
 

 
 

--

Dale E. Reed Jr.      Emerald and RadiusNT
__________________________________________
IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

--------------2209AAF13D92A6B9DCDFE3F2--