|
29.07.2008 21:32:42
|
wand106
Posts 5
|
Hi,
I'm using Tekradius to write CDR's to SQL as a backup to our main CDR system. It has been working fine, but recently I noticed it was causing a big load on the SQL server for some reason. Our kit is only writing STOP messages with duration so we can reconcile if the main system fails.
The problem is that after writing a CDR Tekradius then performs the following query which on a table with 200k records causes the overhead as none of the fields are indexed:-
DELETE from Accounting where StatusType = 'Stop' and AcctSessTime is NULL and UserName = '' and NasIPAddr = 'xxx.xxx.xxx.xxx'and NasPortType = 'Async' and CalledStationID = '441234567890' and CallingStationID = '441234567895' and SessionID = '000000790001A926'
[details scrambled]
Is there anyway to stop it from issuing this command?
My current workaround is to deny Tekradius SQL login delete permissions, this has fixed the problem but now I'm getting alerts saying that it is unable to delete records.
Thanks!
Wayne
|
|
30.07.2008 15:19:37
|
admin
Posts 110
|
Hi,
This behaviour caused by TekRADIUS's secure shutdown parameter. This is not user configurable.
But I'll make it optional in next release.
Best regards,
Yasin KAPLAN
|
|
31.07.2008 12:45:58
|
admin
Posts 110
|
Hi,
I've released version 2.6. This version has an option called "Secure Shutdown" under "Service Parameters" section. You can unheck
this option to prohibit this behaviour.
Best regards,
Yasin KAPLAN
|
|
05.08.2008 15:00:32
|
wand106
Posts 5
|
Hi Yasin, thats great! how do I upgrade I have downloaded but it looks like it is going to replace?
Thanks
Wayne
|
|
05.08.2008 15:32:30
|
admin
Posts 110
|
Hi,
Here is recommended procedure for upgrade;
1. Backup existing TekRADIUS.ini and TekRADIUS.mdb
2. Uninstall existing installation.
3. Install new version
4. Copy old TekRADIUS.ini and TekRADIUS.mdb to TekRADIUS installation directory.
Best regards,
Yasin KAPLAN
wand106 wrote:
Hi Yasin, thats great! how do I upgrade I have downloaded but it looks like it is going to replace?
Thanks
Wayne
|
|
12.08.2008 21:51:21
|
wand106
Posts 5
|
Hi Yasin,
Its working great. Can I make a donation to you for use of this software? If so how?
Thanks,
Wayne
|
|
13.08.2008 15:26:53
|
admin
Posts 110
|
Hi,
Yes, maintaining this work requires some resources :-) You can contribute to TekRADIUS project:
http://www.tekradius.com/donate.html
Best regards,
Yasin KAPLAN
|
|
26.09.2008 01:04:40
|
tjcouey
Posts 4
|
We were seeing this same behavior with 2.5. I upgraded to 2.7 successfully but still see the DELETE statements taking several seconds to complete. Is the only way to resolve this to block the sql user from having delete rights?
|
|
26.09.2008 11:10:18
|
admin
Posts 110
|
Hi,
Please try to disable "Secure Shutdown" feature from Settings / Service Parameters.
Best regards,
Yasin KAPLAN
tjcouey wrote:
We were seeing this same behavior with 2.5. I upgraded to 2.7 successfully but still see the DELETE statements taking several seconds to complete. Is the only way to resolve this to block the sql user from having delete rights?
|
|
26.09.2008 18:36:15
|
tjcouey
Posts 4
|
Even with that feature disabled I still see the CPU intensive deletes in SQL profiler. Is there somewhere I can download 2.6 where this is resolved?
|
|
26.09.2008 18:43:34
|
admin
Posts 110
|
Hi,
Does your access server send Accounting-Checkpoint messages to TekRADIUS?
Best regards,
Yasin KAPLAN
tjcouey wrote:
Even with that feature disabled I still see the CPU intensive deletes in SQL profiler. Is there somewhere I can download 2.6 where this is resolved?
|
|
26.09.2008 18:54:43
|
tjcouey
Posts 4
|
I dont believe so. Here are the Accounting fields we are using:
UserName
SessionID
StatusType
CallingStationID
CalledStationID
AcctSessTime
NasIPAddr
h323_connect_time
h323_disconnect_time
These are accounting packets from cisco routers we are using for CDR stats.
Thanks,
TJC
|
|
26.09.2008 19:05:11
|
admin
Posts 110
|
Hi,
Please send en e-mail and I'll send you an updated version of TekRADIUS.exe.
Yasin
tjcouey wrote:
I dont believe so. Here are the Accounting fields we are using:
UserName
SessionID
StatusType
CallingStationID
CalledStationID
AcctSessTime
NasIPAddr
h323_connect_time
h323_disconnect_time
These are accounting packets from cisco routers we are using for CDR stats.
Thanks,
TJC
|
|
26.09.2008 20:15:53
|
tjcouey
Posts 4
|
It looks like that has resolved the issue, CPU has returned to a normal level on the box.
Thanks for the very quick response!!!!!!
TJC
|
|
pages:
1 |
|---|