radacct is not filled up

Andreas Meyer anmeyer at anup.de
Tue Jul 17 11:08:53 CEST 2012


"Fajar A. Nugraha" <list at fajar.net> wrote:

> > I wonder if it might have something to do with the buffered-sql in
> > /usr/etc/raddb/sites-available. I made no changes to that file.
> Re-read the wiki page. If you HAVE read it correctly, you would've
> seen that you need to change something in that file.

Hm, no luck with this one. I changed buffered.sql to log to sql, but it
does not.

       accounting {
                #  Log traffic to an SQL database.
                #  See "Accounting queries" in sql.conf

                #  Cisco VoIP specific bulk accounting
        #       pgsql-voip


[eap] Freeing handler
++[eap] returns ok
# Executing section post-auth from file /usr/etc/raddb/sites-enabled/default
+- entering group post-auth {...}
[reply_log]     expand: /usr/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /usr/var/log/radius/radacct/
[reply_log] /usr/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /usr/var/log/radius/radacct/
[reply_log]     expand: %t -> Tue Jul 17 10:57:08 2012
++[reply_log] returns ok
[sql]   expand: %{Stripped-User-Name} -> 
[sql]   ... expanding second conditional
[sql]   expand: %{User-Name} -> bitcorner-1

If I understand the buffered.sql right, logging is done to the detail file
but how is it written to the database? Or how is the buffered.sql respected?


More information about the Freeradius-Users mailing list