VMPS sql error - WARNING: Unknown module "sql" in string expansion "%"

[Keith Olsen]

Thanks Alan,

that resolved it.

I’ve spent a fair bit of time getting the VMPS stuff working, in particular with a mysql DB, and have been documenting for the project I am using this on. 

I would be more than happy to share the cookbook on configuring the VMPS if you think there’s any value.

I know there is not much call for VMPS, but I know I would have appreciated a single source to follow.

IF there’s value, let me know where and how I can contribute the documentation.

Thanks for the help!

Keith

On Jan 18, 2015, at 7:25 PM, Alan DeKok <aland at deployingradius.com> wrote:

> On Jan 18, 2015, at 8:37 PM, Keith Olsen <keith.r.olsen at gmail.com> wrote:
>> I have installed 2.2.6 from source on Ubuntu 14.10 and compiled and installed the sql driver
>> 
>> I uncommented the $INCLUDE sql.conf line in radiusd.conf and assured the sql.conf is configured for my mysql environment.
>> 
>> radiusd -X starts without any errors, but when my switch queries for the mac 2 vlan mapping I get the error:
>> 
>> WARNING: Unknown module "sql" in string expansion “%”
> 
>  You’re using the SQL module in an expansion, but not using it as a normal module.  Version 2 isn’t smart about this.  Version 3 is better.
> 
>  You should edit radiusd.conf, and look for the “instantiate” section.  Then, add “sql” there.  That will fix the problem.
> 
>  Alan DeKok.
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html