PPPoE FreeRADIUS: Changing radusergroup upon expiration

6 Jul 2026

      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"

PPPoE FreeRADIUS: Changing radusergroup upon expiration

Horas Hajovan Siregar