For some reason yume is the only package that is in the table. The table
only has one entry at this point. And I am using 5.1b2. I have tried
restarting and deleting the oscar databse. Nothign has seemed to work. Also
I do not know how you are getting oda> as your command line.
-Ben
On Thu, Jul 10, 2008 at 1:18 PM, DongInn Kim <[EMAIL PROTECTED]> wrote:
> 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
> > > [email protected]
> > <mailto:[email protected]>
> > > <mailto:[email protected]
> > <mailto:[email protected]>>
> > > 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
> > > [email protected]
> > <mailto:[email protected]>
> > > <mailto:[email protected]
> > <mailto:[email protected]>>
> > > 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
> > > [email protected]
> > <mailto:[email protected]>
> > > 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
> > [email protected]
> > <mailto:[email protected]>
> > 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
> > [email protected]
> > 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-users
