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