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.
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.
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.
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.
Hope that helps,
Mike
>Alan DeKok wrote:
>> Chan Min Wai <[EMAIL PROTECTED]> wrote:
>>
>>>What about the info that provided by the freeradius?
>>>When we are using ippool which meant that the ipaddress
>actually came
>>>from us. So we should be able to log them right?
>>
>>
>> When the IP address is assigned, yes.
>>
>>
>>>I do try %{reply:FRAME-IP-ADDRESS} in the sql.conf but that
>isn't working.
>>
>>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
