Thanks a lot!!!!
It'working :-)
[sql] expand: %{User-Name} -> [email protected]
[sql] sql_set_user escaped user --> '[email protected]'
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 = '[email protected]' 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 =
'[email protected]' 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!
[email protected] 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
--
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
