rlm_sqlippool in freeradius 1.1.6

[Peter Nixon]

On Tue 08 May 2007, Hugh Messenger wrote:
> I said:
> > Is the rlm_sqlippool in 1.1.6 known to work with MySQL 5?
> >
> > Actually, I'm fairly sure it's not even getting as far as talking to the
> > db. No matter what I try, it just tells me 'missing pool_name'.
>
> Turns out I borked something else in the users file which was breaking the
> Pool-Name statement in sqlippool mode.
>
> The next problem was getting the sqlippool queries to work.  After more
> head / desk pounding, just after I finally got them working, I found this
> post with pretty much the same changes for MySQL  in it:
>
> http://www.mail-archive.com/freeradius-users@lists.freeradius.org/msg30520
>.html
>
> So ... I'm now happily autenticating against my Windows AD (using PAM and
> winbind), assigning PPPOE rate limit information via per user radreply
> table entries, assigning IP's from sqlippools based on
> 'Called-Station-ID', and accounting in the database.
>
> I am now officially a Happy Camper.

Excellent!

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc