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.