issues with duplicate AcctUniqueId attribute values

[Alan DeKok]

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.