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