Cannot create graphs

yoshi911 · Post by **yoshi911** » Mon Jun 01, 2009 6:22 pm

Hi all,

first post here.. brand new linux/ubuntu user so everything is ULTRA wierd/hard/new to me. Thanks in advance for the help.

OK.. I had everything working on Cacti 0.8.7b, I upgraded to Cacti 0.8.7d and can sucesfully open the program.
Enter problem:

on the "localhost", the graphs that were there are no longer working.

Graph Management > "Turn On Graph Debug Mode"
RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="localhost - Processes" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="processes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/share/cacti/site/rra/localhost_proc_19.rrd":proc:AVERAGE \
AREA:a#F51D30FF:"Running Processes" \
GPRINT

LAST:"Current\:%8.0lf" \
GPRINT

AVERAGE:"Average\:%8.0lf" \
GPRINT

MAX:"Maximum\:%8.0lf"

RRDTool Says:

ERROR: opening '/usr/share/cacti/site/rra/localhost_proc_19.rrd': No such file or directory
---------------------------------------------------
also, in the "New Graphs" section, on any graphs that I've attempted to create it says:

Error in data query.

Notice: Undefined variable: column_counter in /usr/share/cacti/site/graphs_new.php on line 887
---------------------------------------------------

I have searched for hours trying to find an allready written solution. I'm guessing it's something to do with file write permissions. I have followed all the directions in http://www.howtoforge.com/cacti_ispconfig (and everywhere else I could find comprehensive directions)
No luck so far.
Please help. Trying to get some good graph happiness

BSOD2600 · Post by **BSOD2600** » Mon Jun 01, 2009 10:18 pm

1) wrong forum, moving for better help

.

2) read http://docs.cacti.net/manual:087:4_help ... #debugging for troubleshooting.

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 2:03 pm

Ok.. in my cacti.log file it reads:

Code: Select all

06/02/2009 12:32:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   snmp_query.id,   snmp_query.name,   snmp_query.xml_path   FR$
06/02/2009 12:35:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
06/02/2009 12:35:00 PM - SYSTEM STATS: Time:299.3372 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
06/02/2009 12:35:01 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'
06/02/2009 12:40:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
06/02/2009 12:40:00 PM - SYSTEM STATS: Time:299.3164 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
06/02/2009 12:40:00 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '1'
06/02/2009 12:44:59 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
06/02/2009 12:44:59 PM - SYSTEM STATS: Time:299.3260 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0

also, when I actually try and create a graph it says that it's sucessfully created "+ Created graph: |host_description| - Load Average"
BUT, it gives this error:

Code: Select all

Warning: Invalid argument supplied for foreach() in /usr/share/cacti/site/graphs_new.php on line 515

I looked through the url about debugging and made sure everything was correct.

Post by **gandalf** » Tue Jun 02, 2009 2:17 pm

The poller's runtime is insane. This way lots of graphs will remain empty. There's something very ugly around. What happens when running cmd.php instead of spine?
Reinhard

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 2:34 pm

yeah I noticed that... I don't think it was polling any actual graphs at that time, oops... I changed things since that time stamp and the new runtime is every 5mins..

this is two pollings

Code: Select all

