Paul Thornton wrote:
I've been trying to debug why accounting information isn't making it into the SQL database on our main FR server (2.1.11) - it seems that this has been the case since upgrading from version 1.something ancient a few months back.
OK... the debug log shows you have a little more upgrading to do for it work "best" in 2.x, but that's OK.
I have a fairly simple MySQL backed setup - and minimal changes of the config files to enable this; just to be clear this was a fresh install of the OS + FreeRADIUS so no danger of old configuration files still lurking around.
Very good.
sql is uncommented in both the authorization and accounting sections of the sites-available/default file (accounting section shown below), and the sql module is enabled in radiusd.conf - the server works just fine for auth via SQL as can be seen in the debug.
Except that the accounting is showing the "unix" module returning "fail".
accounting { ... # Update the wtmp file # # If you don't use "radlast", you can delete this line. unix
Delete that line, and it will probably start working. Try using the debug form on http://networkradius.com/. It will highlight things which you should look at in more detail. Alan DeKok.