sql returns fail for some stop requests

[Arran Cudbard-Bell]

On 22 Jul 2012, at 11:56, Amir Tal wrote:

> Adding unique key to the database results in the following being returned from rlm_sql,
> What happen to accounting data when a duplicate entry is encountered?
> In addition, currently there is no scheduled clearing of the data in radacct table, wont this increase in occurrence?
>  
> --
> [sql]   expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> shimoni
> [sql] sql_set_user escaped user --> 'shimoni'
> [sql]   expand: %{Acct-Input-Gigawords} -> 0
> [sql]   expand: %{Acct-Input-Octets} -> 0
> [sql]   expand: %{Acct-Output-Gigawords} -> 0
> [sql]   expand: %{Acct-Output-Octets} -> 0
> [sql]   expand: %{Acct-Delay-Time} -> 12
> [sql]   expand:  UPDATE radacct SET  acctstoptime       = '%S',  acctsessiontime    = '%{Acct-Session-Time}',  acctinputoctets    = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',  acctoutputoctets   = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}',  acctterminatecause = '%{Acct-Terminate-Cause}',  acctstopdelay      = '%{%{Acct-Delay-Time}:-0}',  connectinfo_stop   = '%{Connect-Info}' WHERE acctsessionid   = '%{Acct-Session-Id}' AND username          = '%{SQL-User-Name}' AND nasipaddress      = '%{NAS-IP-Address}' ->  UPDATE radacct SET  acctstoptime       = '2012-07-22 02:03:28',  acctsessiontime    = '0',  acctinputoctets    = '0' << 32 | '0',  acctoutputoctets   = '0' << 32 | '0',  acctterminatecause = 'User-Error',  acctstopdelay      = '12',  connectinfo_stop   = '' WHERE acctsessionid   = 'erx ip:109.226.0.9:172.29.81.67:3280:96f8:1aa8:87fb:4d2:0062712021' AND username          = 'shimoni' AND nasipaddress      = '109.226.1.12'
> [sql]   expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql
> rlm_sql_mysql: MYSQL check_error: 1062 received
> [sql] Couldn't insert SQL accounting STOP record - Duplicate entry 'c6d3d253355b3dcf' for key 2
> rlm_sql_mysql: MYSQL check_error: 1062 received
> rlm_sql_mysql: Cannot store result
> rlm_sql_mysql: MySQL error 'Duplicate entry 'c6d3d253355b3dcf' for key 2'
> rlm_sql (sql): Released sql socket id: 11
> ++[sql] returns fail
> --

Can you please build against the current v2.1.x HEAD; the debug output doesn't make sense when checking through the rlm_sql.c code. Could you also post your dialup.conf file.

-Arran
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120722/af96ab18/attachment.html>