Re: v4 how to insert reply attributes in the radpostauth sql query?

Alan DeKok via Freeradius-Users <[email protected]> Thu, 26 Mar 2026 06:54:38 +1300

Newsgroups	gmane.comp.freeradius.user
Message-ID	<[email protected]>

On Mar 25, 2026, at 11:44 PM, James Wood via Freeradius-Users <[email protected]> wrote:
> Just before we perform the insert, I am trying to get all of the reply
> attributes we're sending as described here:
> 
> https://www.freeradius.org/documentation/freeradius-server/4.0.0/reference/xlat/pairs/print.html
> 
> &control.Tmp-String-9 := "%pairs.print(reply.[*])"

  You don't need quotes around the %pairs.print() call.  But you likely need to quote the reply.[*] argument.

> and then referencing the tmp string on the query.

  Or, just use %pairs.print() directly.

> I get:
> 
> %pairs.print(reply.[*])
> ^: Unresolved expansion functions are not allowed here
> 
> Any thoughts? If this isn't the right way, please advise how I can get
> these reply attributes into a string ready for the sql insert.

  The %pairs.print() function is in the current git "master" branch.  It's tested in CI on every commit.

$ git grep 'pairs.print' src/tests/keywords
src/tests/keywords/pairs:result_string := "%str.concat(%pairs.print('Tmp-Group-0.[*]'), ', ')"
src/tests/keywords/pairs:result_string := "%pairs.print('Tmp-Group-0.Filter-Id')"
...

  Make sure you're using a recent version of v4.  If you're running something from many months ago, it will out of date.

  Alan DeKok.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

signature.asc (application/pgp-signature, 833 B)