06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.4.1
06/02/2009 02:25:00 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 0 AND 5 ORDER BY id'
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
06/02/2009 02:25:00 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 0 AND 5 ORDER BY id'
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=0'
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=0'
06/02/2009 02:25:00 PM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=0'
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=0'
06/02/2009 02:25:00 PM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, sn$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
06/02/2009 02:25:00 PM - SPINE: Poller[0] Host[5] SNMP Result: Host responded to SNMP
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, sn$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=5'
06/02/2009 02:25:00 PM - SPINE: Poller[0] Host[5] RECACHE: Processing 1 items in the auto reindex cache for '127.0.0.1'
06/02/2009 02:25:00 PM - SPINE: Poller[0] Host[5] SNMP Result: Host responded to SNMP
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_$
06/02/2009 02:25:00 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=5'
06/02/2009 02:25:00 PM - SPINE: Poller[0] Host[5] RECACHE: Processing 1 items in the auto reindex cache for '127.0.0.1'
06/02/2009 02:29:59 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
06/02/2009 02:29:59 PM - SYSTEM STATS: Time:298.3076 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
06/02/2009 02:29:59 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
06/02/2009 02:29:59 PM - SYSTEM STATS: Time:298.3718 Method:spine Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
06/02/2009 02:30:01 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '301', Max Runtime '298', Poller Runs: '1'
06/02/2009 02:30:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/sbin/spine, ARGS:  0 5]
06/02/2009 02:30:01 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '0', Max Runtime '298', Poller Runs: '1'
06/02/2009 02:30:01 PM - POLLER: Poller[0] NOTE: Cron is configured to run too often!  The Poller Interval is '300' seconds, with a minimum Cron period of '3$
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
6/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 0
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The threads variable is 1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 0 AND 5 LIMIT 1'
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: StartHost='0', EndHost='5', TotalPHPScripts='0'
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
06/02/2009 02:30:01 PM - SPINE: Poller[0] Version 0.8.7b starting
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
06/02/2009 02:30:01 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.4.1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.4.1
06/02/2009 02:30:01 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 0 AND 5 ORDER BY id'
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp$
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path$
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=0'
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=0'
06/02/2009 02:30:01 PM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, sn$
06/02/2009 02:30:01 PM - SPINE: Poller[0] Host[5] SNMP Result: Host responded to SNMP
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_$
06/02/2009 02:30:01 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=5'
06/02/2009 02:30:01 PM - SPINE: Poller[0] Host[5] RECACHE: Processing 1 items in the auto reindex cache for '127.0.0.1'

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 2:37 pm

This is the poller.log that I created as suggested in the debugging page

Code: Select all

