freeRadius + MySQL - usergroups

[Bogdan Dumitriu - Technical Support Team]

Hello all,

Is this normal?

It looks like it's comparing group ownership against each group even
though the user is a member of only one group. Why does it has to check
group ownership if there is an entry in the usergroup file for this
user?

It looks like it's running 'SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl'' for each group in the radgroupcheck. Isn't this a
waste of resources? Is there a way to stop it?

Is this normal? Am I missing something?

Thank you for your input.

Bogdan.

modcall: entering group authorize for request 0
rlm_sql (sql): - sql_groupcmp
radius_xlat:  'shipcoadsl'
rlm_sql (sql): sql_set_user escaped user --> 'shipcoadsl'
radius_xlat:  'SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl'
rlm_sql (sql): Released sql socket id: 4
rlm_sql (sql): - sql_groupcmp finished: User does not belong in group
dialup
rlm_sql (sql): - sql_groupcmp
radius_xlat:  'shipcoadsl'
rlm_sql (sql): sql_set_user escaped user --> 'shipcoadsl'
radius_xlat:  'SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl''
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_mysql: query:  SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl'
rlm_sql (sql): Released sql socket id: 3
rlm_sql (sql): - sql_groupcmp finished: User does not belong in group
idm
rlm_sql (sql): - sql_groupcmp
radius_xlat:  'shipcoadsl'
rlm_sql (sql): sql_set_user escaped user --> 'shipcoadsl'
radius_xlat:  'SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl''
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql_mysql: query:  SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl'
rlm_sql (sql): Released sql socket id: 2
rlm_sql (sql): - sql_groupcmp finished: User does not belong in group
ikano
rlm_sql (sql): - sql_groupcmp
radius_xlat:  'shipcoadsl'
rlm_sql (sql): sql_set_user escaped user --> 'shipcoadsl'
radius_xlat:  'SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl''
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: query:  SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl'
rlm_sql (sql): Released sql socket id: 1
rlm_sql (sql): - sql_groupcmp finished: User does not belong in group
adsl
rlm_sql (sql): - sql_groupcmp
radius_xlat:  'shipcoadsl'
rlm_sql (sql): sql_set_user escaped user --> 'shipcoadsl'
radius_xlat:  'SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl''
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_mysql: query:  SELECT GroupName FROM usergroup WHERE
UserName='shipcoadsl'
rlm_sql (sql): - sql_groupcmp finished: User belongs in group
adsl-static