rlm_sqlippool

[Leander S.]

Allright ... got it working ; ) !!!

Neccesary PostreSQL querry is:

INSERT INTO radgroupcheck (groupname, attribute, op, value) VALUES 
('GoupXY', 'Pool-Name', ':=', 'main_pool');

Since we're working with SQL might it be good to mention that in the 
HowTo offered at freeradius.org ?!


Regards,

   Leander



Phil Mayers schrieb:
> On Thu, Jul 31, 2008 at 12:23:50AM +0200, "Leander Schäfer" wrote:
>> Hi,
>>
>> I use FreeRADIUS 2.0.5 combined with PostgreSQL instead of using 
>> raddb/users file etc. .
>>
>> I tried to do the rlm_sqlippool HowTo 
>> (http://wiki.freeradius.org/Rlm_sqlippool) - and it worked out fine 
>> for me so far. BUT only if I put
>> root ~ #  cat /usr/local/etc/raddb/users
>> leo     Pool-Name := "main_pool", Cleartext-Password := "password"
>
> Here the Pool-Name is in the control items, where it should be
>
>>        Service-Type = Framed-User,
>>        Framed-Protocol = PPP,
>> #       Framed-IP-Address = 255.255.255.254,
>>        Framed-IP-Netmask = 255.255.255.255,
>>        Framed-Routing = Broadcast-Listen,
>>        Framed-Filter-Id = "std.ppp",
>>        Framed-MTU = 1492,
>>        Framed-Compression = Van-Jacobsen-TCP-IP,
>> root ~ #
>>
>> But if I put it like that:
>>
>> root ~ #  cat /usr/local/etc/raddb/users
>> leo    Cleartext-Password := "password"
>>        Pool-Name := "main_pool", 
>
> Here it's in the reply items, where it does nothing.
>
>
>>        Service-Type = Framed-User,
>>        Framed-Protocol = PPP,
>> #       Framed-IP-Address = 255.255.255.254,
>>        Framed-IP-Netmask = 255.255.255.255,
>>        Framed-Routing = Broadcast-Listen,
>>        Framed-Filter-Id = "std.ppp",
>>        Framed-MTU = 1492,
>>        Framed-Compression = Van-Jacobsen-TCP-IP,
>> root ~ #
>>
>> The user leo won't get IP Pool address anylonger ... ;/
>
>>
>> But why?! Because I neeed something like a single attribute for 
>> writing it into my PostgreSQL DB over DialupAdmin ;/ because I 
>> actually won't use my raddb/users file any longer
>
> Put the attribute/op/value into the radcheck/radgroupcheck table; 
> those tables are either:
>
> * Compared to the request, for comparison operators
> * Added to the control items, for set operators e.g. :=
>
>>
>> What am I doing wrong?
>>
>> Thx
>>
>>
>> Regards,
>>
>>      Leander
>>
>> -- 
>> Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten 
>> Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
>> -
>> List info/subscribe/unsubscribe? See 
>> http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>