mirror of
https://github.com/Cacti/cacti.git
synced 2026-11-03 10:37:46 +09:00
230 lines
10 KiB
PHP
230 lines
10 KiB
PHP
<?php
|
|
/*
|
|
+-------------------------------------------------------------------------+
|
|
| Copyright (C) 2004-2026 The Cacti Group |
|
|
| |
|
|
| This program is free software; you can redistribute it and/or |
|
|
| modify it under the terms of the GNU General Public License |
|
|
| as published by the Free Software Foundation; either version 2 |
|
|
| of the License, or (at your option) any later version. |
|
|
| |
|
|
| This program is distributed in the hope that it will be useful, |
|
|
| but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
|
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
|
| GNU General Public License for more details. |
|
|
+-------------------------------------------------------------------------+
|
|
| Cacti: The Complete RRDTool-based Graphing Solution |
|
|
+-------------------------------------------------------------------------+
|
|
| This code is designed, written, and maintained by the Cacti Group. See |
|
|
| about.php and/or the AUTHORS file for specific developer information. |
|
|
+-------------------------------------------------------------------------+
|
|
| http://www.cacti.net/ |
|
|
+-------------------------------------------------------------------------+
|
|
*/
|
|
|
|
function upgrade_to_1_2_0() : void {
|
|
db_install_add_column('user_domains_ldap', ['name' => 'cn_full_name', 'type' => 'varchar(50)', 'NULL' => true, 'default' => '']);
|
|
db_install_add_column('user_domains_ldap', ['name' => 'cn_email', 'type' => 'varchar(50)', 'NULL' => true, 'default' => '']);
|
|
|
|
$poller_exists = db_column_exists('poller', 'processes');
|
|
|
|
db_install_add_column('poller', ['name' => 'max_time', 'type' => 'double', 'after' => 'total_time']);
|
|
db_install_add_column('poller', ['name' => 'min_time', 'type' => 'double', 'after' => 'max_time']);
|
|
db_install_add_column('poller', ['name' => 'avg_time', 'type' => 'double', 'after' => 'min_time']);
|
|
db_install_add_column('poller', ['name' => 'total_polls', 'type' => 'int', 'after' => 'avg_time', 'default' => '0']);
|
|
db_install_add_column('poller', ['name' => 'processes', 'type' => 'int', 'after' => 'total_polls', 'default' => '1']);
|
|
db_install_add_column('poller', ['name' => 'threads', 'type' => 'double', 'after' => 'processes', 'default' => '1']);
|
|
db_install_add_column('poller', ['name' => 'sync_interval', 'type' => 'int', 'after' => 'threads', 'default' => '7200']);
|
|
db_install_add_column('poller', ['name' => 'timezone', 'type' => 'varchar(40)', 'default' => '', 'after' => 'status']);
|
|
db_install_add_column('poller', ['name' => 'dbsslkey', 'type' => 'varchar(255)', 'after' => 'dbssl']);
|
|
db_install_add_column('poller', ['name' => 'dbsslcert', 'type' => 'varchar(255)', 'after' => 'dbsslkey']);
|
|
db_install_add_column('poller', ['name' => 'dbsslca', 'type' => 'varchar(255)', 'after' => 'dbsslcert']);
|
|
db_install_add_column('poller', ['name' => 'dbsslcapath', 'type' => 'varchar(255)', 'after' => 'dbsslca']);
|
|
db_install_add_column('poller', ['name' => 'dbsslverifyservercert', 'type' => 'char(3)', 'after' => 'dbsslcapath', 'default' => 'on']);
|
|
|
|
if (!$poller_exists) {
|
|
// Take the value from the settings table and translate to
|
|
// the new Data Collector table settings
|
|
|
|
// Ensure value falls in line with what we expect for processes
|
|
$max_processes = read_config_option('concurrent_processes');
|
|
|
|
if ($max_processes < 1) {
|
|
$max_processes = 1;
|
|
}
|
|
|
|
if ($max_processes > 10) {
|
|
$max_processes = 10;
|
|
}
|
|
|
|
// Ensure value falls in line with what we expect for threads
|
|
$max_threads = read_config_option('max_threads');
|
|
|
|
if ($max_threads < 1) {
|
|
$max_threads = 1;
|
|
}
|
|
|
|
if ($max_threads > 100) {
|
|
$max_threads = 100;
|
|
}
|
|
|
|
db_install_execute("UPDATE poller SET processes = $max_processes, threads = $max_threads");
|
|
}
|
|
|
|
db_install_add_column('host', ['name' => 'location', 'type' => 'varchar(40)', 'after' => 'hostname']);
|
|
db_install_add_key('host', 'index', 'site_id_location', ['site_id', 'location']);
|
|
|
|
db_install_add_column('poller_resource_cache', ['name' => 'attributes', 'type' => 'int unsigned', 'default' => '0']);
|
|
db_install_add_column('external_links', ['name' => 'refresh', 'type' => 'int unsigned']);
|
|
db_install_add_column('automation_networks', ['name' => 'same_sysname', 'type' => 'char(2)', 'default' => '', 'after' => 'add_to_cacti']);
|
|
|
|
db_install_execute("ALTER TABLE user_auth
|
|
MODIFY COLUMN password varchar(256) NOT NULL DEFAULT ''");
|
|
|
|
db_install_execute("ALTER TABLE graph_tree_items
|
|
MODIFY COLUMN sort_children_type tinyint(3) unsigned NOT NULL DEFAULT '0'");
|
|
|
|
db_install_execute('UPDATE graph_templates_graph
|
|
SET t_title="" WHERE t_title IS NULL or t_title="0"');
|
|
|
|
$log_validation_results = db_install_fetch_cell('SELECT value FROM settings WHERE name=\'log_validation\'');
|
|
$log_validation = $log_validation_results['data'];
|
|
|
|
$log_developer_results = db_install_fetch_cell('SELECT value FROM settings WHERE name=\'developer_mode\'');
|
|
$log_developer = $log_developer_results['data'];
|
|
|
|
if ($log_developer !== false && $log_validation === false) {
|
|
db_install_execute('UPDATE settings
|
|
SET name="log_validation" WHERE name="developer_mode"');
|
|
}
|
|
|
|
db_install_add_column('automation_networks', ['name' => 'notification_enabled', 'type' => 'char(2)', 'default' => '', 'after' => 'enabled']);
|
|
db_install_add_column('automation_networks', ['name' => 'notification_email', 'type' => 'varchar(255)', 'default' => '', 'after' => 'notification_enabled']);
|
|
db_install_add_column('automation_networks', ['name' => 'notification_fromname', 'type' => 'varchar(32)', 'default' => '', 'after' => 'notification_email']);
|
|
db_install_add_column('automation_networks', ['name' => 'notification_fromemail', 'type' => 'varchar(128)', 'default' => '', 'after' => 'notification_fromname']);
|
|
|
|
if (db_table_exists('dsdebug')) {
|
|
db_install_rename_table('dsdebug','data_debug');
|
|
}
|
|
|
|
if (!db_table_exists('data_debug')) {
|
|
db_install_execute("CREATE TABLE `data_debug` (
|
|
`id` int(11) unsigned NOT NULL auto_increment,
|
|
`started` int(11) NOT NULL DEFAULT '0',
|
|
`done` int(11) NOT NULL DEFAULT '0',
|
|
`user` int(11) NOT NULL DEFAULT '0',
|
|
`datasource` int(11) NOT NULL DEFAULT '0',
|
|
`info` text NOT NULL,
|
|
`issue` text NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `user` (`user`),
|
|
KEY `done` (`done`),
|
|
KEY `datasource` (`datasource`),
|
|
KEY `started` (`started`))
|
|
ROW_FORMAT=Dynamic
|
|
ENGINE=InnoDB
|
|
COMMENT = 'Datasource Debugger Information';");
|
|
}
|
|
|
|
// Upgrade debug plugin to core access by removing custom realm
|
|
$debug_id_reports = db_install_fetch_cell('SELECT id FROM plugin_config WHERE name = \'Debug\'');
|
|
$debug_id = $debug_id_reports['data'];
|
|
|
|
if ($debug_id !== false && $debug_id > 0) {
|
|
// Plugin realms are plugin_id + 100
|
|
$debug_id += 100;
|
|
db_execute_prepared('DELETE FROM user_auth_realm WHERE realm_id = ?', [$debug_id]);
|
|
db_execute_prepared('DELETE FROM user_auth_group_realm WHERE realm_id = ?', [$debug_id]);
|
|
}
|
|
|
|
// Fix data source stats column type
|
|
$value_parms = db_get_column_attributes('data_source_stats_hourly_last', 'value');
|
|
|
|
if (cacti_sizeof($value_parms)) {
|
|
if ($value_parms[0]['COLUMN_TYPE'] != 'double') {
|
|
db_install_execute('ALTER TABLE data_source_stats_hourly_last MODIFY COLUMN `value` DOUBLE DEFAULT NULL');
|
|
}
|
|
}
|
|
|
|
// Resolve issues with bogus templates issue #1761
|
|
$snmp_queries_results = db_install_fetch_assoc('SELECT id, name
|
|
FROM snmp_query
|
|
ORDER BY id');
|
|
$snmp_queries = $snmp_queries_results['data'];
|
|
|
|
if (cacti_sizeof($snmp_queries)) {
|
|
foreach ($snmp_queries as $query) {
|
|
db_execute_prepared("UPDATE graph_local AS gl
|
|
INNER JOIN (
|
|
SELECT graph_template_id
|
|
FROM graph_local AS gl
|
|
WHERE snmp_query_id = ?
|
|
HAVING graph_template_id NOT IN (
|
|
SELECT graph_template_id
|
|
FROM snmp_query_graph
|
|
WHERE snmp_query_id = ?)
|
|
) AS rs
|
|
ON gl.graph_template_id=rs.graph_template_id
|
|
SET snmp_query_id=0, snmp_query_graph_id=0, snmp_index=''",
|
|
[$query['id'], $query['id']]);
|
|
}
|
|
}
|
|
|
|
$ids_results = db_install_fetch_assoc('SELECT *
|
|
FROM graph_local
|
|
WHERE snmp_query_id > 0
|
|
AND snmp_query_graph_id = 0');
|
|
$ids = $ids_results['data'];
|
|
|
|
if (cacti_sizeof($ids)) {
|
|
foreach ($ids as $id) {
|
|
$query_graph_id_results = db_install_fetch_cell('SELECT id
|
|
FROM snmp_query_graph
|
|
WHERE snmp_query_id = ?
|
|
AND graph_template_id = ?',
|
|
[$id['snmp_query_id'], $id['graph_template_id']]);
|
|
$query_graph_id = $query_graph_id_results['data'];
|
|
|
|
if (empty($query_graph_id)) {
|
|
db_execute_prepared('UPDATE graph_local
|
|
SET snmp_query_id=0, snmp_query_graph_id=0, snmp_index=""
|
|
WHERE id = ?',
|
|
[$id['id']]);
|
|
} else {
|
|
db_execute_prepared('UPDATE graph_local
|
|
SET snmp_query_graph_id=?
|
|
WHERE id = ?',
|
|
[$query_graph_id, $id['id']]);
|
|
}
|
|
}
|
|
}
|
|
|
|
db_install_execute('UPDATE graph_tree_items
|
|
SET host_grouping_type = 1
|
|
WHERE host_id > 0
|
|
AND host_grouping_type = 0');
|
|
|
|
db_install_execute('UPDATE automation_tree_rules
|
|
SET host_grouping_type = 1
|
|
WHERE host_grouping_type = 0');
|
|
|
|
db_install_execute("UPDATE settings
|
|
SET value = IF(value = '1', 'on', '')
|
|
WHERE name = 'hide_console' and value != 'on'");
|
|
|
|
db_install_add_column('sites', ['name' => 'zoom', 'type' => 'tinyint', 'unsigned' => true, 'NULL' => true]);
|
|
|
|
db_install_drop_key('poller_reindex', 'key', 'PRIMARY');
|
|
|
|
db_install_add_key('poller_reindex', 'key', 'PRIMARY', ['host_id', 'data_query_id', 'arg1(187)']);
|
|
|
|
db_install_add_column('poller', ['name' => 'last_sync', 'type' => 'timestamp', 'NULL' => false, 'default' => '0000-00-00 00:00:00']);
|
|
db_install_add_column('poller', ['name' => 'requires_sync', 'type' => 'char(3)', 'NULL' => false, 'default' => '']);
|
|
|
|
db_install_execute('UPDATE poller SET requires_sync = "on" WHERE id != 1');
|
|
|
|
db_install_execute('UPDATE host SET status = 0 WHERE disabled = "on"');
|
|
|
|
db_install_add_column('host', ['name' => 'deleted', 'type' => 'char(2)', 'default' => '', 'NULL' => true, 'after' => 'device_threads']);
|
|
}
|