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