On 05/01/12 15:24, McSparin, Joe wrote:
Does this seem like a doable scenario in the users file it doesn't
return anything but I'm not sure if it is query issue or if those values
are not available in the users file.
DEFAULT Auth-Type = "ntlm_auth"
Tunnel-Type = "VLAN",
Tunnel-Medium-Type = "IEEE-802",
Tunnel-Private-Group-id = "%{sql:SELECT 'vlans.assigned_vlan' FROM
'vlans' WHERE 'vlans.device_mac' = '%{Calling-Station-Id}'}"
That should work.
What does the "debug" say?
It is often preferable to use "unlang" to "users" files entries in the
current server versions; there's a bit more flexibility, in particular
you can run the SQL query once in post-auth, and in debug mode you get a
better idea of what actually matches. e.g.
post-auth {
update reply {
Tunnel-Type = "VLAN",
Tunnel-Medium-Type = "IEEE-802",
Tunnel-Private-Group-id = "%{sql:SELECT ...}"
}
}
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
