apt-get update && apt install freeradius freeradius-utils freeradius-postgresql postgresql sudo phppgadmin -y 

cd /etc/freeradius/3.0/mods-enabled

ln -s ../mods-available/sql sql

Delete -sql and #sql code on sites default
nano /etc/freeradius/3.0/sites-available/default
nano /etc/freeradius/3.0/sites-available/inner-tunnel


#banco de dados
sudo -u postgres psql

CREATE DATABASE radius;
CREATE USER radius WITH PASSWORD 'radpass123456789';
GRANT ALL PRIVILEGES ON DATABASE radius TO radius;

#ajusta o timezone necessario no postgresql para salvar o timestam corretamente. 
cd /etc/freeradius/3.0/mods-available
nano sql
sql {
    # outras opções de configuração do módulo sql
    acct_table1 = "%{tolower:type}_acct"
    acct_table2 = "%{tolower:type}_acct"
   
    # ajuste o timezone para o seu fuso horário
    acct_timezone = "America/Sao_Paulo"
}



configurar o phphpadmin 
nano /etc/postgresql/13/main/postgres.config
listen_addresses = '*'

nano /etc/apache2/sites-enabled/phppgadmin.conf
#requeride localhost
Allow from all 

pode fazer pelo phppgadmin subindo o schema por na sql 
sudo -u postgres psql radius < /etc/freeradius/3.0/mods-config/sql/main/postgresql/schema.sql



nano /etc/freeradius/3.0/mods-available/sql

driver = "rlm_sql_postgresql"
dialect = "postgresql"
server = "localhost"
port = 5432
login = "radius"
password = "radpass123456789"
radius_db = "radius"
read_clients = yes
client_table = "nas"



cd /etc/freeradius/3.0/mods-enabled/
ln  -s ../mods-available/sqlcounter  sqlcounter

nano /etc/freeradius/3.0/mods-available/sqlcounter

##alterar todos os *${modules.sql.dialect}* por postgresql
sqlcounter dailycounter {
sql_module_instance = sql
dialect = ${modules.sql.dialect}
counter_name = Daily-Session-Time
check_name = Max-Daily-Session
reply_name = Session-Timeout
key = User-Name
reset = daily
$INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}


cadastrar o NAS
INSERT INTO public.nas VALUES (1, '177.104.209.254', 'OSNICASATESTE', 'other', NULL, '123456789', NULL, NULL, 'Teste em casa');

Cadastrar um usuario para teste
INSERT INTO radcheck VALUES (1, 'demo', 'Cleartext-Password', ':=', '12345');




https://blog.remontti.com.br/4085


https://mangospot.net/install-freeradius-pgsql-on-debian-or-ubuntu.html