LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Mysql ODA issues during installation of OSCAR 5.1 or SuSE 10.3 (https://www.linuxquestions.org/questions/linux-software-2/mysql-oda-issues-during-installation-of-oscar-5-1-or-suse-10-3-a-767913/)

ibadkureshi 11-09-2009 09:10 AM

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


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