Cacti 0.8.7 Beta 3 and Spine Beta 3 - Availiable for testing

[rony]

Available now, Cacti 0.8.7 Beta 3 and Spine Beta 3 for TESTING!

Do not use this in your production environment!

Attached is the beta version of Spine, the new Cactid for 0.8.7.

If you find any issues, please submit a bug at http://www.cacti.net/bugs.php

Change log:

Cacti 0.8.7
-bug#0000480: Error after altering graphs displayed per page
-bug#0000740: Lack of unique session name conflicts with other PHP applications
-bug#0000829: JVM, Spike detection and Poller
-bug#0000833: favicon.ico support
-bug#0000850: Select All for list view
-bug#0000854: Move "Downed Host Detection" to each device
-bug#0000873: Poller hangs in certain situations
-bug#0000876: Ability to search for host with a not UP status
-bug#0000898: Selecting a CUSTOM timespan and then CLEARing yields "LAST HALF HOUR" preset
-bug#0000899: Settings checks paths for existance
-bug#0000902: cmd.php doesn't work with PHP 4.4.1 under windows
-bug#0000903: snmpgetnext function does not exist in PHP less than 5.0
-bug#0000904: Data Source creation fails without php-snmp
-bug#0000906: Every tenth host does not show on tree during console edit
-bug#0000907: Sorting of data sources when interface numbers are used without leading zeros are incorrectly sorted
-bug#0000908: Graphs created by SNMP data queries are losing their specific names if the template is modified
-bug#0000910: Cacti complains when trying to set the data source "maximum value" to any number with a decimal point
-bug#0000912: Nth Percentile thumbnail graphs fail with RRDtool 1.2.15, 1.2.18
-bug#0000913: Allow direct linking to specific graph pages
-bug#0000919: Problem with ping_tcp function
-bug#0000920: Improved handling of rrdtool --font parameter
-bug#0000921: Improvement to ping.pl script
-bug#0000925: Support for host_* variables in the legend
-bug#0000926: Useful characters are removed when searching
-bug#0000927: Classic export does not recognize thumbnail columns properly
-bug#0000931: New rrdtool fails on empty comment
-bug#0000934: Column 'status_last_error' in table 'host' too short.
-bug#0000937: System output in hosts.php poor for Alcatel
-bug#0000946: Timetick of zero returns down for device
-bug#0000947: Trailing blanK on oid in form causes problems
-bug#0000953: SNMP Passphrase displayed in cleartext
-bug#0000955: Fixed possible denial of service attack by modifying graph image url
-bug#0000956: Additional editing help with tree management
-bug#0000957: Script server output's beginning/trailing data during "Include" causing a synchronization issue
-bug#0000958: Slope Mode is now selectable
-bug#0000959: Alarming added when poller output table is not empty
-bug#0000963: TCP/UDP capitalization
-bug#0000965: When setting filters under utilities, pressing enter takes you back to the main page
-bug#0000966: Log file viewing utility has no ability to filter
-bug#0000969: In some versions of PHP, the graph tree will not view properly
-bug#0000970: Incorrect debug messages in lib/ping.php for failed UDP ping
-bug#0000974: No graphs on Fedora core6 using sunone/iplanet 6.1 SP5
-bug#0000975: Add Nth Percentile aggregate_current - Summing Multiple Data Sources with like names for Nth Percentile
-bug#0000982: Remove invalid references to the "output_string" column in the "data_input" table
-bug#0000983: Bad SQL: snmp_query_graph_rrd.snmp_query_graph_id=
-bug#0000984: Poller does not correctly flush poller_output table after a memory error
-bug#0000989: hyphen - host description used with Data Source Path
-bug#0001001: "Purge User Log" keeps invalid entries
-bug#0001002: Cacti reports incomplete interface status
-bug#0001007: SNMPv3 password field allows command injection
-bug: ss_sql.php causes the script server to crash
-bug: Timeshifter added to base code
-bug: Allow query_ and host_ substitution in COMMENT and CDEF's.
-bug: Command line interface scripts to add devices, graphs, tree's and permissions.
-bug: Correct index error when creating graphs when you have no hosts on your system.
-bug: More recent versions of net-snmp broke SNMP walk functions.
-bug: Adjust for problematic responses from some SNMP agents (IBM AIX).
-bug: Improve logging in cmd.php and poller.php when parameters are not specified correctly.
-bug: Reduce the total number of SQL queries called
-bug: Replace inefficient strip function in process_poller_output
-bug: Some php_snmp implementations return strings as "Hex-STRING:". In these cases properly resolve the string
-bug: Correctly assign right and left click actions for Opera
-bug: Fix SQL error when viewing an invalid Data Source via the Log Viewer
-bug: Fix command line user copy utility
-feature: Paginate the Graph Creation Page
-feature: Add SNMPv3 Support to Cacti
-feature: Add a Notes field to the Device that can contain arbitrary information
-feature: Add Availability Methods to Cacti including per Host Ping Methods and Timeouts
-feature: Add Max OID's to te Host Level
-feature: Allow CSV Export from the various Graphs page
-feature: Add rra_path as a global.php config variable
-feature: Add drop down actions to data queries
-feature: Add drop down actions to data input methods
-feature: Add drop down actions to user administration
-feature: Add filtering and pagination to data queries
-feature: Add filtering and pagination to data input methods
-feature: Add filtering and pagination to host templates
-feature: Add filtering and pagination to user administration
-feature: Add extended LDAP authentication support
-feature: Add Web Basic authentication
-feature: Add authenication realm to modifiable user parameters
-feature: Add multiple polling intervals
-feature: Moved command line scripts to cli sub directory
-feature: include/config.php now only includes database configuration
-feature: include/config_* have been renamed to include/global_*. Note: Script servers need to be updated.
-feature: Allow VRULE's in Cacti to specify an absolute timestamp in addition to [+/-]HH:MM
-feature: Add 1 minute RRA
-feature: Add item select highlighting to main pages
-feature: Let poller.php be more intelligent about poller intervals less than 60 seconds
-feature: Add consistency to Filters by adding nowrap to td items
-feature: Add Graph and Data Source counts to Device page
-feature: Add Poller Interval to Data Sources page
-feature: Keep filters aligned with main page content on window resize
-feature: Add Enable/Disable user
-feature: Add copy and batch copy of users
-feature: Reduce ADODB memory consumption during polling
-feature: Add new RRDtool Function to facilitate CSV export
-feature: Add the ability to ignore custom RRA settings when importing templates and use this behavior by default
-feature: Add technical support output to System Utilities
-compat: Add additional checking due to php-snmp changes in Windows
-compat: Remove GIF as a supported file type for RRDTool 1.2.x and added SVG file type

