On Thu, Jan 12, 2012 at 3:19 PM, asgzl <Li.q.zou@alcatel-sbell.com.cn> wrote:
Dear FR users, I am using FR 2.1.7, mysql as DB. I want to realize the scenario that the pppoe client will be authentic by pppoe username, password and mac address. And at the user's first login, MAC will be remembered (not check at first time). Of course at necessary time the radius admin can remove the MAC remembered so new MAC can be learn. I searched the forum, there are similar topics before, but either too "old" on 1.0.x or not in detail. Anybody can help? Appreciated.
"man unlang". Short version, you can get values from sql db using something like (unstested): update control { Tmp-String-0 := "%{sql: SELECT value from radcheck WHERE username = ... AND attribute = ...}" } ... and you can write values using something like update control { Tmp-String-1 := "%{sql: INSERT IGNORE into radcheck VALUES (.....)}" } -- Fajar