Announcement

Collapse
No announcement yet.

Importing logs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Importing logs

    Hi, i'm trying to upload my nagios.log tp DB, but i'm getting erros while executing the perl script:

    I run:
    [email protected]:~> /usr/local/oreon/cron/parsing_log.pl -a

    Output:
    /var/log/nagios/archives/nagios-03-12-2007-00.log
    Use of uninitialized value in substitution (s///) at /usr/local/oreon/cron/parsing_log.pl line 78, <FILE> line 1395.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1395.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1395.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1395.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1395.
    Use of uninitialized value in substitution (s///) at /usr/local/oreon/cron/parsing_log.pl line 78, <FILE> line 1845.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1845.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1845.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1845.
    Use of uninitialized value in concatenation (.) or string at /usr/local/oreon/cron/parsing_log.pl line 79, <FILE> line 1845.

  • #2
    Line 1395:
    [1173585887] SERVICE ALERT: asusis-ivr1;Unidad c:\;CRITICAL;HARD;1;Connection refused or timed out


    Line 1845:
    [1173586296] SERVICE ALERT: asusis-ivr1;Unidad c:\;OK;HARD;1;Drive C:\ [] - Total: 33.91 GB - Free: 15.99 GB (47%) - Used: 17.91 GB (53%)

    Comment


    • #3
      Ok, now appears this one, i'm not sure about the difference between the scripts:

      asusis-ope2:/usr/local/oreon/log # tail -f ArchiveLogInDB_log

      Warning: Missing argument 5 for insert_in_db() in /usr/local/oreon/cron/reporting/ArchiveLogInDB.php on line 144

      Warning: Missing argument 5 for insert_in_db() in /usr/local/oreon/cron/reporting/ArchiveLogInDB.php on line 144

      Warning: Missing argument 5 for insert_in_db() in /usr/local/oreon/cron/reporting/ArchiveLogInDB.php on line 144

      Warning: Missing argument 5 for insert_in_db() in /usr/local/oreon/cron/reporting/ArchiveLogInDB.php on line 144

      Warning: Missing argument 5 for insert_in_db() in /usr/local/oreon/cron/reporting/ArchiveLogInDB.php on line 144

      asusis-ope2:/usr/local/oreon/log # wc -l ArchiveLogInDB_log
      435 ArchiveLogInDB_log

      Comment


      • #4
        sorry for bugs....

        http://bugs.oreon-project.org/?do=details&id=334
        Julien Mathis
        Centreon Project Leader
        www.merethis.com |

        Comment


        • #5
          I applied the patch, now i get:

          [email protected]:~> /usr/local/oreon/cron/parsing_log.pl -a
          /var/log/nagios/archives/nagios-03-13-2007-00.log
          DBD::mysql:t execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on host \'asusis-dwhd\' timed out after 5 seconds')' at line 1 at /usr/local/oreon/cron/parsing_log.pl line 103, <FILE> line 2267.
          DBD::mysql:t execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on host \'asusis-dwhd\' timed out after 5 seconds')' at line 1 at /usr/local/oreon/cron/parsing_log.pl line 103, <FILE> line 2267.

          [email protected]:~> grep -n .\* /var/log/nagios/archives/nagios-03-13-2007-00.log|grep '^2267'
          2267:[1173679256] Warning: Service performance data command '/usr/bin/printf "%b" "1173679250\tasusis-dwhd\tUnidad d:\\tDrive D:\ [] - Total: 193,3 GB - Free: 46,8 GB (24%) - Used: 146,51 GB (76%)\tOK\tD:\=150022MB;182105,72;188043,95;0;1979 41\n" | /usr/sbin/perfparse-log2mysql' for service 'Unidad d:\' on host 'asusis-dwhd' timed out after 5 seconds

          Comment

          Working...
          X