Skip to content

When a Data Query has a space, indexes may not be properly escaped #5768

@prottoy396

Description

@prottoy396

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:

  1. Linux Cent OS 7, Tried several versions of cacti.
  2. Add a queue in mikrotik ex: XYZ ABC _ XY - which include space & ( _ ) inside the queue name
  3. Add a queue in mikrotik ex: XYZABC - which include no space & ( _ ) inside the queue name
  4. 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.
  5. 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
image
image
image
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
image

image
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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugUndesired behaviourconfirmedBug is confirm by dev teamresolvedA fixed issue

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions