On Thu, 2005-03-03 at 13:54 -0800, Kris Efland wrote: > Excuse me if this has already been discussed but I couldnt find > anything after searching... > > I have FR successfully up and running. I have it "logging" through > sql, and authenticating through ldap. How do I go about getting more > detailed logs out of FR through sql? Currently it is only logging to > postauth_table and is therefore only showing successful logins. I > need it to log to authcheck_table (radcheck) to see if people are > failing to login properly. These are being sent to the logfile but > not to sql. I have broken down the sql config files but they dont > seem to have any insert statements into the radcheck sql table. Do I > have to write these myself? or is it more simplistic than that? Can > you do this when seperating the authentication mechanism from sql? > Thanks in advance. > > Kris I am not exactly sure what you are trying to do, but you should never need to have the server write to radcheck.
The table you are probably looking for is radacct. radcheck is equivalent to the first line of the users file. radacct is equivalent to the detail file. You likely want to add sql to the accounting section. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
