does anyone know where the sql scripts are for generating this dabase?
Announcement
Collapse
No announcement yet.
Problem with Perfparse Database connection : DB Error:
Collapse
X
-
Hello
Code:# tar -xzf perfparse-0.105.6.tar.gz # cd perfparse-0.105.6 # ./configure # make # make install # mysql -u root -p [mysql-password] > create database perfparse; > quit # cd scripts # cat mysql_create.sql | mysql -u root -p perfparse [mysql-password]
-
Be careful to warning msg in ./configure, perfparse doesn't quit on it and you might have problem after..
Go in the /perfparse/bin directory and see if there is plugin wich have been created after 'make install'.
Then,
1 - Enable performance data treatment
2 - Choose the correct method to extract performance data
http://perfparse.sourceforge.net/doc...ng%20Perfparse
Comment
-
# ls -l /opt/apps/nagios/current/var/*.dat
-rw-rw-r-- 1 nagios httpd 814 Jan 8 15:08 /opt/apps/nagios/current/var/host-perfdata.dat
-rw-rw-r-- 1 nagios httpd 549569 Jan 8 14:21 /opt/apps/nagios/current/var/retention.dat
-rw-rw-r-- 1 nagios httpd 5746 Jan 8 15:08 /opt/apps/nagios/current/var/service-perfdata.dat
# cat /opt/apps/nagios/current/etc/perfparse.cfg
################################################## #################
# #
# GENERATED BY OREON #
# #
# Developped by : #
# - Julien Mathis #
# - Romain Le Merlus #
# #
# www.oreon-project.org #
# For information : [email protected] #
################################################## #################
################################################## #################
# #
# Last modification January 8, 2007, 2:57 pm #
# By Oreon_Support #
# #
################################################## #################
Server_Port = "1976"
Service_Log = "/opt/apps/nagios/current/var/serviceperf.log"
Service_Log_Position_Mark_Path = "/opt/apps/nagios/current/var"
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 = "/opt/apps/nagios/current/var/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 = "/opt/apps/nagios/current/var/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"
nagios.cfg
process_performance_data=1
host_perfdata_file=/opt/apps/nagios/current/var/host-perfdata.dat
service_perfdata_file=/opt/apps/nagios/current/var/service-perfdata.dat
host_perfdata_file_template=$TIMET$ $HOSTNAME$ $HOSTCHECKCOMMAND$ $HOSTOUTPUT$ $HOSTSTATE$ $HOSTPERFDATA$
service_perfdata_file_template=$TIMET$ $HOSTNAME$ $SERVICEDESC$ $SERVICEOUTPUT$ $SERVICESTATE$ $SERVICEPERFDATA$
host_perfdata_file_mode=2
service_perfdata_file_mode=a
host_perfdata_file_processing_interval=60
service_perfdata_file_processing_interval=60
host_perfdata_file_processing_command=process-host-perfdata-file
service_perfdata_file_processing_command=process-service-perfdata-file
# cat host-perfdata.out | ../bin/perfparse-log2mysql -c ../etc/perfparse.cfg
+-----------------------------+ +-----------------------------+
| Generic statistics | | Nb Log Lines : 1 |
| Nb lines parsed : 23 | | Nb lines dropped : 23 |
| Start date : 2007-01-08 | | Elapsed time : 00:00:00 |
| Start time : 15:10:59 | | 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 |
+-----------------------------+ +-----------------------------+
all lines aero even though the dat file has data
[[email protected] /opt/apps/nagios/current/var]
# ls -l host-perfdata.dat
-rw-rw-r-- 1 nagios httpd 352 Jan 8 15:10 host-perfdata.dat
any help to get the data in the datbase would be great. thxvision is the art of see'ing the invisable
Comment
Comment