RE: [Monarch-users] (no subject)

[Poltorak P. <Pau...@ev...>]

On sourceforge.net you can find this Bufix:

Error: monarch_update.pl line 1315.
DBD::mysql::db do failed: Cannot add or update a
child row: a foreign key constraint fails
(`monarch2/profile_host_profile_service`, CONSTRAINT
`profile_host_profile_service_ibfk_1` FOREIGN KEY
(`serviceprofile_id`) REFERENCES `profiles_service`
(`serviceprofile_id`) ON DELETE CASCAD)
at ./monarch_update.pl line 1315.

The problem occurrs when a host profile doesn't have
a service profile.

Fix:

Change line 1315 ro read:

if ($values[1]) { $dbh->do("insert into
profile_host_profile_service values('$values
[0]','$values[1]')") }

or comment out the line with a # and update the host
profile thriugh the GUI=20





-----Original Message-----
From: mon...@li...
[mailto:mon...@li...] On Behalf Of List
Receiver
Sent: Wednesday, April 05, 2006 6:47 AM
To: Scott Parris; mon...@li...
Subject: RE: [Monarch-users] (no subject)

Any thoughts on this error yet?  This is the output I get when I re-run
monarch_update.pl:

        Writing /srv/www/cgi-bin/monarch_ajax.cgi
        Updating setup information...

        Checking tables...
DBD::mysql::db do failed: Duplicate entry '7-22' for key 1 at
monarch_update.pl line 1155.
DBD::mysql::db do failed: Duplicate entry '7-22' for key 1 at
monarch_update.pl line 1155.

=20

-----Original Message-----
From: Scott Parris [mailto:sp...@gr...]=20
Sent: Saturday, April 01, 2006 1:50 PM
To: List Receiver
Subject: RE: [Monarch-users] (no subject)

It does appear that something didn't go well during the update. A column
should have been removed from the hosts table for starters. The first
thing to try is rerun monarch_update.pl. There should be some errors if
it doesn't go right.=20
 =20
Scott   =20
 =20
----- Original Message -----
From: List Receiver
Sent: Fri Mar 31 23:33:50 PST 2006
To: mon...@li...
Subject: [Monarch-users] (no subject)
 =20
 =20
I've got a few issues with Monarch 1.0 following an upgrade from .97a.=20

1) Commit or pre-flight show blank screens where they should output
error messages and stats
2) Cloning or adding a new host generates LOADS of sql errors like this:


Error: insert into hosts
values(NULL,'fartyjowels','asdf','1.2.3.4',NULL,NULL,NULL,'9',NULL,NULL,
'1',NULL) DBD::mysql::st execute failed: Column count doesn't match
value count at row 1 at
/usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.=20

3) Running commit does not move any of the generated config files from
the workspace to /usr/local/nagios/etc.  I can manually move them, and
nagios runs, but they're not moved automatically=20

Seems to be some horrendous steps backward in comparison to .97a...I
must have botched the install somehow???=20

Any ideas where to start?=20


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language that extends applications into web and mobile media. Attend the
live webcast and join the prime developer group breaking into this new
coding territory!=20
http://sel.as-us.falkag.net/sel?cmdblnk&kid 0944&bid$1720&dat 1642
_______________________________________________
Monarch-users mailing list
Mon...@li...
https://lists.sourceforge.net/lists/listinfo/monarch-users=20


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642
_______________________________________________
Monarch-users mailing list
Mon...@li...
https://lists.sourceforge.net/lists/listinfo/monarch-users