I use a two port Telebit NetBlazer for testing Emerald and RadiusNT.
I also experienced this problem, even if the Acct-Session-Id is in the =
normal format. I looked in the Calls table and the error is normal =
because the session info was allready there. The error come in Stop acc =
info not in Start as below. The pk key error is from Acct-Status-Type. I =
logged Radius to a file and I noticed that Radius tries twice to insert =
the same SQL statement. The problem was partially solved after i =
restarted Radius. Rebooting the machine was unuseful. I notice that this =
occur after a disconnect because of idle time on the PPP service.
Andrei-Neagu
radrecv: Request from host ce9ce303 code=3D4, id=3D192, length=3D165
Acct-Session-Id =3D "02000012"
User-Name =3D "nilles"
NAS-Identifier =3D 206.156.227.3
NAS-Port =3D 9
Acct-Status-Type =3D Start
Acct-Authentic =3D RADIUS
Vendor-Specific =3D ""
Vendor-Specific =3D ""
Vendor-Specific =3D ""
Vendor-Specific =3D ""
NAS-Name =3D "usr1.linkup.net"
NAS-Port-Type =3D Async
User-Service =3D Framed-User
Framed-Protocol =3D PPP
Framed-Address =3D 206.156.227.153
Acct-Delay-Time =3D 0
Allocating Statement...
SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,AcctStatusType,NASPortType,UserService,FramedProtocol,FramedAddr=
ess
,Acc
tDelayTime) VALUES
(GetDate(),'02000012','nilles','206.156.227.3',9,1,0,2,1,'206
..156.227.153',0)
ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constra
int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
Sending Accounting Ack of id 192 to ce9ce303 (usr1.linkup.net)
Response Time: 60
This started happening after I reset my NAS. It was acting up. I am
talking with my vendor but am not sure I am being fed the correct
infrmation. Can someone tell me exactly how the AcctSessionID is
generated? Is it entirely by the NAS at the point the call is started =
or
how? I assume this is the duplicate key right?
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC300F.ED5A6BE0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IioWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAENgAQAAgAAAAIAAgABBJAG
ADABAAABAAAADAAAAAMAADADAAAACwAPDgAAAAACAf8PAQAAAE0AAAAAAAAAgSsfpL6jEBmdbgDd
AQ9UAgAAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQBTTVRQAGVtZXJhbGRAZW1lcmFsZC5pZWEu
Y29tAAAAAB4AAjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAYAAAAZW1lcmFsZEBlbWVyYWxkLmll
YS5jb20AAwAVDAEAAAADAP4PBgAAAB4AATABAAAAGgAAACdlbWVyYWxkQGVtZXJhbGQuaWVhLmNv
bScAAAACAQswAQAAAB0AAABTTVRQOkVNRVJBTERARU1FUkFMRC5JRUEuQ09NAAAAAAMAADkAAAAA
CwBAOgEAAAACAfYPAQAAAAQAAAAAAAADLjkBCIAHABgAAABJUE0uTWljcm9zb2Z0IE1haWwuTm90
ZQAxCAEEgAEAFgAAAFJFOiBEdXAgS2V5IGluIFJhZGl1cwDiBgEFgAMADgAAAM0HAwAOAAAAJQAp
AAUAOAEBIIADAA4AAADNBwMADgAAAB8ACwAFABQBAQmAAQAhAAAAQTg4MzhGOTBGRDlCRDAxMUIw
MUQwMDQwOTUxMDEzREMACwcBA5AGAMQHAAASAAAACwAjAAAAAAADACYAAAAAAAsAKQAAAAAAAwA2
AAAAAABAADkAQPoYKf8vvAEeAHAAAQAAABYAAABSRTogRHVwIEtleSBpbiBSYWRpdXMAAAACAXEA
AQAAABYAAAABvC//KRiQj4Opm/0R0LAdAECVEBPcAAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwB
AAAADQAAAHJhZG50QG5hZy5ybwAAAAADAAYQkRrFdwMABxCwBgAAHgAIEAEAAABlAAAASVVTRUFU
V09QT1JUVEVMRUJJVE5FVEJMQVpFUkZPUlRFU1RJTkdFTUVSQUxEQU5EUkFESVVTTlRJQUxTT0VY
UEVSSUVOQ0VEVEhJU1BST0JMRU0sRVZFTklGVEhFQUNDVC1TRQAAAAACAQkQAQAAAE8GAABLBgAA
AAsAAExaRnW4gKER/wAKAQ8CFQKoBesCgwBQAvIJAgBjaArAc2V0MvUAACoC4WEHgAYABsMCgGxN
VBKHAfEyA8UCAHAIcnEyEoFzdGVt3QKDMwLkBxMCgzQUDBYIdjUDxhYFfQqACM8J2TvxGg8yNTUC
gAqBDbELYOBuZzEwMxWQCwoVkYUL8mMAQCBJIHURsAAgYSB0d28gcAEZsSBUZWxlYmlTBUAHwHRC
C2B6BJAgHwIQBcAVEBUAC4BnIEVVB4ByB0BkH0BuIkBSiGFkaR8QTlQuCoWLHvAHQHMfkGV4cAZx
7QnwYwmAH2BoBAAfoANgqwJgFSAsJAB2CfAgBpCDJMEScEFjY3QtBmDlBBBpAiAtSSJAJPELgH0m
I24FsADAAyAhIQDAdGYuHuEZoG9rJKEnpUP/B0Aj0B9gAaAgICJTJjIEkK8DYAXAJPEoFWIFkGEf
Eh8mMhGwJuMnkQIQIHdh7wQgKhEaECKweSYiGhAo4B5UKxcFoBJhJ6FTdG/+cB9AJoAtdCgQBUAw
AwrALwVALeEsQBmgdy70cGt+IClQLoArRwNSJmUBkHQxHxAtVHkkMCjkZ2ffJKEipB9gH5AfUGYD
ECqk+x7wMRFpJJQowDW3CIEqQf8D8CSQNiILgBGwH9EswxJT/FFMLPA0cRUgCfAo0TKDfyU0LcMK
sSGQKhEugCPgbM8lwCJBAYAg8WkgGhA6ofcAIDWXKOBSIDApMCGTJjKbAMEk4G4ScC3SdW4fEXhm
dWwo4jc0N6Qk02//JoAIcD1VH1AiwATwAiBAMMsmkCw3byYQaWQqkSGQNxJhLVEmMlBFwCzxcnY3
N2EjJgqFQSJwGhBpLTEHwGFndUaMCvRsafwzNg3wHdwlIRUQQ9EKhaMiEEeBY3Y6PvFxClCzFQAz
tGhvTHEkkDkkkM4zHUAvoQ2wPTQlkESw8D0xOTIlkCAgHRAk0DlOcDY1CoVP0iZ+PSCMIjAB0FFx
MTIiT3l+VTmBR8ASUlEhAwEgIHPxUdpOQVMnMTsBBpAIkUNREQHQNi4xNVWwMtAyNy4zU91QH8JR
ID45T380eFERMYNX3kF1DyYxVPEwoFEgUkFESdRVU1fZVgnwZAWwJrDtJDBjVRFbgiJR2lzfXe8/
Xv9gD2EfVApS5h8QcjGCLklgbmt1cC5AMI50U85XUlk2QXN5JIBvUe4GYUYyURFGIhAHgGTuLVKS
V9lp9VBKsUJwBvDvURFFwWqvWvBkR4EEEVV8l1XQVlomc0QgEGF5NMD3RRJRIAp2QSogQnAowCGi
fzRiOuRy4EaMOlNyV0wASTBOU0VSEyB08FRPqyn0CoUoKgJEOsEsJnLbJsUnQCxSklLiLFSBVMj/
CoV4cldSdwQ0czTSecZ68/tSkmlVLGn0a8Z8tW3FeVZbJnEKhXRwUwdiKWKQQchMVUVcFihHEcB2
wtAoKSwnUVYngdBTZAeCcVWbgnA5LDEsMH4sTqCEQIMiCoVumoJwMMIpRoxPREJDTAA6YWRFeAWQ
RGlLwQVAReUrUjpX1ltNN2ADYCPgeQGAXVuHUnP0RhEg8UTPBRCK8YoQiohdVicAC2AHIZAtUUSB
UFJJTUHAUlkgS0VZCoVDgV8VACIQCoULgAVAJzLAX/UqAydMAEECQBUgBTE5OP5kZeBJYHHhEnAy
8iehJUD6akPCJ4+0IyYGYCJwIaK/JnEIYFTxlBMy0ESDIE6BuzYiTUcoZV2GbT8Acx+w/zlxH/AH
cUwASZAKhS8QJPH7PgYRgHAkMAMAIbE9ZB7w/z3hEcA/0C6AVIEo4B7gBUC/LdMmkCGiZeGcwR9A
bX82/QdAayGiA/Ak0JxCJcFi0e8sMFsQniExA3MIcBJwnhL7LDEhomYkoxJwBaGIQo7H/wNQKLEn
AZyxKgADoCPgB4D/AiAsoSAQAyASYSQQnVE8we9M8AfgJjZ3VkQnYQqFNYD3QDAiED5BP5zBJ4EF
QFTi+xoQPMFiLoNUch9AObQfsP+PMqIjKhEnYj4GBbAKhaXR/6hSMdGg4BJhJNMk8SYykVxhBRBn
aHQ/RoxX1i2/sR+yL7M/s6RX1iHmTQtw+2WhIcBMBAAFQLZ5SWAVAFtGAgSQQDrhIhIuCJBhfi4v
sa+/SM9J30rpGTEAAbzwAAMAEBAAAAAAAwAREAAAAABAAAcw4G6xQP4vvAFAAAgw4G6xQP4vvAEe
AD0AAQAAAAUAAABSRTogAAAAAM53
------ =_NextPart_000_01BC300F.ED5A6BE0--