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 | +---------------------+
hi, run it in debug mode - see what its doing/reporting when doing the SQL INSERT/UPDATE alan
On May 23, 2018, at 4:00 AM, Alexandr <systemn17088@gmail.com> wrote:
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 ?
Those times are created by the access point. FreeRADIUS just writes them to the database. Run the server in debugging mode to see what's going on. Alan DeKok.
participants (3)
-
Alan Buxey -
Alan DeKok -
Alexandr