Thanks a lot!!!! It'working :-) [sql] expand: %{User-Name} -> belen@host.com [sql] sql_set_user escaped user --> 'belen@host.com' rlm_sql (sql): Reserving sql socket id: 4 [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 = 'belen@host.com' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT groupname FROM usergroup WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT groupname FROM usergroup WHERE username = 'belen@host.com' ORDER BY id [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'pruebas' ORDER BY id [sql] User found in group pruebas [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'pruebas' ORDER BY id rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok Sending Access-Accept of id 0 to 192.168.1.39 port 2050 Idle-Timeout := 300 WISPr-Bandwidth-Max-Up := 128000 WISPr-Bandwidth-Max-Down := 128000 Session-Timeout := 259199 Thanks again and Happy holidays! tnt@kalik.net escribió:
My whole log debug is the next (I only have changed the MACs and IP, user y pass of database). I think it's correct but I don't understand why the sql queries are ignored by Radius ż? or at least their aren't in the debug, only radcheck query
..
Module: Instantiating sql sql {
..
* authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username =
'%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id" authorize_group_reply_query = "SELECT radgroupreply.id, radgroupreply.GroupName,radgroupreply.Attribute, radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id"*
You are missing authorize_reply_query and group_membership_query. Queries you are using belong to the 1.1.x schema. Use default queries in dialup.conf that belong to 2.1.3.
You can change the accounting queries to old ones if you don't want to change the schema but keep the authorize.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--