rlm_sqlippool

[Phil Mayers]

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