[SOLVED]Interface.xml query returns 0 items 0 rows

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Moderators, Developers

Post Reply
Author
Message
eholz1
Cacti User
Posts: 129
Joined: Mon Oct 01, 2018 10:09 am

[SOLVED]Interface.xml query returns 0 items 0 rows

#1 Post by eholz1 » Fri Jan 25, 2019 1:20 pm

This issue went away on its own??
Hello Experts,

I have a device that used to return results from the generic cacti interface.xml query.
It returned 504 items and 252 rows.

I am experimenting with this device, and deleted the interface.xml query from the device.

Then I added the query back to the device. It no longer queries the device, and returns
no items and no rows. Re-running the query does nothing, and running the verbose refresh does
nothing as well.

Is there some sort of permissions issue here? I tried another device of the same type,
and created a new data query using the interface.xml file, and it returns no data, but has
the correct index count when run in verbose mode. Any Ideas?

Thanks

eholz1
Last edited by eholz1 on Tue Jan 29, 2019 5:43 pm, edited 1 time in total.

User avatar
camerabob
Cacti User
Posts: 276
Joined: Fri Feb 10, 2017 2:45 pm
Location: Long Island, New York, USA
Contact:

Re: Interface.xml query returns 0 items 0 rows

#2 Post by camerabob » Fri Jan 25, 2019 2:59 pm

If this is with your 1.1.37 then I am clueless. If this is after your upgrade, I would look to see if the installer was run under a different user and perhaps the write rights have changed.
See the Cacti 1.x templates I use at: http://www.camerabob.com/cacti

Live: Cacti 1.2.3 @ CentOS 7-6.1810.2.el7 & PHP 5.4.16-46.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

Test: Cacti 1.2.4 @ CentOS 7-6.1810.2.el7 & PHP 5.4.16-46.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

netniV
Cacti Guru User
Posts: 2686
Joined: Sun Aug 27, 2017 12:05 am

Re: Interface.xml query returns 0 items 0 rows

#3 Post by netniV » Fri Jan 25, 2019 5:02 pm

You said you deleted the interface.xml query, but do you mean you actually deleted the XML file?

eholz1
Cacti User
Posts: 129
Joined: Mon Oct 01, 2018 10:09 am

Re: Interface.xml query returns 0 items 0 rows

#4 Post by eholz1 » Mon Jan 28, 2019 12:33 pm

Hello,

I just deleted the query from the cacti device, not the xml file (since it works on other devices).
If it is any help, the device I am trying to get the query to run on on a Juniper MX80.

The interface.xml query works fine on other devices such as routers, switches, etc.

I will try deleting the device and re-adding it, and see if the query finds interfaces.

Thanks,
eholz1

netniV
Cacti Guru User
Posts: 2686
Joined: Sun Aug 27, 2017 12:05 am

Re: [SOLVED]Interface.xml query returns 0 items 0 rows

#5 Post by netniV » Wed Jan 30, 2019 2:06 pm

I would do an SNMP walk of the device and make sure that the OID's are available for the network interface (see the interface.xml file for which OID's it is looking for).

Post Reply