Freeradius 3 Log user calling IP in table

[Vijay S]

Pretty much what I suggested.

As mentioned you are using mikrotik as NAS. Its DHCP server can use radius
to authorize clients for DHCP address allocation. And sends updates
regarding the same to FR.
you can use the common AVP to map the data.

Regards
Vijay A.

On Thu, Nov 21, 2019, 17:45 Alan DeKok <aland at deployingradius.com> wrote:

> 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.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html