problem with table radacct column acctstarttime acctstoptime

[Александр Михайлов]

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 |
                +---------------------+