Freeradius 3 Log user calling IP in table

[Alan DeKok]

On Nov 20, 2019, at 10:28 PM, JAHANZAIB SYED <aacable at hotmail.com> wrote:
> 
> Let me give more details.
> 
> When end user connects with the network , he gets IP from the NAS DHCP like 10.0.0.20
> When he connects with the NAS using PPPoE Dialer, he then gets IP from the NAS pool like 221.112.112.1 [public IP], this is Framed-Ip-Address which is logged in radacct table by default.
> 
> What we want is to log the end user dhcp IP like 10.0.0.20 into the table (either separate table or additional column named userdhcpip in radacct table
> 
> is there any thing we can get this dhcp ip into the table?

  Does that attribute show up in a packet?  Read the debug output to see.

a) yes - update the SQL and queries to log it

b) no - fix the NAS so that the NAS sends it in a packet.  No amount of poking the RADIUS server will help.

  Alan DeKok.