I'm using freeradius
0.4 with mysql 3.23.41 on SuSE Linux 7.3 for auth. of dial-up users on an
livingston protmaster 2e. The problem: i added all users into a group PPP i set the Simultaneous-Use to 1 when a user is connected and another connection is requested by the same user then connection is accepted the first instance of the user is removed from the "radutmp" file so i see only one instance of the user with "radwho" but when i'm looking at the portmaster i see 2 users connected with the same username here's some part from "radiusd.conf" authorize { preprocess suffix sql counter } authenticate { sql } accounting { detail counter unix radutmp sql } session { radutmp } sql.conf authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM ${authreply_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT ${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value,${groupcheck_table}.op FROM ${groupcheck_table},${usergroup_table} WHERE ${usergroup_table}.Username = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id" authorize_group_reply_query = "SELECT ${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}.Attribute,${groupreply_table}.Value,${groupreply_table}.op FROM ${groupreply_table},${usergroup_table} WHERE ${usergroup_table}.Username = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id" authenticate_query = "SELECT Value,Attribute FROM ${authcheck_table} WHERE UserName = '%{User-Name}' AND ( Attribute = 'Password' OR Attribute = 'Crypt-Password' ) ORDER BY Attribute DESC" MySQL Databases radcheck id UserName Attribute Value op ------------------------------------------------------------------------- 252 user Password pass := radgroupcheck id GroupName Attribute Value op ---------------------------------------------------------------------------------------- 252 PPP Simultaneous-Use 1 := radgroupreply id GroupName Attribute Value op ------------------------------------------------------------------------------------------------------------------------ 13 PPP Framed-Protocol PPP := 12 PPP Service-Type Framed-User := 14 PPP Framed-IP-Address x.x.x.x+ := 15 PPP Framed-Compression ,Van-Jacobson-TCP-IP := usergroup id username groupname ----------------------------------- 1 user PPP THANKS |
- Simultaneous-Use problem Cristian Bica
- Simultaneous-Use problem Pascal Gloor
- Simultaneous-Use problem Svetlana Vyslanko