perfparse-users

[Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

When I run --update for databases I get (see below) -- any ideas?

[root@new-host-6 bin]# ./perfparse-db-tool  --update
Auto-convert database up to version 0.19...

Starting...

Warning, this stage may take some time:
An error occured with the SQL:

  "CREATE TABLE IF NOT EXISTS perfdata_bin_summary_data (
metric_id INT NOT NULL, frequency INT NOT NULL, ctime DATETIME NOT NULL,
PRIMARY KEY (metric_id, frequency, ctime),      FOREIGN KEY (metric_id,
frequency)             REFERENCES perfdata_bin_summary_header
(metric_id, frequency)            ON DELETE RESTRICT,     val_count
INTEGER NOT NULL DEFAULT 0,   sum_val DOUBLE NOT NULLsum_square_val
DOUBLE NOT NULL,  max_val DOUBLE NOT NULL,        min_val DOUBLE NOT
NULL,        max_warn DOUBLE NOT NULL,       min_warn DOUBLE NOT NULL,
max_critical DOUBLE NOT NULL,    min_critical DOUBLE NOT
NULL            ) type=InnoDB"

Failure Message:

  "Can't create table './nagios/perfdata_bin_summary_data.frm' (errno:
150)"



Thanks,
Jonnathan

Re: [Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

I finally got to the bottom of these errors and got the databases
"installed" or --updated as the case may be.  Now I can load the CGI and
see the administration page.  The problem is I am getting no data from
Nagios.  I have checked and double checked my settings.  I feel like i
may be missing something obvious....what can I post to help people help
me?  Sorry -- I am new to Nagios as well as Perfparse...

Thanks!

On Fri, 2005-09-23 at 11:47 -0700, Jonnathan Colt wrote:
> When I run --update for databases I get (see below) -- any ideas?
> 
> [root@new-host-6 bin]# ./perfparse-db-tool  --update
> Auto-convert database up to version 0.19...
> 
> Starting...
> 
> Warning, this stage may take some time:
> An error occured with the SQL:
> 
>   "CREATE TABLE IF NOT EXISTS perfdata_bin_summary_data (
> metric_id INT NOT NULL, frequency INT NOT NULL, ctime DATETIME NOT NULL,
> PRIMARY KEY (metric_id, frequency, ctime),      FOREIGN KEY (metric_id,
> frequency)             REFERENCES perfdata_bin_summary_header
> (metric_id, frequency)            ON DELETE RESTRICT,     val_count
> INTEGER NOT NULL DEFAULT 0,   sum_val DOUBLE NOT NULLsum_square_val
> DOUBLE NOT NULL,  max_val DOUBLE NOT NULL,        min_val DOUBLE NOT
> NULL,        max_warn DOUBLE NOT NULL,       min_warn DOUBLE NOT NULL,
> max_critical DOUBLE NOT NULL,    min_critical DOUBLE NOT
> NULL            ) type=InnoDB"
> 
> Failure Message:
> 
>   "Can't create table './nagios/perfdata_bin_summary_data.frm' (errno:
> 150)"
> 
> 
> 
> Thanks,
> Jonnathan
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. 
> Download it for free - -and be entered to win a 42" plasma tv or your very
> own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users

