Freeradius Accounting

Top  Previous  Next

At this index card you can configure where to store the connection specific information to (file or database). You can use this information with special programs to get reports of the network usage. A freeware tool is for example Radiusreport.

 

Example report from Radiusreport.

radiusreport -tba -l peda -f

/var/log/freeradius/radacct/127.0.0.1/detail-20070420

Radius Log Report for: peda

Date Login Logout Ontime Port BandWt-In/Out Total

-----------------------------------------------------------------

20/04/2007 15:10:18 15:12:00 1m42s W0 8.3K/34.0K 0h01m

20/04/2007 15:15:06 15:15:18 0m12s W0 10.7K/236.4K 0h01m

20/04/2007 15:21:46 15:21:57 0m11s W0 6.5K/159.8K 0h02m

20/04/2007 15:23:58 15:24:12 0m14s W0 11.9K/106.1K 0h02m

20/04/2007 15:26:24 15:26:30 0m06s W0 27.6K/207.7K 0h02m

20/04/2007 15:27:05 15:27:27 0m22s W0 24.3K/73.4K 0h02m

20/04/2007 15:28:29 15:30:12 1m43s W0 7.7K/47.8K 0h04m

-----------------------------------------------------------------

Total Hours: 0h04m

Average Online times: Unavailable - not enough data.

Total Data transferred In/Out: 97.4K/865.4K

 

Internal Accounting:

The whole information is stored at /var/log/freeradius/radaccount. Only available with integrated hard disk.

 

External Accounting:

The information can also be stored to an external mySQL database.

 

Download Freeradius Database Schema: Download the mySQL Schema.
Database Type: At the moment we only support mySQL.
Database Host: Address of the external mySQL database server.
Database Name: Name of the database
Database Username: Username of the mySQL server which has write permissions to the database.
Database Password

 

NOTE: The communication to the database server should only run through an encrypted VPN tunnel.