Newbie and Sqlippool

[Antonio Modesto]

On Wed, 2012-02-01 at 13:31 +0100, Alan DeKok wrote:

> Antonio Modesto wrote:
> >>   That's wrong.  Use "Cleartext-Password :=" instead of "User-Password =="
> > 
> >     The problem is that my production server is running Freeradius 1.8,
> > and it uses the Attribute User-Password
> 
>   No.  The change to Cleartext-Password was done in 1.1.4.  The 1.1.8
> version was released long after that.w
> 
> >, but the module rlm_sqlippool is
> > not working in this version of freeradius. Then if I decide to use
> > sqlippool, will I need to upgrade to freeradius 2.x and change this
> > Attribute in all my MySQL database?
> 
>   It's better if you upgrade, *and* if you change the attribute.


I find that the pool_name is not set, it's trying to find "sqlippool", I
changed the name of my pool to this name and it worked. Maybe I am
putting the update control in the wrong place, I've put it in the
post-auth section.

[sqlippool] 	expand: SELECT FramedIPAddress FROM radippool WHERE
pool_name = 'sqlippool' AND expiry_time < NOW() ORDER BY RAND() LIMIT 1
FOR UPDATE -> SELECT FramedIPAddress FROM radippool WHERE pool_name =
'sqlippool' AND expiry_time < NOW() ORDER BY RAND() LIMIT 1 FOR UPDATE



> 
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120201/63207264/attachment.html>