One option is to configure FR to be a detail file reader which will import the files and can write them to the database. Start by looking at the decoupled-accounting file in the sites-available directory. It shows how to setup a detail file reader.
Tim From: freeradius-users-bounces+tim.sylvester=networkradius....@lists.freeradius.or g [mailto:freeradius-users-bounces+tim.sylvester=networkradius....@lists.freer adius.org] On Behalf Of Gabriel Marais Sent: Tuesday, August 10, 2010 8:13 AM To: [email protected] Subject: Import to MySQL from Flat Files 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 __________ Information from ESET NOD32 Antivirus, version of virus signature database 5354 (20100810) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
