Re: rlm_sqlippool in freeradius 1.1.6
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.h... 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
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
participants (2)
-
Hugh Messenger -
Peter Nixon