Hi Guys
I was wondering if there was any "easy" way to import the accounting packets recorded in the flat files located at /var/log/freeradius/radacct into a MySQL database... My entries in the flat files looks like this (entry stripped) :- Wed Jul 7 22:37:39 2010 NAS-IP-Address = x.x.x.x NAS-Identifier = "rbggs2" Called-Station-Id = "xxxxxx" Framed-Protocol = GPRS-PDP-Context Service-Type = Framed-User NAS-Port-Type = Virtual NAS-Port = xxxxxx Calling-Station-Id = "xxxxxx" Acct-Status-Type = Stop Framed-IP-Address = 10.0.1.46 Acct-Session-Id = "29D015A2275DA802" User-Name = "xxxxxx" Acct-Input-Octets = 7453 Acct-Output-Octets = 5195 Acct-Input-Packets = 108 Acct-Output-Packets = 53 Acct-Terminate-Cause = User-Request Acct-Authentic = RADIUS Acct-Delay-Time = 0 3GPP-PDP-Type = 0 3GPP-SGSN-Address = x.x.x.x 3GPP-GGSN-Address = x.x.x.x Acct-Unique-Session-Id = "684b91e88bf31a83" Timestamp = 1278535059 Request-Authenticator = Verified Thanks, Gabriel
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html