08.07.2011 10:59:10
dcbanaynal
Posts: 19
|
If you set a NAS client's interim update, and TekRADIUS does not get updates in the specified interval, it will TRY to mark sessions as stopped.
But if you monitor whats going on behind at SQL server using Profiler, TekRADIUS submits the foll:
INSERT into Accounting (SessionID, StatusType, UserName, NasIPAddr, [TimeStamp]) values ('6004', 'Stop', 'test', '127.0.0.1', datetime('now', 'localtime'))
This statement will cause an error and nothing will ever be done to the session records. This is because there is no datetime function in SQL server:
Msg 195, Level 15, State 10, Line 1
'datetime' is not a recognized built-in function name.
Thanks,
|
|
|
0
• permalink
|
08.07.2011 11:20:01
Admin
Administrator
Posts: 1833
|
Hi,
Please download and install the latest built from TekRADIUS web site which is posted on July, 6th. 2011
Best regards,
Yasin KAPLAN
|
|
|
0
• permalink
|
08.07.2011 11:23:45
dcbanaynal
Posts: 19
|
Thank you Sir, for your very quick reply.
I will test it after the download.
|
|
|
0
• permalink
|
08.07.2011 11:33:05
dcbanaynal
Posts: 19
|
Thanks, its already working.
The getdate() function did it.
|
|
|
0
• permalink
|
08.07.2011 11:37:51
dcbanaynal
Posts: 19
|
I would like to request it for the Interim Update period, if its possible to enable the field before the up/down button.
The value is in seconds and users will have a time clicking the up or down button if interval is minutes long.
Thanks again, Mr./Engr. Kaplan.
|
|
|
0
• permalink
|
08.07.2011 11:52:52
Admin
Administrator
Posts: 1833
|
I'll consider adding this option. You must set interim update period = 0 to disable checking interim update period.
|
|
|
0
• permalink
|
08.07.2011 12:00:04
dcbanaynal
Posts: 19
|
Yes. But Interim update checking is needed in situations when a NAS full of users will lose contact with TR, so that phantom sessions will be cleared and users can reconnect again.
Thank you very much,
|
|
|
0
• permalink
|