Importing logs

[cyruspy]

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

I run:
nagios@asusis-ope2:~> /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.

[cyruspy]

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%)

[cyruspy]

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

[julio]

sorry for bugs....

http://bugs.oreon-project.org/?do=details&id=334

[cyruspy]

I applied the patch, now i get:

nagios@asusis-ope2:~> /usr/local/oreon/cron/parsing_log.pl -a
/var/log/nagios/archives/nagios-03-13-2007-00.log
DBD::mysql::st 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::st 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.

nagios@asusis-ope2:~> 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