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@test.or.jp | Cleartext-Password | := | test123| | 2 | test123@test.or.jp | Pool-Name | := | pool1 | | 3 | test123@test.or.jp | Fall-Through | = | yes | +----+---------------------+--------------------+----+--------+ 3 rows in set (0.00 sec) 2014-04-30 22:50 GMT+09:00 Alan DeKok <aland@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