and a second thing, if you have multiple radius-servers running remove Client-IP from rlm_unique so that AcctUniqueId is consitent over the machines. but I just made AcctUniqueId a primary key in the DB, works also for me..
Michael > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Ugur GUNCER > Sent: Monday, September 20, 2004 11:57 PM > To: [EMAIL PROTECTED] > Subject: RE: Multiple Accounting Stop packet and rlm_sql (on Mysql) > > > I have a same problem but i fixed > > > You can fix this problem with adding AcctSessionId = > '%{AcctSessionId} > and AcctUniqueId='%{ AcctUniqueId} to WHERE segment at > your sql query > > Iyi Calismalar > Saygilarimla > > > > Ugur GUNCER > Sistem Yoneticisi > Telebizz Tel. ve Int. Hizm. > > Office = +90 212 347 6959 > Gsm = +90 544 535 9737 > Fax = +90 212 347 6949 > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On > > Behalf Of emy emy > > Sent: Monday, September 20, 2004 6:26 PM > > To: [EMAIL PROTECTED] > > Subject: Multiple Accounting Stop packet and rlm_sql (on Mysql) > > > > Hi, > > > > i'm using freeradius with rlm_sql module, and all work > > correctly except when > > Our NAS send multiple accountig stop packets to radius > > reguarding the same session. This couse problem because > > AcctStopTime was updated every time a stop packet arrives, > > and i must save only AcctStopTime sended the first Time. I > > have tryed to change acct_stop_query adding to WHERE condition this: > > accounting_stop_query = "UPDATE ${acct_table} SET > > AcctStopTime = '%S', \ > > AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets > > = '%{Acct-Input-Octets}', \ > > AcctOutputOctets = '%{Acct-Output-Octets}', > > AcctTerminateCause = '%{Acct-Terminate-Cause}', \ > > AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = > > '%{Connect-Info}' \ > > WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName > > = '%{SQL-User-Name}'\ > > AND NASIPAddress = '%{NAS-IP-Address}' and AcctStopTime = 0" > > > > Adding control for acctstoptime=0, but with this condition > > all acct-stop packet recived after the first ,execute the > > accounting_stop_query_alt query, and create on radacct > > duplicate session (no good). > > > > Any Ideas? > > > > Thanks to all > > Amy > > > > _________________________________________________________________ > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > > http://join.msn.com/?page=features/virus > > > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > > --- auto-converted to plaintext by ELAB4 > > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html