Hi folks, I think this has been talked about a couple of times in the past but i can not see the reply with the best way to achieve it so pardon me if i am duplicating the issue/concerns. radacct.groupname is empty obviously there is no default query for it. It's not coming in the radaccouting so i don't think we can do in the accounting query either. have someone already done it ? can you please guide us how to do it? I think writing down step by step will be helpful for the community. Our system information: FreeRADIUS Version 3.0.13 5.5.56-MariaDB MariaDB Server CentOS Linux release 7.4 Thanks --- Regards, Jehanzaib
On Feb 1, 2018, at 11:25 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I think this has been talked about a couple of times in the past but i can not see the reply with the best way to achieve it so pardon me if i am duplicating the issue/concerns.
The issue was already raised and answered.
radacct.groupname is empty obviously there is no default query for it. It's not coming in the radaccouting so i don't think we can do in the accounting query either. have someone already done it ? can you please guide us how to do it? I think writing down step by step will be helpful for the community.
The group name field is useless. The information already exists in SQL in other tables. So... you can get that information by doing other queries on the SQL tables. Alan DeKok.
Hi Alan, I disagree. Why its useless when the default schema have a field named as groupname? Why there is an empty column in my table ? Again you did not reply the best way to achieve. Honestly speaking this is really discouraging the way you replied. On 3/02/2018 1:17 AM, "Alan DeKok" <aland@deployingradius.com> wrote:
On Feb 1, 2018, at 11:25 PM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I think this has been talked about a couple of times in the past but i can not see the reply with the best way to achieve it so pardon me if i am duplicating the issue/concerns.
The issue was already raised and answered.
radacct.groupname is empty obviously there is no default query for it. It's not coming in the radaccouting so i don't think we can do in the accounting query either. have someone already done it ? can you please guide us how to do it? I think writing down step by step will be helpful for the community.
The group name field is useless. The information already exists in SQL in other tables. So... you can get that information by doing other queries on the SQL tables.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
On Feb 2, 2018, at 7:24 AM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I disagree. Why its useless when the default schema have a field named as groupname? Why there is an empty column in my table ?
i.e. there's a column in the table, and you want it filled with something. That isn't a good approach. WHY do you think it's important to fill that column with something? Why not just delete the column? The "group name" is there because someone added it more than 10 years ago, and it was never removed. It's not clear why it was added, and it's not clear what they intended to do with it.
Again you did not reply the best way to achieve. Honestly speaking this is really discouraging the way you replied.
Yes. I *do* want to discourage you from doing unnecessary and pointless work. The simple solution here is to just delete the column from the schema. Then you won't have to see an empty column. Alan DeKok.
I dont just want to fill it i wanted the groupname saved. Its really handy because we keep on changing the groupname with time so its better we save it somewhere. Sure we can delete it from radacct table since this is not related to acct. I can add it in the other table like radpostauth might be? What do you recommend? On 3/02/2018 1:32 AM, "Alan DeKok" <aland@deployingradius.com> wrote:
On Feb 2, 2018, at 7:24 AM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I disagree. Why its useless when the default schema have a field named as groupname? Why there is an empty column in my table ?
i.e. there's a column in the table, and you want it filled with something.
That isn't a good approach.
WHY do you think it's important to fill that column with something? Why not just delete the column?
The "group name" is there because someone added it more than 10 years ago, and it was never removed. It's not clear why it was added, and it's not clear what they intended to do with it.
Again you did not reply the best way to achieve. Honestly speaking this is really discouraging the way you replied.
Yes. I *do* want to discourage you from doing unnecessary and pointless work.
The simple solution here is to just delete the column from the schema. Then you won't have to see an empty column.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
On Feb 2, 2018, at 8:14 AM, J E H A N Z A I B <jehanzaib.kiani@gmail.com> wrote:
I dont just want to fill it i wanted the groupname saved. Its really handy because we keep on changing the groupname with time so its better we save it somewhere. Sure we can delete it from radacct table since this is not related to acct. I can add it in the other table like radpostauth might be?
What do you recommend?
Writing SQL queries to look for open connections without a group name, do the user -> group name lookup, and then write the group name. You can write a simple script to do this, and then run it in a cron job. This script *won't* go into the server, though. It's a very rare use-case, and something which can almost always be done via other methods. Alan DeKok.
participants (2)
-
Alan DeKok -
J E H A N Z A I B