Can I add extra fields to the radius accounting database?

Miguel Angel Quiles wingfox at gmail.com
Mon Sep 5 09:26:58 CEST 2005


Hi,
  I've got freeradius 1.0.2 on a SUSE 9.3. I was thinking if I could add a 
new field to the radius accounting.
I'm using mysql. I already added the field to the radacct table in the 
radius database. And I've tried to modify
the sql.conf file in the raddb directory. When I restart the service the 
freeradius won't start because off an error.
 I've created the field "TunnelType", and I added the values in the 
different queries, such as:
 
accounting_update_query_alt = "INSERT into ${acct_table1} (AcctSessionId, 
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, 
AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, 
AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, 
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, TunnelType) 
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', 
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', 
'%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + 
%{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', 
'', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', 
'%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', 
'%{Framed-IP-Address}', '0', '%{Tunnel-Type:0}')" 

 I hope somebody can help me.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20050905/af7539a5/attachment.html>


More information about the Freeradius-Users mailing list