Re: Attach mac address to username

> eg: would I have to add the table.
> radcheck
> id - - - - - - - - 4567
> UserName - - user1
> Attribute - - - Calling-Session-Id
> op - - - - - - - :=
> Value - - - - - 000bcdfxxx

I think this example is OK, but the op which should be '==' (':='
always matches and sets a freeradius parameter, I don't think that's
what we're looking for).

> Looking at radacct, I am receiving "CallingStationID" which appears to
> be the mac of the connecting client.

You're right, it is Calling-Station-Id, not session... apologizes.

> 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

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