simple queue - save statistic
Please allow roterOS to save statistic of simple queues into HDD. I always lost this data after reboot. I use this for counting user data and FUP. Is here any possibility to do this?
I am not talking about graphing. I am talking about transmitted data via queue (variable total-bytes). I am using this in my script for limiting user speed after transmitting given amount of data. Everything works fine, but after reset this variable is 0 so I want to store this variable on HDD or I need this variable to be stored on HDD by routerOS. I don't want to use external PC for storing this variable. Is here any possibility how to do this.
http://forum.mikrotik.com/viewtopic.php ... ight=queue
http://forum.mikrotik.com/viewtopic.php ... ight=queue
Simple graphs provides information about 'Daily', 'Weekly', 'Monthly', 'Yearly' usage, and provides information like this,
http://demo2.mt.lv/graphs/iface/wlan1/
http://demo2.mt.lv/graphs/iface/wlan1/
Re: simple queue - save statistic
So did you find any solution for saving this data?
Re: simple queue - save statistic
or anyone else? how to save this data?
Re: simple queue - save statistic
Command to get detailed information about queue statistic,
/queue simple print stats
1 D rate=0/35080 total-rate=0 packet-rate=0/10 total-packet-rate=0
queued-bytes=0/0 total-queued-bytes=0 queued-packets=0/0
total-queued-packets=0 bytes=11737/33719917 total-bytes=0
packets=97/40651 total-packets=0 dropped=0/0 total-dropped=0 lends=97/581
total-lends=0 borrows=0/40070 total-borrows=0
/queue simple print stats
1 D rate=0/35080 total-rate=0 packet-rate=0/10 total-packet-rate=0
queued-bytes=0/0 total-queued-bytes=0 queued-packets=0/0
total-queued-packets=0 bytes=11737/33719917 total-bytes=0
packets=97/40651 total-packets=0 dropped=0/0 total-dropped=0 lends=97/581
total-lends=0 borrows=0/40070 total-borrows=0
Re: simple queue - save statistic
Yes, but these statistics are deleted after reboot. But how to save these statistics so it stays there even if router is rebooted?
Re: simple queue - save statistic
Query the router via SNMP. There's OIDs for all the queues.
Re: simple queue - save statistic
Can you be litle more precise about it? Thanks!
Re: simple queue - save statistic
About what? What OIDs are? What SNMP is? Those questions would probably be better suited to a general Google search. SNMP is a common protocol used to monitor network equipment and collect information from it. OIDs are the addresses of data points a system provides. You can use SNMP via the NMS of your choice to monitor simple queues in RouterOS on an external server, and store data on the external data permanently.
Re: simple queue - save statistic
That is ok, thanks for info. But all that are just alternative options. I asked why isn't possible to store this on disk? So it will stay there even after reboot. I don't need server or any other mashine to monitor traffic.. I share connection with 3 other friends, and need to know that simple stats. But I guess that it isn't so simple.
Re: simple queue - save statistic
We've looked into what you describe extensively and decided to build the DBS solution as described in the signature below.Please allow roterOS to save statistic of simple queues into HDD. I always lost this data after reboot. I use this for counting user data and FUP. Is here any possibility to do this?
If you insist in building this yourself you would need to gather and store the data off of the router and save in a "round robin database" a.k.a. "rrdtool" somewhere else. The trick is detecting data rates that are impossible and then ignoring those samples, as it would appear when a register rolls over or by having a counter being reset to zero. One great example of this is provided by the open source program called Cacti (http://www.cacti.net/), where the data is collected through SNMP and saved and graphed using RrdTool.
Once you have the data off the router, then your script would need to retrieve this data, and make adjustments as needed. No simple task.
Re: simple queue - save statistic
It really isn't.That is ok, thanks for info. But all that are just alternative options. I asked why isn't possible to store this on disk? So it will stay there even after reboot. I don't need server or any other mashine to monitor traffic.. I share connection with 3 other friends, and need to know that simple stats. But I guess that it isn't so simple.
Most RouterBOARDs have NAND storage. That limits the number of write cycles. How often do you update the stats on disk? They change all the time, so that's an awful lot of write cycles, until the internal storage breaks.
-
-
DarielHG89
just joined
- Posts: 3
- Joined:
Re: simple queue - save statistic
Store statistics info in a remote server.
In this example i just post the name and bytes.
Script:
queue.php:
In this example i just post the name and bytes.
Script:
Code: Select all
{
/queue simple
:local queueList [find]
:foreach q in=$queueList do={
:local qName [get $q name]
:local qTarget [get $q target]
:local qBytes [get $q bytes]
:local qStatus [get $q disabled]
:if (!$qStatus) do={
:local logmessage ("{\"name\":\"" . $qName . "\",\"bytes\":\"" . $qBytes . "\"}")
:put ($logmessage)
/tool fetch http-method=post http-header-field="Content-Type: application/json" http-data=$logmessage url="http://192.168.100.17/queue.php"
}
}
}Code: Select all
<?php
function isValidJSON($str) {
json_decode($str);
return json_last_error() == JSON_ERROR_NONE;
}
$json = file_get_contents('php://input');
if (strlen($json) > 0 && isValidJSON($json)){
$data = json_decode($json);
date_default_timezone_set("America/New_York");
$njsond = ["LastC"=>date("d-m-Y h:i:sa"),"bytesUD"=>$data->bytes];
echo file_put_contents("Queue-" . $data->name . ".json",json_encode($njsond));
}
?>
Last edited by DarielHG89 on Thu Sep 22, 2022 4:29 am, edited 2 times in total.