<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi all,<br>
<br>
I'm running FreeRADIUS version 2.1.12 on Debian 7.3 and I'm using
User-Profile attribute to organise my users into profiles. I have
active read_groups in sql.conf file but in all groups I need add
Fall-Through to get all attributes of the groups.<br>
<br>
Module: Linked to module rlm_sql<br>
Module: Instantiating module "sql" from file
/etc/freeradius/sql.conf<br>
sql {<br>
driver = "rlm_sql_mysql"<br>
server = "localhost"<br>
port = ""<br>
login = "radius"<br>
password = "radpass"<br>
radius_db = "radiusdb"<br>
<b>read_groups = yes</b><br>
sqltrace = no<br>
sqltracefile = "/var/log/freeradius/sqltrace.sql"<br>
readclients = yes<br>
deletestalesessions = yes<br>
<br>
For example: With Fall-Through attribute equal Yes, there is the
result<br>
<br>
[sql] <b>Checking profile DF_V2_U3</b><br>
[sql] sql_set_user escaped user --> 'DF_V2_U3'<br>
[sql] expand: SELECT groupname FROM
radusergroup WHERE username = '%{SQL-User-Name}'
ORDER BY priority -> SELECT groupname FROM
radusergroup WHERE username = 'DF_V2_U3' ORDER
BY priority<br>
[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 = 'DF' ORDER BY id<br>
[sql] <b>User found in group DF</b><br>
[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 = 'DF' ORDER BY id<br>
[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 = 'V2' ORDER BY id<br>
[sql] <b>User found in group V2</b><br>
[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 = 'V2' ORDER BY id<br>
[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 = 'EX' ORDER BY id<br>
[sql] <b>User found in group EX</b><br>
[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 = 'EX' ORDER BY id<br>
[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 = 'U3' ORDER BY id<br>
[sql] <b>User found in group U3</b><br>
[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 = 'U3' ORDER BY id<br>
rlm_sql (sql): Released sql socket id: 3<br>
++[sql] returns ok<br>
<br>
And with Fall-Through equal No or without it:<br>
<br>
[sql] <b>Checking profile DF_V2_U3</b><br>
[sql] sql_set_user escaped user --> 'DF_V2_U3'<br>
[sql] expand: SELECT groupname FROM
radusergroup WHERE username = '%{SQL-User-Name}'
ORDER BY priority -> SELECT groupname FROM
radusergroup WHERE username = 'DF_V2_U3' ORDER
BY priority<br>
[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 = 'DF' ORDER BY id<br>
[sql] <b>User found in group DF</b><br>
[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 = 'DF' ORDER BY id<br>
rlm_sql (sql): Released sql socket id: 2<br>
++[sql] returns ok<br>
<br>
I add the User-Name and User-Profile with Fall-Through attribute in
radreply table but doesn't work. Always I need add Fall-Through
attribute at the groups or there are another way to create profiles?<br>
<br>
Regards. Fernando.<br>
</body>
</html>