LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-09-2009, 09:10 AM   #1
ibadkureshi
LQ Newbie
 
Registered: Nov 2009
Location: Huddersfield
Posts: 7

Rep: Reputation: 0
Mysql ODA issues during installation of OSCAR 5.1 or SuSE 10.3


hi again,

further to my earlier thread, i changed OS and oscar versions and got through the dependency issues and now as the boot strapper runs i come across the following database error [appended below]. there is 1 sourceforge mailing list about this topic but it died in June 2008 with no answers given. I hope someone can help me out...

output:
--------------------------------------------------------------

--> Making sure there is an ODA database password
Checking for ODA database password file ... found.
Checking for proper ownership and permissions ... correct.
Reading password from file /etc/odapw ... done.
--> Initializing ODA database
Starting the mysql database server ...
/etc/init.d/mysql start
Starting service MySQL ..done
Making sure that the mysql database server starts on subsequent boots ...
chkconfig mysql on
Modifying the global oscar information record
Checking for database existence of node oscar_server ...
The node oscar_server is already in the database
Updating the hostname field in the oscar_server node to <head> ...
Updating the dns_domain field in the oscar_server node to <mi1cluster>
Checking for existence of node group oscar_clients ...
Checking for existence of node group all ...
Checking for existence of 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 1668.
head:/opt/oscar # Oscar Wizard preparation script failed to complete (cd /opt/oscar/scripts && ./wizard_prep) at ./install_cluster line 275.

-----------------------------


Thanks in advance
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
OSCAR 5.0 on SUSE10.1 installation issues ibadkureshi Linux - Software 2 11-05-2009 02:31 PM
DHCP, OSCAR cluster installation, VMware server and PXE-boot problem. Azazwa Linux - Newbie 3 03-31-2009 10:52 AM
SUSE 10.1 Installation issues pmasterp Linux - Newbie 8 10-09-2006 06:11 PM
Problems with Oscar cluster installation pankajrodge123 Linux - Newbie 3 05-05-2006 02:52 AM
SuSe 9.2 installation issues sam_higton SUSE / openSUSE 7 06-10-2005 04:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:28 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration