<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">I have recently inherited working on a freeRadius on openSUSE server on a cellular implementation. I'll be upfront that my Linux skills are minimal and I know nothing about freeRadius.</span><div style="font-family:arial,sans-serif;font-size:13px">
<br></div><div style="font-family:arial,sans-serif;font-size:13px">I don't know what version of freeRadius we are running I was afraid to run radiusd -v because the man page said it would run and exit. This is a production server and I didn't want to risk killing the process. I'll schedule a maintenance window to run that.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">My issue is I need to implement total data transferred daily logging for a particular realm to implement roaming. My first thought was to get it from the detail files. I can probably write a script to accomplish this but I can't find the RAT-Type attribute in the log entries. I need to break out 1xRTT and EVDO totals for this realm. The Radio Access Technology type would be perfect for this but as I said can't find it in the detail file.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">I know a little about mysql but not much. It is implemented on this server. Can I pull this data from the radacct table? I thought I might need to implement the rls_counter module. It is not currently implemented. </div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Sorry I have short windows of time to try things on this server so I'm trying to line up as much as I can ahead of time before getting stuck and wasting a maintenance window.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Here is a sample start record in the detail file:</div><div style="font-family:arial,sans-serif;font-size:13px">
<div>User-Name = "<a href="mailto:5558675309@companyx.com" target="_blank">5558675309@companyx.com</a>"</div><div><span style="white-space:pre-wrap"> </span>NAS-IP-Address = ###.###.###.###</div><div><span style="white-space:pre-wrap"> </span>Acct-Status-Type = Start</div>
<div><span style="white-space:pre-wrap"> </span>Acct-Session-Id = "ecs+xv67"</div><div><span style="white-space:pre-wrap"> </span>Acct-Delay-Time = 0</div><div><span style="white-space:pre-wrap"> </span>Acct-Authentic = RADIUS</div>
<div><span style="white-space:pre-wrap"> </span>NAS-Port = 2265</div><div><span style="white-space:pre-wrap"> </span>NAS-Port-Type = Virtual</div><div><span style="white-space:pre-wrap"> </span>Calling-Station-Id = "111115558675309"</div>
<div><span style="white-space:pre-wrap"> </span>Framed-Protocol = PPP</div><div><span style="white-space:pre-wrap"> </span>Framed-IP-Address = ###.###.###.###</div><div><span style="white-space:pre-wrap"> </span>Event-Timestamp = "Apr 7 2013 00:00:02 EDT"</div>
<div><span style="white-space:pre-wrap"> </span>Acct-Input-Octets = 0</div><div><span style="white-space:pre-wrap"> </span>Acct-Output-Octets = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Correlation-Id = "ecs+yshC"</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-User-Id = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Forward-FCH-Mux-Option = 2337</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Reverse-FCH-Mux-Option = 2337</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Service-Option = 33</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Forward-Traffic-Type = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Reverse-Traffic-Type = 0</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-FCH-Frame-Size = 2</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Forward-FCH-RC = 3</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Reverse-FCH-RC = 3</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-IP-Technology = 1</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Compulsory-Tunnel-Indicator = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-PCF-IP-Address = ###.###.###.###</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-BSID = "14EE00010000"</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Home-Agent-IP-Address = 0.0.0.0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Bad-PPP-Frame-Count = 0</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Number-Active-Transitions = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Terminating-SDB-Octet-Count = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Originating-SDB-OCtet-Count = 0</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Terminating-Number-SDBs = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Originating-Number-SDBs = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-IP-QoS = 0</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Session-Continue = 1</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Inbound-Mobile-IP-Sig-Octets = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Outbound-Mobile-IP-Sig-Octets = 0</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Airlink-Priority = 13</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Received-HDLC-Octets = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Attr-41 = 0x486a95e1</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Module-Orig-Term-Indicator = 0x00000000</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Forward-DCCH-Mux-Option = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Reverse-DCCH-Mux-Option = 0</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-Forward-DCCH-RC = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Reverse-DHHC-RC = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Service-Reference-Id = 0x0104000102040001</div>
<div><span style="white-space:pre-wrap"> </span>3GPP2-DCCH-Frame-Size = 0</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Begin-Session = 1</div><div><span style="white-space:pre-wrap"> </span>3GPP2-Active-Time = 0</div>
<div><span style="white-space:pre-wrap"> </span>Service-Type = Framed-User</div><div><span style="white-space:pre-wrap"> </span>Acct-Unique-Session-Id = "efb3ccab5e594101"</div><div><span style="white-space:pre-wrap"> </span>Stripped-User-Name = "5558675309"</div>
<div><span style="white-space:pre-wrap"> </span>Realm = "<a href="http://companyx.com/" target="_blank">companyx.com</a>"</div><div><span style="white-space:pre-wrap"> </span>Timestamp = 1365307202</div><div><span style="white-space:pre-wrap"> </span>Request-Authenticator = Verified</div>
</div></div>