Accounting to MySQL not working

[Christoph Schwabl]

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