Re: Help with multiple attributes sent with accounting request

2007-03-07 Thread Alan DeKok 
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
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Help with multiple attributes sent with accounting request

2007-03-07 Thread Normando Marcolongo 

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 = "[EMAIL PROTECTED]"
   NAS-Port = 1
   NAS-Port-Type = Wireless-802.11
   NAS-Identifier = "[EMAIL PROTECTED]"
   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 = "[EMAIL PROTECTED]"

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', '[EMAIL PROTECTED]', '', '192.168.1.2', 
'[EMAIL PROTECTED]', '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

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html