Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-757

Purge script for the eventlog and syslog tables

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • None
    • None
    • Poller
    • 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

        1. db-maintenance.php
          6 kB
        2. db-maintenance.php
          6 kB
        3. purge.py
          5 kB

        Activity

          [OBS-757] Purge script for the eventlog and syslog tables
          landy Mike Stupalov added a comment -

          Use housekeeping script.
          Added in r5653.

          landy Mike Stupalov added a comment - Use housekeeping script. Added in r5653.
          moorereason Cameron Moore added a comment -

          Tom,
          It looks like you can close this issue now that the housekeeping script was adding in r5653.

          moorereason Cameron Moore added a comment - Tom, It looks like you can close this issue now that the housekeeping script was adding in r5653.
          moorereason Cameron Moore added a comment -

          Solomon,
          Did you ever figure out why this script was failing for you? If not, your next step is probably to setup Xdebug and VIM to step through the script from the command line to see where it's flaming out.

          moorereason Cameron Moore added a comment - Solomon, Did you ever figure out why this script was failing for you? If not, your next step is probably to setup Xdebug and VIM to step through the script from the command line to see where it's flaming out.
          moorereason Cameron Moore added a comment -

          Can you run it without arguments?

          sh# ./db-maintenance.php

          I'm stumped, too. Can you jump on IRC to troubleshoot? My nick is moorereason. I'm on PHP 5.3.

          moorereason Cameron Moore added a comment - Can you run it without arguments? sh# ./db-maintenance.php I'm stumped, too. Can you jump on IRC to troubleshoot? My nick is moorereason. I'm on PHP 5.3.
          slm4996 Solomon Seal added a comment -

          Nope, I switched that out as the newer versions of discovery use 

          chdir(dirname($argv[0]));

          . I have PHP 5.4.4-14

          slm4996 Solomon Seal added a comment - Nope, I switched that out as the newer versions of discovery use chdir(dirname($argv[0])); . I have PHP 5.4.4-14
          slm4996 Solomon Seal added a comment -

          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.

          slm4996 Solomon Seal added a comment - 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.
          moorereason Cameron Moore added a comment -

          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?

          moorereason Cameron Moore added a comment - 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?
          moorereason Cameron Moore added a comment -

          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?

          moorereason Cameron Moore added a comment - 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?

          People

            sid3windr Tom Laermans
            kedare Mathieu Poussin (K3dare)
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: