Attributes Bandwidth in radgrouprepy table

tnt at kalik.net tnt at kalik.net
Mon Dec 15 19:36:48 CET 2008


>[sql]   expand: SELECT id, username, attribute, value, op FROM radcheck
>WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username,
>attribute, value, op FROM radcheck WHERE username =
>'pepe at dominio.com'           ORDER BY id
>WARNING: Found User-Password == "...".
>WARNING: Are you sure you don't mean Cleartext-Password?
>WARNING: See "man rlm_pap" for more information.

Fix that.

>[sql] User found in radcheck table
>rlm_sql (sql): Released sql socket id: 4
>++[sql] returns ok
>

And what happened to authorize_reply_query? It would be helpful to see
part of the server startup debug where sql module is instatiated.

Ivan Kalik
Kalik Informatika ISP

>It's checking the query in radcheck but not in radgroupreply. And I've
>tested the query in dialup.conf and seems correct
>
>        authorize_group_reply_query = "SELECT ${groupreply_table}.id,
>${groupreply_table}.GroupName,${groupreply_table}.Attribute,
>${groupreply_table}.Value,${groupreply_table}.op FROM
>${groupreply_table},${usergroup_table} WHERE ${usergroup_table}.Username
>= '%{SQL-User-Name}' AND ${usergroup_table}.GroupName =
>${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
>
>Thanks in advance
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>




More information about the Freeradius-Users mailing list