minimum one of the field is marked unique on the table RADONLINE.
check the table indexes!!!
I do not use unique index on my RADONLINE table...
Tuncay
-----Original Message-----
From: Andy De Petter [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 24, 2000 10:49 AM
To: Radiator Mailing
Subject: RE: (RADIATOR) SessionDatabase SQL problem
<snip>
> > Thu Nov 23 20:18:50 2000: ERR: do failed for 'insert into
> RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID,
> TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values
> ('[EMAIL PROTECTED]', '10.10.10.1', 45, '00000414', 975010730,
> '10.10.140.233', 'Async', 'Framed-User')': Duplicate entry
> '10.10.140.1-45' for key 1
> >
> > I have to remove those by hand from the table...
> >
>
> The above look like accounting records with no access request
> prior to them
> arriving.
>
Any way of preventing this to happen??
-Andy
--
......................................................................
: :
: Andy De Petter <[EMAIL PROTECTED]> :
: Skynet NV/SA System Engineer :
: :
: Kol. Bourgstraat 124 _,'| _.-''``-...___..--'; :
: 1140 Brussels /, \'. _..-' , ,--...--''' :
: < \ .`--''' ` /| :
: Tel +32 (0)2 7061311 `-,;' ; ; ; :
: Fax +32 (0)2 7061312 __...--'' __...--_..' .;.' :
: (,__....----''' (,..--'' :
: http://www.skynet.be :
......................................................................
The opinions expressed are personal.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
