Question on sql.conf -> accounting_start_query <-> accounting_start_query_alt

Andreas Engler freeradius at arcor.de
Tue Jul 26 11:05:39 CEST 2005


Hello,

I thought a second time about it and i guess it is an performance 
related decision, because it is most likely that no entry exits.

>>/ to prevent duplicate entries in the radacct table, shouldn't the
>/>/ accounting_start_query be the "UPDATE" query and the
>/
>  How are you going to UPDATE an entry that doesn't exist?
>
>  Alan DeKok.
>

As I understand the behavior of rlm_sql the update of a non existing 
entry will fail and the alternate accounting_start_query_alt(with 
insert) will be transmitted to sql-server. This is the case if a Start 
Record is missing for an incomming Stop-record for instance.
But as i said above the benefit of non duplicate entries vs. performance 
would not be worth it, right.

So now for me remains in which case won't an Insert work but the 
alternate Update, or what for is accounting_start_query_alt.

Another question a little bit of another topic. In may you wrote, that 
the functions of radsqlrelay will  be an integral part of an next 
freeradius version. You talked about a few weeks here "radius server and 
sql server  
<http://lists.freeradius.org/pipermail/freeradius-users/2005-May/043936.html>". 
Ok it belongs to cvs head. Could you tell me the stand of development or 
where i can find the information?

Sorry for my mistake on the meaning of "string" in RFC 2865 in articel 
"Difference between dictionary and RFC 2865 for Attribute Class 
<http://lists.freeradius.org/pipermail/freeradius-users/2005-July/045566.html>". 
It was related to the wish of informational use of the Class Attribute.

Thank you

Andreas

Andreas Engler wrote:

> Hello,
>
> to prevent duplicate entries in the radacct table, shouldn't the
> accounting_start_query be the "UPDATE" query and the
> accounting_start_query_alt be the "INSERT into" query as it is the case
> on stop and update.
>
> In which case would the accounting_start_query fail and the
> accounting_start_query_alt work?
>
> Could someone point me in the right direction?
>
> I know, that freeradius manages handled retransmitted Acct-Requests, so
> duplicate entries only would show up if at some point it wouldn't
> remember. I don't know if this is impossible.
>
> Thank you.
>
> Andreas
>
>
>





More information about the Freeradius-Users mailing list