Ian Crakanthorp wrote: > Hi, > > I have successfully installed 6.0.5 on Scientific Linux, pre 5.5, cant > remember if it was 5.4 or 5.3. I was tweaking it, to get the image > better for our envirnoment, so less fixing up needed to be done after > imaging. > > The problem is I got the database rather messy with images that no > longer existed etc etc. So decided to reinstall a clean system. How > ever when running oscar_config --bootstrap it fails creating the > database with the messages: > > Starting MySQL: [ OK ] > > Successfully initialized ODA > > Database Initialization... > Restarting the database service... > starting service mysqld... starting service mysqld... mysqld (pid 9766) > is running... > Stopping MySQL: [ OK ] > Starting MySQL: [ OK ] > Database_status: 1 > Modifying the global oscar information record > DB_DEBUG>/usr/bin/set_global_oscar_values: > ====> in Database::update_table SQL: UPDATE Clusters SET > server_distribution='rhel', headnode_interface='eth0', > installation_date=NOW(), server_architecture='x86_64', > oscar_version='6.0.5', server_distribution_version='5' > 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. > Checking for database existence of node oscar_server ... > ERROR: Impossible to > execute /usr/bin/create_and_populate_basic_node_info > at /usr/bin/oscar-config line 99 > ERROR: Impossible to install the server side of OSCAR > at /usr/bin/oscar-config line 99 > ERROR: Impossible to complete stage 2 of the bootstrap. > at /usr/bin/oscar-config line 99 > ERROR: Impossible to bootstrap OSCAR at /usr/bin/oscar-config line 100 > main::bootstrap() called at /usr/bin/oscar-config line 331 > ERROR: Impossible to bootstrap OSCAR at /usr/bin/oscar-config line 332. > > > Anyone seen this and know how to fix? > This looks somewhat familiar. I think the layout of the oscar database tables can change from version to version. It might be best to give the mysql command "drop database oscar" so it can make a clean start.
------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users
