freeradius and postgres - why needs to restart freeradius every nas table change?

Jarosław Kłopotek jkl at interduo.pl
Tue Aug 22 12:34:44 UTC 2023


Hi guys,

1. I added "disabled" boolean type column to nas table.
2. I added "disabled IS NOT TRUE" as WHERE condition in 
/etc/freeradius/3.0/mods-config/sql/main/postgresql/queries.conf

I run SQL query: UPDATE nas SET disabled = true WHERE id = 2000;

I expect: "no login anymore"
I get: "I can login"

After restarting freeradius - I get what I want.

Is is normal?

-- 
Jarosław Kłopotek, kom. 607 893 111
INTERDUO Bujek Kłopotek Sowa sp.j.
ul. Krańcowa 17, 21-100 Lubartów
tel. 81 475 3000




More information about the Freeradius-Users mailing list