GNU FREERADIUS
Sawmill is a GNU FreeRADIUS log analyzer (it also supports the 1021 other log formats listed to the left).
It can process log files
in GNU FreeRADIUS format, and generate dynamic statistics from them,
analyzing and reporting events.
Sawmill can parse GNU FreeRADIUS logs, import them into a MySQL, Microsoft SQL Server, or Oracle database (or its own built-in database),
aggregate them, and generate dynamically filtered reports, all through a web interface.
Sawmill can perform GNU FreeRADIUS log analysis on any platform, including Windows, Linux, FreeBSD, OpenBSD, Mac OS, Solaris, other UNIX, and others.
Sawmill stores the following non-numerical fields in its database for GNU FreeRADIUS, generates reports for each field, and allows dynamic filtering on any combination of these fields:
| Field | | Internal Name |
|---|
| | date/time | | date_time |
| | day of week | | day_of_week |
| | hour of day | | hour_of_day |
| | client IP address | | client_ip_address |
| | framed IP address | | framed_ip_address |
| | framed protocol | | framed_protocol |
| | session ID | | acct_session_id |
| | status type | | acct_status_type |
| | input gigawords | | acct_input_gigawords |
| | output gigawords | | acct_output_gigawords |
| | called station ID | | called_station_id |
| | calling station ID | | calling_station_id |
| | NAS IP address | | nas_ip_address |
| | NAS identifier | | nas_identifier |
| | NAS port | | nas_port |
| | NAS port type | | nas_port_type |
| | service type | | service_type |
| | username | | user_name |
| | user account reason code | | usr_acct_reason_code |
| | user call arrival time | | usr_call_arrival_time |
| | user call end time | | usr_call_end_time |
| | user chassis call channel | | usr_chassis_call_channel |
| | user chassis call slot | | usr_chassis_call_slot |
| | authentic | | acct_authentic |
| | link count | | acct_link_count |
| | multi session ID | | acct_multi_session_id |
| | unique session ID | | acct_unique_session_id |
| | terminate cause | | acct_terminate_cause |
| | login IP host | | login_ip_host |
| | login service | | login_service |
| | login TCP port | | login_tcp_port |
| | outer IP address | | outer_ip_address |
Sawmill stores the following numerical fields in its database for GNU FreeRADIUS, aggregating them and including them as columns in most reports:
| Numerical Field | | Internal Name |
|---|
| | events | | events |
| | output octets | | acct_output_octets |
| | input octets | | acct_input_octets |
| | output packets | | acct_output_packets |
| | input packets | | acct_input_packets |
| | session time | | acct_session_time |
| | delay time | | acct_delay_time |
See Sawmill Features to learn more about Sawmill's options for viewing, customizing, filtering, exporting and scheduling GNU FreeRADIUS reports.
Sawmill also supports 1021 other log formats.