Re: [Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

Thanks to the help from a couple people on this list I have gotten a lot
farther, but still have no data, hosts, or much of anything displaying
in the perfparse cgi.  I noticed when Perfparse is running that it
creates a file perfdata-service.log, and when Perfpase is no longer
running that the file disappears.  The file size always remains at 0.  I
believe this is where the nagios pipe method should be populating this
file with data but for some reason its not.  I have pasted my perfparse
--show_config below to see if I am missing something obvious.  

Thanks for any input and/or suggestions.

Jon

===

[root@new-host-6 bin]# ./perfparsed --show_config

Perfparsed [options]


# File where Perfparse logs messages
# Error_Log = "string"
Error_Log = "/usr/local/nagios/var/perfparse.log"

# Rotate Perfparse log files
# Error_Log_Rotate = "Y/N"
Error_Log_Rotate = "Yes"


# Keep N days of error log. Compress recent logs and remove too old ones
# Error_Log_Keep_N_Days = "value"
Error_Log_Keep_N_Days = "7"


# When perfparse cannot parse a line, it drops it to that file
# Drop_File = "string"
Drop_File = "/usr/local/nagios/var/perfparse.drop"


# Drop_File_Rotate = "Y/N"
Drop_File_Rotate = "no"


# Keep N days of drop file log. Compress recent logs and remove too old
ones
# Drop_File_Keep_N_Days = "value"
Drop_File_Keep_N_Days = "7"


# Port for perfparsed server
# Put 0 or "" to disable the server
# Server_Port = "value"
Server_Port = "1976"


# Log source from nagios (or other tools) that perfparse will scan
# Authorized values: a file name, '-' for stdin, '|' for a fifo and '>'
for a host:port socket
# For sockets, a command 'history' will be sent before retreiving the
data
# Service_Log = "string"
Service_Log = "|/usr/local/nagios/var/perfdata-service.log"


# Save the read position in the nagios log file ? If yes, perfparse will
start from that position instead of from the beginning
# Service_Log_Save_Position = "Y/N"
Service_Log_Save_Position = "yes"

# Path for files containing the read position for nagios log files
# Service_Log_Position_Mark_Path = "string"
Service_Log_Position_Mark_Path = "/usr/local/nagios/var"

# Lock file for perfparsed
# Daemon_Lock = "string"
Daemon_Lock = "/usr/local/nagios/var/perfparsed.lock"


# Run perfparsed as a daemon
# Daemonize = "Y/N"
Daemonize = "no"


# Perform some periodic cleanup every day
# Periodic_Cleanup = "Y/N"
Periodic_Cleanup = "yes"


# Lock file for perfparsed periodic cleanup process
# Periodic_Cleanup_Lock = "string"

Periodic_Cleanup_Lock =
"/usr/local/nagios/var/perfparsed_periodic_cleanup.lock"


# Perform some periodic cleanup every day at HHMM
# Periodic_Cleanup_Hour = "value"

Periodic_Cleanup_Hour = "0230"


# Dummy hostname if gethostname() does not work
# Dummy_Hostname = "string"
Dummy_Hostname = "dummy"


# Don't store raw data
# No_Raw_Data = "Y/N"
No_Raw_Data = "no"


# Don't store bin data
# No_Bin_Data = "Y/N"
No_Bin_Data = "no"


# Path where storage modules are
# Storage_Modules_Dir = "string"
Storage_Modules_Dir = "/usr/local/nagios/lib"

# Modules to load (Coma separated values)
# Storage_Modules_Load = "string"
Storage_Modules_Load = "mysql"

# File to contain Storage Modules Status
# Storage_Modules_Status_File = "string"
Storage_Modules_Status_File =
"/usr/local/nagios/var/storage_modules.status"

# Storage Module : mysql
# ==============================

# Database user
# DB_User = "string"
DB_User = "nagios"


# Database password
# DB_Pass = "string"
DB_Pass = "nagios"


# Database name
# DB_Name = "string"
DB_Name = "nagios"


# Database hostname
# DB_Host = "string"
DB_Host = "localhost.localdomain"

Re: [Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

Garrett,

I am sure I am quite annoying....if I am coming across like that, my
apologizes.  I finally have data coming into Perfparse.  How long did it
take before you were able to see graphs?  For example, I click on, "View
Raw Plugin Data" -- and I can see my services that I am monitoring.
Then if I click "all" -- I can see that <host> was pinged 7 times
sucessfully in the last 30 minutes.  But at the bottom its showing a
broken image.  Should a graph be showing there?  Also if I return to the
main menu and click on "View and Graph Binary Data"  -- I get a list of
<hosts> that have things checked like disk space and such.  But when I
click on the graph icon, I get a blank page.  I started to wonder if it
just takes time for data to populate the database?  

I ended up reverting back to 1.2 from 2.0b4 and followed your config
files in order to get it working late last night.

Thanks again for any input,

Jon

On Tue, 2005-09-27 at 15:58 -0500, Garrett Honeycutt wrote:
> On Tue, 2005-09-27 at 11:35 -0700, Jonnathan Colt wrote:
> > Are you running Nagios 2.0b4?
> > 
> > Jon
> 
> No, I am running the 1.2 branch.
> 
> -g

Re: [Perfparse-users] Fwd: SQL Errors

[Garrett H. <gh...@3g...>]

On Wed, 2005-09-28 at 12:30 -0700, Jonnathan Colt wrote:
> Garrett,
> 
> I am sure I am quite annoying....if I am coming across like that, my
> apologizes.  I finally have data coming into Perfparse.  How long did it
> take before you were able to see graphs?  For example, I click on, "View
> Raw Plugin Data" -- and I can see my services that I am monitoring.
> Then if I click "all" -- I can see that <host> was pinged 7 times
> sucessfully in the last 30 minutes.  But at the bottom its showing a
> broken image.  Should a graph be showing there?  Also if I return to the
> main menu and click on "View and Graph Binary Data"  -- I get a list of
> <hosts> that have things checked like disk space and such.  But when I
> click on the graph icon, I get a blank page.  I started to wonder if it
> just takes time for data to populate the database?  
> 
> I ended up reverting back to 1.2 from 2.0b4 and followed your config
> files in order to get it working late last night.
> 
> Thanks again for any input,
> 
> Jon

You should not see a broken image. You should see an image with little
to no visible data on it since you just started polling. Make sure you
have GD installed. If you are running a RedHat based system make sure
you both the gd and gd-devel packages. But if data is populating then
you are on the right track. Go back to your perfparse source directory
and run ./configure with the same args as last time and pay close
attention to the output and make sure you aren't getting any errors,
especially with GD. 

-g

-- 
// Garrett Honeycutt
// Sr. Systems Administrator
// 3GUpload.com, Inc.
// 317.472.4969 Office

Re: [Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

Good news and bad news.  I am seeing graphed data.  However, its only
from one machine being monitored.  Any ideas why the others wouldnt
work?  Also I have no graphs showing in the RAW Plugin when I choose
"generate report" after picking a service.  It shows a broken image.
Obviously the GD is working because I can see graphs for one host/all
services on that host.  I have no idea at this point what I am doing
wrong.

Thanks for *any* input,

Jon


On Wed, 2005-09-28 at 16:00 -0500, Garrett Honeycutt wrote:
> On Wed, 2005-09-28 at 13:53 -0700, Jonnathan Colt wrote:
> > I will try recompling.  A bit of fooling around has given some more
> > information.  When I goto "Graph Binary Data" and click on a machine
> > that monitors disk space.  Then click on the volume that its monitoring.
> > I do get a graph.  But the graph is empty.  I looked at the raw data and
> > it only has 2 samples of data.  Point of me saying this is that I
> > believe that the GD is working if its able to show this graph...or am I
> > wrong?  Also is it not showing anything on the graph because it only has
> > 2 sample thus far?
> > 
> > Thanks for any input, you have been TONS of help...I will have to send
> > you a Starbucks gift card or something...
> > 
> > Jon
> > 
> > On Wed, 2005-09-28 at 15:36 -0500, Garrett Honeycutt wrote:
> > > did you just now install it or was it installed before you compiled
> > > perfparse? if you just now did it, then you will need to recompile
> > > perfparse.
> > > 
> > > in fact, recompiling perfparse can't hurt :)
> > 
> 
> sounds like everything is working fine.. take a break and come back to
> it tomorrow and check out your graphs :)
> 
> -g

Re: [Perfparse-users] Fwd: SQL Errors

[Garrett H. <gh...@3g...>]

Does the service you are monitoring return performance data?

-g

On Thu, 2005-09-29 at 16:37 -0700, Jonnathan Colt wrote:
> Good news and bad news.  I am seeing graphed data.  However, its only
> from one machine being monitored.  Any ideas why the others wouldnt
> work?  Also I have no graphs showing in the RAW Plugin when I choose
> "generate report" after picking a service.  It shows a broken image.
> Obviously the GD is working because I can see graphs for one host/all
> services on that host.  I have no idea at this point what I am doing
> wrong.
> 
> Thanks for *any* input,
> 
> Jon
> 
> 
> On Wed, 2005-09-28 at 16:00 -0500, Garrett Honeycutt wrote:
> > On Wed, 2005-09-28 at 13:53 -0700, Jonnathan Colt wrote:
> > > I will try recompling.  A bit of fooling around has given some more
> > > information.  When I goto "Graph Binary Data" and click on a machine
> > > that monitors disk space.  Then click on the volume that its monitoring.
> > > I do get a graph.  But the graph is empty.  I looked at the raw data and
> > > it only has 2 samples of data.  Point of me saying this is that I
> > > believe that the GD is working if its able to show this graph...or am I
> > > wrong?  Also is it not showing anything on the graph because it only has
> > > 2 sample thus far?
> > > 
> > > Thanks for any input, you have been TONS of help...I will have to send
> > > you a Starbucks gift card or something...
> > > 
> > > Jon
> > > 
> > > On Wed, 2005-09-28 at 15:36 -0500, Garrett Honeycutt wrote:
> > > > did you just now install it or was it installed before you compiled
> > > > perfparse? if you just now did it, then you will need to recompile
> > > > perfparse.
> > > > 
> > > > in fact, recompiling perfparse can't hurt :)
> > > 
> > 
> > sounds like everything is working fine.. take a break and come back to
> > it tomorrow and check out your graphs :)
> > 
> > -g
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
-- 
// Garrett Honeycutt
// Sr. Systems Administrator
// 3GUpload.com, Inc.
// 317.472.4969 Office