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