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
|
<?
/* Database Cleanup. This file is part of JFFNMS
* Copyright (C) <2003> Kovacs Andrei <kandrei@comtrust.ro>
* Copyright (C) <2003> Javier Szyszlican <javier@jffnms.org> (Modifications)
* This program is licensed under the GNU GPL, full terms in the LICENSE file
*/
$jffnms_functions_include = "engine";
include_once("../conf/config.php");
detach();
$raw_days = get_config_option("raw_events_store");
if ($raw_days > 0) {
$period=time()-(60*60*24*$raw_days);
$dtdelete=date("Y-m-d 00:00:00",$period);
logger ("Cleaning up raw messages older than $dtdelete ($raw_days days)...\n");
// Traps cleanup
$query_traps = "select id from traps where date <= ".$period;
$result_traps = db_query ($query_traps) or die ("Query failed - TC1 - ".db_error());
$result_del_varbinds = 0;
while ($rows_traps = db_fetch_array($result_traps)) {
$id = $rows_traps['id'];
$query="delete from traps_varbinds where trapid = ".$id;
$result_del_varbinds = db_query ($query) or die ("Query failed: TC2 - Delete varbinds - ".db_error());
}
$query = "delete from traps where date <= ".$period;
$result_del_traps = db_query ($query) or die ("Query failed: TC3 - Delete traps - ".db_error());
logger ("Cleanup of traps/traps_varbinds tables finished... ($result_del_traps, $result_del_varbinds)\n");
// END Traps cleanup
// Acct cleanup
$query = "delete from acct where date <= '$dtdelete'";
$result_del_acct = db_query ($query) or die ("Query failed: AC1 - Delete acct - ".db_error());
logger ("Cleanup of acct table finished... ($result_del_acct)\n");
// END Acct cleanup
// Syslog cleanup
$query = "delete from syslog where date <= '$dtdelete'";
$result_del_syslog = db_query ($query) or die ("Query failed: SC1 - Delete syslog - ".db_error());
logger ("Cleanup of syslog table finished... ($result_del_syslog)\n");
// END Syslog cleanup
}
$days = get_config_option("events_store");
if ($days > 0) {
$period=time()-(60*60*24*$days);
$dtdelete=date("Y-m-d 00:00:00",$period);
logger ("Cleaning up Events/Alarms older than $dtdelete ($days days)...\n");
// Alarms cleanup
$query = "delete from alarms where date_stop <= '$dtdelete' and not (date_stop <= '0001-01-01 00:00:00') "; //this will just delete finished alarms which end is older than dtdelete
$result_del_alarms = db_query ($query) or die ("Query failed: AC2 - Delete Alarms - ".db_error());
logger ("Cleanup of alarms table finished... ($result_del_alarms)\n");
// END Alarms cleanup
// Events cleanup
$query = "delete from events where date <= '$dtdelete'";
$result_del_events = db_query ($query) or die ("Query failed: EC1 - Delete Events - ".db_error());
logger ("Cleanup of events table finished... ($result_del_events)\n");
// END Events cleanup
}
//Hosts Config Cleanup
$config_days = get_config_option("host_configs_store");
if ($config_days > 0) {
$period=time()-(60*60*24*$config_days);
$dtdelete=date("Y-m-d 00:00:00",$period);
logger ("Cleaning up Host Configs older than $dtdelete ($config_days days)...\n");
$query = "delete from hosts_config where date <= '$dtdelete' and id > 1";
$result_del_config = db_query ($query) or die ("Query failed: CC1 - Delete hosts_config - ".db_error());
logger ("Cleanup of hosts_config table finished... ($result_del_config)\n");
}
$tables_to_repair = array("events","alarms","traps","syslog","acct","hosts_config");
foreach ($tables_to_repair as $table) {
logger ("Repairing $table table...");
$result = db_repair ($table);
logger ("done, $result\n");
}
db_close();
?>
|
