Announcement

Collapse
No announcement yet.

Problem with Perfparse Database connection : DB Error:

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with Perfparse Database connection : DB Error:

    does anyone know where the sql scripts are for generating this dabase?
    vision is the art of see'ing the invisable

  • #2
    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]
    Romain Le Merlus
    Centreon Forge
    MERETHIS

    Comment


    • #3
      merci.

      then after that it will just work correct? or is there any additional steps I have to take?
      vision is the art of see'ing the invisable

      Comment


      • #4
        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
        Romain Le Merlus
        Centreon Forge
        MERETHIS

        Comment


        • #5
          # 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
          vision is the art of see'ing the invisable

          Comment

          Working...
          X