problem with table radacct column acctstarttime acctstoptime

[Alexandr]

freeradius -v3.0.18

Instead db mysql in table radacct  shows incorrect time column 
acctstartime and acctstoptime in v.3 , if I will use v.2 or v.4 it will 
be ok. It's a bug ?


/var/log

                                                     Tue May 22 14:10:14 
2018
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Name = "systemn"
Called-Station-Id = "18-A6-F7-77-34-20:U_need?"
NAS-Port-Type = Wireless-802.11
Service-Type = Framed-User
NAS-Port = 1
Calling-Station-Id = "38-2D-D1-32-61-1E"
Connect-Info = "CONNECT 54Mbps 802.11g"
Acct-Session-Id = "50405B44E552BE9F"
WLAN-Pairwise-Cipher = 1027076
WLAN-Group-Cipher = 1027076
WLAN-AKM-Suite = 1027073
Event-Timestamp = "May 22 2018 14:06:04 MSK"
Acct-Delay-Time = 0
NAS-IP-Address = 192.168.1.3
Tmp-String-9 = "ai:"
Acct-Unique-Session-Id = "4eebe6180c8f71124f48580c88965921"
Timestamp = 1526987414

                                                       Tue May 22 
16:06:56 2018
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
User-Name = "systemn"
Called-Station-Id = "18-A6-F7-77-34-20:U_need?"
NAS-Port-Type = Wireless-802.11
Service-Type = Framed-User
NAS-Port = 1
Calling-Station-Id = "38-2D-D1-32-61-1E"
Connect-Info = "CONNECT 54Mbps 802.11g"
Acct-Session-Id = "50405B44E552BE9F"
WLAN-Pairwise-Cipher = 1027076
WLAN-Group-Cipher = 1027076
WLAN-AKM-Suite = 1027073
Event-Timestamp = "May 22 2018 16:02:46 MSK"
Acct-Delay-Time = 0
Acct-Session-Time = 7002
Acct-Input-Packets = 3576
Acct-Output-Packets = 1851
Acct-Input-Octets = 429484
Acct-Input-Gigawords = 0
Acct-Output-Octets = 729649
Acct-Output-Gigawords = 0
NAS-IP-Address = 192.168.1.3
Tmp-String-9 = "ai:"
Acct-Unique-Session-Id = "4eebe6180c8f71124f48580c88965921"
Timestamp = 1526994416


On AP (access point openwrt) seted correct time



MYSQL:

mysql> select acctstarttime, acctsessiontime, acctstoptime, 
acctinputoctets, acctoutputoctets, acctsessionid from radacct;

+---------------------+-----------------+---------------------+-----------------+------------------+------------------+
               | acctstarttime       | acctsessiontime | 
acctstoptime        | acctinputoctets | acctoutputoctets | 
acctsessionid    |
+---------------------+-----------------+---------------------+-----------------+------------------+------------------+
               | 0000-00-00 00:00:00 |            68     | 0000-00-00 
00:00:00 |           38240   |             55976    | 6443639F657526A9     |
               | 0000-00-00 00:00:00 |            1982 | 0000-00-00 
00:00:00 |          225720  |            340295   | 0E1A73B95E5440A2    |
               | 0000-00-00 00:00:00 |            37     | 0000-00-00 
00:00:00 |           15182   |               17591  | 13A640668372BE96    |
               | 0000-00-00 00:00:00 |            7040 | 0000-00-00 
00:00:00 |          214251  |            198763   | 7218BBDC869071C0   |
               | 0000-00-00 00:00:00 |            7034 | 0000-00-00 
00:00:00 |        1258946  |         3001674    | 6F167E9A04670B6E    |
               | 0000-00-00 00:00:00 |            7033 | 0000-00-00 
00:00:00 |        2809545  |       50253172    | 5EBC5DA61E869DAE  |
               | 0000-00-00 00:00:00 |            7002 | 0000-00-00 
00:00:00 |          429484  |            729649   | 50405B44E552BE9F   |
               | 0000-00-00 00:00:00 |            3882 | 0000-00-00 
00:00:00 |          832739  |           4944760  | 4524CB7AF305309D  |
               | 0000-00-00 00:00:00 |               0    | 
NULL                          |                     0 |                0 
| D0A7050D8D899789 |
+---------------------+-----------------+---------------------+-----------------+------------------+------------------+

mysql> select now();

                +---------------------+
                 | now()               |
                +---------------------+
                 | 2018-05-23 10:34:46 |
                 +---------------------+