radacct is not filled up

[Andreas Meyer]

Hello!

"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
        sql


                #  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/192.168.1.254/reply-detail-20120717
[reply_log] /usr/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /usr/var/log/radius/radacct/192.168.1.254/reply-detail-20120717
[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?

  Andreas