Freeradius-Devel

Download

freeradius-devel@lists.freeradius.org

July 2026

1 participants
1 discussions

PPPoE FreeRADIUS: Changing radusergroup upon expiration
by Horas Hajovan Siregar 06 Jul '26

06 Jul '26

Hello sir, Will the PPPoE user automatically disconnect upon expiration, and will the new profile be applied upon reconnection? this my default query sql group_membership_query = "\ SELECT groupname \ FROM ( \ SELECT 'expired-profile' AS groupname \ WHERE '%{NAS-Port-Type}' = 'Virtual' \ AND EXISTS ( \ SELECT 1 FROM radcheck \ WHERE username = '%{SQL-User-Name}' \ AND attribute = 'Expiration' \ AND STR_TO_DATE(value, '%d %b %Y %H:%i:%s') < NOW() \ ) \ UNION \ SELECT rug.groupname \ FROM radusergroup rug \ WHERE rug.username = '%{SQL-User-Name}' \ AND NOT EXISTS ( \ SELECT 1 FROM radcheck \ WHERE username = '%{SQL-User-Name}' \ AND attribute = 'Expiration' \ AND STR_TO_DATE(value, '%d %b %Y %H:%i:%s') < NOW() \ ) \ ORDER BY groupname \ LIMIT 1 \ ) AS grp"

1 0