Re: Attach mac address to username

[Shane]

Joachim Bloche wrote:
Would your suggestion be automatic or would I need to manually add the
attribute.
   

I think you can do it automatically, provided your NAS sends
Calling-Station-Id with the authentication request. In this case you
may rewrite the post-auth request to add the row in radcheck (see
sql.conf). But I'm quite new to freeradius, and there may be 2 issues
: I'm not sure wether it's possible to use an INSERT in post-auth, and
I'm not sure wether the NAS will send the calling-station-id with the
authentication-request (but if it doesn't, there will be no
solution...). Anyway, this will be easy to check, but I have no radius
server for the week-end.
If this doesn't work, then you'll have to use a trigger or any other
mean, in order to insert the row in radcheck when the first accounting
start for this user occurs. This would be less convenient, but still
not very complicated.
Joachim
 

Ok I don't know how to do it.
Am I after something like this and where do I call it in sql.conf
"INSERT into ${authcheck_table} (id, UserName, Attribute, op, value) 
values('', '%{SQL-User-Name}', 'Calling-Session-Id', '==', 
'%{Called-Station-Id}')"

Thanks
Shane
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html