Problem with Perfparse Database connection : DB Error:

[djekels]

does anyone know where the sql scripts are for generating this dabase?

[rom]

Hello

#  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]

[djekels]

merci.

then after that it will just work correct? or is there any additional steps I have to take?

[rom]

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

[djekels]

# 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. thx