expire_on_login.conf « postgresql « counter « sql « mods-config « raddb - freeradius - debian 12 backports: freeradius

summary refs log tree commit diff stats

path: root/raddb/mods-config/sql/counter/postgresql/expire_on_login.conf

blob: 6ec4c4e969a858a2cd6316ab1d823f8c9e28c3f6 (plain)

query = "\
	SELECT EXTRACT(EPOCH FROM (NOW() - acctstarttime)) \
	FROM radacct \
	WHERE UserName='%{${key}}' \
	ORDER BY acctstarttime \
	LIMIT 1;"