Release of Cacti 0.8.7h

Important information about Cacti developments that all users should be interested in.

Moderators: Moderators, Developers

Locked
Author
Message
User avatar
rony
Developer/Forum Admin
Posts: 6016
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Release of Cacti 0.8.7h

#1 Post by rony » Sun Sep 25, 2011 9:09 pm

Release of Cacti 0.8.7h

We the Cacti Group are proud to release the following:
  • Cacti 0.8.7h
  • Spine 0.8.7h
  • Cacti Plugin Architecture 3.0 for Cacti 0.8.7h
Cacti 0.8.7h Change Log
  • bug#0001403: Reapply Suggested Names does not work correctly for graphs and data sources not associated with Data Queries
  • bug#0001568: Remove PHP 5.3 deprecated functions
  • bug#0001584: Concurrent changes to graph tree ordering can corrupt sort values
  • bug#0001626: Symbol ($) does not appear in labels/gprint strings to rrdtool during graph generation
  • bug#0001632: Script server treats quoted arguments with spaces incorrectly as multiple separate arguments
  • bug#0001646: MySQL SSL connection support
  • bug#0001660: Modifying data template values does not propagate as expected
  • bug#0001678: Adding graphs to a device fails to add entries to poller_item if using the script server
  • bug#0001768: Perform consistency check on ds maximum vs. ds minimum
  • bug#0001783: Graph Export export date is incorrect
  • bug#0001812: Data template copying ignores some item templating
  • bug#0001814: Command line device add script fails when SNMP default is disabled
  • bug#0001815: One minute polling not working correctly
  • bug#0001816: Cannot export graph data to CSV with IE 8
  • bug#0001819: MySQL "TYPE=" command deprecated since MySQL 4.1 removed in MySQL 5.4.4
  • bug#0001826: Zoomed graph views should auto refresh
  • bug#0001828: Reapply Suggested Name prompt as spelling problems
  • bug#0001835: Graph edit page has more than one html form tag
  • bug#0001847: Graph export API function has required argument not defined
  • bug#0001851: Graph creation selector does not work with data query that has no associated graph templates
  • bug#0001855: Improper formatting of data queries can result in SQL errors
  • bug#0001862: Ping script does not process output of update ping utility
  • bug#0001867: RRDtool Cacti fetch function does not work for some locales
  • bug#0001876: PHP function strip_quotes causes HEX values to be truncated
  • bug#0001880: Form validation error message does not highlight text area control
  • bug#0001882: Cacti snmp_walk function fails if max_oids is an empty value
  • bug#0001890: Default tree view mode set to single pane mode not working
  • bug#0001893: Data input method description text does not make sense
  • bug#0001900: Equal sign not correctly parsed in snmp data results
  • bug#0001903: Undefined variable: mode in lib/ldap.php on line 375
  • bug#0001918: Script server does not accept more than one blank space before the function name
  • bug#0001926: Importing templates "using defaults for this installation" associates all rra's defined
  • bug#0001928: graph_image.php does not check local_graph_id
  • bug#0001929: Error when exporting templates are not properly reported
  • bug#0001930: No error reporting for wrong RRA
  • bug#0001934: Poller does not process SIGTERM signal correctly
  • bug#0001936: Removing multiple data sources is inefficient
  • bug#0001937: Technical support page uses check table which waits for table lock
  • bug#0001939: Do not query for number or items per host if concurrent polling processes is set to one
  • bug#0001954: Usage of PHP_SELF without basename in html.php (at least partly fixed)
  • bug#0001956: Attempts to update existing tree item fail
  • bug#0001967: Reflected XSS on Cacti 0.8.7g
  • bug#0001989: IE9 breaks Cacti when objects are hidden using 'display:none;' style tag
  • bug#0001993: Undefined index in lib/html.php
  • bug#0001995: REQUEST_URI not properly escaped in graph_view.php for preview mode
  • bug#0002005: Saving Script Server or Script Data Input Method Results in SQL Error
  • bug#0002060: NAN values in hdd utilization graphs (Poller Output Table not Empty)
  • bug: Fix SQL injection issues in login page
  • bug: RRDtool fetch in Cacti fails to function properly on rrdtool files with NaN values in the output
  • bug: Accept "Connection refused" on TCP ping tests
  • bug: Add missing row selection javascript to graph preview
  • bug: Script server throws "undefined variable" error when in debug mode
  • bug: Removing graphs does not take advantage of bulk deletes
  • bug: Fixed issue with multiple "U" results for a data input method with multiple output parameters
  • bug: SNMP v3 use AuthNoPriv when privacy passphrase is empty
  • bug: Fixed sql errors when using template and search filter on graph management
  • bug: Delete Data Source multi fails to perform bulk deletes on Data Source items
  • bug: Allow Timespan Selector to work with $_REQUEST as well as $_POST
  • bug: While in the mrtg view of Cacti Graphs, or in viewing graph properties zoom fails
  • bug: The filepath api call should trim the filename before checking for the files existance
  • bug: Fix issues with IE9 while editing templates
  • bug: Form action in graph_items.php incorrect
  • bug: Initial drawing of tree causing Next/Previous with malformed URI
  • feature#0001519: Spine enhancement for parallel collection of data at device level
  • feature#0001667: Get values of |host_*| variables in graph elements from data source
  • feature#0001922: Reindex method "Index Count Changed" requires that OID_NUM_INDEXES is given for SNMP Data Queries
  • feature#0001923: Implement counting for script (server) data queries just like OID_NUM_INDEXES
  • feature#0001924: Allow for reindex method "Index Count Changed" to apply to script (server) queries as well
  • feature#0001952: Ability to use input field of a script in graph title
  • feature: Make reindexing and repopulating the poller cache a lossless process
  • feature: Change default font sizes
  • feature: Add analyze database and push out host cli scripts
