strange part is that default file is configured with accounting enabled.. inner-tunnel also on the init log can see accouting being loaded.. radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/3.0/radiusd.conf } # server server default { # from file /etc/freeradius/3.0/sites-enabled/default # Loading authenticate {...} # Loading authorize {...} # Loading accounting {...} # Loading session {...} # Loading post-auth {...} } # server default server inner-tunnel { # from file /etc/freeradius/3.0/sites-enabled/inner-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-auth {...} } # server inner-tunnel radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 1812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = * port = 1813 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipv6addr = :: port = 1812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipv6addr = :: port = 1813 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Ready to process requests Enviado do Outlook<http://aka.ms/weboutlook> ________________________________ De: Freeradius-Users <freeradius-users-bounces+portalnet2=outlook.com.br@lists.freeradius.org> em nome de Pedro Daniel Costa <portalnet2@outlook.com.br> Enviado: sábado, 3 de setembro de 2022 10:33 Para: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Assunto: RE: Freeradius 3.0.20 Fresh Install not storing radacct logs in mysql table radacct Hi Matthew thanks for your input, my NAS data is stored inside MYSQL nas table.. i just set sql to fetch data from it.. could you please guide me on which file i need to edit? because on my sites/enabled, default file i have accounting selected with sql inside the accounting . but for some reason its not updating the data inside the radact table.. inside accounting i have sql,detail,sqlipool enabled.. sqlipool seems to log just the login information and stores it inside the the radipool table. Enviado do Outlook<http://aka.ms/weboutlook> ________________________________ De: Freeradius-Users <freeradius-users-bounces+portalnet2=outlook.com.br@lists.freeradius.org> em nome de Matthew Newton <mcn@freeradius.org> Enviado: quinta-feira, 1 de setembro de 2022 23:21 Para: freeradius-users@lists.freeradius.org <freeradius-users@lists.freeradius.org> Assunto: Re: Freeradius 3.0.20 Fresh Install not storing radacct logs in mysql table radacct On 02/09/2022 02:59, Pedro Daniel Costa wrote:
radcheck, radgroupcheck, radgroupreply, radipools configured ok.. and client logs in using username and password, and can browse the web normaly, the issue is on radacct table mysql that is not storing data at all, i have rebooted clients device couple of times,to see if radacct would update the log, but nothing happens.. only think i can see is radpostauth storing username, pass xored md5 and login date.. nothing else..
Configure the NAS to send accounting packets. If FreeRADIUS doesn't receive any information it can't log anything. -- Matthew - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html