1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
#!/usr/bin/env php
<?php
/*
+-------------------------------------------------------------------------+
| Copyright (C) 2004-2024 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/ |
+-------------------------------------------------------------------------+
*/
require(__DIR__ . '/../site/include/cli_check.php');
require_once($config['base_path'] . '/lib/poller.php');
require_once($config['base_path'] . '/lib/utility.php');
require_once($config['base_path'] . '/lib/template.php');
/* switch to main database for cli's */
if ($config['poller_id'] > 1) {
db_switch_remote_to_main();
}
/* process calling arguments */
$parms = $_SERVER['argv'];
array_shift($parms);
$execute = false;
if (cacti_sizeof($parms)) {
foreach($parms as $parameter) {
if (strpos($parameter, '=')) {
list($arg, $value) = explode('=', $parameter, 2);
} else {
$arg = $parameter;
$value = '';
}
switch ($arg) {
case '--execute':
$execute = true;
break;
case '--version':
case '-V':
case '-v':
display_version();
exit(0);
case '--help':
case '-H':
case '-h':
display_help();
exit(0);
default:
print 'ERROR: Invalid Parameter ' . $parameter . "\n\n";
display_help();
exit(1);
}
}
}
if ($execute) {
print "NOTE: Repairing All Duplicated Templates\n";
} else {
print "NOTE: Performing Check of Templates\n";
}
/* repair data templates first */
if ($execute) {
print "NOTE: Repairing Data Templates\n";
} else {
print "NOTE: Performing Check of Data Templates\n";
}
$damaged_template_ids = db_fetch_assoc("SELECT DISTINCT data_template_id FROM data_template_rrd WHERE hash='' AND local_data_id=0");
if (cacti_sizeof($damaged_template_ids)) {
foreach($damaged_template_ids as $id) {
$template_name = db_fetch_cell('SELECT name FROM data_template WHERE id=' . $id['data_template_id']);
print "NOTE: Data Template '$template_name' is Damaged and can be repaired\n";
}
$damaged_templates = db_fetch_assoc("SELECT * FROM data_template_rrd WHERE hash='' AND local_data_id=0");
if (cacti_sizeof($damaged_templates)) {
print "NOTE: -- Damaged Data Templates Objects Found is '" . cacti_sizeof($damaged_templates) . "'\n";
if ($execute) {
foreach($damaged_templates as $template) {
$hash = get_hash_data_template($template['local_data_template_rrd_id'], 'data_template_item');
db_execute("UPDATE data_template_rrd SET hash='$hash' WHERE id=" . $template['id']);
}
}
}
} else {
print "NOTE: No Damaged Data Templates Found\n";
}
/* reset the array */
$damaged_templates = array();
/* repair graph templates */
if ($execute) {
print "NOTE: Repairing Graph Templates\n";
} else {
print "NOTE: Performing Check of Graph Templates\n";
}
$damaged_template_ids = db_fetch_assoc("SELECT DISTINCT graph_template_id FROM graph_template_input WHERE hash=''");
if (cacti_sizeof($damaged_template_ids)) {
foreach($damaged_template_ids as $id) {
$template_name = db_fetch_cell('SELECT name FROM graph_templates WHERE id=' . $id['graph_template_id']);
print "NOTE: Graph Template '$template_name' is Damaged and can be repaired\n";
}
$damaged_templates = db_fetch_assoc("SELECT * FROM graph_template_input WHERE hash=''");
if (cacti_sizeof($damaged_templates)) {
print "NOTE: -- Damaged Graph Templates Objects Found is '" . cacti_sizeof($damaged_templates) . "'\n";
if ($execute) {
foreach($damaged_templates as $template) {
$hash = get_hash_graph_template(0, 'graph_template_input');
db_execute("UPDATE graph_template_input SET hash='$hash' WHERE id=" . $template['id']);
}
}
}
} else {
print "NOTE: No Damaged Graph Templates Found\n";
}
/* display_version - displays version information */
function display_version() {
$version = get_cacti_cli_version();
print "Cacti Database Template Repair Utility, Version $version, " . COPYRIGHT_YEARS . "\n";
}
/* display_help - displays the usage of the function */
function display_help () {
display_version();
print "\nusage: repair_templates.php [--execute]\n\n";
print "A utility designed to repair any damaged Cacti Graph and Data Templates. That lacked a hash.\n";
print "This utility should not need to be used in any modern Cacti install.\n\n";
print "Optional:\n";
print " --execute - Perform the repair. Otherwise check for errors.\n";
}
|
