Invalid variable expansion, mysql pattern matching, like %
Hello, I'm using FreeRADIUS Version 3.0.8in a debian 8. I want to exec a sql query to return a value in Reply-Message: /etc/freeradius/users user Cleartext-Password := "pass" Reply-Message := "%{sql:SELECT username FROM radpostauth WHERE client like 'PA%' ....}" When I run freeradius server in debug mode, I get: Tue May 3 11:58:52 2016 : Debug: (0) files: ::: Examining Reply-Message Tue May 3 11:58:52 2016 : ERROR: (0) files: %{sql:SELECT username FROM radpostauth WHERE client like 'PA%' .... Tue May 3 11:58:52 2016 : ERROR: (0) files: ^ Invalid variable expansion If I delete the % in users files: /etc/freeradius/users user Cleartext-Password := "pass" Reply-Message := "%{sql:SELECT username FROM radpostauth WHERE client like 'PA' ....}" When I run freeradius server in debug mode, I get: rlm_sql (sql): Reserved connection (4) (0) files: Executing select query: SELECT username FROM radpostauth WHERE client like 'PA' and ... (0) files: SQL query returned no results rlm_sql (sql): Released connection (4) (0) files: EXPAND %{sqllocal:SELECT username FROM radpostauth WHERE client like 'PA' and I have this running in older versions of freeradius.Sorry for my english and thank you very much in advance. :::::::::::::::::::::::::::::::::::: :: Ana Gallardo Gómez :: ::::::::::::::::::::::::::::::::::::
On Tue, May 03, 2016 at 12:26:15PM +0200, Ana Gallardo Gómez wrote:
Tue May 3 11:58:52 2016 : Debug: (0) files: ::: Examining Reply-Message Tue May 3 11:58:52 2016 : ERROR: (0) files: %{sql:SELECT username FROM radpostauth WHERE client like 'PA%' .... Tue May 3 11:58:52 2016 : ERROR: (0) files: ^ Invalid variable expansion
% is the expansion escape character. Try %% instead. See http://networkradius.com/doc/3.0.10/unlang/xlat_character.html Matthew -- Matthew Newton, Ph.D. <mcn4@le.ac.uk> Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk>
participants (2)
-
Ana Gallardo Gómez -
Matthew Newton