I'm pretty sure that if you don't use unique indeces on your session table,
that it isn't confirm to the reality .. eg, your table will say more users
are online, while they aren't.
-A
> -----Original Message-----
> From: Tuncay MARGILIC [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 24, 2000 1:07 PM
> To: Andy De Petter; Radiator Mailing
> Subject: RE: (RADIATOR) SessionDatabase SQL problem
>
>
> 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.
