i had the same problem too, but whit the pair 'nas-identifier/nas-port'. i could solve it changing the AddQuery sentence at 'session sql' clause from 'insert into ...' to 'replace into ...'.
the problem, as i could see, is when due an error or any other reason, Radiator keeps a session entry but that sessions is not real yet.
regards
--Original Message Text---
From: manager
Date: Tue, 16 Oct 2001 17:45:22 +1000
I keep getting this error
('username', 'Oct 16, 2001 14:23', 1, 0, '00000019',
'patton1.domain.com.au', 6)': Server message number=2627 severity=14 state=1
line=3 server=ntserver procedure=calls_insert text=Violation of PRIMARY KEY
constraint 'pk_ServerPorts': Attempt to insert duplicate key in object
'ServerPorts'.Server message number=3621 severity=0 state=0 line=3
server=ntserver procedure=calls_insert text=Command has been aborted.
My set up is
Radiator using emerald.cfg to back into platpus
I have 3 portmaster3 which don't cause this problem
And 2 (recently added) patton2800 NAS boxes which cause the above problem.
>From what I can see is when the patton boxes are switch off and on again
the session id or " '00000019'" part from above resets back to zero.
and you end up with '00000019' from patton box 1 and then again from patton
box 2.
Is there a fix for this or work around for this problem ?
Thanks for any help
Matthew
ONO Service Provider
Planificaci�n y Dise�o de Red
Tfno: +34 91 623 2909
Fax: +34 91 623 2911
