Simultaneous-Use not working on RADIUSdesk-2016-5-1.ova (also MAC filter does not work)

[Dulus]

Hello, i just ran the lastest VM RADIUSdesk-2016-5-1.ova . I assume everything here is already setup. I created an permanent user (with radius autherntication and accounting checked) profile and added "check" attribute Simultaneous-Use:=1 . And i am still able to use more devices to connect with the same user profile.

Also i have tried to add only a specific MAC address with check attribute Calling-Station-Id , but i am still able to connect with outher devices.

Also tried to add a device via BYOD manager and checked "Connect only from listed devices". but still able to connect with other devices.

Am i missing something ?

Thanks.

[ryan low]

check your mysql file. ../raddb/mods-config/sql/main/mysql/queries.conf

Uncomment simul_count_query to enable simultaneous use checking

simul_count_query = "\
SELECT COUNT(*) \
FROM ${acct_table1} \
WHERE username = '%{SQL-User-Name}' \
AND acctstoptime IS NULL"

simul_verify_query = "\
SELECT \
radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, \
callingstationid, framedprotocol \
FROM ${acct_table1} \
WHERE username = '%{SQL-User-Name}' \
AND acctstoptime IS NULL"

[Dulus]

I havent found the path you have mentioned, but i have found :
/etc/freeradius/mods-config/sql/main/mysql/queries.conf

and in that file that line is uncommented as you can see below:

#######################################################################
# Simultaneous Use Checking Queries
#######################################################################
# simul_count_query     - query for the number of current connections
#                       - If this is not defined, no simultaneous use checking
#                       - will be performed by this module instance
# simul_verify_query    - query to return details of current connections
#                               for verification
#                       - Leave blank or commented out to disable verification step
#                       - Note that the returned field order should not be changed.
#######################################################################

#
#  Uncomment simul_count_query to enable simultaneous use checking
#
simul_count_query = "\
        SELECT COUNT(*) \
        FROM ${acct_table1} \
        WHERE username = '%{SQL-User-Name}' \
        AND acctstoptime IS NULL"

simul_verify_query = "\
        SELECT \
                radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, \
                callingstationid, framedprotocol \
        FROM ${acct_table1} \
        WHERE username = '%{SQL-User-Name}' \
        AND acctstoptime IS NULL"

#######################################################################
# Accounting and Post-Auth Queries
#######################################################################