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

2005-07-26 Thread Nicolas Baradakis
Andreas Engler wrote: > 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. INSERT may fail if your SQL schema defines a unique index to prevent insertion of duplicate accounting records. With MySQL 4.1 you could use th

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

2005-07-26 Thread Andreas Engler
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

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

2005-07-25 Thread Alan DeKok
Andreas Engler <[EMAIL PROTECTED]> wrote: > 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. - List info/subscribe/unsubscribe? See http://www.freeradiu

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

2005-07-25 Thread Andreas Engler
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_qu