Caso queira adicionar o campo Groupname (plano contratado) ao Radius para ser exibido no Made4Graph, rodar o comando abaixo no Radius:
CREATE DEFINER=`adminDB`@`%` TRIGGER `radacct_stop_InsertGroupName` BEFORE INSERT ON `radacct`
FOR EACH ROW BEGIN
DECLARE paramGroupName VARCHAR(64);
SELECT groupname INTO paramGroupName FROM radusergroup WHERE username = new.username LIMIT 1;
IF(paramGroupName IS NULL) THEN
SET new.groupname = 'SEM GRUPO';
ELSE
SET new.groupname = paramGroupName;
END IF;
END
