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
>
BEGIN:VCARD
VERSION:2.1
N:Guncer;Ugur
FN:Ugur Guncer ([EMAIL PROTECTED])
ORG:Telebizz Internet Hizmetleri
TITLE:Sistem Yoneticisi
TEL;WORK;VOICE:+90 (212) 347 69 59
TEL;CELL;VOICE:+90 (532) 748 29 78
TEL;WORK;FAX:+90 (212) 347 69 49
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Akinci Bayiri=0D=0ASokak No:13 Cevre Apt. =0D=0AB Blok Daire: 5;Mecidiyeko=
y, Istanbul;;80290;T=FCrkiye
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Akinci Bayiri=0D=0ASokak No:13 Cevre Apt. =0D=0AB Blok Daire: 5=0D=0AMecidiy=
ekoy, Istanbul 80290=0D=0AT=FCrkiye
URL;WORK:http://www.telebizz.org.uk
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20040422T084832Z
END:VCARD
