Mikrotik RouterOS Statistics (Update 02/10/2009)

[foxmulder]

it seems doesn't work anymore on 4.10? i've got nan on all interface, cacti 0.8.7g on freebsd 8.1..

[anrima]

it seems doesn't work anymore on 4.10? i've got nan on all interface, cacti 0.8.7g on freebsd 8.1..

Make sure you are set to SNMP V1 on Cacti and then refresh the queries. This fixed the issue for me.

Cheers!

[eltonzoto]

Yes, you should change SNMP version from 2 to 1. For me it works too.


Btw, is there a way to monitor NAT sessions on Mikrotik?

[mojiro]

Yes, you should change SNMP version from 2 to 1. For me it works too.


Btw, is there a way to monitor NAT sessions on Mikrotik?

you mean the nat'ed connections?

[eltonzoto]

Yes, you should change SNMP version from 2 to 1. For me it works too.


Btw, is there a way to monitor NAT sessions on Mikrotik?

you mean the nat'ed connections?

For example, I have a board-router Mikrotik with NAT. Inside router i can see max number NAT-sessions which users opens (for Internet, P2P etc.). I need one Cacti template, which will describe the max/min/aver nr. of all sessions in time.

[mojiro]

I will review the snmp tree of Mikrotik, but I do not think that there is something new or an easy workaround.

[eltonzoto]

I will review the snmp tree of Mikrotik, but I do not think that there is something new or an easy workaround.

Anyway, thanks

[eugenevdm]

....

Just one queston, is there no way to read out SNR and CCQ on MikroTik?

The only work I ever saw done on CCQ is this:
http://wiki.mikrotik.com/wiki/Munin_Monitoring

I have also logged support on MikroTik's forum, without any answer:
http://forum.mikrotik.com/viewtopic.php?f=7&t=44397

[tudor2k3]

On cacti 0.8.7g (Gentoo Linux, rrdtool 1.3.8 (also tried 1.3.9 and 1.4.5), apache 2.2.17), after adding a device with routeros v5.5 (also tried v4.16), snmp v1, the host shows up fine, but when trying to monitor queue tree, an error appears:

+ Running data query [14].
+ Found type = '3' [snmp query].
+ Could not find data query XML file at '/var/web/htdocs/cacti/resource/snmp_queries/mikrotik_queue_simple.xml'
+ Error parsing XML file into an array.
+ Could not find data query XML file at '/var/web/htdocs/cacti/resource/snmp_queries/mikrotik_queue_simple.xml'
+ Could not find data query XML file at '/var/web/htdocs/cacti/resource/snmp_queries/mikrotik_queue_simple.xml'
+ Could not find data query XML file at '/var/web/htdocs/cacti/resource/snmp_queries/mikrotik_queue_simple.xml'

Also, if I look and the device, all associated data queries have 0 items/rows:

1) Mikrotik - Queue - Simple (Verbose Query) Uptime Goes Backwards Success [0 Items, 0 Rows] Reload Data Query Delete Data Query Association
2) Mikrotik - Queue - Tree (Verbose Query) Uptime Goes Backwards Success [0 Items, 0 Rows] Reload Data Query Delete Data Query Association
3) Mikrotik - Wireless - Client (Verbose Query) Uptime Goes Backwards Success [0 Items, 0 Rows] Reload Data Query Delete Data Query Association
4) Mikrotik - Wireless - Registration Table (Verbose Query) Uptime Goes Backwards Success [0 Items, 0 Rows] Reload Data Query Delete Data Query Association
5) SNMP - Interface Statistics (Verbose Query) Uptime Goes Backwards Success [0 Items, 0 Rows] Reload Data Query Delete Data Query Association

