Acct-Multi-Session-Id parameter with SQL
Hi, I am trying to use Acct-Multi-Session-Id parameter with SQL and i don't see it in the radacct table. Any ideea how I should do this? In radacct files exists Mon Aug 22 00:00:05 2011 Acct-Status-Type = Interim-Update WiMAX-Hotline-Indicator = "active" WiMAX-IP-Technology = Reserved-0 Acct-Session-Id = "00-17-c4-3d-41-ea3020\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000" Acct-Multi-Session-Id = "18ed983f3c2371c6f4bc692e0c89dffe" Framed-IP-Address = 10.91.91.10 User-Name = "{am=1}gogu@domain.ro" Calling-Station-Id = "00-17-c4-3d-41-ea" NAS-Identifier = "IonM" NAS-IP-Address = 192.168.60.122 WiMAX-BS-Id = 0x000003000008 Framed-Pool = "USB" Event-Timestamp = "Aug 5 2011 00:07:52 EEST" WiMAX-GMT-Timezone-offset = 0 Acct-Session-Time = 300 Acct-Authentic = RADIUS Acct-Unique-Session-Id = "13ef07adccdde161" Timestamp = 1313960405 Request-Authenticator = Verified Regards, Ion
It exists in the 'radacct' detail file, because FreeRADIUS is just dumping out the packet contents. Add an additional column to the radacct table and modify the queries in raddb/sql/<database>/dialup.conf. -Arran On 22 Aug 2011, at 15:27, Martin wrote:
Hi,
I am trying to use Acct-Multi-Session-Id parameter with SQL and i don't see it in the radacct table. Any ideea how I should do this? In radacct files exists
Mon Aug 22 00:00:05 2011 Acct-Status-Type = Interim-Update WiMAX-Hotline-Indicator = "active" WiMAX-IP-Technology = Reserved-0 Acct-Session-Id = "00-17-c4-3d-41-ea3020\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000" Acct-Multi-Session-Id = "18ed983f3c2371c6f4bc692e0c89dffe" Framed-IP-Address = 10.91.91.10 User-Name = "{am=1}gogu@domain.ro" Calling-Station-Id = "00-17-c4-3d-41-ea" NAS-Identifier = "IonM" NAS-IP-Address = 192.168.60.122 WiMAX-BS-Id = 0x000003000008 Framed-Pool = "USB" Event-Timestamp = "Aug 5 2011 00:07:52 EEST" WiMAX-GMT-Timezone-offset = 0 Acct-Session-Time = 300 Acct-Authentic = RADIUS Acct-Unique-Session-Id = "13ef07adccdde161" Timestamp = 1313960405 Request-Authenticator = Verified
Regards, Ion
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Arran Cudbard-Bell a.cudbardb@freeradius.org RADIUS - Half the complexity of Diameter
participants (2)
-
Arran Cudbard-Bell -
Martin