Alan DeKok wrote:
Mike Jakubik <mikej@rogers.com> wrote:First of all, the above can be accomplished in SQL using the checkval module and the += OP. Thats great and dandy until you need to specify numbers that users can NOT dial to. In any case that will not work for me, as i need to do this for each group defined in SQL, not DEFAULT for all users.So add the group as an additional check item.
It does not work with the != OP.
This doesn't work quite the same in SQL, because the module doesn't support multiple entries.Yes it does, just not with a logical NOT.As I said, it's not really supported.I installed FreeRadius because it touted SQL support, now im finding out the features are limited, which is disappointing.There are few programs with unlimited features. That being said, I still think what you want is doable in FreeRADIUS. Perhaps you could try discussing the problem, rather than SQL as a solution. Odds are there's more than one way to reach the goal. If you're fixated on SQL, you may not see another solution.
If there is a way to accomplish this outside of SQL, im quite open to suggestions. As long as i can refer to the groups which are in SQL. Basically, i need to be able to restrict certain user groups from dialing certain numbers.