The alternative query is there because if it fails to update the record (lets say the start record never got logged) then it inserts a whole new record with both a start and a stop.

 

From: freeradius-users-bounces+john.mylchreest=ioko.com@lists.freeradius.org [mailto:freeradius-users-bounces+john.mylchreest=ioko.com@lists.freeradius.org] On Behalf Of ravi reddy
Sent: 27 July 2006 09:02
To: freeradius-users@lists.freeradius.org
Subject: Mysql--just clarification

 

Hi Users

              I am using Freeradius-1.1.2 with mysql database:

In sql.conf i found these following

accounting_stop_query
and
accounting_stop_query_alt

one have update querie and the later have the insert query  this is became a lots confusion to me..

can any body please explain me why these two

i think only one is enough just update

any suggestions please:-)



Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes.

Unless otherwise agreed expressly in writing, this communication is to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it has been sent. If you have reason to believe that you are not the intended recipient of this communication, please contact the sender immediately. No employee is authorised to conclude any binding agreement on behalf of ioko with another party by e-mail without prior express written confirmation.

ioko365 Ltd. VAT reg 656 2443 31. Reg no 3048367. All rights reserved.