Help with multiple attributes sent with accounting request
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
Normando Marcolongo wrote:
Using rlm_sql *only the first "Colubris-AVPair" attribute is being logged*:
Yes. In the CVS head, you can log the second, or later ones. 1.1.x doesn't have this capability. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
participants (2)
-
Alan DeKok -
Normando Marcolongo