Wielkie dzięki. Masz zgrzewkę dobrego browaru ode mnie 2018-02-02 9:31 GMT+01:00 Sławomir Paszkiewicz <paszczus@gmail.com>:

Ja używam.

Filter-Id

authorize_reply_query = "SELECT id, lower(name) as UserName , 'Framed-IP-Address' as Attribute, inet_ntoa(ipaddr) as Value, '==' as op \ FROM nodes \ WHERE name = '%{User-Name}' \ UNION \ SELECT 0 AS id, '%{User-Name}' AS UserName, 'Filter-Id' AS Attribute, \ CONCAT(ROUND(COALESCE(x.downceil, y.downceil, z.downceil)),'/', ROUND(COALESCE(x.upceil, y.upceil, z.upceil))) AS Value, ':=' AS op \ FROM (SELECT n.id, MIN(n.name) AS name, SUM(t.downceil/o.cnt) AS downceil, SUM(t.upceil/o.cnt) AS upceil \ FROM nodeassignments na JOIN assignments a ON (na.assignmentid = a.id) JOIN tariffs t ON (a.tariffid = t.id) \ JOIN nodes n ON (na.nodeid = n.id) JOIN (SELECT assignmentid, COUNT(*) AS cnt FROM nodeassignments GROUP BY assignmentid \ ) o ON (o.assignmentid = na.assignmentid) WHERE (a.datefrom <= unix_timestamp() OR a.datefrom = 0) \ AND (a.dateto > unix_timestamp() OR a.dateto = 0) AND a.suspended = 0 AND n.name = '%{User-Name}' \ GROUP BY n.id \ ) x \ LEFT JOIN ( \ SELECT SUM(t.downceil)/o.cnt AS downceil, \ SUM(t.upceil)/o.cnt AS upceil \ FROM assignments a \ JOIN tariffs t ON (a.tariffid = t.id) \ JOIN nodes n ON (a.customerid = n.ownerid) \ JOIN (SELECT COUNT(*) AS cnt, ownerid FROM nodes \ WHERE NOT EXISTS (SELECT 1 FROM nodeassignments, assignments a \ WHERE assignmentid = a.id AND nodeid = nodes.id \ AND a.suspended = 0 AND (a.dateto > unix_timestamp() OR a.dateto = 0)) \ GROUP BY ownerid \ ) o ON (o.ownerid = n.ownerid) \ WHERE (a.datefrom <= unix_timestamp() OR a.datefrom = 0) \ AND (a.dateto > unix_timestamp() OR a.dateto = 0) AND a.suspended = 0 \ AND NOT EXISTS (SELECT 1 FROM nodeassignments WHERE assignmentid = a.id) \ AND n.name = '%{User-Name}' \ GROUP BY n.id \ ) y ON (1=1) \ RIGHT JOIN (SELECT n.id, n.name, 256 AS downceil, 256 AS upceil \ FROM nodes n WHERE n.name = '%{User-Name}' \ ) z ON (1=1);" }

Pozdrawiam,

SP

W dniu 02.02.2018 o 08:21, Marcin pisze:

Witam Czy ktoś z lms'owiczów używa z lmsem radiusa w połączeniu z accel-pppd z shapeingiem? Chodzi mi jakie konkretnie wartości zwrócić z radiusa by wartości to shapeingu były dynamicznie ustawiane? Dla mikrotika zwracam *Mikrotik-Rate-Limit* a co zwrócić dla accel-pppd?

z góry dzięki

-- Pozdrawiam Marcin / nicraM

_______________________________________________ lms mailing listlms@lists.lms.org.plhttp://lists.lms.org.pl/mailman/listinfo/lms

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms

-- Pozdrawiam Marcin / nicraM