NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote: > We're looking to move from Merit radius/LDAP to Freeradius/MySQL,
That's a good idea. > however , I seem to be at a loss for configuring Freeradius to use > MySQL. I didn't have any problems compiling Freeradius 0.7 with > MySQL support and I have configured sql.conf. My question lies in > how do you configure radiusd.conf to use MySQL for everything but > accounting? sql can be used in the 'authorize' section. > I would still like to use radutmp based accounting rather than > logging it in the database. The 'radutmp' file is NOT accounting! It keeps track of who is currently logged on, but it may be wrong, and it WILL destroy data, once someone has logged off. You definitely do NOT want to use radutmp for anything other than enforcing Simultaneous-Use. > When running "radiusd -X" it appears to load the sql module without > problem, but then it halts at the end. The first several times, I > tried to add "sql" to the preacct, authorize, authenticate, and > session sections, but it appears that "sql" is only appropriate for > session. No, you can add it to the 'authorize' section, too. > I have searched through the list archives via Google and didn't > seem to find anybody that has a specific start-to-finish > Freeradius/MySQL configuration guide. See: http://www.frontios.com/freeradius.html http://www.y-min.or.jp/~nob/FreeBSD/freeradius-MySQL.html They may be outdated, but they're a start. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
