Re: [Perfparse-users] Problems with MySQL and documentations

[Jessica H. <Je...@gm...>]

> Hi,
> 
> Another problem is that no data is storaged into the database. The
> tables are all there, because I've seen them with show tables and
> describe <name>
> 
> The database:
> 
> ./mysql  (as root)
> dann
> mysql> create database perfparse;
> mysql> quit
> 
> now in my perfparse directory:
> 
> cat mysql_create.sql | mysql -u root -p -D perfparse
> 
> This only works as root (i don't know why)
> 
> now ./mysql again and a look to the database:
> 
> mysql> use perfparse;
> Database changed
> mysql> show tables;
> +---------------------------------+
> | Tables_in_perfparse |
> +---------------------------------+
> | perfdata_bin_summary |
> | perfdata_bin_summary_data |
> | perfdata_bin_summary_del_policy |
> | perfdata_bin_summary_header |
> | perfdata_delete_policy |
> | perfdata_graphs |
> | perfdata_host |
> | perfdata_host_group |
> | perfdata_prefs |
> | perfdata_raw_summary |
> | perfdata_raw_summary_data |
> | perfdata_registry |
> | perfdata_service |
> | perfdata_service_bin |
> | perfdata_service_metric |
> | perfdata_service_raw |
> | perfdata_state |
> | perfdata_users |
> +---------------------------------+
> 18 rows in set (0.00 sec)
> 
> mysql>
> describe
>
perfdata_service;
>
+------------------------+--------------------------------+------+-----+----------+-------+
> | Field | Type | Null | Key | Default |
> Extra
>
|
>
+------------------------+--------------------------------+------+-----+----------+-------+
> | service_id | int(11) | | UNI | 0 | |
> | host_name | varchar(75) | | PRI | | |
> | service_description | varchar(75) | | PRI | | |
> | last_perfdata_raw | int(11) | YES | MUL | NULL | |
> | raw_delete_policy | int(11) | YES | | NULL | |
> | raw_delete_policy_name | varchar(20) | YES | MUL | NULL | |
> | raw_delete_policy_type | enum('template','user','host') | | | template |
> |
> | is_deleted | tinyint(4) | YES | | 0
> |
>
|
>
+------------------------+--------------------------------+------+-----+----------+-------+
> 8 rows in set (0.00 sec)
> 
> mysql> select host_name
> -> from perfdata_service;
> Empty set (0.00 sec) 
> 
> 
> This is empty... I've worked after this documentation:
> 
> http://wiki.perfparse.org/tiki-index.php?page=BuildingMethod4Example
> 
> 
> 
> In the perfdata-service log, are always the newest datas and it is
> updated regularly.
> 
> 
> Then create a Nagios command to run perfparse-log2mysql every time a
> log is
> generated.
> 
> Is this the command???
> 
> # vi perfparse_nagios_pipe_command.pl
> add at the end...
> system ('/opt/nagios/bin/perfparse-log2mysql --serviceperf-log
> /opt/nagios/var/perfdata-service.log');
> 
> I do this this like in this documentation:
> http://wiki.perfparse.org/tiki-index.php?page=BuildingMethod4Example
> 
> But in the original documentation are more things described like:
> 
> 5.2. Periodic Nagios Log Parse
> 
> 
> Then add the following four lines to the 'HOST AND SERVICE
> PERFORMANCE DATA PROCESSING COMMANDS' section:
> 
> 
> xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
> xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT
> $\t$PERFDATA$
> 
> xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
> xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC
> $\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$                                   
>  
>             
>                                                    
>                                                                     
>        Should I write this down? or not?                            
>                                                                     
> 
> 
> 5.3. Nagios Invokes Perfparse
> 
> 
> Edit misccommands.cfg and add the following :
> 
> 
> define command{
>         command_name    process-service-perfdata
>         command_line    /usr/bin/printf "%b" "$TIMET$\t$HOSTNAME
> $\t$SERVICEDESC$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$\n" |
> $USER2$/bin/perfparse-log2mysql -c $USER2$/etc/perfparse.cfg
>         }
> 
>                                                                     
>       $USER2$ is defined in resources.cfg and points to the         
>       Perfparse installation directory.                             
>                                                                     
> 
> 
> 
>                                                                     
>         In perfparse.cfg, Service_Log must be defined as "-".       
>                                                                    
> 
> 
> 5.4. Periodic User Log Parse
> 
> 
> Edit misccommands.cfg and add the following :
> 
> 
> define command{
>         command_name    process-service-perfdata
>         command_line    $USER2$/bin/perfparse_nagios_command.pl
> $USER2$/var/perfdata-service.log "$TIMET$" "$HOSTNAME$"
> "$SERVICEDESC$" "$OUTPUT$" "$SERVICESTATE$" "$PERFDATA$"
>         }
> 
>                                                                     
>       $USER2$ is defined in resources.cfg and points to the         
>       Perfparse installation directory.                             
>                                                                     
> 
> 
> 
> What's up with this??? Can I write down two of the same misccommands
> in one cfg? I think not! I think I can use a command_name only once
> a time, or I'm wrong?
> 
> 
> 
> Edit a script like this :
> 
> 
> #!/bin/sh
> $USER2=/perfparse/installation/directory
> 
> mv ${USER2}/var/perfdata-service.log
> ${USER2}/var/perfdata-service.log1
> cat ${USER2}/var/perfdata-service.log1 |
> ${USER2}/bin/perfparse-log2mysql -c ${USER2}/etc/perfparse.cfg
> rm ${USER2}/var/perfdata-service.log1
> 
>                                                                     
>         In perfparse.cfg, Service_Log must be defined as "-".       
>                                                                     
> 
> And what is this? Where should I let this script, How should I name
> this? Must I write down something in a config file?
> 
> 
> Sorry for my questions which looks like I'm a dummbass but I know
> not so mus about this. I'm learning all these things but I don't
> know what I should do now.
> Wenn I look at googel for my problems I don't find many things. For
> nagios I've found a very good german forum but I've found no english
> or german perfparse forum. :-(
> 



And this mesage is reporting by nagios:
Perfparse-log2* [options]

  -e, --error-log <string>           : Perfparse log
  --drop-file <string>               : File for dropped lines
  -l, --serviceperf-log <string>     : Input log source (from nagios or
perfparsed)
  --history_start_tm <integer>       : Start timestamp for history
retreiving
  --history_end_tm <integer>         : End timestamp for history retreiving
  -s, --status-bar                   : Show status bar
  -r, --report                       : Print a report
  --no-raw-data                      : Don't store raw data
  --no-bin-data                      : Don't store bin data
  --storage_modules_dir <string>     : Path where storage modules are
  --storage_modules_load <string>    : Modules to load (CSV)
  --show_config                      : Show config
Missing value for option --serviceperf-log



/usr/local/nagios/var/perfdata-service.log: line 1: 1108546252: command not
found


I don't know what it mean...

-- 
DSL Komplett von GMX +++ Supergünstig und stressfrei einsteigen!
AKTION "Kein Einrichtungspreis" nutzen: http://www.gmx.net/de/go/dsl