Reporting Bugs

http://www.cacti.net/bugs.php

Download Cacti

http://www.cacti.net/download_cacti.php

Download Plugin Architecture

http://www.cacti.net/downloads/pia/cact ... 3.0.tar.gz

Download Spine

http://www.cacti.net/spine_download.php


Thanks!
The Cacti Group
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]

noname
Cacti Guru User
Posts: 1566
Joined: Thu Aug 05, 2010 2:04 am
Location: Japan

Re: Release of Cacti 0.8.7h

#2 Post by noname » Sun Sep 25, 2011 11:40 pm

Please edit cacti.sql before importing it.

Line 406-421:
CREATE TABLE data_input_fields (
...
KEY type_code (type_code), <--delete trailing comma
) ENGINE=MyISAM;

sukanta
Cacti User
Posts: 139
Joined: Tue Jan 26, 2010 6:12 am

Re: Release of Cacti 0.8.7h

#3 Post by sukanta » Mon Sep 26, 2011 2:41 am

So Far Smooth in new Installation in test Server....CentOS5.6...

Will Update further....

Any Update Precaution Required from 0.8.7g

sukanta
Cacti User
Posts: 139
Joined: Tue Jan 26, 2010 6:12 am

Re: Release of Cacti 0.8.7h

#4 Post by sukanta » Mon Sep 26, 2011 1:00 pm

|query_ifHighSpeed| not accepting in rrd_maximum. In is working in 0.8.7g.

Followings are already there interface.xml

<ifHighSpeed>
<name>HighSpeed</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.2.1.31.1.1.1.15</oid>
</ifHighSpeed>
Attachments
highspeed.jpg
highspeed.jpg (89.89 KiB) Viewed 24734 times

User avatar
rony
Developer/Forum Admin
Posts: 6016
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Re: Release of Cacti 0.8.7h

#5 Post by rony » Mon Sep 26, 2011 2:16 pm

