Lynx
Senior Member
Fantastic add on Jack Yaz. AutoBW works perfectly with CAKE even with custom CAKE script override.
For those using auto bandwidth calculations - do you still have the tests run every hour on 12 and 42 as default? I can see one issue with this is the tests may get distorted by other general use of the connection at those times. Would be interested to know how others handle this.
Otherwise, in terms of the script I only changed the line:
such that spdstats_WAN is replaced by spdstats_VPNC1:
because I want the auto bandwidth calculation based on average VPN results. Works with this tiny change. Kudos in terms of coding in facilitating such a straightforward change.
Albeit did take me a little while to figure that one out!
Jack Yaz might be nice to make that a configurable parameter in GUI for those like me who use VPN for everything.
For those using auto bandwidth calculations - do you still have the tests run every hour on 12 and 42 as default? I can see one issue with this is the tests may get distorted by other general use of the connection at those times. Would be interested to know how others handle this.
Otherwise, in terms of the script I only changed the line:
Code:
echo "SELECT avg($metric) FROM (SELECT $metric FROM spdstats_WAN ORDER BY [Timestamp] DESC LIMIT $avgcalc);"
Code:
echo "SELECT avg($metric) FROM (SELECT $metric FROM spdstats_VPNC1 ORDER BY [Timestamp] DESC LIMIT $avgcalc);"
Albeit did take me a little while to figure that one out!
Jack Yaz might be nice to make that a configurable parameter in GUI for those like me who use VPN for everything.
Last edited: