rlm_sql question

[Norbert Wegener]

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
>