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]> 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>
> 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 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 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 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
> 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
