How the hell do you use multiple NOT values with rlm_checkval and sql??

[Mike Jakubik]

Alan DeKok wrote:
> Mike Jakubik <mikej at 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.