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
them?
When I *do* have the "manual calls update" option checked, it tries to do
callsonline
updating, but gets an error saying:
SQL Statement: UPDATE CallsOnline Set Username='test',AcctStatusType=2,
CallDate=GetDate(),
FramedAddress=NULL WHERE NASIdentifier='155.212.1.106' 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
radiusnt.sql
script that came in the .zip file.
Thanks,
Jim Whaley