Dirty but working-with-large-files script to multiline grep out interesting lines from detail files.

Usage examples:

callingstationid extraction:

username extraction:

Tired of faulty Ubuntu UIs, I found this useful, simple and straight command to switch keyboard layout in X:

setxkbmap -layout "it"

Give it in a terminal window inside the user X session, tested with Gnome and Cinnamon desktop.

Postgres DB: add a column for IPv6 accounting
   alter table radacct add framedipv6address inet;

This magnificent database uses the same data type for IPv4 and v6 addresses :)

FreeRADIUS: raddb/sql/postgresql/dialup.conf add proper IPv6 lines

accounting_start_query = "INSERT INTO ${acct_table1} \
  (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, \
   NASPortId, NASPortType, AcctStartTime, AcctAuthentic, \
  ConnectInfo_start, CalledStationId, CallingStationId, ServiceType, \
  FramedProtocol, FramedIPAddress, FramedIPv6Address, AcctStartDelay, XAscendSessionSvrKey) \
  VALUES('%{Acct-Session-Id}', \
  '%{Acct-Unique-Session-Id}', \
  '%{SQL-User-Name}', \
  NULLIF('%{Realm}', ''), \
  '%{NAS-IP-Address}', \
  %{%{NAS-Port}:-NULL}, \
  '%{NAS-Port-Type}', \
  ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), \
  '%{Acct-Authentic}', \
  '%{Connect-Info}', \
  '%{Called-Station-Id}', \
  '%{Calling-Station-Id}', \
  '%{Service-Type}', \
  '%{Framed-Protocol}', \
  NULLIF('%{Framed-IP-Address}', '')::inet, \
  NULLIF('%{Framed-IPv6-Address}', '')::inet, \
  0, \
  '%{X-Ascend-Session-Svr-Key}')"

accounting_update_query = "UPDATE ${acct_table1} \
  SET FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, \
  FramedIPv6Address = NULLIF('%{Framed-IPv6-Address}', '')::inet, \
...

accounting_stop_query = "UPDATE ${acct_table2} \
...
  FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, \
  FramedIPv6Address = NULLIF('%{Framed-IPv6-Address}', '')::inet, \
...

Some WLCs (wireless lan controllers) use the same session ID tracking for a session across
multiple access points (NAS-Port). 
Freeradius by default builds his session tracking using all of

• User-Name
• Acct-Session-Id
• NAS-IP-Address
• Client-IP-Address
• NAS-Port
  

as key.
This results in never finished sessions since a client moving from one access point to another does
maintain the same Acct-Session-Id (provided by the WLC), but changes the Acct-Unique-Session-Id.

Example:

Radius type    | Acct-Session-Id | NAS-Port | Acct-Unique-Session-Id
---------------+-----------------+----------+-----------------------
Start          | A               | M        | X
Interim-Update | A               | M        | X
Interim-Update | A               | N        | Y
Stop           | A               | N        | Y

To change the way FreeRADIUS buils the  Acct-Unique-Session-Id I modified raddb/modules/acct_unique as follows:

#acct_unique {
#       key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port"
#}

acct_unique {
        key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address"
}