rlm_postgresql , accounting and Framed-IP-Address

[Phil Mayers]

Francisco Gimeno wrote:
> hello.. Thanks for your answer!...
> 
> then, how could I put the IP there?
> Is the post-auth hook the right place?

Yes, if you execute an SQL query in the post-auth section it can use 
%{reply:Framed-IP-Address}

> 
> 2007/2/12, Phil Mayers < p.mayers at imperial.ac.uk 
> <mailto:p.mayers at imperial.ac.uk>>:
> 
>     Francisco Gimeno wrote:
>      >
>      > The %{reply:Framed-IP-Address} or %{Framed-IP-Address} isn't
>     xlated at
>      > all... SQL module is executed after sqlippool, so, that variable
>     should
>      > be available.
> 
>     Nop. Accounting replies contain NO attributes, therefore reply:Anything
>     is invalid/empty.
> 
>     For accounting queries to log the IP address, your NAS must send the
>     Framed-IP-Address attribute in the accounting request. If it doesn't (as
>     it must not be) you can't log it.
> 
>     Consult the documentation for your NAS.
> 
>     You've undoubtedly taken that reply:Framed-IP-Address from the
>     "post-auth" query where it is valid.
> 
> 
> 
> ------------------------------------------------------------------------
> 
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html