------=_NextPart_000_0075_01BD901C.13316450
Content-Type: text/plain;
charset="big5"
Content-Transfer-Encoding: quoted-printable
Hi 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=3D4, id=3D148, length=3D54
NAS-Identifier =3D 127.0.0.1
NAS-Port =3D 0
User-Name =3D "test"
Acct-Session-Id =3D "12794148"
Acct-Status-Type =3D Start
SQL Statement: UPDATE CallsOnline Set =
Username=3D'test',AcctStatusType=3D1,
CallDate
=3DGetDate(), FramedAddress=3DNULL WHERE NASIdentifier=3D'127.0.0.1' and =
NASPort=3D0
AND
(DateAdd(Second, 0-delay, GetDate()) >=3D 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=3D4, id=3D167, length=3D60
NAS-Identifier =3D 127.0.0.1
NAS-Port =3D 0
User-Name =3D "test"
Acct-Session-Id =3D "12800167"
Acct-Status-Type =3D Stop
Acct-Session-Time =3D 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=3D'test',AcctStatusType=3D2,
CallDate
=3DGetDate(), FramedAddress=3DNULL WHERE NASIdentifier=3D'127.0.0.1' and =
NASPort=3D0
AND
(DateAdd(Second, 0-delay, GetDate()) >=3D 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=3DTimeLeft-180 Where
TimeLeft<>Null
And TimeLeft<>-9999 And Login=3D'test'
Sending Accounting Ack of id 167 to 7f000001 (localhost)
Resp Time: 110 Auth: 0/0 -> 0 Acct: 2/0/0 -> 2
******************************************************************
any idea ?
------=_NextPart_000_0075_01BD901C.13316450
Content-Type: text/html;
charset="big5"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">