SQL: radpostauth empty fields
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. -- *Stephane Bourque* *CEO & Founder* *Arilia Wireless Inc.* *"Everything connected"* stephane.bourque@arilia.com +1(778)558-3524 *www.arilia.com <http://www.arilia.com>*
On Sep 20, 2023, at 2:38 PM, Stephane Bourque <stephane.bourque@arilia.com> wrote:
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.
Then the NAS isn't sending the Calling-Station-ID or Called-Station-ID attributes. FreeRADIUS can't invent things it's never seen.
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?
Read the debug log as suggested in all of the documentation, including the message you get when you join the list. Then, notice that there's no Calling-Station-ID or Called-Station-ID attributes in the packets. Or, you're using PEAP or TTLS. And you're logging the *inner* authentication, which doesn't have the Calling-Station-ID or Called-Station-ID attributes. To fix that, just edit the "inner-tunnel" virtual server, and copy those attributes from the outer request. Alan DeKok.
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.
On Sep 20, 2023, at 2:45 PM, Conrad Classen <conrad.classen@gmail.com> wrote:
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.
That, too. :) But always read the debug output. It will say exactly what it's doing, and it should be clear if the problem is that the packets don't contain Calling-Station-Id, *or* the SQL queries don't use it. Alan DeKok.
Thanks Alan & Conrad. The queries.conf did not have the 2 missing fields. Just added and all is working as expected now. Thanks for the quick response. On Wed, Sep 20, 2023 at 11:49 AM Alan DeKok <aland@deployingradius.com> wrote:
On Sep 20, 2023, at 2:45 PM, Conrad Classen <conrad.classen@gmail.com> wrote:
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.
That, too. :)
But always read the debug output. It will say exactly what it's doing, and it should be clear if the problem is that the packets don't contain Calling-Station-Id, *or* the SQL queries don't use it.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Alan DeKok -
Conrad Classen -
Stephane Bourque