|
From: List R. <lis...@ma...> - 2006-04-05 04:45:05
|
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
|
|
From: Poltorak P. <Pau...@ev...> - 2006-04-05 05:19:06
|
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 |
|
From: List R. <lis...@ma...> - 2006-04-06 19:36:41
|
That fixed her right up. Thanks Scott.
=20
-----Original Message-----
From: Scott Parris [mailto:sp...@gr...]=20
Sent: Wednesday, April 05, 2006 11:16 AM
To: List Receiver; mon...@li...
Subject: RE: [Monarch-users] (no subject)
Comment out line 1155. It appears that the table was properly populated
during the previous run and it's trying to repopulate it (hence
duplicate entry). =20
=20
----- Original Message -----
From: List Receiver
Sent: Tue Apr 4 21:45:04 PDT 2006
To: Scott Parris ; mon...@li...
Subject: RE: [Monarch-users] (no subject)
=20
=20
Any thoughts on this error yet? This is the output I get when I re-run
monarch_update.pl:=20
Writing /srv/www/cgi-bin/monarch_ajax.cgi=20
Updating setup information...=20
Checking tables...=20
DBD::mysql::db do failed: Duplicate entry '7-22' for key 1 at
monarch_update.pl line 1155.=20
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...]
Sent: Saturday, April 01, 2006 1:50 PM
To: List Receiver
Subject: RE: [Monarch-users] (no subject)=20
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
=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=20
error messages and stats=20
2) Cloning or adding a new host generates LOADS of sql errors like this:
Error: insert into hosts=20
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=20
value count at row 1 at=20
/usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.=20
3) Running commit does not move any of the generated config files from=20
the workspace to /usr/local/nagios/etc. I can manually move them, and=20
nagios runs, but they're not moved automatically=20
Seems to be some horrendous steps backward in comparison to .97a...I=20
must have botched the install somehow???=20
Any ideas where to start?=20
-------------------------------------------------------=20
This SF.Net email is sponsored by xPML, a groundbreaking scripting=20
language that extends applications into web and mobile media. Attend the
live webcast and join the prime developer group breaking into this new=20
coding territory!=20
http://sel.as-us.falkag.net/sel?cmdblnk&kid 0944&bid$1720&dat 1642=20
_______________________________________________=20
Monarch-users mailing list=20
Mon...@li...=20
https://lists.sourceforge.net/lists/listinfo/monarch-users=20
|
|
From: Scott P. <sp...@gr...> - 2006-04-05 18:16:10
|
Comment out line 1155. It appears that the table was properly populated during the previous run and it's trying to repopulate it (hence duplicate entry).
----- Original Message -----
From: List Receiver
Sent: Tue Apr 4 21:45:04 PDT 2006
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.
-----Original Message-----
From: Scott Parris [mailto:sp...@gr...]
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.
Scott
----- Original Message -----
From: List Receiver
Sent: Fri Mar 31 23:33:50 PST 2006
To: mon...@li...
Subject: [Monarch-users] (no subject)
I've got a few issues with Monarch 1.0 following an upgrade from .97a.
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.
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
Seems to be some horrendous steps backward in comparison to .97a...I
must have botched the install somehow???
Any ideas where to start?
-------------------------------------------------------
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?cmdblnk&kid 0944&bid$1720&dat 1642
_______________________________________________
Monarch-users mailing list
Mon...@li...
https://lists.sourceforge.net/lists/listinfo/monarch-users
|