- Have the Free Speed installed.
- Read-only user in the database of Free Speed.
- Have cgnat bypass for the server of Free Speed.
- Have access to the RADIUS database/API to associate tests with users
- Register the database of Free Speed in Made 4 Graph.
- Wait 5 minutes for it to run the first time.
- Access the Customer Dash with any PPPoE user.
- Check every 5 minutes to see if there were any tests in Libre Speed in the last 5 minutes.
- If tests have been done, it searches the radius through the IP for which user had that IP at the time of the test.
- Enter the test ID and the Radius (PPPoE) user in our database.
- When to open the user in Customer Dash He will consult on Free Speed to get the test data.
- Note: It only starts counting from the moment the bank was registered, the retroactive ones do not appear.
- If you want to add the field Groupname (contracted plan) to Radius to be shown on Made4Graph, run the command below on 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
