#######################################################################
        #  Authorization Queries
        #######################################################################
        #  These queries compare the check items for the user
        #  in ${authcheck_table} and setup the reply items in
        #  ${authreply_table}.  You can use any query/tables
        #  you want, but the return data for each row MUST
        #  be in the  following order:
        #
        #   0 . Row ID (currently unused)
        #   1 . UserName/GroupName
        #   2 . Item Attr Name
        #   3 . Item Attr Value
        #   4 . Item Attr Operation
        #######################################################################

        # Use these for case insensitive usernames. WARNING: Slower queries!
# authorize_check_query = "SELECT id, UserName, Attribute, Value, Op \
#   FROM ${authcheck_table} \
#   WHERE LOWER(UserName) = LOWER('%{SQL-User-Name}') \
#   ORDER BY id"
# authorize_reply_query = "SELECT id, UserName, Attribute, Value, Op \
#   FROM ${authreply_table} \
#   WHERE LOWER(UserName) = LOWER('%{SQL-User-Name}') \
#   ORDER BY id"

#test_check = "select radacctid as id, username as UserName, 'Pass' as Attribute, '==' as Op from radacct limit 1"

authorize_check_query = " \
SELECT \
        1 AS id, \
        '%{SQL-User-Name}' AS username, \
        retcheckattribute('%{SQL-User-Name}', \
        '%{NAS-IP-Address}') AS attribute, \
        retcheckpassword('%{SQL-User-Name}', \
        '%{NAS-IP-Address}') AS password, \
        '==' AS op \
WHERE \
        retenableservice( '%{User-Name}', retservicetype('%{NAS-IP-Address}')) = 1 \
AND \
        setlimit('%{User-Name}',retservicetype('%{NAS-IP-Address}'),'%{Called-Station-Id}') = 1  ORDER BY id"

И Т.Д.

if ("%{sql:SELECT COUNT(username) FROM 'usergroup' WHERE username ="'%{SQL-User-Name}'}" > 0) { 
        authorize_check_query = "select  1  as id, '1500001' as username, 'Password' as attribute, '123456' as password"
} 

FreeRADIUS Version  2 . 0 . 4 , for host i486-pc-linux-gnu, built on Sep   7   2008  at  23 : 35 : 34 
Copyright (C)  1999 - 2008  The FreeRADIUS server project and contributors. 
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A 
PARTICULAR PURPOSE. 
You may redistribute copies of FreeRADIUS under the terms of the 
GNU General Public License. 
Starting - reading configuration files ...
including configuration file /etc/freeradius/radiusd.conf
including configuration file /etc/freeradius/proxy.conf
including configuration file /etc/freeradius/clients.conf
including configuration file /etc/freeradius/snmp.conf
including configuration file /etc/freeradius/eap.conf
including configuration file /etc/freeradius/sql.conf
including configuration file /etc/freeradius/sql/our_radius.conf
/etc/freeradius/sql/our_radius.conf[ 48 ]: Parse error in condition at: "%{sql:SELECT COUNT(username) FROM 'usergroup' WHERE username ="'%{SQL-User-Name}'}" >  0 ) {
Errors reading /etc/freeradius/radiusd.conf