Cellular Roaming Accounting

[Gerry Gasca]

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.

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.

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.

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.

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.

Here is a sample start record in the detail file:
User-Name = "5558675309 at companyx.com"
NAS-IP-Address = ###.###.###.###
Acct-Status-Type = Start
Acct-Session-Id = "ecs+xv67"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
NAS-Port = 2265
NAS-Port-Type = Virtual
Calling-Station-Id = "111115558675309"
Framed-Protocol = PPP
Framed-IP-Address = ###.###.###.###
Event-Timestamp = "Apr  7 2013 00:00:02 EDT"
Acct-Input-Octets = 0
Acct-Output-Octets = 0
3GPP2-Correlation-Id = "ecs+yshC"
3GPP2-User-Id = 0
3GPP2-Forward-FCH-Mux-Option = 2337
3GPP2-Reverse-FCH-Mux-Option = 2337
3GPP2-Service-Option = 33
3GPP2-Forward-Traffic-Type = 0
3GPP2-Reverse-Traffic-Type = 0
3GPP2-FCH-Frame-Size = 2
3GPP2-Forward-FCH-RC = 3
3GPP2-Reverse-FCH-RC = 3
3GPP2-IP-Technology = 1
3GPP2-Compulsory-Tunnel-Indicator = 0
3GPP2-PCF-IP-Address = ###.###.###.###
3GPP2-BSID = "14EE00010000"
3GPP2-Home-Agent-IP-Address = 0.0.0.0
3GPP2-Bad-PPP-Frame-Count = 0
3GPP2-Number-Active-Transitions = 0
3GPP2-Terminating-SDB-Octet-Count = 0
3GPP2-Originating-SDB-OCtet-Count = 0
3GPP2-Terminating-Number-SDBs = 0
3GPP2-Originating-Number-SDBs = 0
3GPP2-IP-QoS = 0
3GPP2-Session-Continue = 1
3GPP2-Inbound-Mobile-IP-Sig-Octets = 0
3GPP2-Outbound-Mobile-IP-Sig-Octets = 0
3GPP2-Airlink-Priority = 13
3GPP2-Received-HDLC-Octets = 0
3GPP2-Attr-41 = 0x486a95e1
3GPP2-Module-Orig-Term-Indicator = 0x00000000
3GPP2-Forward-DCCH-Mux-Option = 0
3GPP2-Reverse-DCCH-Mux-Option = 0
3GPP2-Forward-DCCH-RC = 0
3GPP2-Reverse-DHHC-RC = 0
3GPP2-Service-Reference-Id = 0x0104000102040001
3GPP2-DCCH-Frame-Size = 0
3GPP2-Begin-Session = 1
3GPP2-Active-Time = 0
Service-Type = Framed-User
Acct-Unique-Session-Id = "efb3ccab5e594101"
Stripped-User-Name = "5558675309"
Realm = "companyx.com"
Timestamp = 1365307202
Request-Authenticator = Verified
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130409/bc0fe2da/attachment.html>