Re: Accounting and RadiusNT

ACCS Internet ( internet@accs.net )
Sat, 31 Jan 1998 14:20:18

At 10:39 AM 1/31/98 -0800, you wrote:
Okie here is a few partial captures of the -x15 debug mode.
I really appreciate everyones help here. This has been bugging a few of us
for quite some time. Here is the capture.

NAS-IP-Address = 205.243.37.3
NAS-Port = 8
User-Name = "cpapc4854"
Password = ":P\025\332\311\374\364\250\005S\177\266\246\266\273\232"
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = ":P\025\332\311\374\364\250\005S\177\266\246\266\273\232"

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login=
'cpapc4854' or sa.Shell='cpapc4854') AND ma.CustomerID=sa.CustomerID and
sa.Acti
ve<>0 and ma.Active<>0

ODBC: SQLFetch Error:100: (00000)

Not Found in ODBC, Checking users file...
rad_authenticate()
Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is WINNT\ACCS_NET
decrypted pwd is 060972
(WINNT) User:cpapc4854 Domain:ACCS_NET Password:060972

Password = "\207\330Whq'\N"\270L\341\256c\341c"
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "\207\330Whq'\N"\270L\341\256c\341c"

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

ODBC: SQLFetch Error:100: (00000)

Not Found in ODBC, Checking users file...
rad_authenticate()
Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is WINNT\ACCS_NET
decrypted pwd is mwtwo1mm
(WINNT) User:bweaver Domain:ACCS_NET Password:mwtwo1mm
Sending Reject of id 233 to cdf32503 (accs-rt2)

Resp Time: 550 Auth: 4/4 -> 8 Acct: 0/0/0 -> 0

Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is WINNT\ACCS_NET
decrypted pwd is mwtwo1mm
(WINNT) User:bweaver Domain:ACCS_NET Password:mwtwo1mm
Sending Reject of id 128 to cdf32501 (accs-rt1)

Resp Time: 951 Auth: 5/6 -> 11 Acct: 0/0/0 -> 0
radrecv: Request from host cdf32501 code=1, id=141, length=69
NAS-IP-Address = 205.243.37.1
NAS-Port = 6
User-Name = "tsar1"
Password = "\257\356\371\013\336\036M\232T\002\3068\332\362\033\222"
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "\257\356\371\013\336\036M\232T\002\3068\332\362\033\222"

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login=
'tsar1' or sa.Shell='tsar1') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 an
d ma.Active<>0

chkPwd->strvalue is WINNT\ACCS_NET
decrypted pwd is rm229a1
(WINNT) User:tsar1 Domain:ACCS_NET Password:rm229a1
Sending Ack of id 141 to cdf32501 (accs-rt1)
User-Service = Framed-User
Framed-Protocol = PPP

Resp Time: 1642 Auth: 8/6 -> 14 Acct: 0/0/0 -> 0
radrecv: Request from host cdf32501 code=1, id=141, length=69
NAS-IP-Address = 205.243.37.1
NAS-Port = 6
User-Name = "tsar1"
Password = "\257\356\371\013\336\036M\232T\002\3068\332\362\033\222"
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "\257\356\371\013\336\036M\232T\002\3068\332\362\033\222"

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login=
'tsar1' or sa.Shell='tsar1') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 an
d ma.Active<>0

Password = ""
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = ""

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

ODBC: SQLFetch Error:100: (00000)

Not Found in ODBC, Checking users file...
rad_authenticate()
Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is WINNT\ACCS_NET
decrypted pwd is mwtwo1mm
(WINNT) User:bweaver Domain:ACCS_NET Password:mwtwo1mm
Sending Reject of id 234 to cdf32503 (accs-rt2)

Resp Time: 511 Auth: 9/7 -> 16 Acct: 0/0/0 -> 0

------------------------------------------------------------------------
End of capture.

-Jason

-Jason Kallner
ACCS Internet Services
internet@accs.net