Plugin Monitor 0.8.1 "Error: Save Failed"

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
alexp
Posts: 6
Joined: Mon Dec 17, 2007 4:38 pm
Location: USA

Plugin Monitor 0.8.1 "Error: Save Failed"

Post by alexp »

Fresh installation of cacti on W2K3R2 SP2 (VM).
cacti-0.8.7a
mysql-5.0.45-win32
php-5.2.5-Win32
rrdtool-1.2.26-bin-w32
net-snmp-5.4.1-3.win32
I was able to add new devices to Cacti until the install of weathermap plug-in. The list of plug-ins from global.php:
$plugins = array();
$plugins[] = 'settings';
$plugins[] = 'thold';
$plugins[] = 'monitor';
$plugins[] = 'weathermap';
I can do everything else, but add new device.
All ntfs permissions are according to the http://home.comcast.net/~bsod2600/install_windows.html
Console -> Utilities -> View Cacti Log File doesn't have any particular errors about this.
Any help appreciated.
Attachments
This is the error I am getting.
This is the error I am getting.
PluginMonitorError.PNG (84.38 KiB) Viewed 13784 times
This is the Settings/Misc page.
This is the Settings/Misc page.
SettingsMisc.PNG (81.49 KiB) Viewed 13784 times
Last edited by alexp on Wed Dec 19, 2007 6:12 pm, edited 1 time in total.
alexp
Posts: 6
Joined: Mon Dec 17, 2007 4:38 pm
Location: USA

Post by alexp »

Forgot to mention:
IIS 6.0.
The Debug errors:
12/17/2007 04:12:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor'
12/17/2007 04:12:00 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor'
12/17/2007 03:33:38 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor'

Hope it will help.
Thanks,
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

If you disable weathermap and/or all plugins, does it work again?
alexp
Posts: 6
Joined: Mon Dec 17, 2007 4:38 pm
Location: USA

Post by alexp »

Nope, I have tryed it, already.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Still sounds like a plugin issue, moving.
User avatar
Howie
Cacti Guru User
Posts: 5508
Joined: Thu Sep 16, 2004 5:53 am
Location: United Kingdom
Contact:

Post by Howie »

alexp wrote:Forgot to mention:
IIS 6.0.
The Debug errors:
12/17/2007 04:12:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor'
12/17/2007 04:12:00 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor'
12/17/2007 03:33:38 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor'

Hope it will help.
Thanks,
Does the cacti mysql user have permission to modify the database? That looks like monitor is trying to add a new field to the host table and failing.

Weathermap will try and do the same kind of thing to add it's own tables to store map info in too, as would thold.

If the use does have permission for CREATE and ALTER on the cacti db, then try logging onto the mysql command-line tool as that user and pasting in that SQL (ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor) and see what mysql says.
Weathermap 0.98a is out! & QuickTree 1.0. Superlinks is over there now (and built-in to Cacti 1.x).
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)
alexp
Posts: 6
Joined: Mon Dec 17, 2007 4:38 pm
Location: USA

Post by alexp »

I have tryed to disable all plug-ins (not the Weathermap, only) and after restarting host server, was able to add new device.
Now, I am enabling plug-ins one-by-one.
I think the last post have so much sence to me. I'll try to do my best to follow your advice, but I am the fresh meat in mySQL.
alexp
Posts: 6
Joined: Mon Dec 17, 2007 4:38 pm
Location: USA

Post by alexp »

Ok, I have follwed the advice and looks like mySQL error is gone.
The C:\Inetpub\wwwroot\cacti\plugins\monitor\monitor.sql is now:

ALTER TABLE host ADD monitor char(3) default 'on' not null AFTER disabled;
ALTER TABLE host ADD monitor_text text null AFTER monitor;
REPLACE INTO `user_auth_realm` VALUES (32, 1);

But I am still getting error after I am adding a new device. As soon as I hit "Create":
Error: Save Failed.
When I disable "monitor" plug-in in C:\Inetpub\wwwroot\cacti\include\global.php
I am able to save new device, again.
Could it be the "monitor" plugin configuration?


[/img]
kelbyc
Cacti User
Posts: 52
Joined: Mon Nov 28, 2005 8:50 am

Post by kelbyc »

I had the same error. To fix it, manually run the SQL statements from the monitor.sql file against your Cacti DB. After I ran them to setup the db for Monitor I could add devices without the error.
alexp
Posts: 6
Joined: Mon Dec 17, 2007 4:38 pm
Location: USA

Post by alexp »

No Go!
I have tryed everything I know. Including the "manually run the SQL statements from the monitor.sql file against your Cacti DB".
After trying to save or create new device getting the same: "Error: Save Failed."
Will appreciate any suggestions.
rsalomon
Posts: 6
Joined: Fri Oct 19, 2007 3:03 pm

Error: Save Failed Device

Post by rsalomon »

I had the same issue after upgrading to 0.8.7e. I had to disable the wmi plugin and that fixed my problem.

# vi /var/www/html/include/global.php

//$plugins[] = 'wmi';


Ron
apereira
Posts: 22
Joined: Mon Sep 29, 2008 9:58 am

I have the same problem

Post by apereira »

I have this same problem, and when I disable WMI it works fine for me, but I need to use WMI on my network, I have many win32 servers to monitor using WMI.

Any solution to resolve this problem with WMI???

I m on 0.8.7e version.
Pilly
Posts: 29
Joined: Thu Dec 18, 2008 6:26 am

Post by Pilly »

Ive also got this error.

Version 0.8.7g

ReportIt 0.7.1
Monitor 0.8.2
Settings 0.6
Rrdclean 0.38
Thold 0.4.2 (installed not enabled)
Update 0.4
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Blob fields can not have a blank as a default. This might be an old version of monitor.

TheWitness

Http://docs.cacti.net has all the latest
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests