Re: Frame-IP-Address in SQL?

Mitchell, Michael J wrote:
> The accounting_xxx_query queries in sql.conf are run in response to the
> freeRADIUS server receiving an *accounting* request from a NAS. This is
> independent from the authorization/authentication process that has
> occurred previously. The sql queries log what was received in the
> *accounting* request that it is currently processing- that's why they
> are being called from the *accounting* sections of radiusd.conf, and why
> they are called accounting_xxx_query in sql.conf.

Thank for clearing me up. I don't really know that.

> So with this in mind, to insert Framed-IP-Address into the database you
> should use the value that is *received* in the *accounting* request, ie
> %{Framed-IP-Address}, as per the default configuration in sql.conf. If
> your NAS isn't sending the Framed-IP-Address attribute in the accounting
> request, then the sql module cannot insert it in the database.

That just too bad... My NAS didn't support Framed-IP-Address...
So no way to log it right?

> You appear to be struggling (or at least confused) with the fundamentals
> of RADIUS. I would suggest doing some reading up on the RADIUS protocol,
> and how a NAS interacts with a RADIUS server. Once you understand that,
> you'll better understand how freeRADIUS works, what the various sections
> of radiusd.conf mean, and you can begin to understand how to configure
> freeRADIUS to get the results you want.

Yes, I'm too confused, but thank to you, much have been clear out.

>
> I would also recommend testing your freeRADIUS configuration using
> "radclient" (comes with freeRADIUS - check the bin directory - man
> radclient). This will allow you to send arbitrary RADIUS requests to the
> server and determine the results in a controlled environment. Once you
> have that working correctly you can try it with a real NAS.

Thank You
Regards,
Chan Min Wai

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