authentetication with mysql and NAS type= other

Fajar A. Nugraha list at fajar.net
Wed Dec 7 17:12:21 CET 2011


On Wed, Dec 7, 2011 at 11:02 PM, tolik_shavlovsky at mail.ru
<tolik_shavlovsky at mail.ru> wrote:
> SELECT id, username, attribute,
> value, op FROM radcheck WHERE username = 'KeepAliveUserNameAndPassword'
> ORDER BY id

> SELECT groupname FROM radusergroup
> WHERE username = 'KeepAliveUserNameAndPassword' ORDER BY priority

What do you get when you execute those two queries in mysql directly?

> [sql] User KeepAliveUserNameAndPassword not found

the sql module says the user is not found. It doesn't lie.

> =======================================
> login and password are correct!

And how did you know that? Did you setup the tables correctly? Hint:
execute those two queries above.

-- 
Fajar



More information about the Freeradius-Users mailing list