Details
-
Improvement
-
Resolution: Fixed
-
Minor
-
None
-
None
-
None
-
Observium 5134, Python 2.7.5
Description
Here is a simple purge script that removes entries in the eventlog and syslog tables older than a given interval.
Attachments
Activity
I bet it has to do with
chdir(dirname(__FILE__));
|
Try changing it to
chdir(dirname($argv[0]));
|
What version of PHP are you using?
Solomon,
Weird. I've been running it the whole time without using php in the command line like that. The beginning of the file is exactly like discovery.php. Does discovery.php work?
Nice, an odd thing on my system. When running I have to execute it like
/opt/observium # php db-maintenance.php -r Table "devices_perftimes" has 5,723,433 records using 371.44 Mb
|
Table "eventlog" has 19,797 records using 9.30 Mb
|
Table "perf_times" has 5,659,049 records using 375.44 Mb
|
Table "syslog" has 1,284,730 records using 788.94 Mb
|
If I run it like run all the rest of my php scripts (by successfully allowing env to load php) it fails like so:
/opt/observium # ./db-maintenance.php -r
|
: No such file or directory
|
Uploading a new version.
Original version used
dbFetch("SELECT COUNT(*) FROM...")
|
in show_table_interval_report() when I should have used dbFetchCell().
I'm attaching a PHP script inspired by Mathieu's Python script.
Run the script with no options to see the help output. Should be self-explanatory.
New version with perf_times and devices_perftimes purge support.
Something like this would be great to see incorporated. I've been using my own script, not as elegant as this to keep my syslog trimmed.
Yes, discovery.php, poller and all of my own scripts work. I've verified ownership permissions and selinux is all set the same as discovery.php as well. I'm stumped, I've even gone over the file for syntax errors and while I've replaced a few possible things, nothing has helped.