I'm not sure that is correct. If you look at the code, DeleteQuery runs
right before a new session is entered into the online database. So if
your query includes removing the Framed IP from the database you should be
good to go. Using the ping type and changing up your DeleteQuery should
keep your online database almost perfect. The only instance where things
can get goofy are when a Stop packet is lost and the next user who gets
the Framed IP of the lost Stop packet user has their Start packet lost.
Just modify your DeleteQuery statement per Mike's previous suggestion and
you should be all set.
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------
On Jun 15, Clement molded the electrons to say....
>I downloaded 2.16.1 and checked the document. It says "DeleteQuery" "is
>executed whenever a user session finishes". So this modification will
>not work because the problem that we want to fix is a loss of the
>account close packet. And that sessions are not closed properly.
>
>I suppose the change is to allow 2 SQL statements for "AddQuery". One
>like this to delete any pre-existing one. And the normal one to create
>the record. This can be made the default as no 2 sessions should share
>the same IP address or same NASID and NASPORT pair.
>
>
>Mike McCauley wrote:
>> The DeleteQuery gets run just before adding a new session. I wonder if the
>> right thing is to alter the DeleteQuery so it deletes the IP address too:
>>
>> DeleteQuery delete from RADONLINE where (NASIDENTIFIER='%N' and
>> NASPORT=0%{NAS-Port}) or FRAMEDIPADDRESS = '%{Framed-IP-Address}'
>>
>> Thoughts?
>>
>> Cheers.
>
>Regards,
>
>Clement
>ANS Communications P/L
>===============================================
>Post Addr: P O Box 6626 Blacktown BC, NSW 2148
>Tel: (02) 9552 1655 Fax: (02) 9972 2633
>
>===
>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.
