Re: 1.1.7 and rlm_sql_mysql duplicated query
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 + From: [EMAIL PROTECTED] 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Re: 1.1.7 and rlm_sql_mysql duplicated query
Santiago Balaguer Garc#237;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. The problem was in the NAS itself indeed and not in freeradius. Thanks. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
RE: 1.1.7 and rlm_sql_mysql duplicated query
The answer is not totally correct. Because a microcuts in the connectibity of hotspot cause that hotspot re-sends the acct request. In that case, you have to desactivate: - accounting_start_query_alt - accounting_stop_query_alt 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 + From: [EMAIL PROTECTED] 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 _ La vida de los famosos al desnudo en MSN Entretenimiento http://entretenimiento.es.msn.com/- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html