Accounting and Acct-Delay-Time in MySQL

Stefan Winter stefan.winter at
Mon Nov 15 11:45:33 CET 2010


the default queries for mysql log Acct-Delay-Time into the columns   
acctstartdelay and acctstopdelay, respectively. They leave the 
timestamps for acctstarttime and acctstoptime at %S. For a non-zero 
delay, this means that a database reader needs to do math to get the 
start and stop times.

It is rather unintuitive that a database user needs to calculate the 
*actual* event times manually by substracting the values. This is 
something that MySQL can easily do on its own at INSERT or UPDATE.

Is there a specific reason why the two are kept separate? If not, I'll 
merrily volunteer to update the default query set to do so; I'll do this 
for my deployment's custom queries anyway. This would also make the two 
columns for delay time obsolete.

Any thoughts on this?


Stefan Winter

Ingenieur de Recherche
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche
6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473

More information about the Freeradius-Users mailing list