Groundwork Support Forum

[Guest]

get the following errors


Please correct the following:
Error: insert into services values('',NULL,'2','1','0','0','1','1','check_local_load!5.0,4.0,3.0!10.0,6.0,4.0','') DBD::mysql::st execute failed: Column 'host_id' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.
Error: insert into file_service values('23','Error: insert into services values(\'\',NULL,\'2\',\'1\',\'0\',\'0\',\'1\',\'1\',\'check_local_load!5.0,4.0,3.0!10.0,6.0,4.0\',\'\') DBD::mysql::st execute failed: Column \'host_id\' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.\n') DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 500.
Error: insert into services values('',NULL,'3','1','0','0','1','16','check_local_users!20!50','') DBD::mysql::st execute failed: Column 'host_id' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.
Error: insert into file_service values('23','Error: insert into services values(\'\',NULL,\'3\',\'1\',\'0\',\'0\',\'1\',\'16\',\'check_local_users!20!50\',\'\') DBD::mysql::st execute failed: Column \'host_id\' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.\n') DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 500.
Error: insert into services values('',NULL,'6','2','1',NULL,'1','24',NULL,'') DBD::mysql::st execute failed: Column 'host_id' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.
Error: insert into file_service values('23','Error: insert into services values(\'\',NULL,\'6\',\'2\',\'1\',NULL,\'1\',\'24\',NULL,\'\') DBD::mysql::st execute failed: Column \'host_id\' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.\n') DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 500.
Error: insert into services values('',NULL,'4','1','0','0','1','19','check_ping!100.0,20%!500.0,60%','') DBD::mysql::st execute failed: Column 'host_id' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.
Error: insert into file_service values('23','Error: insert into services values(\'\',NULL,\'4\',\'1\',\'0\',\'0\',\'1\',\'19\',\'check_ping!100.0,20%!500.0,60%\',\'\') DBD::mysql::st execute failed: Column \'host_id\' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.\n') DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 500.
Error: insert into services values('',NULL,'5','1','0','0','1','22','check_local_disk!20%!10%!/','') DBD::mysql::st execute failed: Column 'host_id' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.
Error: insert into file_service values('23','Error: insert into services values(\'\',NULL,\'5\',\'1\',\'0\',\'0\',\'1\',\'22\',\'check_local_disk!20%!10%!/\',\'\') DBD::mysql::st execute failed: Column \'host_id\' cannot be null at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 523.\n') DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails at /usr/local/groundwork/monarch/lib/MonarchStorProc.pm line 500.

[Peter_Loh]

Hi,
Can you please describe when you are seeing these errors? There are several ways to create a new host in GroundWork Monitor.
1. The easiest is to log in as admin, go to the Configuration tab, select Hosts menu option, then select New Host Wizard and follow the instructions.
2. Another way is in the Configuration tab, select Clone Host, then select the existing host you wish to replicate.
3. One other way is to go to Control, Load to load an existing set of Nagios files into the configuration tool.

Are you using any of these methods when you get these errors?
Regards,
Peter

[Guest]

i was using the first way.

[Peter_Loh]

For some reason it looks like the configuration database did not get created properly. Can you send me a copy of the "monarch" database? You can create this with the following command:
mysqldump monarch > monarch_backup.sql
Please email me the monarch_backup.sql file and we will try to find out why this is not working for you.
[email protected].
Thanks,
Peter

[Peter_Loh]

I think we found the problem. When you select New Host Wizard, you are probably seeing a question
"An existing host wizard session exists for test. Do you wish to continue with this host definition? (No will delete the host). "
Answer "NO" here, then continue to complete the wizard. You should be able to add a host without these errors. This was data left over from a qa test. Sorry.
Peter

[chris]

If I create a new host through the host wizard or by cloning localhost I cannot see the new hosts in the Status page or under nagios.

Everything seems OK as the hosts appear on the configure page fine, but nagios knows nothing about them.

MySQL is OK as the hosts appear in the monarch database, but not in sv.

I have manually run /usr/local/groundwork/feeder/nagios2db_hostgroupcheck.pl but nothing happens. I have stopped/started groundwork, but still no change on the status page.

SLES 9 SP2

Chris

[emily]

[quote="chris"]If I create a new host through the host wizard or by cloning localhost I cannot see the new hosts in the Status page or under nagios.

Have you reloaded your Nagios configuration by going Configuration --> Control -->Commit?
Cheers
Emily

[Guest]

javascript:emoticon('') That did it. RTFM javascript:emoticon('')

Thanks emily!

[chris]

I can add hosts etc now, but the only way I can see them is to stop and start gwservices. Surely this can't be right? Its not a problem to do this, but it is a bit of a pain.

Chris

[Peter_Loh]

Yes, right now you do need to stop and start gwservices due to a bug (yes it is a pain ). This will be fixed in the next release, available in about a week. The sv update will be part of the nagios commit process.

[databases]

databasesoutlet storevancouver canadascrapbooking suppliessolar energyatv partsinterior doorsmasteringgemstone jewelryindia travelart supplydalamanhologrambeef jerkymemorialsperidotmitutoyolawn carekitchen stoolstraining programbakersfield cahoteles en sevillabreguetsciatic nervesports watch