rlm_sqlippool in freeradius 1.1.6

Hugh Messenger hugh at alaweb.com
Tue May 8 06:15:43 CEST 2007


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.

Thanks to everyone who has answered my questions over the last week or so.

   -- hugh




More information about the Freeradius-Users mailing list