Not a stupid question but yes I did and I also saved it to a file so I =
could load it up but it just goes on with the sql error until i go in to =
the server and re-port several times and mess around saving the ports =
several times to find that maybe port 2 will work and port 1 will not or =
port 4 and 2 wont work but 1 will. Strange !!
David Moore
moored@romtech.com.au
-----Original Message-----
From: David Harris [SMTP:dharris@stargate.1starnet.com]
Sent: Sunday, 18 January 1998 12:46
To: RadiusNT@iea-software.com
Subject: Re: Its back again (SQL error 2627)
Stupid Question but did you save your settings to flash rom?
At 09:39 AM 1/17/98 +1100, you wrote:=20
>>>>
<excerpt><smaller>I Turned off the USR TC again and now the errors are
back I can't get any calls on line and users are not having there =
on-line
information logged so they can't be billed. I need to be able to turn =
off
and on the USR from time to time and still be able to work normally
without having to go through days of fiddling to try and get the USR to
work, can any body suggest a solution.
</smaller> =20
<smaller> SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,AcctStatusType,NASPortType,UserService,FramedProtocol,FramedAddr=
ess,Acc
tDelayTime) VALUES
(GetDate(),'0001000B','test','xxx.xxx.xxx.xxx',2,1,0,2,1,'xxx.xxx.xxx.xxx=
',0)</smaller>=20
=20
<smaller>ODBC: SQLExecDirect Error 2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object
'Calls'.Sending Accounting Ack of id 33 to cb230605 (ROMUSR)</smaller>=20
<smaller>Resp Time: 20 Auth: 1/0 -> 1 Acct: 0/0/2 -> 2
</smaller> =20
<smaller>David Moore
<<mailto:moored@romtech.com.au>moored@romtech.com.au
</smaller> =20
</excerpt><<<<<<<<
"The woods are lovely, dark and deep. But I have promises to keep,
And lines to code before I sleep, And lines to code before I sleep."
David Harris
Operations Manager
StarNet OnLine Systems
----------------------------------------------------------
RadiusNT Mailing List lists@iea-software.com
------ =_NextPart_000_01BD2443.51AAF8D0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IhIIAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA0AEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAAUQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFJhZGl1c05UQGllYS1z
b2Z0d2FyZS5jb20AU01UUABSYWRpdXNOVEBpZWEtc29mdHdhcmUuY29tAAAAAB4AAjABAAAABQAA
AFNNVFAAAAAAHgADMAEAAAAaAAAAUmFkaXVzTlRAaWVhLXNvZnR3YXJlLmNvbQAAAAMAFQwBAAAA
AwD+DwYAAAAeAAEwAQAAABwAAAAnUmFkaXVzTlRAaWVhLXNvZnR3YXJlLmNvbScAAgELMAEAAAAf
AAAAU01UUDpSQURJVVNOVEBJRUEtU09GVFdBUkUuQ09NAAADAAA5AAAAAAsAQDoBAAAAHgD2XwEA
AAAaAAAAUmFkaXVzTlRAaWVhLXNvZnR3YXJlLmNvbQAAAAIB918BAAAAUQAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAAAAFJhZGl1c05UQGllYS1zb2Z0d2FyZS5jb20AU01UUABSYWRpdXNOVEBpZWEt
c29mdHdhcmUuY29tAAAAAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAACGWYBBIABACQA
AABSRTogSXRzIGJhY2sgYWdhaW4gKFNRTCBlcnJvciAyNjI3KQCOCgEFgAMADgAAAM4HAQASABMA
AAARAAAADAEBIIADAA4AAADOBwEAEgASADgAMgAAAGQBAQmAAQAhAAAAMUMyRTEwMThEOThGRDEx
MUE0MUIwMEEwQzk1OUFGQjMAJgcBA5AGAOAKAAAjAAAACwACAAEAAAALACMAAQAAAAMAJgAAAAAA
CwApAAEAAAADAC4AAAAAAAIBMQABAAAA0gAAAFBDREZFQjA5AAEAAgBJAAAAAAAAADihuxAF5RAa
obsIACsqVsIAAG1zcHN0LmRsbAAAAAAATklUQfm/uAEAqgA32W4AAABaOlxNYWlsXG1haWxib3gu
cHN0ABgAAAAAAAAAJynGSu7C0BGjAgCgyVmvs6KAAAAAAAAAGAAAAAAAAAAnKcZK7sLQEaMCAKDJ
Wa+zwoAAABAAAAAcLhAY2Y/REaQbAKDJWa+zJAAAAFJFOiBJdHMgYmFjayBhZ2FpbiAoU1FMIGVy
cm9yIDI2MjcpAAAAAwA2AAAAAABAADkAYE2YHecjvQEeAHAAAQAAACQAAABSRTogSXRzIGJhY2sg
YWdhaW4gKFNRTCBlcnJvciAyNjI3KQACAXEAAQAAABYAAAABvSPnHWEYEC4ij9kR0aQbAKDJWa+z
AAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAAFgAAAG1vb3JlZEByb210ZWNoLmNvbS5hdQAA
AAMABhDYrB9OAwAHEKgGAAAeAAgQAQAAAGUAAABOT1RBU1RVUElEUVVFU1RJT05CVVRZRVNJRElE
QU5ESUFMU09TQVZFRElUVE9BRklMRVNPSUNPVUxETE9BRElUVVBCVVRJVEpVU1RHT0VTT05XSVRI
VEhFU1FMRVJST1JVTlRJAAAAAAIBCRABAAAAwgYAAL4GAACQCwAATFpGdTkI2v8DAAoAcmNwZzEy
NRYyAPgLYG4OEDAzM50B9yACpAPjAgBjaArA4HNldDAgBxMCgwBQoRB2cHJxMhF2fQqA2QjIIDsJ
bw4wNQKACoHsdWMAUAsDYxISC8QHsAJvBUBhIHN0dXCwaWQgcQpQF7BpAiAoIGJ1BUB5B5FJID5k
F/EAcBgAGTAHQHNvSRegYXYJgCBpBUB06xogF5BmAxBlF6AaIBkw2QWgdWwYAAkAYRqDF9ATGKMa
oWp1F7AgZ2+nB5EYgQPwdGgawGgbUd5xAyAEkANgBcB1AjADEf5pHYEakAOgGtEeYwSQGmDnBcAZ
kglwLXAJESCBIMH/B0AawAdzGZIHgSKBA2AfQPcYABpBC4BnHlMhcgQgIcxvGtEbIBmhHjBhBUAA
wHlaYiQ0IBLwA/BsAyB3rQWwaxmDIXMxJyRuF2H7BbEhczQZgycRAiEndBiydShkLgYAdCIADyAb
UCFuIQqiCoQsVkQjsRgATTpvBbBlLBQEYC2xZEAlA2F0BZBoLgWgbS4OYQxwLC0LMGxpMza/AUAW
kAFAEsAXYAWQdBIEUDE2IC0yUk8FEGfrC4AiEU0i8WErwDJTLBYPMWQxMQsTMWZpLTE0xjQBQDCw
MTgwAUAM0FE182IgRgNhOgyDYjsRYC00SArABRAEIFtTYE1UUDpkEQE4oUCLF7AKwGcmMGUuMTnC
9m4RQC8iXSwVNyAGYAIwLTeHUyNhJnAsKFA4ICpKAHB1CsB5KFA5OSM9EA4gOjQ2OydUbxU3h1Ic
QGkdUE5UQNkIkGEtGhABgHcKwDowYy8xOyh1YmoxkT8IZfY6GSAkgWIA0CexOgAf8RAoU1FMHtUy
NjL8Nykz/zUKMLQLtiwjK3DtF9NRGDoZUnkIYBozSVK/BcARMRhgDyAldAtgcx5AJQNhPywfCkEF
QDA5KDozORFwTShQLzGkNy890SsxD0AwPODdSWJ3MWJC0EuqPk/hS6owPGV4YwSQBTA+PK5zAMAn
UASQPhkwVAhwFzqgGABAcGYeU1VTUv0+0ENDdRmSKNAH4B5iHuPfIxIt1UMzG6EAcCcdcRFA/xmB
PZBWECdQHcMwsDqgGYP/HVAEkFTzKMMRACPGWIECIN4tV4JLpAuAAhByAMAYY/0JAGcrwCOBIDNW
0lYyJpH+YidBCYArUBkwOqAacRrR/yaRAaAbQSAiUjFSgkukGZL/GIFS1gNSIjMgE2DSGZIYUb8n
UV35J4Mo0FrRJ1B5S6R/HhIIYFjYGiAfwR4wI0Fnnx5APLEdwVKwGyBkZFeB/2TjK4A9kBmSVnJS
1hrQY7VfJ5E84FYRVqMG4GQ9kHN/ZaArwB1hF5EG8BjAGHEu9VArL1GGIE8bUXcGAEQBHytwOhEH
gDvRGSBOU0WEUlRvAVRPIENXAh1LpChv0i0wLuAsQWMPMaAGYAQQGHFJZCxVCSCRTmEHgCxOQVO/
cdA7wQaQCJFLqnKCUAkRx3EUbnEdUFR5cHJzdGLfdVNyAgZhI8BRECw3QHJRtGRQMWFvCOF3FUFm
gI8JcAQQcRJLqnREZQtgAnkHYikgVkFMVTRFU3AlRxFAcNIoKRQsJzaAME4hMEInr3wALuAXsHyh
eH1ALn1J4XygMiwxLE5AflJ9Pz1+gClsCUuqbK9RpE9ETEJDQtBD8UV4BZBE5mkJcDGgIEVERzeA
gPqcW00N4ANgQGJdW4MSe24UIKREBRAgwYZwhuhdHlYYcAtgGGNmMVBSSQBNQVJZIEtFWT9LpAWg
AIArgQuABUAncPRrX2/TJ0LQTMBukQUx/xrRC4AgkUkBF9AwsFYQLuBsIGtcER/xb0HTS6Qn/YuU
LjuxGVAj4XEhI1FKcj+P8SewZjEX8Q9gGsJjYigyMzAw4DVD0FJP3k1TEYAvbR5CsHMcsAdi10LQ
FyGVkUEYwGhC0E2AvRFgLWyQKGCP8m7hMJZA/i8S8JZxDlBrX2xvbXgtP31QhTwWgxvgJlEDEBrQ
OvsuTy9SPp0vL1MxEhvgR3V7mD+ZTC9Q96M1S68sayL+VB5xJ4AEcFhUCQAaYGOQTzzgPLAnpQEA
ZXArUEL/GMEZMFjxJDEDYQQAJWSN0P2nsCxMCxmhV4IlcwWgAQDvXJFasRtQGTBzG0CpgRFw86qP
q5wuIqR/gTewT7Ff7zgar3+0P7UsT3VwIgAYYv0EIE0AcDNxc1u1L7kfmTDHbmFyMFaBT25MV5IG
sP8XsG6gsyuBRTJTvS++P79P/zPWP4e20QMQI9K68B1huUy/MLAXsDmgQC+7zxOBAMXwAAADABAQ
AAAAAAMAERAAAAAAHgBCEAEAAAABAAAAAAAAAAMAgBD/////QAAHMMDzRKLmI70BQAAIMMDzRKLm
I70BCwAfgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADACOACCAGAAAAAADAAAAAAAAARgAA
AABShQAAdBAAAB4AJIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAAADguMDIAAAAAAwAl
gAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAC6ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAA
AAAAAAMAL4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAwgAggBgAAAAAAwAAAAAAAAEYA
AAAAEYUAAAAAAAADADOACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AQ4AIIAYAAAAAAMAA
AAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAESACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAA
AAEAAAAAAAAAHgBFgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAB4APQABAAAA
BQAAAFJFOiAAAAAAAwANNP03AABW8w==
------ =_NextPart_000_01BD2443.51AAF8D0--