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:
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,


Comment