> -----Oorspronkelijk bericht-----
> Van: edy [mailto:edy at melsa dot net dot id]
> Verzonden: dinsdag 18 juli 2006 8:51
> Aan: m0n0wall
> Onderwerp: RE: [m0n0wall] Captive portal per-user bandwidth limitation
> 
> anyone can help me ?
> i got some problem, im try to use Captive portal per-user bandwidth
> limitation, but still not work.
> 
> im using gnu radius as radius server, and this is my attrib tables
> 
> 
>
+------------------+-------------------------------------------+-------+
--
> ----+
> | user_name  | attr                                      | value | op
|
>
+------------------+--------------------------------------------+-------
+-
> -----+
> | meong         | WISPr-Bandwidth-Max-Down | 128   | =    |
> | meong         | WISPr-Bandwidth-Max-Up     | 128   | =    |
>
+------------------+--------------------------------------------+-------
+-
> -----+
> 
> and this is my sqlserver file query :
> 
> # Query to select the password for the given user. Should return one
> string.
> auth_query  SELECT password \
>             FROM passwd \
>             WHERE user_name='%u' \
>             AND active='Y'
> 
> # This query returns groups the user belongs to
> group_query SELECT user_group FROM groups where user_name='%u'
> 
> # This query returns a list of a/v pairs to be added to user's check
> pairs.
> check_attr_query  SELECT attr,value,op \
>                   FROM attrib \
>                   WHERE user_name='%u' AND op IS NOT NULL
> 
> 
> # This query returns a list of a/v pairs to be included in reply
packet.
> # The query is used only if the user is authorized successfully.
> reply_attr_query  SELECT attr,value \
>                   FROM attrib \
>                   WHERE user_name='%u' AND op IS NULL
> 
> 
> 
> well im sorry to disturb you all, im still newbie in this radius thing
> :)
> 
I'm not familiar with gnu radius but can you do a radius query test
using something similar to radtest to see if the radius server returns
the attributes

J.

-- 
Jonathan De Graeve
Network/System Engineer
Imelda vzw
Informatica Dienst
+32 15/50.52.98
jonathan dot de dot graeve at imelda dot be

---------
Always read the manual for the correct way to do things because the
number of incorrect ways to do things is almost infinite
---------