Hi all,
I'm on freeradius-0.7.1. I want to add the following VSA's to the
accounting_start_query?
---SNIP---
Cisco-Service-Info = "Naccess_5"
Cisco-Service-Info = "Utest"
Cisco-Service-Info = "TP"
---SNIP---
They don't have a "unique name".
The separation is done with the first letter of the "Cisco-Service-Info"-value
(in this case "N", "U", "T").
I'm only able to get the first value to MySQL (in this case "Naccess_5").
How can access the values of the others?
from sql.conf:
---SNIP---
accounting_start_query = "INSERT into radacct (RadAcctId, AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay,
CiscoServiceInfoN) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
'%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}',
'%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}',
'%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0',
(SUBSTRING('%{Cisco-Service-Info}' FROM 2)) )"
---SNIP---
TIA!
Uli
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
