Below is a list of the oscar tables and what is in the Groups table. If it needs to be populated the same as the example in the previous email then the Groups table is not being created correctly. To double check I run oscar-config --startover to remove the extra rpms, removed mysql rpms and deleted directories. I then manually installed mysql and mysql-server, then rerun oscar-config --bootstrap which reinstall and configured the required packages however it still produced the same errors. The only point I can see from the log file is that the Mysql root password hasn't been set yet though this shouldn't cause these errors.
Database changed mysql> show tables; +-----------------------+ | Tables_in_oscar | +-----------------------+ | Cluster_Partitions | | Clusters | | Group_Nodes | | Group_Packages | | Groups | | Image_Package_Status | | Images | | Manage_status | | Networks | | Nics | | Node_Package_Status | | Nodes | | OscarFileServer | | Package_status | | Packages | | Packages_config | | Packages_servicelists | | Packages_switcher | | Partition_Nodes | | Partitions | | Status | | Wizard_status | +-----------------------+ 22 rows in set (0.00 sec) mysql> select * from Groups; +----+---------+----------+---------+ | id | name | selected | type | +----+---------+----------+---------+ | 1 | Default | 1 | package | +----+---------+----------+---------+ 1 row in set (0.00 sec) --------------------------------------------------------------------- Richard A. Young Division of ICT Services Email: richard.yo...@usq.edu.au Phone: (07) 46315557 Mob: 0437544370 Fax: (07) 46312798 --------------------------------------------------------------------- -----Original Message----- From: Patrick Nolan [mailto:patrick.no...@stanford.edu] Sent: Tuesday, 14 September 2010 2:53 PM To: oscar-users@lists.sourceforge.net Subject: Re: [Oscar-users] Mysql Error during bootstrap Richard Young wrote: > I am attempting to install Oscar 6.0.5-1 on RHEL 5.5 and have run into a > problem configuring the Mysql database. When running oscar-config > --bootstrap, the configuration has gone past the installation of the extra > rpms then started the configuration of the Oscar databases but produced the > errors below. I have looked at the created databases and they seem to be > correct with the required tables. The installed Mysql rpms are > mysql-5.0.77-4.el5_5.3 and mysql-server-5.0.77-4.el5_5.3. I have attached the > bootstrap log from the last attempt, I have also used the --startover option > to clean out the installation and started again. Has anybody come across this > error before and/or know how to fix it? > > > DBD::mysql::db do failed: Cannot add or update a child row: a foreign key > constraint fails (`oscar/Nodes`, CONSTRAINT `Nodes_ibfk_2` FOREIGN KEY > (`group_name`) REFERENCES `Groups` (`name`) ON DELETE CASCADE ON UPDATE > CASCADE) at /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line 713. > DB_DEBUG>/usr/bin/create_and_populate_basic_node_info: > ====> in Database::do_insert SQL : INSERT INTO Nodes (cluster_id, hostname, > name, group_name) SELECT 1, 'oscar_server', 'oscar_server', 'oscar_server' > Error message: Failed to insert values into Nodes table in database <oscar>: > Cannot add or update a child row: a foreign key constraint fails > (`oscar/Nodes`, CONSTRAINT `Nodes_ibfk_2` FOREIGN KEY (`group_name`) > REFERENCES `Groups` (`name`) ON DELETE CASCADE ON UPDATE CASCADE) at > /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line 719. > /usr/bin/create_and_populate_basic_node_info: SQL command that failed was: > <INSERT INTO Nodes (cluster_id, hostname, name, group_name) SELECT 1, > 'oscar_server', 'oscar_server', 'oscar_server'> at > /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line 719. > DB_DEBUG>/usr/bin/create_and_populate_basic_node_info: > ====>Failed to insert values via << INSERT INTO Nodes (cluster_id, hostname, > name, group_name) SELECT 1, 'oscar_server', 'oscar_server', 'oscar_server' >> > at /usr/bin/create_and_populate_basic_node_info line 80 > ERROR: Impossible to set headnode information in the database at > /usr/bin/create_and_populate_basic_node_info line 84. <etc. etc.> I'm using version 5.1, so the line numbers in your scripts don't match up with mine. The one thing I can tell from the error messages is that your table "Groups" doesn't seem to have a row with "oscar_server" in the "name" column. Can you check that? Here's what my Groups table looks like: mysql> select * from Groups; +----+---------------+----------+---------+ | id | name | selected | type | +----+---------------+----------+---------+ | 1 | core | 0 | package | | 2 | Default | 1 | package | | 3 | oscar_clients | 0 | node | | 4 | included | 0 | package | | 5 | oscar_server | 0 | node | | 6 | image | 0 | image | | 7 | all | 0 | node | | 8 | Default_node | 0 | node | +----+---------------+----------+---------+ 8 rows in set (0.00 sec) Your mileage may vary. I hope someone who knows about 6.0.5 can comment on this. In my early struggles I sometimes found it necessary to drop the whole "oscar" database and let the installation process create it again from scratch. Otherwise corrupt data would persist and cause confusion. ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email. The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt. The University of Southern Queensland is a registered provider of education with the Australian Government (CRICOS Institution Code No's. QLD 00244B / NSW 02225M) ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users
