groupname not coming in the radacct table
Hi folks, I am running *FreeRADIUS 3.0.13 *and missing the groupname in the radacct table. Apart from groupname everything else seems to be working fine. Any idea how can i add it ? I dont think i can add into the account insert insert query. but i tried it and its empty there as well. i tried in /etc/raddb/mods-config/sql/main/mysql/queries.conf
On Dec 12, 2017, at 4:27 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I am running *FreeRADIUS 3.0.13 *and missing the groupname in the radacct table. Apart from groupname everything else seems to be working fine.
Any idea how can i add it ? I dont think i can add into the account insert insert query. but i tried it and its empty there as well. i tried in /etc/raddb/mods-config/sql/main/mysql/queries.conf
You have to get the group name from somewhere. It's not in the RADIUS packets, so you have to write policies to check for it. And you can't check for it in an Access-Request packet, and hope it's in a later Accounting-Request packet. You have to do the check for each packet individually. Alan DeKok.
Ok ya i have just checked and its not in the Access request. Do u know how to acehive this please ? There should an easy way because i assign a group to a user and the usergroup repies as well. On 14/12/2017 2:37 AM, "Alan DeKok" <aland@deployingradius.com> wrote:
On Dec 12, 2017, at 4:27 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I am running *FreeRADIUS 3.0.13 *and missing the groupname in the radacct table. Apart from groupname everything else seems to be working fine.
Any idea how can i add it ? I dont think i can add into the account
insert
insert query. but i tried it and its empty there as well. i tried in /etc/raddb/mods-config/sql/main/mysql/queries.conf
You have to get the group name from somewhere. It's not in the RADIUS packets, so you have to write policies to check for it.
And you can't check for it in an Access-Request packet, and hope it's in a later Accounting-Request packet. You have to do the check for each packet individually.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
On Dec 13, 2017, at 2:11 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
Ok ya i have just checked and its not in the Access request.
Please read what I wrote... I *know* it's not in the Access-Request. It's in a database. YOUR database. So... do you know what database you're using? Do you know where those groups are stored in the DB? Do you know how to query groups in the DB?
Do u know how to acehive this please ? There should an easy way because i assign a group to a user and the usergroup repies as well.
Then you already know the answers to the questions above. And, you should be able to come up with a solution. Alan DeKok.
Thanks Alan. I am confused because groupname is in the default schema in the radacct table. Why will we put in there if the default mysql query dont have it. On 14/12/2017 8:19 AM, "Alan DeKok" <aland@deployingradius.com> wrote:
On Dec 13, 2017, at 2:11 PM, J E H A N Z A I B < jehanzaib.kiani@gmail.com> wrote:
Ok ya i have just checked and its not in the Access request.
Please read what I wrote... I *know* it's not in the Access-Request. It's in a database. YOUR database.
So... do you know what database you're using? Do you know where those groups are stored in the DB? Do you know how to query groups in the DB?
Do u know how to acehive this please ? There should an easy way because i assign a group to a user and the usergroup repies as well.
Then you already know the answers to the questions above. And, you should be able to come up with a solution.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
On Dec 13, 2017, at 2:39 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
Thanks Alan. I am confused because groupname is in the default schema in the radacct table. Why will we put in there if the default mysql query dont have it.
The configurations have changed over time. Feel free to suggest improvements. Alan DeKok.
ya looks like it something is missed since it used to be working in 2.x version On Thu, Dec 14, 2017 at 8:56 AM, Alan DeKok <aland@deployingradius.com> wrote:
On Dec 13, 2017, at 2:39 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
Thanks Alan. I am confused because groupname is in the default schema in the radacct table. Why will we put in there if the default mysql query dont have it.
The configurations have changed over time. Feel free to suggest improvements.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
-- Regards, Jehanzaib
On Dec 13, 2017, at 4:46 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
ya looks like it something is missed since it used to be working in 2.x version
You know, I do have access to the v2 source... Nothing in v2 would put "groupname" into the "radacct" table. If it does that in your configuration, it's because you made a change to the default configuration, and added this. Alan DeKok.
participants (2)
-
Alan DeKok -
J E H A N Z A I B