Spine 0.8.7
-bug: Fix configure issues with hybrid 64 bit OS'
-feature: Rename to spine
-feature: Update copyright
-feature: Add tab stops and autoindent to source code
-feature: Make spike detection more generic
-feature: Add snmpv3 support including contexts

[mrnoodle]

The font settings issue reported in Bug 0001011 (System Level Font Settings Not Applied to Graphs) has not been corrected.

Previously, the font settings in the System configuration properly set the Font in the RRD graphs but the Font size was not applied correctly.

Now the font size is applied correctly but the font that is supposed to be used is not.

I have set the "Use Custom Fonts" option and set the same variables in the User settings as in the System and neither will allow the selected Font to be applied.

Since the original Bug has been listed as Fixed, do I need to submit a new bug report?

[TheWitness]

Simply reopen it.

TheWitness

[mrnoodle]

Bug has been reopened.

I didn't realize I was not logged in and that it was an option.

[fraz]

I upgraded my cacti playground from Version 0.8.6j to cacti 0.8.7 beta 3.

Now, the poller isn't working

--> output from poller
09/24/2007 09:30:04 AM - SYSTEM STATS: Time:1.1724 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0

--> when I try to create a new graph I got a sql error messge like this:
9/24/2007 09:44:29 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"INSERT INTO poller_item (local_data_id, host_id, action,hostname, snmp_community, snmp_version, snmp_timeout, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, rrd_name, rrd_path, rrd_num, rrd_step, rrd_next_step, arg1, arg2, arg3) VALUE (11, 2, 0,'cobp0708.brose.net', 'public', '1', '500', '', '', 'MD5', '', 'DES', '', '161', 'traffic_out', '/srv/www/htdocs/cacti/rra/cobp0708_traffic_in_11.rrd', '2', '300', '0', '.1.3.6.1.2.1.2.2.1.16.1', '', '')'

