Accounting to MySQL not working

Alan DeKok aland at
Fri May 28 19:04:22 CEST 2010

Christoph Schwabl wrote:
> this part is (and was) enabled
> please find below the configuration of the files (which is the same configuration as for 2.0.4 - this configuration is working for 2.0.4)
> however, it seems the sql line is ignored by the radius server

  This happens in one of two cases:

1) the server is reading a *different* file than the one you're editing

2) there are *two* "accounting" sections, and the server is using the
first rather than the second.

> BTW: If I uncomment all 'sql' entries, I get data into the radpostauth table, but I never get data into the radacct table.

  Then either it isn't receiving accounting packets, *or* it's not using
the sql configuration you think it's using.

> Has somebody a working configuration for logging into the radacct mysql table with freeradius v2.1.8 (under Debian Lenny)?

$ cd /etc/raddb/sites-enabled
$ grep sql *

  And un-comment the lines that look like:

default:#	sql

  This is the default config, and it does work.

  Alan DeKok.

More information about the Freeradius-Users mailing list