well ill try using  ":=" but it doesn't work. gnu radius said  
"SQL: invalid operator: :="

but thanks anyway, now im try to use  freeradius. 
i hope it can work with freeradius.

thanks for the help, next maybe i need your help again.
:D 

On 7/18/2006, "Jurgen van Vliet" <jurgenvv at xs4all dot nl> wrote:

>Hi Edy,
>
>Did you try with :=  as operator instead of = ?
>With freeradius (the one I know) it only works when using :=
>
>Goodluck,
>
>Jurgen
>
>> -----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
>> :)
>>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: m0n0wall dash unsubscribe at lists dot m0n0 dot ch
>For additional commands, e-mail: m0n0wall-help@lists.m0n0.c