SQL: radpostauth empty fields

[Conrad Classen]

Have a look at the very bottom of the 
/etc/freeradius/mods-config/sql/main/postgresql/queries.conf file.


You will have to add in the two missing fields if you want them.

Cheers.


On 2023/09/20 20:38, Stephane Bourque wrote:
> Hi,
>
> We are using FreeRadius with SQL and everything is working fine right now.
> We are using PostgreSQL. We are noticing all empty fields in the
> radpostauth DB, namely callingstationid and calledstationid. All of our
> sites have the following:
>
> post-auth {
> update {
> &reply: += &session-state:
> }
> sql06
> exec
> remove_reply_message_if_eap
> Post-Auth-Type REJECT {
> eap06
> remove_reply_message_if_eap
> }
>
> Post-Auth-Type Challenge {
> }
> }
>
> I am assuming this is where something is missing to update these fields. I
> am not finding information of what we would need to add or modify in order
> to populate the fields.
>
> Is there a link you can point me to or an explanation on how to solve this
> problem?
>
> We have not modified the basic SQL queries or DB schemas.
>
> Thank you.
>
>