|
||||||||
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 > :) > |