Please forget this question. Someone had changed a network setting, so that mysql and rlm_sql did not reach the same databases. Right now everything works as expected. Sorry Norbert Wegener Norbert Wegener schrieb:
I am using freeradius 1.1.4 with mysql.
I had to change the authorize_check_query.
authorize_check_query = "SELECT radcheck.id, radcheck.UserName, radcheck.Attribute, radcheck.Value, radcheck.op \ FROM radcheck,nas \ WHERE (Username = '%{SQL-User-Name}') \ and (nas.type='Enterasys Networks' and nas.nasname= '%{NAS-IP-Address}') \ ORDER BY id"
Now radiusd -AX gives me: .. rlm_sql (enterasys): sql_set_user escaped user --> '000000007509' radius_xlat: 'SELECT radcheck.id, radcheck.UserName, radcheck.Attribute, radcheck.Value, radcheck.op FROM radcheck,nas WHERE (Username = '000000007509') and (nas.type='Enterasys Networks' and nas.nasname= '172.31.110.150') ORDER BY id' rlm_sql (enterasys): Reserving sql socket id: 3 rlm_sql_mysql: query: SELECT radcheck.id, radcheck.UserName, radcheck.Attribute, radcheck.Value, radcheck.op FROM radcheck,nas WHERE (Username = '000000007509') and (nas.type='Enterasys Networks' and nas.nasname= '172.31.110.150') ORDER BY id rlm_sql (enterasys): User 000000007509 not found in radcheck
..
where the same query in mysql shows:
mysql> SELECT radcheck.id, radcheck.UserName, radcheck.Attribute, radcheck.Value, radcheck.op FROM radcheck,nas WHERE (Username = '000000007509') and (nas.type='Enterasys Networks' and nas.nasname= '172.31.110.150') ORDER BY id; +---------+--------------+-----------+--------+----+ | id | UserName | Attribute | Value | op | +---------+--------------+-----------+--------+----+ | 1180894 | 000000007509 | Auth-Type | Accept | += | +---------+--------------+-----------+--------+----+ 1 row in set (0.00 sec)
I would have expected the same results as well from rlm_sql as from mysql directly. Why do the results differ?
Thanks Norbert Wegener
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html