...
A MySQL schema is contained in the shwl_add_shwl_del_pmu.sql in the attached archive. It is used by the shwl_add.sh, shwl_del.sh and pam_to_mysql_update.sh scripts to log events and errors. It contains a single table named 'event_log', it's format is as follows:
| 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 | The value of the NAS-IP-Address FreeRADIUS attribute, when applicable | The value of the NAS-Port FreeRADIUS attribute, when applicable | The value of the Called-Station-Id FreeRADIUS attribute, when applicable | The value of the NAS-Identifier FreeRADIUS attribute, when applicable | The value of the Framed-MTU FreeRADIUS attribute, when applicable | The value of the NAS-Port-Type FreeRADIUS attribute, when applicable | The value of the EAP-Type FreeRADIUS attribute, when applicable | The value of the Event-Timestamp FreeRADIUS attribute, when applicable | The time when the entry is logged | Description of the event, see below for details. |
shwl_add.sh
shwl_del.sh
script_launcher.py
...