| Nb lines parsed : 25 | | Nb lines dropped :

[djekels]

I am not sure what I have done wrong but for some reason no performance data is going into perfparse database.

I followed the instructions as illustrated on http://perfparse.sourceforge.net/docs.php nad on http://www.oreon-project.org/install...perfparse.html



# cat service-perfdata.dat | ../bin/perfparse-log2mysql -c ../etc/perfparse.cfg -r
00:00:00 read 25 @ 0.0 l/sec. Met 0 @ 0.00 Met/l. Drop 25.
+-----------------------------+ +-----------------------------+
| Generic statistics | | Nb Log Lines : 1 |
| Nb lines parsed : 25 | | Nb lines dropped : 25 |
| Start date : 2007-01-05 | | Elapsed time : 00:00:00 |
| Start time : 17:01:32 | | Rate : (line/sec) 0.00 |
+-----------------------------+ +-----------------------------+

+-----------------------------+ +-----------------------------+
| MySQL storage statistics | | |
| New Hosts : 0 | | Metric/line : 0.00 |
| New Metrics : 0 | | Metrics Recorded : 0 |
| New Services : 0 | | Summary Rec Added : 0 |
| New Summary Group : 0 | | SQL Queries : 19 |
+-----------------------------+ +-----------------------------+
[[email protected] /opt/apps/nagios/current/var]

here is my perfparse.cfg

# cat ../etc/perfparse.cfg
################################################## #################
# #
# GENERATED BY OREON #
# #
# Developped by : #
# - Julien Mathis #
# - Romain Le Merlus #
# #
# www.oreon-project.org #
# For information : [email protected] #
################################################## #################

################################################## #################
# #
# Last modification January 5, 2007, 4:53 pm #
# By Oreon_Support #
# #
################################################## #################

Server_Port = "1976"
Service_Log = "-"
Service_Log_Position_Mark_Path = "/opt/apps/nagios/current/var/serviceperf.log"
Error_Log = "/opt/apps/nagios/current/var/perfparse.log"
Error_Log_Rotate = "Yes"
Error_Log_Keep_N_Days = "7"
Drop_File = "/tmp/perfparse.drop"
Drop_File_Rotate = "Yes"
Drop_File_Keep_N_Days = "7"
Lock_File = "/var/lock/perfparse.lock"
Show_Status_Bar = "Yes"
Do_Report = "Yes"
Default_user_permissions_Policy = "rw"
Default_user_permissions_Host_groups = "rw"
Default_user_permissions_Summary = "rw"
Output_Log_File = "Yes"
Output_Log_Filename = "/var/log/perfparse_output_log"
Output_Log_Rotate = "Yes"
Output_Log_Keep_N_Days = "7"
Use_Storage_Socket_Output = "No"
Storage_Socket_Output_Host_Name = "localhost"
Storage_Socket_Output_Port = "1974"
Use_Storage_Mysql = "Yes"
No_Raw_Data = "No"
No_Bin_Data = "No"
DB_User = "root"
DB_Pass = ""
DB_Name = "perfparse"
DB_Host = "localhost"
Dummy_Hostname = "dummy"
Storage_Modules_Load = "mysql"


But I still get zero results posting to the datbase. -- please help.
Thank you,
ops: Donny ops:

[-Archi-]

Well, maybe you should take a look at your service-perfdata.dat (or file template) to ensure that the delimiter character between performance data is tabulation (\t) and not space. With spaces, the format of datafile is not recognized by perfparse in parsing operation.

[djekels]

I have tabs in the file

actuall the \t dissappear in the file once you generate and push the files to nagios.

however in vi it shows up as a tab...

still no luck.