Hi!

We are using freeradius 1.0.4, I'm receiving this kind of accounting from our access points:

rad_recv: Accounting-Request packet from host 195.32.84.44:32771, id=215, length=221
        User-Name = "normando@wifi.user"
        NAS-Port = 1
        NAS-Port-Type = Wireless-802.11
        NAS-Identifier = "micso@wifi.ap"
        NAS-IP-Address = 192.168.1.2
        Acct-Status-Type = Start
        Calling-Station-Id = "00-16-CB-BD-1F-54"
        Called-Station-Id = "00-03-52-DC-5A-60"
        Event-Timestamp = "Mar  2 2007 16:09:38 CET"
        Acct-Delay-Time = 0
        Acct-Session-Id = "30965f0f"
        Acct-Authentic = RADIUS
        Framed-IP-Address = 172.21.7.65
        Colubris-AVPair = "ssid=micso.wifi"
        Colubris-AVPair = "nat-port-range=5000-5049"
        WISPr-Location-Name = "micso@wifi.ap"

Using rlm_sql only the first "Colubris-AVPair" attribute is being logged:

radius_xlat:  'INSERT into radacct (`Colubris-AVPair`, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASIdentifier,NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,ClientIPAddress, AcctStartDelay, AcctStopDelay) values('ssid=3Dmicso.wifi', '137281aa', '73ff613a5a1e65ff', 'normando@wifi.user', '', '192.168.1.2', 'micso@wifi.ap', '1', 'Wireless-802.11', '2007-03-02 16:24:51', '0', '0', 'RADIUS', '', '', '0', '0', '00-03-52-DC-5A-60', '00-16-CB-BD-1F-54', '', '', '', '172.21.7.65', '195.32.84.44', '0', '0')'

Is there a way to log both? Obviously we are interested in the second attribute (Colubris-AVPair = "nat-port-range=5000-5049") :-)

Thank you for your time.
Normando