Hello! "Fajar A. Nugraha" <l...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html