06/02/2009 02:35:00 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '1'
06/02/2009 02:35:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/sbin/spine, ARGS:  0 5]
Waiting on 1/1 pollers.
*** buffer overflow detected ***: /usr/sbin/spine terminated
======= Backtrace: =========
/lib/tls/i686/cmov/libc.so.6(__fortify_fail+0x48)[0xb7a7eda8]
/lib/tls/i686/cmov/libc.so.6[0xb7a7ceb0]
/lib/tls/i686/cmov/libc.so.6[0xb7a7c7b7]
/lib/tls/i686/cmov/libc.so.6(__snprintf_chk+0x34)[0xb7a7c6a4]
/usr/sbin/spine[0x8051dad]
/usr/sbin/spine[0x805210d]
/lib/tls/i686/cmov/libpthread.so.0[0xb7b2a4ff]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0xb7a6549e]
======= Memory map: ========
08048000-0805a000 r-xp 00000000 fc:00 629562     /usr/sbin/spine
0805a000-0805b000 r--p 00011000 fc:00 629562     /usr/sbin/spine
0805b000-0805c000 rw-p 00012000 fc:00 629562     /usr/sbin/spine
0805c000-0805e000 rw-p 0805c000 00:00 0
085cb000-086b2000 rw-p 085cb000 00:00 0          [heap]
b7158000-b7162000 r-xp 00000000 fc:00 171866     /lib/tls/i686/cmov/libnss_files-2.9.so
b7162000-b7163000 r--p 00009000 fc:00 171866     /lib/tls/i686/cmov/libnss_files-2.9.so
b7163000-b7164000 rw-p 0000a000 fc:00 171866     /lib/tls/i686/cmov/libnss_files-2.9.so
b7164000-b7171000 r-xp 00000000 fc:00 171709     /lib/libgcc_s.so.1
b7171000-b7172000 r--p 0000c000 fc:00 171709     /lib/libgcc_s.so.1
b7172000-b7173000 rw-p 0000d000 fc:00 171709     /lib/libgcc_s.so.1
b717a000-b717b000 ---p b717a000 00:00 0
b717b000-b797d000 rw-p b717b000 00:00 0
b797d000-b797f000 r-xp 00000000 fc:00 171858     /lib/tls/i686/cmov/libdl-2.9.so
b797f000-b7980000 r--p 00001000 fc:00 171858     /lib/tls/i686/cmov/libdl-2.9.so
b7980000-b7981000 rw-p 00002000 fc:00 171858     /lib/tls/i686/cmov/libdl-2.9.so
b7981000-b7add000 r-xp 00000000 fc:00 171855     /lib/tls/i686/cmov/libc-2.9.so
b7add000-b7ade000 ---p 0015c000 fc:00 171855     /lib/tls/i686/cmov/libc-2.9.so
b7ade000-b7ae0000 r--p 0015c000 fc:00 171855     /lib/tls/i686/cmov/libc-2.9.so
b7ae0000-b7ae1000 rw-p 0015e000 fc:00 171855     /lib/tls/i686/cmov/libc-2.9.so
b7ae1000-b7ae4000 rw-p b7ae1000 00:00 0
b7ae4000-b7af9000 r-xp 00000000 fc:00 171862     /lib/tls/i686/cmov/libnsl-2.9.so
b7af9000-b7afa000 r--p 00014000 fc:00 171862     /lib/tls/i686/cmov/libnsl-2.9.so
b7afa000-b7afb000 rw-p 00015000 fc:00 171862     /lib/tls/i686/cmov/libnsl-2.9.so
b7afb000-b7afe000 rw-p b7afb000 00:00 0
b7afe000-b7b22000 r-xp 00000000 fc:00 171859     /lib/tls/i686/cmov/libm-2.9.so
b7b22000-b7b23000 r--p 00023000 fc:00 171859     /lib/tls/i686/cmov/libm-2.9.so
b7b23000-b7b24000 rw-p 00024000 fc:00 171859     /lib/tls/i686/cmov/libm-2.9.so
b7b24000-b7b39000 r-xp 00000000 fc:00 171871     /lib/tls/i686/cmov/libpthread-2.9.so
b7b39000-b7b3a000 r--p 00014000 fc:00 171871     /lib/tls/i686/cmov/libpthread-2.9.so
b7b3a000-b7b3b000 rw-p 00015000 fc:00 171871     /lib/tls/i686/cmov/libpthread-2.9.so
b7b3b000-b7b3d000 rw-p b7b3b000 00:00 0
b7b3d000-b7b51000 r-xp 00000000 fc:00 171835     /lib/libz.so.1.2.3.3
b7b51000-b7b52000 r--p 00013000 fc:00 171835     /lib/libz.so.1.2.3.3
b7b52000-b7b53000 rw-p 00014000 fc:00 171835     /lib/libz.so.1.2.3.3
b7b53000-b7c86000 r-xp 00000000 fc:00 171967     /lib/i686/cmov/libcrypto.so.0.9.8
b7c86000-b7c8e000 r--p 00132000 fc:00 171967     /lib/i686/cmov/libcrypto.so.0.9.8
b7c8e000-b7c9b000 rw-p 0013a000 fc:00 171967     /lib/i686/cmov/libcrypto.so.0.9.8
b7c9b000-b7c9f000 rw-p b7c9b000 00:00 0
b7c9f000-b7ca8000 r-xp 00000000 fc:00 171857     /lib/tls/i686/cmov/libcrypt-2.9.so
b7ca8000-b7ca9000 r--p 00008000 fc:00 171857     /lib/tls/i686/cmov/libcrypt-2.9.so
b7ca9000-b7caa000 rw-p 00009000 fc:00 171857     /lib/tls/i686/cmov/libcrypt-2.9.so
b7caa000-b7cd2000 rw-p b7caa000 00:00 0
b7cd2000-b7e73000 r-xp 00000000 fc:00 621453     /usr/lib/libmysqlclient_r.so.15.0.0
b7e73000-b7e76000 r--p 001a0000 fc:00 621453     /usr/lib/libmysqlclient_r.so.15.0.0
b7e76000-b7eb6000 rw-p 001a3000 fc:00 621453     /usr/lib/libmysqlclient_r.so.15.0.0
b7eb6000-b7eb8000 rw-p b7eb6000 00:00 0
b7eb8000-b7f49000 r-xp 00000000 fc:00 621429     /usr/lib/libnetsnmp.so.15.1.0
b7f49000-b7f4a000 ---p 00091000 fc:00 621429     /usr/lib/libnetsnmp.so.15.1.0
b7f4a000-b7f4b000 r--p 00091000 fc:00 621429     /usr/lib/libnetsnmp.so.15.1.0
b7f4b000-b7f4d000 rw-p 00092000 fc:00 621429     /usr/lib/libnetsnmp.so.15.1.0
b7f4d000-b7f6b000 rw-p b7f4d000 00:00 0
b7f71000-b7f74000 rw-p b7f71000 00:00 0
b7f74000-b7f75000 r-xp b7f74000 00:00 0          [vdso]
b7f75000-b7f91000 r-xp 00000000 fc:00 171710     /lib/ld-2.9.so
b7f91000-b7f92000 r--p 0001b000 fc:00 171710     /lib/ld-2.9.so
b7f92000-b7f93000 rw-p 0001c000 fc:00 171710     /lib/ld-2.9.so
bfc7e000-bfc93000 rw-p bffeb000 00:00 0          [stack]
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 2:42 pm

