Invalid variable expansion, mysql pattern matching, like %

[Matthew Newton]

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 at 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 at le.ac.uk>