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.
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.
Thanks
---------------------------------------------------------------------
Richard A. Young
Division of ICT Services
HPC Support Officer
University of Southern Queensland
Toowoomba, Queensland 4350
Australia
Email: richard.yo...@usq.edu.au Phone: (07) 46315557
Mob: 0437544370 Fax: (07) 46312798
---------------------------------------------------------------------
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)
From: root [r...@usqhpc00.usq.edu.au]
Sent: Tuesday, 14 September 2010 11:54 AM
To: Richard Young
Verbosity: 10
=====================================================================
========
== OSCAR bootstrap
=====================================================================
========
--> install_prereq found: /usr/bin/install_prereq Dealing with Prereq
--> AppConfig ( /usr/share/oscar/prereqs/AppConfig, check_and_fix)
--> Prereq status for redhat-el, 5, x86_64
found matching block
[mandriva.*|redhat.*|centos.*|fedora.*|scientific_linux.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/AppConfig):
--> perl-AppConfig: is installed
--> AppConfig is already installed, nothing to do.
INFO: the /tftpboot/oscar/rhel-5-x86_64.url already exists, we do nothing at
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/PackagePath.pm line 1060.
INFO: the /tftpboot/distro/redhat-el-5-x86_64.url file already exists, we do
nothing at
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/PackagePath.pm line 1102.
Updating OSCAR on your system...
=====================================================================
========
== Setting redhat-el-5-x86_64...
=====================================================================
========
--> Adding # Generated file; please do not manually edit
to /tftpboot/distro/redhat-el-5-x86_64.url
--> Adding # Generated file; please do not manually edit
to /tftpboot/oscar/rhel-5-x86_64.url
--> ... using default distro repo
--> Using the distro repo file:/tftpboot/distro/redhat-el-5-x86_64
for redhat-el-5-x86_64
--> Adding file:/tftpboot/distro/redhat-el-5-x86_64
in /tftpboot/distro/redhat-el-5-x86_64.url
Adding the repositories: [ file:/tftpboot/distro/redhat-el-5-x86_64
]
Array: 1 element(s)
--> [WARN] /tftpboot/distro/redhat-el-5-x86_64
does not exist
--> Skipping empty local repo (file:/tftpboot/distro/redhat-el-5-x86_64
)
--> [INFO] No repository to be added
--> ... using default OSCAR repo
--> ... using default repo:
--> http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
Adding the repositories: [
http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64 ]
Array: 1 element(s)
--> Adding online repo
--> (http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64)
--> Adding http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64 in
--> /tftpboot/oscar/rhel-5-x86_64.url Adding
--> http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
to /tftpboot/oscar/rhel-5-x86_64.url
Success: 02_update_repo_conffile
Success: 01_update_ubuntu_repo
--> Dealing with Prereq packman (/usr/share/oscar/prereqs/packman,
--> check_and_fix) Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/packman):
--> packman: is installed
--> packman is already installed, nothing to do.
Loaded plugins: rhnplugin, security
Cleaning up Everything
--> Dealing with Prereq yume (/usr/share/oscar/prereqs/yume,
--> check_and_fix) Prereq status for redhat-el, 5, x86_64
found matching block [redhat.*:5:.*]
--> Prereqs status (/usr/share/oscar/prereqs/yume):
--> yum-metadata-parser: is installed
--> perl-IO-Tty: is installed
--> python-elementtree: is installed
--> python-urlgrabber: is installed
--> sqlite: is installed
--> python-sqlite: is installed
--> yum: is installed
--> createrepo: is installed
--> yume: is installed
--> yume is already installed, nothing to do.
Adding the repositories: [ file:/tftpboot/oscar/rhel-5-x86_64
file:/tftpboot/oscar/common-rpms ]
Array: 2 element(s)
--> Skipping empty local repo (file:/tftpboot/oscar/rhel-5-x86_64)
--> Skipping empty local repo (file:/tftpboot/oscar/common-rpms)
--> [INFO] No repository to be added
--> Select online repo
--> http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
Adding the repositories: [ file:/tftpboot/distro/redhat-el-5-x86_64 ]
Array: 1 element(s)
--> Adding valid local repo (file:/tftpboot/distro/redhat-el-5-x86_64)
--> Adding file:/tftpboot/distro/redhat-el-5-x86_64 in
--> /tftpboot/distro/redhat-el-5-x86_64.url
--> Adding file:/tftpboot/distro/redhat-el-5-x86_64
to /tftpboot/distro/redhat-el-5-x86_64.url
--> Select valid local repo file:/tftpboot/distro/redhat-el-5-x86_64
Pools to prepare for distro redhat-el-5-x86_64:
[ http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
file:/tftpboot/distro/redhat-el-5-x86_64 ]
Array: 2 element(s)
Preparing pools: http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
file:/tftpboot/distro/redhat-el-5-x86_64
--> Analysing http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
[yum]
Detected format for pool
http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64: rpm
--> Analysing file:/tftpboot/distro/redhat-el-5-x86_64
Pool id: redhat-el-5-x86_64.
Detecting the distro pool redhat-el-5-x86_64 Distro id (OS_Detect syntax
distro-version-arch:
redhat-el-5-x86_64 Pool format: rpm
Detected format for pool file:/tftpboot/distro/redhat-el-5-x86_64: rpm
Pool: http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
=====================================================================
========
== Preparing pool: http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
=====================================================================
========
--> Analysing http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
[yum]
Detected format for pool
http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64: rpm
--> Binary package format for the pool: rpm
--- checking md5sum for http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64
... remote repo,
no check needed.
Current checksum (/tmp/pool_unstable_rhel-5-x86_64.md5): 0
--> Pool http://bison.csm.ornl.gov/repos/unstable/rhel-5-x86_64 ready
Pool: file:/tftpboot/distro/redhat-el-5-x86_64
=====================================================================
========
== Preparing pool: file:/tftpboot/distro/redhat-el-5-x86_64
=====================================================================
========
--> Analysing file:/tftpboot/distro/redhat-el-5-x86_64
Pool id: redhat-el-5-x86_64.
Detecting the distro pool redhat-el-5-x86_64 Distro id (OS_Detect syntax
distro-version-arch:
redhat-el-5-x86_64 Pool format: rpm
Detected format for pool file:/tftpboot/distro/redhat-el-5-x86_64: rpm
--> Binary package format for the pool: rpm
--- checking md5sum for file:/tftpboot/distro/redhat-el-5-x86_64
Current checksum (/tmp/pool_distro_redhat-el-5-x86_64.md5): 0 Read checksum
file
/tmp/pool_distro_redhat-el-5-x86_64.md5: c98f5068f63b06205cf01e7798200aac Old
checksum
(/tmp/pool_distro_redhat-el-5-x86_64.md5): c98f5068f63b06205cf01e7798200aac
CHECKSUM: /tmp/pool_distro_redhat-el-5-x86_64.md5 new:0
old:c98f5068f63b06205cf01e7798200aac
--> Pool file:/tftpboot/distro/redhat-el-5-x86_64 ready
-->
Dealing with Prereq ORM
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/ORM):
--> orm: is installed
-->
Dealing with Prereq OSCAR-Database
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/OSCAR-Database):
--> oda: is installed
-->
Dealing with Prereq Selector
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/Selector):
--> oscar-selector: is installed
--> oscar-selector-x11: is installed
-->
Dealing with Prereq Configurator
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/Configurator):
--> configurator: is installed
-->
Dealing with Prereq base
--> Prereq status for redhat-el, 5, x86_64
found matching block [redhat.*|centos.*|scientific_linux.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/base):
--> dhcp: is installed
--> gd: is installed
--> nfs-utils: is installed
--> openssh: is installed
--> openssh-clients: is installed
--> openssh-server: is installed
--> openssl: is installed
--> tcpdump: is installed
--> xinetd: is installed
--> httpd: is installed
--> php: is installed
--> expat: is installed
--> python: is installed
--> zlib: is installed
--> zlib-devel: is installed
--> shadow-utils: is installed
--> libcap: is installed
--> ntp: is installed
-->
Dealing with Prereq perl-XML-Parser
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/perl-XML-Parser):
--> perl-XML-Parser: is installed
-->
Dealing with Prereq perl-XML-Simple
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/perl-XML-Simple):
--> perl-XML-Simple: is installed
-->
Dealing with Prereq perl-HTML-Tree
--> Prereq status for redhat-el, 5, x86_64
found matching block [.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/perl-HTML-Tree):
--> perl-HTML-Tree: is installed
-->
Dealing with Prereq perl-Tk
--> Prereq status for redhat-el, 5, x86_64
found matching block
[fedora.*|mandriva.*|redhat.*|centos.*|scientific_linux.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/perl-Tk):
--> perl-Tk: is installed
-->
Dealing with Prereq perl-Qt
--> Prereq status for redhat-el, 5, x86_64
found matching block
[fedora.*|mandriva.*|redhat.*|centos.*|scientific_linux.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/perl-Qt):
--> perl-Qt: is installed
--> Executing: /usr/bin/oda --init mysql
Initializing ODA: mysql
-->
Dealing with Prereq oda
--> Prereq status for redhat-el, 5, x86_64
found matching block [redhat-.*:.*:.*]
--> Prereqs status (/usr/share/oscar/prereqs/oda):
--> mysql: is installed
--> perl-DBD-MySQL: is installed
--> perl-DBI: is installed
--> mysql-server: is installed
Database Initialization...
Restarting the database service...
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... --> Executing: /sbin/service mysqld status mysqld
(pid 17891) is
running...
--> [SystemService] Return code: 0
--> Executing: /sbin/service mysqld restart
Stopping MySQL: [60G[ [0;32m OK [0;39m] Starting MySQL: [60G[ [0;32m OK
[0;39m]
--> [SystemService] Return code: 0
DB_DEBUG>0 10 6 4 3 2 1 0:
====> MySQL root password is not set.
Database_status: 0
Checking for ODA database password file ... found.
Checking for proper ownership and permissions ... correct.
Reading password from file /etc/odapw ... done.
--> Password ok, now creating the database Executing
--> /usr/bin/create_oscar_database
DB_DEBUG>0 10 6 4 3 2 1 0:
====> MySQL root password is not set.
--> Creating the OSCAR database ...
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting host = localhost
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting port = 3306
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting database = oscar
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting type = mysql
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting user = oscar
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting password =
DB_DEBUG>/usr/bin/create_oscar_database:
====> in set_option_defaults setting password = oscar.643.658.201.053
DB_DEBUG>/usr/bin/create_oscar_database:
====> in oda::create_database install_driver succeeded DB_DEBUG>0 10 6 4 3 2 1
0:
====> MySQL root password is not set.
DB_DEBUG>/usr/bin/create_oscar_database:
====> <mysql -uroot -e "GRANT ALL ON oscar.* TO os...@localhost identified by
\"oscar.643.658.201.053\";"> succeeded
DB_DEBUG>/usr/bin/create_oscar_database:
====> <mysql -uroot -e "GRANT SELECT,INSERT,UPDATE,DELETE ON oscar.* TO oscar
identified by \"oscar.643.658.201.053\";"> succeeded
DB_DEBUG>/usr/bin/create_oscar_database:
====> <mysql -uroot -e "GRANT SELECT ON oscar.* TO anonymous"> succeeded
DB_DEBUG>/usr/bin/create_oscar_database:
====> in oda::create_database createdb <oscar> with master user <oscar>
succeeded
--> ... OSCAR database successfully created.
DB_DEBUG>/usr/bin/create_oscar_database:
====> in Database::create_table runs the command : mysql -u oscar
-poscar.643.658.201.053
oscar < /usr/share/oscar/prereqs/oda/etc/oscar_table.sql
DB_DEBUG>/usr/bin/create_oscar_database:
====> <mysql -u oscar -poscar.643.658.201.053 oscar <
/usr/share/oscar/prereqs/oda/etc/oscar_table.sql> succeeded
DB_DEBUG>/usr/bin/create_oscar_database:
===========================((( All the OSCAR tables are created
)))===========================
--> Executing /usr/bin/prepare_oda
DB_DEBUG>/usr/bin/prepare_oda:
====> ARGV=<>
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
Enabling service mysqld... [INFO] The service is already enabled
done
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... --> Executing: /sbin/service mysqld status
mysqld (pid 18422) is running...
--> [SystemService] Return code: 0
--> Executing: /sbin/service mysqld restart
Stopping MySQL: [60G[ [0;32m OK [0;39m]
Starting MySQL: [60G[ [0;32m OK [0;39m]
--> [SystemService] Return code: 0
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting host = localhost
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting port = 3306
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting database = oscar
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting type = mysql
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting user = oscar
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting password =
DB_DEBUG>/usr/bin/prepare_oda:
====> in set_option_defaults setting password = oscar.643.658.201.053
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::list_databases install_driver succeeded for driver mysql
DB_DEBUG>/usr/bin/prepare_oda:
====> executing function _ListDBs on database <oscar>: localhost, 3306
DB_DEBUG>0 10 6 4 3 2 1 0:
====> MySQL root password is not set.
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::list_databases _ListDBs succeeded returned <information_schema
mysql oscar
test>
DEBUG>/usr/bin/prepare_oda:
====>print_hash
-- in oda::oda_connect called from package=main /usr/bin/prepare_oda:143
database_connected_flag=0 passed_options_ref= ->
-- database => <oscar>
-- debug => <1>
-- host => <localhost>
-- password => <oscar.643.658.201.053>
-- port => <3306>
-- type => <mysql>
-- user => <oscar>
DEBUG>/usr/bin/prepare_oda:
====>print_hash
-- in oda::oda_connect options_ref= ->
-- database => <oscar>
-- debug => <1>
-- host => <localhost>
-- password => <oscar.643.658.201.053>
-- port => <3306>
-- type => <mysql>
-- user => <oscar>
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::oda_connect connnecting to database <oscar> as user <oscar>,
password
<oscar.643.658.201.053> using connect argument <DBI:mysql:oscar>
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::oda_connect connected to database <oscar>
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::database_server_version sql_command=<SELECT version();>
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::database_server_version fetchall_arrayref returned: (
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::database_server_version (5.0.77)
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::database_server_version returning saved <5.0.77>
DEBUG>/usr/bin/prepare_oda:
====>print_hash
-- in oda::list_tables new cached_all_table_names_ref ->
-- Cluster_Partitions => <1>
-- Clusters => <1>
-- Group_Nodes => <1>
-- Group_Packages => <1>
-- Groups => <1>
-- Image_Package_Status => <1>
-- Images => <1>
-- Manage_status => <1>
-- Networks => <1>
-- Nics => <1>
-- Node_Package_Status => <1>
-- Nodes => <1>
-- OscarFileServer => <1>
-- Package_status => <1>
-- Packages => <1>
-- Packages_config => <1>
-- Packages_servicelists => <1>
-- Packages_switcher => <1>
-- Partition_Nodes => <1>
-- Partitions => <1>
-- Status => <1>
-- Wizard_status => <1>
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::oda_disconnect called from package=main /usr/bin/prepare_oda:154
DB_DEBUG>/usr/bin/prepare_oda:
====> in oda::oda_disconnect disconnnecting
--> Execution /usr/bin/populate_default_package_set
--> Populating default package set
--> Make a 'Default' group selected
--> Get a list of all installable packages
--> Checking for existence of package set <Default>
--> Initializing package set <Default>
--> Update the Node_Package_Status table
DB_DEBUG>0 10 6 4 3 2 1 0:
====> MySQL root password is not set.
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... --> Executing: /sbin/service mysqld restart
Stopping MySQL: [60G[ [0;32m OK [0;39m]
Starting MySQL: [60G[ [0;32m OK [0;39m]
--> [SystemService] Return code: 0
Successfully initialized ODA
Database Initialization...
Restarting the database service...
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/default
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel
Opening file /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/rhel5
Opening file
/usr/lib/perl5/vendor_perl/5.8.8/OSCAR/OCA/OS_Settings/linux-x86_64-redhat-el-
5-5
Called getitem with mysql_daemon and returning /etc/init.d/mysqld
$VAR1 = {
'ssh_daemon' => '/etc/init.d/sshd',
'ssh_package' => 'sshd',
'dhcp_configfile' => '/etc/dhcpd.conf',
'init' => '/etc/init.d ',
'portmap_package' => 'portmap',
'monitord_daemon' => '/etc/init.d/systemimager-server-monitord',
'exports_file' => '/etc/exports',
'dhcp_daemon' => '/etc/init.d/dhcpd',
'nfs_package' => 'nfs',
'mysql_daemon' => '/etc/init.d/mysqld'
};
starting service mysqld... --> Executing: /sbin/service mysqld status
mysqld (pid 18734) is running...
--> [SystemService] Return code: 0
--> Executing: /sbin/service mysqld restart
Stopping MySQL: [60G[ [0;32m OK [0;39m]
Starting MySQL: [60G[ [0;32m OK [0;39m]
--> [SystemService] Return code: 0
DB_DEBUG>0 10 6 4 3 2 1 0:
====> MySQL root password is not set.
Database_status: 1
--> Setting all the OSCAR global values
DB_DEBUG>/usr/bin/set_global_oscar_values:
====> after GetOptions ARGV=<>
DEBUG>/usr/bin/set_global_oscar_values:
====>print_hash
-- DB_DEBUG>/usr/bin/set_global_oscar_values:
====> options after GetOptions ->
-- debug => <1>
-- interface => <bond0>
-- verbose => <0>
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.
------------------------------------------------------------------------------
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