sukanta wrote:|query_ifHighSpeed| not accepting in rrd_maximum. In is working in 0.8.7g.

Followings are already there interface.xml

<ifHighSpeed>
<name>HighSpeed</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.2.1.31.1.1.1.15</oid>
</ifHighSpeed>
The other replacements are not replaced. Did you create the graph correctly through the data query?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Release of Cacti 0.8.7h

#6 Post by TheWitness » Mon Sep 26, 2011 2:38 pm

The ifHighSpeed appears to be a customization and not standard release as the maximum would have to be ifHighSpeed multiplied by some value.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

User avatar
rony
Developer/Forum Admin
Posts: 6016
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Re: Release of Cacti 0.8.7h

#7 Post by rony » Mon Sep 26, 2011 3:46 pm

noname wrote:Please edit cacti.sql before importing it.

Line 406-421:
CREATE TABLE data_input_fields (
...
KEY type_code (type_code), <--delete trailing comma
) ENGINE=MyISAM;

*sigh* This is fixed in the release now...
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]

sukanta
Cacti User
Posts: 139
Joined: Tue Jan 26, 2010 6:12 am

Re: Release of Cacti 0.8.7h

#8 Post by sukanta » Mon Sep 26, 2011 11:34 pm

rony wrote:
sukanta wrote:|query_ifHighSpeed| not accepting in rrd_maximum. In is working in 0.8.7g.

Followings are already there interface.xml

<ifHighSpeed>
<name>HighSpeed</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.2.1.31.1.1.1.15</oid>
</ifHighSpeed>
The other replacements are not replaced. Did you create the graph correctly through the data query?

=======================

|query_ifSpeed| Also not giving any value in Maximum Value but graphs are coming....

ifHighSpeed also should be standard otherwise 10G port will not be monitored.

aocampo
Posts: 15
Joined: Wed Sep 29, 2010 11:03 am

Re: Release of Cacti 0.8.7h

#9 Post by aocampo » Tue Sep 27, 2011 6:46 pm

I have a trouble with Spine 0.8.7h. When I run spine via CLI, the execution is successful, but when I select spine on the poller type, it fails. I have previously used Spine 0.8.7g without problems.

This is my spine.conf:

DB_Host localhost
DB_Database cacti
DB_User cacti
DB_Pass *****
DB_Port 3306
DB_PreG 0


These are the spine parameters:

Maximum Concurrent Poller Processes: 1
Maximum Threads per Process: 10
Number of PHP Script Servers: 1
Script and Script Server Timeout Value: 25
The Maximum SNMP OID's Per SNMP Get Request: 10


This is my log in devel level:

09/27/2011 12:40:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/sbin/spine, ARGS: 0 92]
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 4
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 1000
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The threads variable is 10
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: StartHost='0', EndHost='92', TotalPHPScripts='0'
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
09/27/2011 12:40:01 PM - SPINE: Poller[0] Version 0.8.7h starting
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Spine has cap_net_raw capability.
09/27/2011 12:40:01 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
09/27/2011 12:40:01 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
09/27/2011 12:40:01 PM - SPINE: Poller[0] NOTE: Spine will support multithread device polling.
09/27/2011 12:40:01 PM - SPINE: Poller[0] NOTE: Spine is behaving in a 0.8.7g+ manner
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 2
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 3
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 4
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 5
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 6
09/27/2011 12:40:01 PM - SPINE: Poller[0] Host[0] TH[1] Total Time: 0.001 Seconds
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] Host[0] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 7
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 8
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 9
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 10
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 9
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/27/2011 12:40:01 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 10


Thanks in advance for your help!

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Release of Cacti 0.8.7h

#10 Post by TheWitness » Tue Sep 27, 2011 10:30 pm

I'm suspecting something to do with your environment. Can you turn up the logging from crontab to a temporary file and see what comes from the poller.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

