OK, obviously "apitest" is not populated to the "Packages" table.
Can you please post what packages are populated on your "Packages" table? You can check this with the "oda" command line as well as the normal database SQL. Here is what I would do to check what packages are populated. ---------- [EMAIL PROTECTED] ~]# oda oda> packages List of the field(package) in Packages ================================= apitest base c3 disable-services documentation ganglia jobmonarch lam linux-ha loghost maui mpich mtaconfig netbootmgr ntpconfig oda openmpi opium pfilter pvm rapt sc3 selinux sge sis switcher sync-files torque yume oda> \q [EMAIL PROTECTED] ~]# ---------- If apitest and any other packages are not populated at any reason, I would re-setup oda like the following and then re-install oscar. ---------- [EMAIL PROTECTED] ~]# oda oda> remove_oda Warning: This operation removes the oscar database, user, and its all permissions Warning: once your oscar database is dropped, you will get out of this console Warning: ODA will be ready to create a new oscar database Do you really want to remove oda (y/n)? y ---------- BTW, if you are installing oscar5.0 on Open SUSE 10.3, the above oda cli would not work properly. Probably you'd better run "start_over" and then re-install OSCAR. Why don't you use oscar5.1b2? http://svn.oscar.openclustergroup.org/php/download.php?d_name=beta Regards, - DongInn Ben Lieblich wrote: > Hi DongInn. Here is my log. Thanks for your help. > > -Ben > > On Wed, Jul 9, 2008 at 3:49 PM, DongInn Kim <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hi Ben, > > The error happened because the "Group_Packages" table tried to get > populated with even not existing packages on the Packages table. > > I think this should not happen but this can happen if very unlikely > your database was not cleaned up after start_over or the Packages > table could not be fully populated at some reason. > > We can not really see why it happened until we see your full verbose > oscarinstall.log so if you have the right one, please post the log > after compressing it. > > Regards, > > - DongInn > > > Ben Lieblich wrote: > > Is there an email at which I can contact him (DongInn)? Thanks > for your > > help. > > > > -Ben > > > > > > On Wed, Jul 9, 2008 at 1:35 PM, Michael Edwards > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > > > > I would probably start with a clean install of Suse at this > point, > > but if you want to try again, try doing it with > > > > env OSCAR_VERBOSE=3 ./install_cluster eth0 > > > > and see if you get any more helpful errors. DongInn might > have more > > to say about the actual SQL error, hes the database guru. > > > > On Tue, Jul 8, 2008 at 4:06 PM, Ben Lieblich > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > > > > I am trying to install oscar on what is to be my head > node for a > > small cluster but I can not seem to get around the > following error: > > > > Creating the OSCAR database ... > > ... OSCAR database successfully created. > > Checking for database existence of node oscar_server ... > > Updating the hostname field in the oscar_server node to > > <dls-seqlinux> ... > > Updating the dns_domain field in the oscar_server node to > > <rutgers.edu <http://rutgers.edu> <http://rutgers.edu/>> > > Checking for existence of node group oscar_clients ... > > Checking for existence of node group all ... > > Creating node group all ... > > Checking for existence of node group Default_node ... > > Creating node group Default_node ... > > Checking for existence of package set <Default> > > Initializing package set <Default> > > DBD::mysql::db do failed: Cannot add or update a child row: a > > foreign key constraint fails (`oscar/Group_Packages`, > CONSTRAINT > > `Group_Packages_ibfk_1` FOREIGN KEY (`package`) REFERENCES > > `Packages` (`package`) ON DELETE CASCADE) at > > /opt/oscar/lib/OSCAR/oda.pm <http://oda.pm> > <http://oda.pm/> line 733. > > DB_DEBUG>./wizard_prep: > > ====> in Database::do_update SQL : INSERT INTO Group_Packages > > (group_name, package, selected)VALUES ('Default', > 'apitest', '1') > > Error message: Failed to update Group_Packages table in > database > > <oscar>: Cannot add or update a child row: a foreign key > > constraint fails (`oscar/Group_Packages`, CONSTRAINT > > `Group_Packages_ibfk_1` FOREIGN KEY (`package`) REFERENCES > > `Packages` (`package`) ON DELETE CASCADE) at > > /opt/oscar/lib/OSCAR/oda.pm <http://oda.pm> > <http://oda.pm/> line 739. > > ./wizard_prep: SQL command that failed was: <INSERT INTO > > Group_Packages (group_name, package, selected)VALUES > ('Default', > > 'apitest', '1')> at /opt/oscar/lib/OSCAR/oda.pm > <http://oda.pm> <http://oda.pm/> > > line 739. > > DB_DEBUG>./wizard_prep: > > ====>Failed to insert values via << INSERT INTO > Group_Packages > > (group_name, package, selected)VALUES ('Default', 'apitest', > > '1') >> at /opt/oscar/lib/OSCAR/Database > > .pm line 1681. > > Oscar Wizard preparation script failed to complete at > > ./install_cluster line 275. > > > > > > Everything up to here seems fine. I have used start_over and > > have restarted the machine every which way and have been > > troubleshooting the mysql error but I can not seem to get > rid of > > this error message. Can anyone help me please? Would be > greatly > > appreciated. Thanks. > > > > P.S. I am running openSUSE 10.3 with Oscar 5.0 and mysql: Ver > > 14.12 Distrib 5.0.45, for suse-linux-gnu (i686). > > > > -Ben > > > > > ------------------------------------------------------------------------- > > Sponsored by: SourceForge.net Community Choice Awards: > VOTE NOW! > > Studies have shown that voting for your favorite open source > > project, > > along with a healthy diet, reduces your potential for chronic > > lameness > > and boredom. Vote Now at > http://www.sourceforge.net/community/cca08 > > _______________________________________________ > > Oscar-users mailing list > > Oscar-users@lists.sourceforge.net > <mailto:Oscar-users@lists.sourceforge.net> > > <mailto:Oscar-users@lists.sourceforge.net > <mailto:Oscar-users@lists.sourceforge.net>> > > https://lists.sourceforge.net/lists/listinfo/oscar-users > > > > > > > > > ------------------------------------------------------------------------- > > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > > Studies have shown that voting for your favorite open source > project, > > along with a healthy diet, reduces your potential for chronic > lameness > > and boredom. Vote Now at > http://www.sourceforge.net/community/cca08 > > _______________________________________________ > > Oscar-users mailing list > > Oscar-users@lists.sourceforge.net > <mailto:Oscar-users@lists.sourceforge.net> > > <mailto:Oscar-users@lists.sourceforge.net > <mailto:Oscar-users@lists.sourceforge.net>> > > https://lists.sourceforge.net/lists/listinfo/oscar-users > > > > > > > > > ------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------- > > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > > Studies have shown that voting for your favorite open source project, > > along with a healthy diet, reduces your potential for chronic > lameness > > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Oscar-users mailing list > > Oscar-users@lists.sourceforge.net > <mailto:Oscar-users@lists.sourceforge.net> > > https://lists.sourceforge.net/lists/listinfo/oscar-users > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Oscar-users mailing list > Oscar-users@lists.sourceforge.net > <mailto:Oscar-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/oscar-users > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > > > ------------------------------------------------------------------------ > > _______________________________________________ > Oscar-users mailing list > Oscar-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/oscar-users ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users