I am using SLES9 sp3 with
php4 - 4.3.4
mysql - 4.0.18

is mysql to old (4.0.18 ), is there a workaround available?

please help!

regards
Franz

[oxo-oxo]

While waiting for a developer....

Try from command prompt

Code: Select all

mysql cacti -u cactiuser -p

And enter

Code: Select all

INSERT INTO poller_item (local_data_id, host_id, action,hostname, snmp_community, snmp_version, snmp_timeout, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, rrd_name, rrd_path, rrd_num, rrd_step, rrd_next_step, arg1, arg2, arg3) VALUE (11, 2, 0,'cobp0708.brose.net', 'public', '1', '500', '', '', 'MD5', '', 'DES', '', '161', 'traffic_out', '/srv/www/htdocs/cacti/rra/cobp0708_traffic_in_11.rrd', '2', '300', '0', '.1.3.6.1.2.1.2.2.1.16.1', '', '');

And post the result

[fraz]

I got:

mysql> INSERT INTO poller_item (local_data_id, host_id, action,hostname, snmp_community, snmp_version, snmp_timeout, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, rrd_name, rrd_path, rrd_num, rrd_step, rrd_next_step, arg1, arg2, arg3) VALUE (11, 2, 0,'cobp0708.brose.net', 'public', '1', '500', '', '', 'MD5', '', 'DES', '', '161', 'traffic_out', '/srv/www/htdocs/cacti/rra/cobp0708_traffic_in_11.rrd', '2', '300', '0', '.1.3.6.1.2.1.2.2.1.16.1', '', '');
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUE (11, 2, 0,'cobp0708.brose.net', 'public', '1', '500', '',
mysql>

It looks like a "small" syntax error, but I can't find anything ...

regards
Franz

[oxo-oxo]

Apparently no syntax problems from a newer mysql server...

Code: Select all

mysql> INSERT INTO poller_item (local_data_id, host_id, action,hostname, snmp_community, snmp_version, snmp_timeout, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, rrd_name, rrd_path, rrd_num, rrd_step, rrd_next_step, arg1, arg2, arg3) VALUE (11, 2, 0,'cobp0708.brose.net', 'public', '1', '500', '', '', 'MD5', '', 'DES', '', '161', 'traffic_out', '/srv/www/htdocs/cacti/rra/cobp0708_traffic_in_11.rrd', '2', '300', '0', '.1.3.6.1.2.1.2.2.1.16.1', '', '');
Query OK, 1 row affected (0.00 sec)

mysql>

[fraz]

Thanks for help to denmark from germany ...

Any workaround available?

regards
Franz

[oxo-oxo]

Sorry:not that I know of.
Let's see if a developer has a comment.

[rony]

Please run the System Utilities -> Technical Support. If there are any table issues, you need to run a repair on the database.

[cigamit]

Just glancing
) VALUE (
should probably be
) VALUES (

Found where the issue is in SVN and committing now.

[rony]

Fyi, I will be posting Beta 4 by the Wednesday of this week.

[fraz]

Now it works, thanks for help!

Now, lets jump to the next bug ...

regards
Franz

[fraz]

I am on the next bug:

Code: Select all

09/24/2007 07:23:40 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host_id, snmp_query_id, snmp_index, FROM host_snmp_cache WHERE host_id=4 AND snmp_query_id=10 GROUP BY host_id, snmp_query_id, snmp_index ORDER BY CAST(snmp_index AS unsigned) LIMIT 0,20"

Is this command not allow at mysql 4.0?

I disabled line 418/419 at utilities.php

Code: Select all

# print "  <td>" . $item["Engine"] . "</td>\n";
# print "  <td>" . $item["Collation"] . "</td>\n";

because this entries are not available at mysql 4.0

regards
Franz

regards
Franz