[RadiusNT] AcctDelayTime and update serverports query

Serkan SUBASI ( (no email) )
Fri, 2 Jun 2000 11:36:48 +0300

This is a multi-part message in MIME format.

------=_NextPart_000_0051_01BFCC86.8F8EFD20
Content-Type: text/plain;
charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

we are using RadiusNT 2.5.213
options related
manual callsonline
stop records only

Database MS SQL 6.5

below is part of SQL 6.5 trace , and I want to know why the update
serverports query
calculates current time minus 2 seconds then if the resulting time greater
than the current records calldate then update that record.
this means that , if someone disconnects in less than 2 seconds, than
serverports not updated, this condition is a big problem for concurrency

as the insert calls statement shows that AcctDelayTime = 0, where this 2
(two) second comes from ?

-- 22/05/2000 11:48:12,326 SQL (ID=7, SPID=29, User=bla bla ...
INSERT INTO Calls
(CallDate,AcctStatusType,NASIdentifier,NASPort,AcctDelayTime,Frame
dAddress,U
serName,AcctInputOctets,AcctOutputOctets,AcctSessionID,AcctSessionTime)
VALUES
(GetDate(),2,'xxx.xxx.xxx.xxx',16636,0,'195.214.176.41','bca',419,
593,'15788
',176)
go
-- 22/05/2000 11:48:12,373 Duration 0,046, CPU 0,015, Reads 1, Writes 0

-- 22/05/2000 11:48:12,390 SQL (ID=7, SPID=29, User=bla bla ...
UPDATE sp Set sp.Username='bca',sp.AcctStatusType=2,
sp.CallDate=GetDate(),
sp.FramedAddress='195.214.176.41', CallerID=NULL,
AcctSessionID='15788' From
Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND
s.IPAddress='xxx.xxx.xxx.xxx' and sp.Port=16636 AND
(DateAdd(Second, 0-2, GetDate()) >= CallDate OR CallDate IS NULL)
go
-- 22/05/2000 11:48:12,390 Duration 0,000, CPU 0,000, Reads 0, Writes 0

I also tried the some other revisions of RadiusNT 2.5.209, 2.5.210,
2.5.212 and this query is the same in those.
and another point this 2 second shows itself in update serverports query
for start as 1 second
is this condition related to AcctStatusType ?
Is there anyone to help me ?

thanks in advance

Serkan SUBASI

------=_NextPart_000_0051_01BFCC86.8F8EFD20
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIKWzCCAj0w
ggGmAhEAzbp/VvDf5LxU/iKss3KqVTANBgkqhkiG9w0BAQIFADBfMQswCQYDVQQGEwJVUzEXMBUG
A1UEChMOVmVyaVNpZ24sIEluYy4xNzA1BgNVBAsTLkNsYXNzIDEgUHVibGljIFByaW1hcnkgQ2Vy
dGlmaWNhdGlvbiBBdXRob3JpdHkwHhcNOTYwMTI5MDAwMDAwWhcNMjgwODAxMjM1OTU5WjBfMQsw
CQYDVQQGEwJVUzEXMBUGA1UEChMOVmVyaVNpZ24sIEluYy4xNzA1BgNVBAsTLkNsYXNzIDEgUHVi
bGljIFByaW1hcnkgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkwgZ8wDQYJKoZIhvcNAQEBBQADgY0A
MIGJAoGBAOUZv22jVmEtmUhx9mfeuY3rt56GgAqRDvo4Ja9GiILlc6igmyRdDR/MZW4MsNBWhBiH
mgabEKFz37RYOWtuwfYV1aioP6oSBo0xrH+wNNePNGeICc0UEeJORVZpH3gCgNrcR5EpuzbJY1zF
4Ncth3uhtzKwezC6Ki8xqu6jZ9rbAgMBAAEwDQYJKoZIhvcNAQECBQADgYEATD+4i8Zo3+5DMw5d
6abLB4RNejP/khv0Nq3YlSI2aBFsfELM85wuxAc/FLAPT/+Qknb54rxK6Y/NoIAK98Up8YIiXbix
3YEjo3slFUYweRb46gVLlH8dwhzI47f0EEA8E8NfH1PoSOSGtHuhNbB7Jbq4046rPzidADQAmPPR
cZQwggMuMIICl6ADAgECAhEA0nYujRQMPX2yqCVdr+4NdTANBgkqhkiG9w0BAQIFADBfMQswCQYD
VQQGEwJVUzEXMBUGA1UEChMOVmVyaVNpZ24sIEluYy4xNzA1BgNVBAsTLkNsYXNzIDEgUHVibGlj
IFByaW1hcnkgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkwHhcNOTgwNTEyMDAwMDAwWhcNMDgwNTEy
MjM1OTU5WjCBzDEXMBUGA1UEChMOVmVyaVNpZ24sIEluYy4xHzAdBgNVBAsTFlZlcmlTaWduIFRy
dXN0IE5ldHdvcmsxRjBEBgNVBAsTPXd3dy52ZXJpc2lnbi5jb20vcmVwb3NpdG9yeS9SUEEgSW5j
b3JwLiBCeSBSZWYuLExJQUIuTFREKGMpOTgxSDBGBgNVBAMTP1ZlcmlTaWduIENsYXNzIDEgQ0Eg
SW5kaXZpZHVhbCBTdWJzY3JpYmVyLVBlcnNvbmEgTm90IFZhbGlkYXRlZDCBnzANBgkqhkiG9w0B
AQEFAAOBjQAwgYkCgYEAu1pEigQWu1X9A3qKLZRPFXg2uA1Ksm+cVL+86HcqnbnwaLuV2TFBcHqB
S7lIE1YtxwjhhEKrwKKSq0RcqkLwgg4C6S/7wju7vsknCl22sDZCM7VuVIhPh0q/Gdr5FegPh7Yc
48zGmo5/aiSS4/zgZbqnsX7vyds3ashKyAkG5JkCAwEAAaN8MHowEQYJYIZIAYb4QgEBBAQDAgEG
MEcGA1UdIARAMD4wPAYLYIZIAYb4RQEHAQEwLTArBggrBgEFBQcCARYfd3d3LnZlcmlzaWduLmNv
bS9yZXBvc2l0b3J5L1JQQTAPBgNVHRMECDAGAQH/AgEAMAsGA1UdDwQEAwIBBjANBgkqhkiG9w0B
AQIFAAOBgQCIuDc73dqUNwCtqp/hgQFxHpJqbS/28Z3TymQ43BuYDAeGW4UVag+5SYWklfEXfWe0
fy0s3ZpCnsM+tI6q5QsG3vJWKvozx74Z11NMw73I4xe1pElCY+zCphcPXVgaSTyQXFWjZSAA/Rgg
5V+CprGoksVYasGNAzzrw80FopCubjCCBOQwggRNoAMCAQICEB9dvEg6wB6+U33ZreBml3kwDQYJ
KoZIhvcNAQEEBQAwgcwxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2ln
biBUcnVzdCBOZXR3b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBB
IEluY29ycC4gQnkgUmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAx
IENBIEluZGl2aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0ZWQwHhcNOTkwOTI0
MDAwMDAwWhcNMDAwODE4MjM1OTU5WjCCARExFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYD
VQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3Jl
cG9zaXRvcnkvUlBBIEluY29ycC4gYnkgUmVmLixMSUFCLkxURChjKTk4MR4wHAYDVQQLExVQZXJz
b25hIE5vdCBWYWxpZGF0ZWQxNDAyBgNVBAsTK0RpZ2l0YWwgSUQgQ2xhc3MgMSAtIE1pY3Jvc29m
dCBGdWxsIFNlcnZpY2UxFjAUBgNVBAMUDVNlcmthbiBTdWJhc2kxHzAdBgkqhkiG9w0BCQEWEHNz
dWJhc2lAdHVyay5uZXQwXDANBgkqhkiG9w0BAQEFAANLADBIAkEAwp/57lwvje8bHpD46BK/pNek
RewU/tSDPFeE0BTIyoP3AhL4/RAK2kaQjU5W3CpN/dnIuY7ucfPCq1d+QUEIQwIDAQABo4IBwTCC
Ab0wCQYDVR0TBAIwADCBrAYDVR0gBIGkMIGhMIGeBgtghkgBhvhFAQcBATCBjjAoBggrBgEFBQcC
ARYcaHR0cHM6Ly93d3cudmVyaXNpZ24uY29tL0NQUzBiBggrBgEFBQcCAjBWMBUWDlZlcmlTaWdu
LCBJbmMuMAMCAQEaPVZlcmlTaWduJ3MgQ1BTIGluY29ycC4gYnkgcmVmZXJlbmNlIGxpYWIuIGx0
ZC4gKGMpOTcgVmVyaVNpZ24wEQYJYIZIAYb4QgEBBAQDAgeAMIGGBgpghkgBhvhFAQYDBHgWdmQ0
NjUyYmQ2M2YyMDQ3MDI5Mjk4NzYzYzlkMmYyNzUwNjljNzM1OWJlZDFiMDU5ZGE3NWJjNGJjOTcw
MTc0N2RhNWQzZjQxNDFiZWFkYjJiZDJlODkyMWVhZDY5ZjlkNzExNDg5Y2EyYmM0NWZmZjNlYTQ1
MGMwMAYKYIZIAYb4RQEGBwQiFiA3MjE1MDVkNGVjMmU4YjVmMTkxMTkwYzg1MzhjY2IwMzAzBgNV
HR8ELDAqMCigJqAkhiJodHRwOi8vY3JsLnZlcmlzaWduLmNvbS9jbGFzczEuY3JsMA0GCSqGSIb3
DQEBBAUAA4GBADJV2iZIjkcIrOLDyqlppGGJ9KumGtQAlxJAovfa35uLtLIltZ0VNg4S6xY4i3Te
JAf0WAnLOTYcwZh6EUhvRorQqmS6lnjSJLgdS6eXG6O7Z1ZcxR0J1FU+kojTwNWreaxWv4gYWC/r
a44VWVCo6o31Vii4hfqPzWIHOeE8wIRIMYIC2zCCAtcCAQEwgeEwgcwxFzAVBgNVBAoTDlZlcmlT
aWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrMUYwRAYDVQQLEz13d3cu
dmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkgUmVmLixMSUFCLkxURChjKTk4
MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAxIENBIEluZGl2aWR1YWwgU3Vic2NyaWJlci1QZXJz
b25hIE5vdCBWYWxpZGF0ZWQCEB9dvEg6wB6+U33ZreBml3kwCQYFKw4DAhoFAKCCAZAwGAYJKoZI
hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDAwNjAyMDgzNDQ5WjAjBgkqhkiG
9w0BCQQxFgQUWS/cKGGPju0HXF5VfVgdDJFPjLAwPAYJKoZIhvcNAQkPMS8wLTANBggqhkiG9w0D
AgIBKDAHBgUrDgMCBzAHBgUrDgMCGjAKBggqhkiG9w0CBTCB8gYJKwYBBAGCNxAEMYHkMIHhMIHM
MRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y
azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJl
Zi4sTElBQi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFs
IFN1YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkAhAfXbxIOsAevlN92a3gZpd5MA0GCSqG
SIb3DQEBAQUABEBUDUrZnwTcmPWEa5BCJEtYa4u/P/tBLb2OAxs/cfTh7uPBgU3NXNSC1FHdisng
3jW+FdivnvsMQ1W+27X1JMMKAAAAAAAA

------=_NextPart_000_0051_01BFCC86.8F8EFD20--