Plugin Monitor 0.8.1 "Error: Save Failed"

[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.

[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,

[BSOD2600]

If you disable weathermap and/or all plugins, does it work again?

[alexp]

Nope, I have tryed it, already.

[BSOD2600]

Still sounds like a plugin issue, moving.

[Howie]

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.

[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]

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]

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]

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]

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]

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]

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

[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