-
-
Notifications
You must be signed in to change notification settings - Fork 437
When a Data Query has a space, indexes may not be properly escaped #5768
Description
Describe the bug
Mikrotik Queue Traffic dont show in graph (also real time) if the Queue name has a space & ( _ ) inside
To Reproduce
Steps to reproduce the behavior:
- Linux Cent OS 7, Tried several versions of cacti.
- Add a queue in mikrotik ex: XYZ ABC _ XY - which include space & ( _ ) inside the queue name
- Add a queue in mikrotik ex: XYZABC - which include no space & ( _ ) inside the queue name
- Now if I add queue graph for both queue; "XYZABC" will show traffic with no issue, Where as " XYZ ABC _ XY" will not show any data.
- Also I have noticed, the larger name of a queue graph, dont show the traffic, I am little confused actually, what is causing no traffic visible in queue.
Expected behavior
Queue name with a space & ( _ ) should behave the same and get traffic info.
Screenshots



The Queue has traffic, but shows traffic_in & out 0 during troubleshoot, where another queue with no space always getting some value here instead of 0 always


Notice the RED and Green mark, I am pretty confused is it facing issue showing graph for the Queue Name which is a "larger name" or "Space and Special Character" in queue name.
All these three queue has traffic in mikrotik, but only the smaller name maybe showing graph value in cacti, please check this bug
Plugin (please complete the following information):
- Version: [2.4, 2.3, 3.1]
- Source: [github]
- Identifer: [yum package name]
Desktop (please complete the following information):
- OS: [Cent OS 7 & 8]
- Browser [chrome, firefox]
- Version [latest]
Additional context
I am facing a issue for long. I have installed cacti 1.2.24 and 1.2.27 in a Cent OS 7 server. Tried installing each mikrotik plugin version on each server. My problem is
When I can creating any graph for Mikrotik Queue, it gets data if the Queue name has no (space & ( _ ) ) inside, but if there is any space & ( _ ) in the Queue name, there i got no graph at all in 5 min or 1 min even in real time. everything works fine with the queue name not having space & ( _ ).
Please suggest me what can i do now, already checked from several Mikrotik, tried to install several version of cacti and mikrotik plugin also.