Freeradius 3.0 Radacct

[Jorge Pereira]

> On 3 May 2021, at 17:37, juliana sales porto <julianaporto3 at hotmail.com> wrote:
> 
> Hi everyone, I am facing a problem.
> 
> 

I can’t see any debug output. Please take a look at https://wiki.freeradius.org/guide/Users-Mailing-List <https://wiki.freeradius.org/guide/Users-Mailing-List>


> I have deployed a freeradius server version 3.0 with MySQL in Ubuntu (20.04). There are the respective versions of the radius and MySQL:
> 
> mysql  Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
> 
> radiusd: FreeRADIUS Version 3.0.20, for host x86_64-pc-linux-gnu
> 
> FreeRADIUS Version 3.0.20
> 

We’ve the latest 3.0.21, please feel free to use the official packages available in http://packages.networkradius.com/

> 
> My situation is: from a mobile phone I need to connect to an access point and authenticate to that WLAN network (802.11i-WPA-802.1x) using a username and password specified in the radius database.
> 

WPA2 Enterprise, right?

> I would like to know why there is a new table radpostauth. Actually I don't know if this is a new table, but I have a old freeradius server where this specifications: FreeRADIUS Version 2.1.12, for host x86_64-pc-linux-gnu, built on Jul 26 2017 at 15:30:42 and mysql  Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3. This server didn't has this table (radpostauth), and for some reason when I installed the new server with freeradius updates and mysql the table Radacct doesn't have any information. Is empty!
> 

Well, the radpostauth exists since FreeRADIUS 2.x.x as can be seen here https://github.com/FreeRADIUS/freeradius-server/blob/v2.x.x/raddb/sql/mysql/schema.sql#L127 <https://github.com/FreeRADIUS/freeradius-server/blob/v2.x.x/raddb/sql/mysql/schema.sql#L127>
> I would like to know why this is happening and why I can't receive inserts on Radacct
> 

Please, your email looks pretty confusing. Because you’re mixing “upgrade from 2.x to 3.x” + “accounting issues”. I really encourage you first to read the https://wiki.freeradius.org/guide/Users-Mailing-List <https://wiki.freeradius.org/guide/Users-Mailing-List> , https://wiki.freeradius.org/guide/radiusd-X <https://wiki.freeradius.org/guide/radiusd-X> then back to us with more information.

> 
> 
> Att,
> 
> Juliana Porto
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html