the "delay" parameter

SomeOne ( (no email) )
Wed, 3 Jun 1998 03:21:52 +0800

Dale,
Here is the problem after run the latest 2.5.116 version, we user MS SQL 6.5
and test with "radlogin test start" and then "radlogin test stop"

RadiusNT Standard Initialized...

radrecv: Request from host 7f000001 code=4, id=148, length=54
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "test"
Acct-Session-Id = "12794148"
Acct-Status-Type = Start

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

ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'delay'.

Sending Accounting Ack of id 148 to 7f000001 (localhost)

Resp Time: 70 Auth: 0/0 -> 0 Acct: 1/0/0 -> 1
radrecv: Request from host 7f000001 code=4, id=167, length=60
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "test"
Acct-Session-Id = "12800167"
Acct-Status-Type = Stop
Acct-Session-Time = 180

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,UserName,AcctSes
sionId,AcctStatusType,AcctSessionTime) VALUES
(GetDate(),'127.0.0.1',0,'test','128
00167',2,180)

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

ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'delay'.

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

Sending Accounting Ack of id 167 to 7f000001 (localhost)

Resp Time: 110 Auth: 0/0 -> 0 Acct: 2/0/0 -> 2
******************************************************************
any idea ?