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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html