Session start times issues

[Alan DeKok]

On Jan 26, 2019, at 8:43 AM, Philemon Jaomalaza <philemon.jaomalaza at gmail.com> wrote:
> If the nas has a wrong date and time, the sqlcounter does not work correctly. 

  If I take the tires off of my car, it doesn't drive well.

  Solution: fix the REAL problem.

> The attribute Event-Timestamp got the wrong data and time from nas.

  Fix the NAS.  Anything else is an ugly hack.

> I found this features in preacct substitution:
> 
>        update request {
>                &FreeRADIUS-Acct-Session-Start-Time = "%{expr: %l - %{%{Acct-Session-Time}:-0} - %{%{Acct-D$
>        }
> 
> I uncomente it but nothing change.
> 
> Where is the best way to have the good local time of radius server on "acctstarttime" column of "radacct" on sql database ? 

  Fix the NAS.

  Alan DeKok.