Created attachment 796916 [details]
packstack answer file

Description of problem:
=======================
packstack does not create tables in head db.
As a result of that, The openstack-heat-engine service failed to start

Version-Release number of selected component (if applicable):
=============================================================
openstack-packstack-2013.2.1-0.9.dev756.el6.noarch

How reproducible:
=================
1/1

Steps to Reproduce:
===================
1. Install Openstack via packstack, Use the answer file attached to this mail as a template.
2. Check Heat Engine status:
$ service openstack-heat-engine status
heat-engine dead but pid file exists

3. Check Heat DB:

mysql> use heat;
Database changed
mysql> show tables;
Empty set (0.00 sec)


Actual results:
===============
openstack-heat-engine service failed to start with the following error:

ProgrammingError: (ProgrammingError) (1146, "Table 'heat.stack' doesn't exist") 'SELECT stack.created_at AS stack_created_at, stack.updated_at AS stack_updated_at, stack.deleted_at AS stack_deleted_at, stack.id AS stack_id, stack.name AS stack_name, stack.raw_template_id AS stack_raw_template_id, stack.username AS stack_username, stack.tenant AS stack_tenant, stack.action AS stack_action, stack.status AS stack_status, stack.status_reason AS stack_status_reason, stack.parameters AS stack_parameters, stack.user_creds_id AS stack_user_creds_id, stack.owner_id AS stack_owner_id, stack.timeout AS stack_timeout, stack.disable_rollback AS stack_disable_rollback \nFROM stack \nWHERE stack.deleted_at IS NULL AND stack.owner_id IS NULL' ()
2013-09-12 17:50:06.459 15663 TRACE heat.openstack.common.threadgroup

Expected results:
=================
Heat should be fully functional post installation via packstack.