Accounting to MySQL not working
Alan Buxey
A.L.M.Buxey at lboro.ac.uk
Thu May 27 23:15:00 CEST 2010
hi,
according to the debug:
+- entering group accounting {...}
[detail] expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d ->
+/var/log/freeradius/radacct/192.168.1.10/detail-20100527
[detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to
+/var/log/freeradius/radacct/192.168.1.10/detail-20100527
[detail] expand: %t -> Thu May 27 23:32:23 2010
++[detail] returns ok
++[unix] returns ok
[radutmp] expand: /var/log/freeradius/radutmp -> /var/log/freeradius/radutmp
[radutmp] expand: %{User-Name} -> chrissql
++[radutmp] returns ok
[attr_filter.accounting_response] expand: %{User-Name} -> chrissql
attr_filter: Matched entry DEFAULT at line 12
++[attr_filter.accounting_response] returns updated
Sending Accounting-Response of id 77 to 192.168.1.10 port 1646
Finished request 19.
so, its drops into accouting section...it does
detail
unix
radutmp
attr_filter.accounting_response
but where oh were was the SQL being called? hmm, from here is doesnt
look like you are calling it. check the sites-enabled/* files (I dont
know what virtual servers you have running or what you've called
them) and please uncomment the 'sql'
It comes after the lines that say:
#
# Log traffic to an SQL database.
#
# See "Accounting queries" in sql.conf
alan
More information about the Freeradius-Users
mailing list