authentic by chap (pppoe) and mac

Fajar A. Nugraha list at
Thu Jan 12 09:49:52 CET 2012

On Thu, Jan 12, 2012 at 3:19 PM, asgzl <Li.q.zou at> 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 (.....)}"


More information about the Freeradius-Users mailing list