...
log_id | device_username | device_ip | device_mac | rad_attr_NAS-IP-Address | rad_attr_NAS-Port | rad_attr_Called-Station-Id | rad_attr_NAS-Identifier | rad_attr_Framed-MTU | rad_attr_NAS-Port-Type | rad_attr_EAP-Type | rad_attr_Event-Timestamp | log_time | event | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A unique identifier for the entry, auto-generated by MySQL | See the below sections on each script for all possible values | See the below sections on each script for all possible values | See the below sections on each script for all possible values | The value of the NAS-IP-Address FreeRADIUS RADIUS attribute, when applicable | The value of the NAS-Port FreeRADIUS RADIUS attribute, when applicable | The value of the Called-Station-Id FreeRADIUS RADIUS attribute, when applicable | The value of the NAS-Identifier FreeRADIUS RADIUS attribute, when applicable | The value of the Framed-MTU FreeRADIUS RADIUS attribute, when applicable | The value of the NAS-Port-Type FreeRADIUS RADIUS attribute, when applicable | The value of the EAP-Type FreeRADIUS RADIUS attribute, when applicable | The value of the Event-Timestamp FreeRADIUS RADIUS attribute, when applicable | The time when the entry is logged | Description of the event, see the below sections on each script for all possible values |
NOTE: The 'log_time' column indicates the time when the MySQL entry was logged (i.e. all the scripts use the MySQL NOW() function in the field for this column in all their queries), whereas the rad_attr_Event-Timestamp column contains the content of the Event-Timestamp RADIUS attribute, when applicable, which is expected to contain the timestamp of when the RADIUS server received the request ('@@@').
shwl_add.sh
This script is intended to be run by script_launcher.py (below mentioned).
...