Hello!
"Fajar A. Nugraha" <[email protected]> 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
