Help needed with DATA QUERIES - rrd not created

[niobe]

Help! I am having some major problems with Data Queries

I have been struggling with this aspect of Cacti for several weeks to no avail. After reading tutorials and posting etc I am quite sure I am doing everything right. I have a fully working cacti installation and every thing works fine except data queries.

Here is the problem: I am creating a Cisco query IGMP (multicast) as per attached template and xml. No matter what I do something goes wrong when I create new graphs:

- RRA files are not created
- RRA files are not referenced in the data source definition
- Suggested values (|query_blah|) are not substituted

I can see no reason at all for this within Cacti or my XML file.

Attached screenshots show example data source and graph defns created with the data query.

I would really appreciate some help trying to work this out!

Cacti Version - 0.8.7b
Plugin Architecture - 2.0
Poller Type - CMD.php
Server Info - Linux 2.6.18-53.1.14.el5xen
Web Server - Apache/2.2.3 (Red Hat)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, dom, gd, ldap, mysql, mysqli, odbc, PDO, pdo_mysql, PDO_ODBC, pdo_sqlite, snmp, xmlreader, xmlwriter, xsl
MySQL - 5.0.22
RRDTool - 1.2.23
SNMP - 5.3.1
Plugins

• PHP Network Weathermap (weathermap - v0.95a)
  Device Status Monitoring (Status - v4)
  Network Inventory Management System (NIMS - v0.1)
  Network Discovery (discovery - v0.8.3)
  SuperLinks (superlinks - v0.72)
  Create Aggregate Graphs (aggregate - v0.64)
  Host Info (hostinfo - v0.2)

[atrias]

do you get any errors in your cacti log??

I also have problems with my data queries

plz see

http://forums.cacti.net/viewtopic.php?p=132744#132744

[niobe]

do you get any errors in your cacti log??

Good question, not at standard level but I'll try at debug. Nothing in httpd logs.

I also have problems with my data queries

I think separate problem as I am only having problems with NEW data queries. My interfaces stats etc work fine. This is why it's so strange though - I am copying the methods used in interface.xml and Gandalf's HOWTO exactly...

[niobe]

Nothing I can see in the logs - it's mainly SQL stuff.

The problem seems to be when it comes time to create the RRD file. My data source doesn't get created. I am trying to reverse engineer how this happens but it's painful! I think it may be somewhere in lib/template.php -> create_complete_graph_from_template

If any developers can help me figure out where to look I would much appreciate it!

Edit: Ok so the poller creates the rrd files every cycle via "rrdtool_function_update". So maybe something screwy in the db after all..

[niobe]

Another update..

I have tried this on a FRESH cacti install with no plugin architecture and still get the same problem - RRDs aren't created.

[niobe]

Y.A.U.

On the fresh install NONE of the data queries work, including interface graphs.

[cbscpe]

Did you check security issues with the directory where the rrd's should be created?

[niobe]

yep chmod 666 my entire cacti directory - but non data-query graphs get created ok.

[niobe]

I have opened bug #0001224 for this. This should not be happening on a fresh install of a 'stable' release.

[Bokin]

Well have same troubles with a new cacti installation.

rrd would not created

[niobe]

Well have same troubles with a new cacti installation.

rrd would not created

For me the plot thickens - a fresh install with PA2.1 works.

I am starting to suspect the problem is in some of the database functions - one of the things I did was resave all related graph/data templates and rebuild the query. This seemed tohelp...

[voyager]

It would be helpful if have got an update over this topic