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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
