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.
NOTE: The communication to the database server should only run through an encrypted VPN tunnel. |