search

inverse-inc / packetfence

PacketFence is a fully supported, trusted, Free and Open Source network access control (NAC) solution. Boasting an impressive feature set including a captive-portal for registration and remediation, centralized wired and wireless management, powerful BYOD management options, 802.1X support, layer-2 isolation of problematic devices; PacketFence can be used to effectively secure networks small to very large heterogeneous networks.
https://packetfence.org
GNU General Public License v2.0
1.27k stars 274 forks source link

Accounting not showing on the dashboard #8188

Closed oLuciaZo closed 1 week ago

oLuciaZo commented 1 week ago

Describe the problem Accounting not display on dashboard systemctl status packetfence-radiusd-acct.service is running already and show netstat -an port is listening 0.0.0.0:1813 I have showing on database there is no any record to radacct

Symptoms I have show radius-acct.log and found some issues Jun 20 00:09:44 packetfence radiusd-acct-docker-wrapper[44605]: Thu Jun 20 00:09:44 2024 : ERROR: (1115443) sql: ERROR: rlm_sql_mysql: ERROR 1690 (BIGINT UNSIGNED value is out of range in 'p_acctinputoctets@3 - Previous_Input_Octets@21'): 22003 Jun 20 00:09:45 packetfence radiusd-acct-docker-wrapper[44605]: Thu Jun 20 00:09:45 2024 : ERROR: (1115939) sql: ERROR: rlm_sql_mysql: ERROR 1690 (BIGINT UNSIGNED value is out of range in 'p_acctinputoctets@3 - Previous_Input_Octets@21'): 22003

The devices what I have testing is Aruba Wireless

oLuciaZo commented 1 week ago

From this error that due the case CPU of Guest running 100%

oLuciaZo commented 1 week ago

I have found in the docker is not binding address for 0.0.0.0 but it specific IP from host instead cbca9c2a9d03 packetfence/pfacct:v13.2.0 "/bin/sh -c /usr/loc…" 33 seconds ago Up 31 seconds 10.20.22.220:1813->1813/udp, 0.0.0.0:2056->2056/udp, :::2056->2056/udp