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

Reply via email to