Hi,
On Fri, Nov 24, 2000 at 09:08:37AM +1100, Hugh Irvine wrote:
>
> Hello Carlos -
>
> On Fri, 24 Nov 2000, Carlos Canau wrote:
> > Hi,
> >
> > I'm having problems with SessionDatabase SQL. I've seen Start
> > records arriving after the Stop records that leave a NASPORT blocked
> > on the table.
> > How to do the sanity check ?
> >
>
> It sounds like the NAS(s) need the sanity check, not Radiator.
The diff between the packets is two to three seconds. I think
that the problem isn't on the NAS... maybe something on the NAS config
can be tuned somehow... but,...
I've seen also sessions of two seconds getting START, STOP,
and again a START... maybe a re-transmit... it block the port on the
table.
>
> > The NAS are c5300 and the NASPORT can't be trivially used to
> > do a snmpget into a variable (I'm using 'radius-server attribute
> > nas-port format c', but the others are the same with respect to
> > NASPORT on RADONLINE...).
> >
>
> In any case, Radiator already does sanity checking by removing stale records
> when the next access request arrives for that NAS/NASPORT pair.
I'm not yet using 2.17.x ...
Thu Nov 23 17:27:03 2000: ERR: do failed for 'insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE) values ('[EMAIL PROTECTED]', '10.10.10.19', 6, '6D000C19', 975000423,
'10.10.10.134', 'Async', 'Framed-User')': Duplicate entry '10.10.10.19-6' for key 1
Thu Nov 23 17:27:03 2000: ERR: do failed for 'insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE) values ('[EMAIL PROTECTED]', '10.10.10.19', 6, '6D000C19', 975000423,
'10.10.10.134', 'Async', 'Framed-User')': Duplicate entry '10.10.10.19-6' for key 1
Thu Nov 23 18:06:16 2000: ERR: do failed for 'insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE) values ('[EMAIL PROTECTED]', '10.10.10.19', 6, '6D000C24', 975002776,
'10.10.10.135', 'Async', 'Framed-User')': Duplicate entry '10.10.10.19-6' for key 1
Thu Nov 23 18:06:16 2000: ERR: do failed for 'insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE) values ('[EMAIL PROTECTED]', '10.10.10.19', 6, '6D000C24', 975002776,
'10.10.10.135', 'Async', 'Framed-User')': Duplicate entry '10.10.10.19-6' for key 1
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
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...
>
> If you want to manually remove records from the session database, you can
> simply use radpwtst to send the corresponding Stop record to flush the entry.
I got several of them daily... from different NAS's. I'm
thinking of doing a replace into or in doing some crontab script to
periodically clean the table... or something that tails forever the
logfile looking for entries to clean ... :-/////
thks,
</canau
===
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.