callsonline / concurrency

Jim Whaley ( )
Fri, 05 Jun 1998 15:02:05 -0400

Hello. I'm currently evaluating the radiusnt 2.5-116 which was recently
posted here.

It works great and I love the new features (I'm running a very OLD version
on another
machine now)...

I'm using MS SQL server 6.5 for the ODBC database.

When I *don't* have the "manual calls update" option checked, no
callsonline updating
seems to happen at all. Do I need some triggers? If so, where can I can

When I *do* have the "manual calls update" option checked, it tries to do
updating, but gets an error saying:

SQL Statement: UPDATE CallsOnline Set Username='test',AcctStatusType=2,
FramedAddress=NULL WHERE NASIdentifier='' and NASPort=3
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'.

I don't see any fields called 'delay' anywhere. I'm sure that's the
problem :-)

For testing purposes, I made a NEW database on SQL Server, and ran the
script that came in the .zip file.


Jim Whaley