Here is an example of the problem I am having.. RadiusNT 2.5 is running on
the SQL server itself.
I logged in, and connected, then disconnected immediately.. There was a
stop record generated when I disconnected.. Then, I tried to reconnect and
was rejected because the stop record was not processed properly.. If you
can shed any light on this, I'd greatly appreciate it..
-Rick
--=====================_898373577==_
Content-Type: text/plain; charset="us-ascii"
Content-Disposition: attachment; filename="radiuslog.txt"
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
radrecv: Request from host ce67006a code=1, id=149, length=111
User-Name = "rick"
Password = "\256`\275\342\377%\350\236\001\307=\232\333n`\261"
NAS-Identifier = 206.103.0.106
NAS-Port = 9
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Connect-Info = "49333 LAPM/V42BIS"
NAS-Port-DNIS = "1523"
Caller-Id = "9738751444"
rad_authenticate_ODBC()
Password = "\256`\275\342\377%\350\236\001\307=\232\333n`\261"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extensi
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Sh
ell From MasterAccounts ma, SubAccounts sa Where (sa.Login='rick' or sa.Shell='
rick' or sa.Email='rick') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and m
a.Active<>0
Decrypted Password: password
Database Password: password
Checking for duplicate logins.
SQL Statement: RadCheckOnline 'rick'
rick found on-line 0 time(s).
SQL Statement: RadGetConfigs 13
User-Service = Framed-User (2)
Framed-Protocol = PPP (1)
Framed-Address = 206.103.0.20 (1)
Sending Ack of id 149 to ce67006a (pm3.skylands.net)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 206.103.0.20
Resp Time: 200 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0
radrecv: Request from host ce67006a code=4, id=150, length=127
Acct-Session-Id = "23000020"
User-Name = "rick"
NAS-Identifier = 206.103.0.106
NAS-Port = 9
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Connect-Info = "49333 LAPM/V42BIS"
NAS-Port-DNIS = "1523"
Caller-Id = "9738751444"
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 206.103.0.20
Acct-Delay-Time = 0
SQL Statement: UPDATE CallsOnline Set Username='rick',AcctStatusType=1, CallDa
te=GetDate(), FramedAddress='206.103.0.20' WHERE NASIdentifier='206.103.0.106' a
nd NASPort=9 AND (DateAdd(Second, 0-1, GetDate()) >= CallDate OR CallDa
te IS NULL)
Sending Accounting Ack of id 150 to ce67006a (pm3.skylands.net)
Resp Time: 120 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host ce67006a code=4, id=151, length=186
Acct-Session-Id = "23000020"
User-Name = "rick"
NAS-Identifier = 206.103.0.106
NAS-Port = 9
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Session-Time = 3
Acct-Authentic = RADIUS
Connect-Info = "49333 LAPM/V42BIS"
Acct-Input-Octets = 167
Acct-Output-Octets = 130
NAS-Port-DNIS = "1523"
Caller-Id = "9738751444"
Acct-Terminate-Cause = User-Request
Vendor-Specific = ""
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 206.103.0.20
Acct-Delay-Time = 0
SQL Statement: INSERT INTO Calls (CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,NASPortType,AcctStatusType,AcctSessionTime,ConnectInfo,AcctInputOctets,
AcctOutputOctets,NASPortDNIS,CallerId,AcctTerminateCause,UserService,FramedProto
col,FramedAddress,AcctDelayTime) VALUES (GetDate(),'23000020','rick','206.103.0.
106',9,0,2,3,'49333 LAPM/V42BIS',167,130,'1523','9738751444',1,2,1,'206.103.0.20
',0)
Sending Accounting Ack of id 121 to ce670069 (pm.skylands.net)
Resp Time: 111 Auth: 2/0 -> 2 Acct: 3/0/0 -> 3
radrecv: Request from host ce67006a code=1, id=152, length=111
User-Name = "rick"
Password = "\342\212\243,\300\357\022\030\006J6\026\203\250j\330"
NAS-Identifier = 206.103.0.106
NAS-Port = 9
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Connect-Info = "49333 LAPM/V42BIS"
NAS-Port-DNIS = "1523"
Caller-Id = "9738751444"
rad_authenticate_ODBC()
Password = "\342\212\243,\300\357\022\030\006J6\026\203\250j\330"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extensi
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Sh
ell From MasterAccounts ma, SubAccounts sa Where (sa.Login='rick' or sa.Shell='
rick' or sa.Email='rick') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and m
a.Active<>0
Decrypted Password: password
Database Password: password
Checking for duplicate logins.
SQL Statement: RadCheckOnline 'rick'
rick found on-line 1 time(s).
Sending Reject of id 152 to ce67006a (pm3.skylands.net)
User: rick already logged onto system 1 time(s).
User: rick already logged onto system 1 time(s).
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data) VALUE
S (14, GetDate(), 'rick', '1')
Resp Time: 100 Auth: 2/1 -> 3 Acct: 3/0/0 -> 3
^C
C:\radius>
--=====================_898373577==_
Content-Type: text/plain; charset="us-ascii"
--=====================_898373577==_--