Due to https://bugzilla.redhat.com/show_bug.cgi?id=1046326, I was forced to install openstack-heat-common on my mysql running machine. This being a test setup I don't have a mysql root password set. The only I was able to tell heat-db-setup to move on was to "" the password. [root@fab2 ~]# heat-db-setup rpm -y -r "" -p heattest Installing on an RPM system. mysql-server-5.1.71-1.el6.x86_64 Another MySQL daemon already running with the same unix socket. Starting mysqld: [FAILED] Verified connectivity to MySQL. Creating 'heat' database. Updating 'heat' database password in /etc/heat/heat.conf /usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py:683: SADeprecationWarning: The 'listeners' argument to Pool (and create_engine()) is deprecated. Use event.listen(). Pool.__init__(self, creator, **kw) /usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py:159: SADeprecationWarning: Pool.add_listener is deprecated. Use event.listen() self.add_listener(l) ERROR: (OperationalError) (1045, "Access denied for user 'heat'@'localhost' (using password: YES)") None None ERROR 1146 (42S02) at line 1: Table 'heat.migrate_version' doesn't exist Final sanity check failed. and testing with: [root@fab2 ~]# heat-db-setup rpm -y -p heattest Installing on an RPM system. mysql-server-5.1.71-1.el6.x86_64 Another MySQL daemon already running with the same unix socket. Starting mysqld: [FAILED] Please enter the password for the 'root' MySQL user: Verified connectivity to MySQL. Creating 'heat' database. Updating 'heat' database password in /etc/heat/heat.conf /usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py:683: SADeprecationWarning: The 'listeners' argument to Pool (and create_engine()) is deprecated. Use event.listen(). Pool.__init__(self, creator, **kw) /usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py:159: SADeprecationWarning: Pool.add_listener is deprecated. Use event.listen() self.add_listener(l) ERROR: (OperationalError) (1045, "Access denied for user 'heat'@'localhost' (using password: YES)") None None ERROR 1146 (42S02) at line 1: Table 'heat.migrate_version' doesn't exist Final sanity check failed. without providing a root password. Also, before trying to install or run mysql, heat-db-setup should: 1) check if mysql is already installed -> skip yum invokation, I might not want an update of the db middle of deploying 2) check if it's running with a service mysql status before trying to start a service.
Steve mentioned on IRC not to use this tool, but this is what we are advertising to customers: https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Linux_OpenStack_Platform/4/html/Installation_and_Configuration_Guide/sect-Configuring_the_Orchestration_Service.html as official tool to fill the db.
*** This bug has been marked as a duplicate of bug 1046326 ***
heat-db-setup is a developer tool and is being removed from RHOS packaging. See https://bugzilla.redhat.com/show_bug.cgi?id=1046326#c10 for rationale behind closing this as a dup.