Radbox Radius Attributes via SQL Statement?

I authenticate users via Radius, and I have the option to assign Radius attributes via SQL queries, but I can't find any documentation on this for the rest of my life. Does anyone know the correct syntax?

+1


source to share


2 answers


Ok I figured it out, and for someone else who has this problem:

On the "Authorization" tab in the list of responses: When adding an attribute from an SQL query, the first selected variable from the query is an attribute, and the second is a value.

ex.

SELECT 'attribute', value FROM table WHERE username ='$u'

For a more specific example:



SELECT 'Ascend-Data-Rate', hsbrate.rate FROM hsbrate, customer WHERE customer.id = hsbrate.id AND username='$u'

This statement will basically pass the following:
Ascend-Data-Rate = 1024000

(assumes 1024000 is the speed value stored in the database)

NOTE: $ u is a friendly variable in Radbox Radius that denotes the authentication of the current user.

+1


source


kylex, try these links and see if they help. In particular, the first

http://www.xperiencetech.com/forum/topic.asp?TOPIC_ID=97



http://www.xperiencetech.com/forum/topic.asp?TOPIC_ID=62

0


source







All Articles