Freeradius 3.0.20 Fresh Install not storing radacct logs in mysql table radacct

[Pedro Daniel Costa]

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 at lists.freeradius.org> em nome de Pedro Daniel Costa <portalnet2 at outlook.com.br>
Enviado: sábado, 3 de setembro de 2022 10:33
Para: FreeRadius users mailing list <freeradius-users at 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 at lists.freeradius.org> em nome de Matthew Newton <mcn at freeradius.org>
Enviado: quinta-feira, 1 de setembro de 2022 23:21
Para: freeradius-users at lists.freeradius.org <freeradius-users at 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