Hello, I have a small problem with accounting to mysql.
freeradius 2.1.8 mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 The NAS is sending accounting data, which I can see in: more /var/log/freeradius/radacct/192.168.1.10/detail-20100526 ... Wed May 26 23:43:57 2010 Acct-Session-Id = "00000039" Called-Station-Id = "0011.2177.0da4" Calling-Station-Id = "001f.3b1c.f25b" Cisco-AVPair = "ssid=testradius" Cisco-AVPair = "vlan-id=0" Cisco-AVPair = "nas-location=unspecified" User-Name = "testuser" Cisco-AVPair = "connect-progress=Call Up" Acct-Session-Time = 237 Acct-Input-Octets = 35971 Acct-Output-Octets = 64059 Acct-Input-Packets = 473 Acct-Output-Packets = 98 Acct-Authentic = RADIUS Acct-Status-Type = Interim-Update NAS-Port-Type = Wireless-802.11 Cisco-NAS-Port = "296" NAS-Port = 296 Service-Type = Framed-User NAS-IP-Address = 192.168.1.10 Acct-Delay-Time = 0 Acct-Unique-Session-Id = "4d69927723cb56d8" Timestamp = 1274910237 Request-Authenticator = Verified But I cann't find accounting data in MySQL database. My configuration is: radiusd.conf ================== ... $INCLUDE sql.conf ... readclients = yes ... sites-enabled/inner-tunnel ================== ... authorize { chap mschap unix suffix update control { Proxy-To-Realm := LOCAL } eap { ok = return } files sql expiration logintime pap } ... sites-enabled/default ================== ... authorize { preprocess chap mschap suffix eap { ok = return } unix files sql expiration logintime pap } ... accounting { detail unix radutmp sql attr_filter.accounting_response } ... Using users (radcheck) and clients (nas) from MySQL are working well. However, accounting into MySQL is not working. Anybody an idea? thx & br Christoph -- GMX.at - Österreichs FreeMail-Dienst mit über 2 Mio Mitgliedern E-Mail, SMS & mehr! Kostenlos: http://portal.gmx.net/de/go/atfreemail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html