Wrong date of freeradius 3 recording in MySql

[Nikolai Petrov]

Thanks for the quick answer.
These are fields. This is the picture at the moment.
[image: image.png]
You are right
[image: image.png]
But the date on Nas is OK
[image: image.png]
Hotspot-9 is in another time zone.
*I have another machine with freeradius 2. I will connect Hotspot-9 to it
and see if the problem is in the NAS.*

Best Regards,
Nikolai Petrov


На вт, 12.01.2021 г. в 22:13 ч. Alan DeKok <aland at deployingradius.com>
написа:

> On Jan 12, 2021, at 3:06 PM, Nikolai Petrov <nikolai.petrov06 at gmail.com>
> wrote:
> > I installed FreeRADIUS 3, Daloradius, and MySQL Debian 9.
> > After some struggle I drove everything I had on another machine with a
> > similar installation but with freeradius 2.
> > I noticed a problem with accounting (wrote in db). The time is correct,
> but
> > the date is 2 days ago. The problem is from freeradius. When I write from
> > PHP in MySql my date is ok, but from accounting, it comes with a date of
> -2
> > days.
>
>   Which field in SQL?
>
>   If it's the Acct start time or stop time, that comes directly from the
> NAS.  FreeRADIUS doesn't create / edit it.
>
>   If you look at the radius.log file, you'll see it logging messages with
> todays date.  It gets that date from the system.
>
>   Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 30447 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20210112/7e40dd41/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 149065 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20210112/7e40dd41/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 5408 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20210112/7e40dd41/attachment-0005.png>