I double checked and the file is there. Also, tried monitoring CPU usage and after one query showing up, I got all 0%.
SNMP debugging shows(I think it's the CPU load OIDs):

Jul/18/2011 11:20:02 snmp community: snet-mon-v1
Jul/18/2011 11:20:02 snmp,debug getnextgetbulk .1.3 reps:0 nonreps:0
Jul/18/2011 11:20:02 snmp packet from: 10.7.0.101 version: 0
Jul/18/2011 11:20:02 snmp community: snet-mon-v1
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.1.3.0
Jul/18/2011 11:20:02 snmp packet from: 10.7.0.101 version: 0
Jul/18/2011 11:20:02 snmp community: snet-mon-v1
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.25.3.3.1.2.1
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.4.24.3.0
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.25.2.3.1.5.1
Jul/18/2011 11:20:02 snmp,debug grouping OIDs
Jul/18/2011 11:20:02 snmp,debug oid >.5.1<
Jul/18/2011 11:20:02 snmp,debug oid >.6.1<
Jul/18/2011 11:20:02 snmp,debug error: no such name
Jul/18/2011 11:20:02 snmp packet from: 10.7.0.101 version: 0
Jul/18/2011 11:20:02 snmp community: snet-mon-v1
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.25.3.3.1.2.1
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.25.2.3.1.5.1
Jul/18/2011 11:20:02 snmp,debug error: no such name
Jul/18/2011 11:20:02 snmp packet from: 10.7.0.101 version: 0
Jul/18/2011 11:20:02 snmp community: snet-mon-v1
Jul/18/2011 11:20:02 snmp,debug get .1.3.6.1.2.1.25.2.3.1.5.1
Jul/18/2011 11:20:02 snmp,debug error: no such name

Anyone got any ideeas?

Thanx.

[noname]

>> I double checked and the file is there.

Is this the problem on permissions?
Can Cacti (and poller) read that file?

% ls -l /var/web/htdocs/cacti/resource/snmp_queries/mikrotik_queue_simple.xml

[tudor2k3]

Yes, it was owned by root:root, and everybody else had read permissions. I've set it to be owned by apache:apache and everything is fine now. Thanx.

[Firefig]

it seems doesn't work anymore on 4.10? i've got nan on all interface, cacti 0.8.7g on freebsd 8.1..

Make sure you are set to SNMP V1 on Cacti and then refresh the queries. This fixed the issue for me.

Cheers!

never thought it could be as easy as that. Read more in www.debuntu.org/how-to-monitor-your-ser ... -and-cacti

[ashadebi]

Hello Mojiro,

it's great template... but after I update the version mikrotik to 5.8 fron 4.17, i get a problem..
Have anyone try it in the latest version?

Verbose work with snmp v2. but graph not shown properly..

Data Query Debug Information
+ Running data query [13].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/home/public_html/mrtg/resource/snmp_queries/mikrotik_queue_simple.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.14988.1.1.2.1.1.2'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.143' value: 'ICMP'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.54' value: 'kantor bawah'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.68' value: 'DCOST - Graha Family'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.87' value: 'Infosolusi Localloop'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.112' value: 'Mikes-Apartements'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.123' value: 'Hotspot Intiland'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.136' value: 'Surfindo - DCOST'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.137' value: 'DCost - Sun City - SDA'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.138' value: 'BTS- TOLO'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.144' value: 'Moratel'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.145' value: 'Mora - Gramedia'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.146' value: 'Mora - Circle K'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.147' value: 'Mora - Tafakul'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.148' value: 'Mora - Arsys'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.149' value: 'Indonet'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.150' value: 'Indonet - PIOS'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.159' value: 'Indonet - Graha Family'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.151' value: 'Indonet - Metro'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.156' value: 'DCOST - Kapas Krampung'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.157' value: 'Mora - Koesuma-bangsa'
+ Index found at OID: '.1.3.6.1.4.1.14988.1.1.2.1.1.2.158' value: 'KOST'
+ Located input field 'qsName' [walk]
............
........

[PamanGembuL]

i got some problem here...traffic output it doesn't show continously. really need help..

queue-error.png (47.82 KiB) Viewed 6061 times

Code: Select all

Cacti Version 	0.8.7e
Cacti OS 	unix
SNMP Version 	NET-SNMP version: 5.4.2.1
RRDTool Version 	RRDTool 1.3.x
Hosts 	12
Graphs 	250
Data Sources 	Script/Command: 5
SNMP: 4
SNMP Query: 241
Script Query: 1
Total: 251

cacti running smoothly, there is no error messages. also rra files was create

Code: Select all

01/29/2012 02:30:04 PM - SYSTEM STATS: Time:3.2317 Method:cmd.php Processes:1 Threads:N/A Hosts:12 HostsPerProcess:12 DataSources:467 RRDsProcessed:238
01/29/2012 02:35:05 PM - SYSTEM STATS: Time:3.3380 Method:cmd.php Processes:1 Threads:N/A Hosts:13 HostsPerProcess:13 DataSources:467 RRDsProcessed:238
01/29/2012 02:40:03 PM - SYSTEM STATS: Time:2.3326 Method:cmd.php Processes:1 Threads:N/A Hosts:13 HostsPerProcess:13 DataSources:467 RRDsProcessed:238
01/29/2012 02:45:05 PM - SYSTEM STATS: Time:3.2690 Method:cmd.php Processes:1 Threads:N/A Hosts:13 HostsPerProcess:13 DataSources:489 RRDsProcessed:249

[tudor2k3]

(at least) a temporary solution: snmp v1 works for me with RouterOS v5.11