aocampo
Posts: 15
Joined: Wed Sep 29, 2010 11:03 am

Re: Release of Cacti 0.8.7h

#11 Post by aocampo » Wed Sep 28, 2011 10:34 am

It was the output:

Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
.
.
.

In addition, I have got the following output in cacti.log:

09/28/2011 10:25:00 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
09/28/2011 10:25:00 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

09/28/2011 10:25:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:298.9579 Method:spine Processes:1 Threads:10 Hosts:55 HostsPerProcess:55 DataSources:1365 RRDsProcessed:0')"
09/28/2011 10:25:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '1'
09/28/2011 10:25:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/sbin/spine, ARGS: 0 92]
09/28/2011 10:25:01 AM - SYSTEM STATS: Time:298.9579 Method:spine Processes:1 Threads:10 Hosts:55 HostsPerProcess:55 DataSources:1365 RRDsProcessed:0


Thanks for your help!

c3226026
Cacti User
Posts: 87
Joined: Mon Jan 17, 2011 12:15 pm

Re: Release of Cacti 0.8.7h

#12 Post by c3226026 » Wed Sep 28, 2011 11:19 am

Hello TheWitness,

I think there is something wrong on CLog setup.php file in the trunk directory, it's not possible to install it, when I click on the red button, nothing is done, I have a blank page, and when I refresh plugins page I cannot activate it (because I see only red button).

Could you loock about it please ?

Thanks in advanced.

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Release of Cacti 0.8.7h

#13 Post by TheWitness » Wed Sep 28, 2011 11:58 am

make sure that the plugins array in config.php does not include it. also, make sure you do not have backups of that plugin in other directories under the plugins directory.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Release of Cacti 0.8.7h

#14 Post by TheWitness » Wed Sep 28, 2011 12:00 pm

aocampo wrote:It was the output:

Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
.
.
.

In addition, I have got the following output in cacti.log:

09/28/2011 10:25:00 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
09/28/2011 10:25:00 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

09/28/2011 10:25:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:298.9579 Method:spine Processes:1 Threads:10 Hosts:55 HostsPerProcess:55 DataSources:1365 RRDsProcessed:0')"
09/28/2011 10:25:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '1'
09/28/2011 10:25:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/sbin/spine, ARGS: 0 92]
09/28/2011 10:25:01 AM - SYSTEM STATS: Time:298.9579 Method:spine Processes:1 Threads:10 Hosts:55 HostsPerProcess:55 DataSources:1365 RRDsProcessed:0


Thanks for your help!
roll back to the old spine until you figure this out.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

aocampo
Posts: 15
Joined: Wed Sep 29, 2010 11:03 am

Re: Release of Cacti 0.8.7h

#15 Post by aocampo » Wed Sep 28, 2011 1:50 pm

TheWitness wrote:
aocampo wrote:It was the output:

Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
.
.
.

In addition, I have got the following output in cacti.log:

09/28/2011 10:25:00 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
09/28/2011 10:25:00 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

09/28/2011 10:25:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:298.9579 Method:spine Processes:1 Threads:10 Hosts:55 HostsPerProcess:55 DataSources:1365 RRDsProcessed:0')"
09/28/2011 10:25:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '1'
09/28/2011 10:25:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/sbin/spine, ARGS: 0 92]
09/28/2011 10:25:01 AM - SYSTEM STATS: Time:298.9579 Method:spine Processes:1 Threads:10 Hosts:55 HostsPerProcess:55 DataSources:1365 RRDsProcessed:0


Thanks for your help!
roll back to the old spine until you figure this out.
Hi TheWitness!

Sadly, when I tried to rollback the change, it did not work :( I tried to run manually the poller but nothing appears:

Code: Select all

[email protected]:/usr/share/cacti# php -q poller.php 
No log handling enabled - turning on stderr logging
But when I change the poller type to cmd.php it works! It seems that something is broken after the upgrade :(

Thanks for your time!

Locked