Combine Proxy Answer with Local Information

[Alan DeKok]

Dan Fisher | Fluidata wrote:
> However I am having real problems getting the mysql part working. I have
> tried using examples other people are using that work and they either
> just get treated as a string or the server wont even run in debug mode.

  If it doesn't run in debugging mode, it prints a *descriptive* error
saying why.

> I don’t appear to be able to use the sql module itself as I get an error
> saying its not supported in the post-proxy configuration section.

  Use "sql.authorize", instead of just "sql".

> Where %{2} is the result of a regular expression to split a full
> username so I just have the domain to use later on.
>  
>         if ( "%{sql: SELECT Attribute from radreply where username
> =’%{2}’ and attribute='Tunnel-Password'}" ) {

  What the heck is that supposed to do?

> WARNING: Unknown module "sql" in string expansion "%{sql: SELECT
> Attribute from radreply where Username ='burst.net' and
> Attribute='Tunnel-Password'}"

  So... you haven't configured the SQL module.  How is it supposed to do
SQL qeuries?

> /etc/raddb/sites-enabled/default[562]: "SQL" modules aren't allowed in
> 'post-proxy' sections -- they have no such method.

  Use "sql.authorize".

  And configure the SQL module.

  Alan DeKok.