issues with duplicate AcctUniqueId attribute values

[Alex Sharaz]

Thanks for that.

I'll take the detail.work file causing issues and  copy it over to a test
server and run that in debug mode.

thx for the unlang snippet


On 5 December 2016 at 12:24, Alan DeKok <aland at deployingradius.com> wrote:

> On Dec 5, 2016, at 6:14 AM, Alex Sharaz <alex.sharaz at york.ac.uk> wrote:
> >
> > While I track down why the above is happening ....
> >
> > 1). Can I enable debugging in just the buffered-sql virt server ? Its a
> > pain running all of a server in debug mode
>
>   Set up a test server with only buffered-sql.
>
> > 2). Is it possible to manually take a detail.work file and pipe it into
> > buffered sql offline?
>
>   Set up a test server.
>
> > 3). When buffered-sql sees
> >
> > rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
> > (4) sql: rlm_sql_postgresql: ERROR:  duplicate key value violates unique
> > constraint "radacct_acctuniqueid_key"
> > (4) sql: rlm_sql_postgresql: DETAIL:  Key
> > (acctuniqueid)=(e5aa2781f1f3842a1b9e7590ce9d2ab6) already exists.
> > (4) sql: SQL query returned: need alt query
> > (4) sql: No additional queries configured
> > rlm_sql (sql): Released connection (3)
> > (4)     [sql] = noop
> > (4)   } # accounting = noop
> > (4) detail (/var/spool/freeradius/detail): No response to request.  Will
> > retry in 30 seconds
> >
> > it seems to block processing of subsequent  statements. Any way of
> telling
> > it to skip that update log an error and move onto the next one?
>
> $ man unlang
>
>         ...
>         sql
>         if (noop) {
>                 ok
>         }
>
>   That should do it.
>
>   Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html