|
|
| Author |
Message |
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
 Posted: Mon Apr 14, 2008 12:10 am Post subject: Help needed with DATA QUERIES - rrd not created |
 |
|
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!
| Quote: | 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
PluginsPHP 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) |
| Description: |
|
| Filesize: |
23.88 KB |
| Viewed: |
1505 Time(s) |
|
| Description: |
|
| Filesize: |
21.75 KB |
| Viewed: |
1505 Time(s) |
|
| Description: |
| XML for resources/snmp_queries/ |
|
Download |
| Filename: |
cisco_igmp.xml |
| Filesize: |
2.32 KB |
| Downloaded: |
44 Time(s) |
| Description: |
|
Download |
| Filename: |
cacti_graph_template_cisco_-_igmp_groups.xml |
| Filesize: |
12.97 KB |
| Downloaded: |
47 Time(s) |
|
|
| Back to top |
|
 |
atrias
Joined: 29 Dec 2007
Posts: 13
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Mon Apr 14, 2008 7:27 pm Post subject: |
|
|
| atrias wrote: | | 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.
| atrias wrote: |
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...
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Mon Apr 14, 2008 9:51 pm Post subject: |
|
|
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..
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Mon Apr 14, 2008 10:52 pm Post subject: |
|
|
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.
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Tue Apr 15, 2008 12:50 am Post subject: |
|
|
Y.A.U.
On the fresh install NONE of the data queries work, including interface graphs.
|
|
| Back to top |
|
|
cbscpe
Joined: 11 Apr 2008
Posts: 15
Location: Switzerland
|
| Posted: Tue Apr 15, 2008 11:57 am Post subject: |
|
|
| Did you check security issues with the directory where the rrd's should be created?
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Tue Apr 15, 2008 6:28 pm Post subject: |
|
|
| yep chmod 666 my entire cacti directory - but non data-query graphs get created ok.
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Tue Apr 15, 2008 9:26 pm Post subject: |
|
|
| I have opened bug #0001224 for this. This should not be happening on a fresh install of a 'stable' release.
|
|
| Back to top |
|
|
Bokin
Joined: 28 Mar 2008
Posts: 41
|
| Posted: Wed Apr 16, 2008 6:25 am Post subject: |
|
|
Well have same troubles with a new cacti installation.
rrd would not created 
|
|
| Back to top |
|
|
niobe
Cacti User
Joined: 10 Mar 2008
Posts: 93
Location: Australia
|
| Posted: Wed Apr 16, 2008 6:49 pm Post subject: |
|
|
| Bokin wrote: | 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...
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
