v4 how to insert reply attributes in the radpostauth sql query?
I'm playing around with v4 and one thing I can't get working is how to insert all of the mapped reply attributes when I insert into the SQL radpostauth table. 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/x... &control.Tmp-String-9 := "%pairs.print(reply.[*])" and then referencing the tmp string on the query. 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. Thanks James -- Visit purple.ai <https://purple.ai/> Purple on LinkedIn <https://uk.linkedin.com/company/purple-wifi> Email disclaimer <http://www.purple.ai/email-disclaimer/>
On Mar 25, 2026, at 11:44 PM, James Wood via Freeradius-Users <freeradius-users@lists.freeradius.org> 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/x...
&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.
Hi Alan, Thanks for this. I am on the 'alpha1' release as I couldn't find the v4 source directly on GitHub. Do you have the URL directly to the latest v4 source files so I can rebuild the very latest? Thanks, James On Wed, 25 Mar 2026, 17:54 Alan DeKok, <alan.dekok@inkbridge.io> wrote:
On Mar 25, 2026, at 11:44 PM, James Wood via Freeradius-Users < freeradius-users@lists.freeradius.org> 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/x...
&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.
-- Visit purple.ai <https://purple.ai/> Purple on LinkedIn <https://uk.linkedin.com/company/purple-wifi> Email disclaimer <http://www.purple.ai/email-disclaimer/>
On Mar 26, 2026, at 10:44 AM, James Wood <james.wood@purplewifi.com> wrote:
Thanks for this. I am on the 'alpha1' release as I couldn't find the v4 source directly on GitHub. Do you have the URL directly to the latest v4 source files so I can rebuild the very latest?
The "alpha1" release is many years old. :( You can just use the "master" branch from GitHub. It's the latest development version of v4. The CI/CD framework ensures that the server always builds, and always passes the tests. Alan DeKok.
Thanks, I'll rebuild from master and work from there. James On Wed, 25 Mar 2026, 22:01 Alan DeKok, <alan.dekok@inkbridge.io> wrote:
On Mar 26, 2026, at 10:44 AM, James Wood <james.wood@purplewifi.com> wrote:
Thanks for this. I am on the 'alpha1' release as I couldn't find the v4 source directly on GitHub. Do you have the URL directly to the latest v4 source files so I can rebuild the very latest?
The "alpha1" release is many years old. :(
You can just use the "master" branch from GitHub. It's the latest development version of v4. The CI/CD framework ensures that the server always builds, and always passes the tests.
Alan DeKok.
-- Visit purple.ai <https://purple.ai/> Purple on LinkedIn <https://uk.linkedin.com/company/purple-wifi> Email disclaimer <http://www.purple.ai/email-disclaimer/>
participants (2)
-
Alan DeKok -
James Wood