How to define Pool-Name with radcheck table

[lucky]

Hi Alan

I removed Fall-Through row. then it works fine!
Thanks!

2014-05-01 13:05 GMT+09:00 lucky <aurens.memuro02 at gmail.com>:
> Hi Alan
>
> I wrote Pool-Name and Fall-Through as below.
> But it doesn't work.
> Is there any wrong ?
>
> mysql> select * from radcheck;
> +----+---------------------+--------------------+----+--------+
> | id | username            | attribute          | op | value  |
> +----+---------------------+--------------------+----+--------+
> |  1 | test123 at test.or.jp  | Cleartext-Password | := | test123|
> |  2 | test123 at test.or.jp  | Pool-Name          | := | pool1  |
> |  3 | test123 at test.or.jp  | Fall-Through       | =  | yes    |
> +----+---------------------+--------------------+----+--------+
> 3 rows in set (0.00 sec)
>
> 2014-04-30 22:50 GMT+09:00 Alan DeKok <aland at deployingradius.com>:
>> yata wrote:
>>> I'm using freeradius2 as a radius-server and dhcp-server.
>>> When I connect to freeradius by defined user in /etc/raddb/users , it
>>> is successful.
>>> But I wanna define users in mysql's radcheck table.
>>> I inserted userID and password in radcheck table then following
>>> messages were displaied and connection failed.
>>
>>   You need to follow the instructions.  Do NOT put "User-Password" into
>> the radcheck table.  Put "Cleartext-Password".
>>
>>> it seems to be failed to find pool-name
>>> How should I define pool-name in radcheck table or somewhere?
>>
>>   You define it just like any other attribute.  You've already put a
>> password entry into the radcheck table.  Add another row for the
>> Pool-Name.  It's exactly the same.
>>
>>   Alan DeKok.
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html