<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi!<br>
<br>
We are using freeradius 1.0.4, I'm
receiving this kind of accounting from our access points:<br>
<br>
<tt>rad_recv: Accounting-Request packet from host 195.32.84.44:32771,
id=215, length=221<br>
User-Name = <a class="moz-txt-link-rfc2396E"
href="mailto:normando@wifi.user">"normando@wifi.user"</a><br>
NAS-Port = 1<br>
NAS-Port-Type = Wireless-802.11<br>
NAS-Identifier = <a class="moz-txt-link-rfc2396E"
href="mailto:micso@wifi.ap">"micso@wifi.ap"</a><br>
NAS-IP-Address = 192.168.1.2<br>
Acct-Status-Type = Start<br>
Calling-Station-Id = "00-16-CB-BD-1F-54"<br>
Called-Station-Id = "00-03-52-DC-5A-60"<br>
Event-Timestamp = "Mar 2 2007 16:09:38 CET"<br>
Acct-Delay-Time = 0<br>
Acct-Session-Id = "30965f0f"<br>
Acct-Authentic = RADIUS<br>
Framed-IP-Address = 172.21.7.65<br>
Colubris-AVPair = "ssid=micso.wifi"<br>
Colubris-AVPair = "nat-port-range=5000-5049"<br>
WISPr-Location-Name = <a class="moz-txt-link-rfc2396E"
href="mailto:micso@wifi.ap">"micso@wifi.ap"</a></tt><br>
<br>
Using rlm_sql <b>only the first "Colubris-AVPair" attribute is being
logged</b>:<br>
<br>
<tt>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',
'<a class="moz-txt-link-abbreviated" href="mailto:normando@wifi.user">normando@wifi.user</a>',
'', '192.168.1.2', '<a class="moz-txt-link-abbreviated"
href="mailto:micso@wifi.ap">micso@wifi.ap</a>', '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')'</tt><br>
<br>
Is there a way to log both? Obviously we are interested in the second
attribute (Colubris-AVPair = "nat-port-range=5000-5049") :-)<br>
<br>
Thank you for your time.<br>
Normando<br>
<br>
</body>
</html>