Re: 1.1.7 and rlm_sql_mysql duplicated query

[Phil Mayers <p.mayers@imperial.ac.uk>]

Santiago Balaguer García wrote:
> The answer is not totally correct. Because a microcuts in the 
> connectibity of hotspot cause that hotspot re-sends the acct request.

No, because then the Acct-Session-Id would remain the same.

> In that case, you have to desactivate:
>  - accounting_start_query_alt
>  - accounting_stop_query_alt

No. Re-read the original post. The Acct-Session-Id is different, hence 2 
sessions are being inserted into SQL, but no Accounting-Stop ever gets 
send for the 1st.

The NAS is misbehaving.

>  
> Maybe It can cause that some requests do not register, and it is a risk 
> that you must accept.
>
>  > Date: Mon, 18 Feb 2008 01:36:54 +0000
>  > From: p.mayers@imperial.ac.uk
>  > To: freeradius-users@lists.freeradius.org
>  > Subject: Re: 1.1.7 and rlm_sql_mysql duplicated query
>  >
>  > > So when the user logs I have two queries inserting similar data 
> with different sessions ids:
>  > >
>  > > 47B7691A2F4300 and 47B7691A2F4301
>  > >
>  > >
>  > > I would really appreciate some guidance from this point on as I'm 
> pretty much out of ideas.
>  >
>  > Your NAS is broken / misbehaving. It sends the Acct-Session-Id and it's
>  > sending two. Consult your NAS documentation for possible reasons (e.g.
>  > some Cisco NAS send accounting sessions for the PPP LCP and IPCP layers
>  > - this can be disabled) or open a bug with the vendor.
>  >
>  > -
>  > List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>
>
> ------------------------------------------------------------------------
> Sigue los principales acontecimientos deportivos en directo. MSN Motor 
> <http://video.msn.com/video.aspx?mkt=es-es>
>
>
> ------------------------------------------------------------------------
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html