Getting more info on radpostauth

[Ibrahim AKSIT]

Hello dear Andres Gomez and list members,

I have added additional fields like *ip*, *mac *into *radpostauth *table
and modified mysql queries as below accordingly
at  */etc/freeradius/mods-config/sql/main/mysql/queries.conf* file.


post-auth {
        query = "\
                INSERT INTO ${..postauth_table} \
                        (username, pass, reply, authdate, *ip*, *mac*) \
                VALUES ( \
                        '%{SQL-User-Name}', \
                        '%{%{User-Password}:-%{Chap-Password}}', \
                        '%{reply:Packet-Type}  - %{reply:Reply-Message}', \
                        '%S', \

*  '%{NAS-IP-Address}', \                        '%{Calling-Station-Id}' \*
            )"
}

I hope this is gonna help you and be informative.
Have a great day all folks.

İbrahim AKŞİT

Best Regards and Wishes
Yours Sincerely.


On Tue, Sep 29, 2020 at 3:09 AM Andrés Gómez <andres.gomez.ruiz at gmail.com>
wrote:

> Hi Alan and dear list.
>
> Currently I use freeradius 3 to authenticate wifi users using SQL module.
> After each  authentication request I can see a new entry on radpostauth
> table in my database.... Everything OK.
>
> Radpostauth table has the information about username, pass, reply message
> and authdate.
>
> I need a record about the callingstationid parameter that is arriving in
> each request. So, If I create a new row in that table, how can I modify the
> SQL query in order to insert the callingstationid in that table?
>
> Thanks a lot
>
>
> --
> *C. Andrés Gómez R.*
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html