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.