sql.conf problem

Norbert Wegener nw at sbs.de
Wed Oct 25 13:30:19 CEST 2006


Alan DeKok schrieb:
> Norbert Wegener <nw at sbs.de> wrote:
>   
>> In a certain context I want to accept all incoming requests.
>>     
>
>   Ok...
>
>   
>> mysql> select * from radcheck where UserName='000000000009';
>> +---------+--------------+--------------+----+----------+---------------------+
>> | id      | UserName     | Attribute    | op | Value    | 
>> validto             |
>> +---------+--------------+--------------+----+----------+---------------------+
>> | 1159463 | 000000000009 | Hint         | += | assignvl | 2006-10-31 
>> 00:00:00 |
>> | 2512785 | 000000000009 | Auth-Type    | := | Accept   | 
>> NULL                |
>> | 2512786 | 000000000009 | Idle-Timeout | =  | 123      | 
>> NULL                |
>>     
>
>   What are you trying to do here?  You're setting Hint (which won't
> work the way you want), ...
This here is still experimental. Finally I want to do the following: 
User accounts may belong to a group and the group information isn't 
stored in the radcheck table, because it depends on different parameters 
and may change more or less frequently. Therefore I would like to setup 
an authorize_check_query, that determines the group the account belongs 
to and add a Hint from radcheck, depending on the query result. When 
this Hint is assigned, I would like to get results depending on that 
Hint in authorize_group_check_query.

So how could I assign a Hint using MySQL and use it later? Is it 
possible at all the way I would like to use it?

Thanks
Norbert Wegener


 



More information about the Freeradius-Users mailing list