Sorry if this is an information overload.

But, this error shows up before I ever attempt to create a graph on the main "new graphs" page if I select "Graph Types: All"

Code: Select all

()  	
Host: localhost (127.0.0.1) Graph Types: All 	*Edit this Host
*Create New Host

[b]Warning: Invalid argument supplied for foreach() in /usr/share/cacti/site/graphs_new.php on line 515[/b]
Graph Templates
Graph Template Name 	
Create: (select graph type to create)

However, if I select one of the graphs:

Code: Select all

()     
Host: localhost (127.0.0.1) Graph Types: SNMP - Interface Statistics    *Edit this Host
*Create New Host 

Data Query [SNMP - Interface Statistics]  	 

Reload Associated Query
Error in data query.

[b]Notice: Undefined variable: column_counter in /usr/share/cacti/site/graphs_new.php on line 887[/b]

How can I find "line 515" or "line 887" inside graphs_new.php ??? (only wondering as a side note, not that this is the cause of the error)

Post by **gandalf** » Tue Jun 02, 2009 2:59 pm

Did you compile spine on your own?
Reinhard

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 3:35 pm

I don't fully understand the whole... "compile" thing.. but I don't think so. To install cacti I followed the instructions at: http://www.ubuntugeek.com/install-and-c ... erver.html
I think spine was installed through this command:

Code: Select all

sudo apt-get install cacti-cactid

BUT. It only installed version 0.8.7b, and I needed a script that was made with 0.8.7c, so after it took me forever, I figured out how to upgrade it. (I was stuck on finding what my default cacti directory was.)
Now I have version 0.8.7d "working", but without graphs yet.

Thanks for the help,
Yoshi

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 3:37 pm

I changed my poller to cmd.php just to see if anything started working.

Something changed.....

no longer am I getting any errors in the "new graphs" page....
AND....

Code: Select all

RRDTool Says:

OK

but.. any graph that I attempt to make, does not show up in the graph tree...
PROGRESS... (I did change to cmd.php when first sugested, then I finished going through the debugging section... I think it might have been wrong permissions)

EDIT:
Just went to create another graph and it still has this error (with cmd.php poller)
Warning: Invalid argument supplied for foreach() in /usr/share/cacti/site/graphs_new.php on line 515
EDIT2:
Grr...
though I changed nothing, seems any success I had for a moment was false hope...

Code: Select all

RRDTool Says:

ERROR: opening '/usr/share/cacti/site/rra//38.rrd': No such file or directory

yoshi911 · Post by **yoshi911** » Tue Jun 02, 2009 4:45 pm

OK.... Officially call me Bi-Polar.... maybe I wasn't waiting long enough... because before my edits I had just deleted and remade my couple devices and graphs that I'm working with....
so maybe I didn't give it enough time... because now its:

Code: Select all

RRDTool Says:

OK

Cannot create graphs

Cannot create graphs

Who is online