sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}"
default_user_profile = "DEFAULT"
nas_query = "SELECT id, nasname, shortname, type, secret FROM ${nas_table}"
    authorize_check_query = "SELECT id, name as username, 'Password' as attribute, passwd as value, ':=' as op \
          FROM nodes \
          WHERE name = '%{SQL-User-Name}' \
          ORDER BY id"


        authorize_reply_query = "SELECT id, name as username, 'Framed-IP-Address' as attribute, inet_ntoa(ipaddr) as value, '==' as op \
        FROM nodes WHERE name = '%{SQL-User-Name}' \
        UNION \
        SELECT nodes.id, nodes.name as username,'Mikrotik-Rate-Limit' as attribute, CONCAT(uprate,'k/',downrate,'k') as value, '==' as op \
        FROM nodes,assignments,tariffs WHERE nodes.name =  '%{SQL-User-Name}' and assignments.customerid=nodes.ownerid AND assignments.tariffid=tariffs.id \
        UNION \
        SELECT nodes.id, nodes.name as username,'Port-Limit' as attribute, climit as value, '==' as op \
        FROM nodes,assignments,tariffs WHERE nodes.name =  '%{SQL-User-Name}' and assignments.customerid=nodes.ownerid AND assignments.tariffid=tariffs.id;"