AcctSessionTime missing in Interims-Update / calculated by FR

Michael Markstaller michael at markstaller.de
Fri Mar 23 20:17:38 CET 2018


Hi,

FR: 2.1.12 on Debian

I have a probably easy and stupid problem:

The Cisco ASA (5525-X, 9.4.4) doesn't send AcctSessionTime in
"Interim-Update"
so I want FR to just calculate it to be able to purge stale sessions (by
a sep. cronjob)

The f* ASA also doesn't send updates more than once an hour, so
debugging is very time-consuming..


I have changed in /etc/freeradius/sql_log:
--- cut ---
	Interim-Update = "UPDATE ${acct_table}                       \
     SET AcctSessionTime = unix_timestamp(now()) -
unix_timestamp(acctstarttime), \
	 AcctInputOctets = '%{Acct-Input-Octets}',                   \
	 AcctOutputOctets = '%{Acct-Output-Octets}'                  \
	 WHERE AcctSessionId = '%{Acct-Session-Id}'                  \
	 AND UserName = '%{User-Name}';"
--- cut ---

but it doesn't work, AcctSesssionTime in DB stays at 0 - though the
remainder works still fine and logs to MySQL..

Any hints?

Michael


More information about the Freeradius-Users mailing list