Re[6]: authentetication with mysql and NAS type= other

[Толик Шавловский]

Hi,

mysql> use freeradius;
Database changed
mysql> select * from radcheck;
+----+-----------------+--------------------+----+------------------+
| id | username        | attribute          | op | value            |
+----+-----------------+--------------------+----+------------------+
|  1 | user            | Password           | == | user             |
|  3 | test at wimax.com  | Cleartext-Password | := | test             |
|  5 | test1 at wimax.com | Cleartext-Password | := | test             |
| 10 | user            | Simultaneous-Use   | := | 1                |
|  8 | test at wimax.com  | Framed-Filter-Id   | := | SP=data:MSF=data |
|  9 | test1 at wimax.com | Framed-Filter-Id   | := | SP=data:MSF=data |
+----+-----------------+--------------------+----+------------------+


user is for WiFi
test and tes1 is for WimAX.

all usernames are authenticated for WiFi.

Wimax cannot.  I don't know why it uses username = 'KeepAliveUserNameAndPassword', like in the debug?? when i used users file in FR with the same usernames, it was ok. I really use same usernames for auth in my Wimax CPEs.

07 декабря 2011, 20:17 от "Fajar A. Nugraha" <list at fajar.net>:
> 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
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>