How to define Pool-Name with radcheck table

[lucky]

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