Part of multiple polling is to support either MySQL replication, or to
replicate tables requred for remote data collection. These changes will
enable the later method, but are not complete.
The replicate_tables in lib/poller.php function is designed to handle
each of the table replecation types. When complete, it will handle all
table replication based upon poller state.
There may be additional table schema changes to increase performance,
but those changes have not been validated yet.
Throws an sql error. Replace into cannot take a where statement.
05/13/2016 10:18:41 PM - CMDPHP SQL Backtrace: (/utilities.php: 38 repopulate_poller_cache)(/lib/utility.php: 53 api_data_source_cache_crc_update)(/lib/api_data_source.php: 31 db_execute_prepared)(/lib/database.php: 158 cacti_debug_backtrace)
05/13/2016 10:18:41 PM - CMDPHP ERROR: A DB Exec Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name='data_source_cache_crc_0'' at line 1
05/13/2016 10:18:41 PM - CMDPHP ERROR: A DB Exec Failed!, Error:1064, SQL:"REPLACE INTO settings SET value = ? WHERE name='data_source_cache_crc_0''
this commit will cause your 1.0 environment to break. to fix, please
run the script 'profile_migrate.php'. this commit includes a major new
feature to allow your Cacti system to have multiple polling intervals
and for you to create identical graphs using multiple polling intervals
in a sane way. this is an initial commit, one that has been tested.
however, there will be subsequent commits. however, after migration,
this should be considered stable.
Changes include:
- Convert some <br> to </li>
- Update ChangeLog per 0.8.8d release
- Fix Max Values on UCD/SNMP Memory Template
- Change Cacti Group Format to Modern Theme
- Fix Locking on Graphs
- Force Image format to PNG for Legacy Graph Image
- Correct form Logic on Settings to Fix Reverse Proxy's
- Shorten Uptime Display on Device Edit
- Force a Locale Setting for i18n on Graphs
- Fix Resizable Columns to resize only the current column
- Add DropIcon selectmenu Widget to modern theme
- Fix Issue where delete data source multi leaves orphan records
- Correct performance bug in Boost engine
- Optimize array_to_sql_or performance
- Correct and issue where pushing out data query objects to host cache
could leave orphan elements
- Add OID_REWRITE_PATTERN Feature on input
- Add VALUE/REGEXP Feature on output
- Optimize strip_quotes function to be more intellegent
- Escape shell arguments on Script Data Input types
- Allow Special Characters for LDAP passwords
- Correct LDAP class defect for anonymous binding
- Bypass php-snmp for now
- Correct rrdcleaner bytes units
- Fix loadavg_multi.pl to respect i18n
- Remove legacy row counters from snmpagent pages
1) Realtime integration complete
2) Added option to update sys OID's in spine and cmd.php
3) Updated poller as well
4) Made cmd.php argument processing sane
5) Remove one more 'rrdtool_graph' variant (aka Realtime)
6) Moved Realtime settings under Visual
7) Added some core Javascript utility functions
8) Added minimum width to dropdowns to make more appealing
9) Cleanup some redundant syntax in headers
10) Typos in format files
git-svn-id: svn+ssh://repo.cacti.net/var/data/svnroot/cacti/cacti/branches/0.8.8@7678 860744bd-22fc-0310-8c96-e9fe5004b5ca
2) Allow Locking/UnLocking of Graphs
3) ToolTips
4) Correct Minor Issues with Login/Out/Permission associated with Theme JS
5) Upgrade jQuery which has Fixes for Major issue in Safari 7/8.1
git-svn-id: svn+ssh://repo.cacti.net/var/data/svnroot/cacti/cacti/branches/0.8.8@7662 860744bd-22fc-0310-8c96-e9fe5004b5ca
Change double quotes to single quotes where possible
Move to prepared statements were possible
git-svn-id: svn+ssh://repo.cacti.net/var/data/svnroot/cacti/cacti/branches/0.8.8@7642 860744bd-22fc-0310-8c96-e9fe5004b5ca
2) Improved and Moved RRDCleaner Under Utilities (Tested to 1M RRDfiles, very fast)
3) Normalized the 'message' display so it can be used in 'All' Ajax page refreshes
4) Fixed a JavaScript issue that prevented List View from working well.
5) Remove some deprecated references to "Dual" and "Single" pane Tree View
6) Added 'pulsate' Javascript function for some nice notification (see RRDCleaner GUI)
git-svn-id: svn+ssh://repo.cacti.net/var/data/svnroot/cacti/cacti/branches/0.8.8@7553 860744bd-22fc-0310-8c96-e9fe5004b5ca
- data sources were not paying respect to sequence
- applying Larry's fix to Graph templates as well
git-svn-id: svn+ssh://repo.cacti.net/var/data/svnroot/cacti/cacti/branches/0.8.7@4917 860744bd-22fc-0310-8c96-e9fe5004b5ca
-bug: Re-Apply Suggested Data Source names results in a SQL error for rrd_maximum='query_ifSpeed'
git-svn-id: svn+ssh://repo.cacti.net/var/data/svnroot/cacti/cacti/branches/0.8.7@4912 860744bd-22fc-0310-8c96-e9fe5004b5ca