Open Stack

Hey Y'all,

I'm working on the latest RDO icehouse release of openstack and am 
following the redhat guide to set this stuff up (which looks almost like 
all the other guides with a few differences), and am stuck on the 
Neutron part.  I *think* I have all the backend services set up 
(neutron-server on the controller, and neutron agents on the network 
node), and want to create my first public network, but I'm getting an error:

# neutron net-create ext-net --router:external=True
Request Failed: internal server error while processing your request.

Looking in the neutron server logs, I see:

2014-03-31 14:50:47.746 3192 INFO urllib3.connectionpool [-] Starting 
new HTTP connection (1): my-internal-server.edu
2014-03-31 14:50:47.854 3192 ERROR neutron.api.v2.resource 
[req-d20aad3f-d200-484c-b73a-9556efe62386 None] create failed
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource Traceback 
(most recent call last):
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib/python2.6/site-packages/neutron/api/v2/resource.py", line 87, 
in resource
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     result = 
method(request=request, **args)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib/python2.6/site-packages/neutron/api/v2/base.py", line 411, in 
create
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     obj = 
obj_creator(request.context, **kwargs)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib/python2.6/site-packages/neutron/plugins/openvswitch/ovs_neutron_plugin.py", 
line 501, in create_network
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     network)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib/python2.6/site-packages/neutron/db/db_base_plugin_v2.py", line 
927, in create_network
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     return 
self._make_network_dict(network, process_extensions=False)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib/python2.6/site-packages/neutron/db/db_base_plugin_v2.py", line 
842, in _make_network_dict
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     for 
subnet in network['subnets']]}
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib/python2.6/site-packages/neutron/openstack/common/db/sqlalchemy/models.py", 
line 57, in __getitem__
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     return 
getattr(self, key)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/attributes.py", 
line 168, in __get__
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     return 
self.impl.get(instance_state(instance),dict_)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/attributes.py", 
line 453, in get
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     value = 
self.callable_(state, passive)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/strategies.py", 
line 508, in _load_for_state
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     return 
self._emit_lazyload(session, state, ident_key)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/strategies.py", 
line 574, in _emit_lazyload
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     result = 
q.all()
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py", 
line 2115, in all
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     return 
list(self)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py", 
line 2227, in __iter__
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     return 
self._execute_and_instances(context)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py", 
line 2242, in _execute_and_instances
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     result = 
conn.execute(querycontext.statement, self._params)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1449, in execute
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     params)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1584, in _execute_clauseelement
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource 
compiled_sql, distilled_params
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1698, in _execute_context
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     context)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1691, in _execute_context
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     context)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", 
line 331, in do_execute
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource 
cursor.execute(statement, parameters)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in 
execute
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource 
self.errorhandler(self, exc, value)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource   File 
"/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in 
defaulterrorhandler
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource     raise 
errorclass, errorvalue
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource 
ProgrammingError: (ProgrammingError) (1146, "Table 
'neutron.ipallocationpools' doesn't exist") 'SELECT subnets.tenant_id AS 
subnets_tenant_id, subnets.id AS subnets_id, subnets.name AS 
subnets_name, subnets.network_id AS subnets_network_id, 
subnets.ip_version AS subnets_ip_version, subnets.cidr AS subnets_cidr, 
subnets.gateway_ip AS subnets_gateway_ip, subnets.enable_dhcp AS 
subnets_enable_dhcp, subnets.shared AS subnets_shared, 
ipavailabilityranges_1.allocation_pool_id AS 
ipavailabilityranges_1_allocation_pool_id, 
ipavailabilityranges_1.first_ip AS ipavailabilityranges_1_first_ip, 
ipavailabilityranges_1.last_ip AS ipavailabilityranges_1_last_ip, 
ipallocationpools_1.id AS ipallocationpools_1_id, 
ipallocationpools_1.subnet_id AS ipallocationpools_1_subnet_id, 
ipallocationpools_1.first_ip AS ipallocationpools_1_first_ip, 
ipallocationpools_1.last_ip AS ipallocationpools_1_last_ip \nFROM 
subnets LEFT OUTER JOIN ipallocationpools AS ipallocationpools_1 ON 
subnets.id = ipallocationpools_1.subnet_id LEFT OUTER JOIN 
ipavailabilityranges AS ipavailabilityranges_1 ON ipallocationpools_1.id 
= ipavailabilityranges_1.allocation_pool_id \nWHERE %s = 
subnets.network_id' ('ca36a372-5d73-420b-ab3c-d4530e2c2a2a',)
2014-03-31 14:50:47.854 3192 TRACE neutron.api.v2.resource
2014-03-31 14:50:47.857 3192 INFO neutron.wsgi 
[req-d20aad3f-d200-484c-b73a-9556efe62386 None] 
112.113.114.115,10.1.1.147 - - [31/Mar/2014 14:50:47] "POST 
/v2.0/networks.json HTTP/1.1" 500 296 0.113226

If I had to guess, I'd say that, based on the above error messages, the 
mysql "neutron.ipallocationpools" table does not exist (checking... 
Nope, it's not there).  Other neutron tables are in the neutron database 
however, just not that one.

I thought Neutron sort of automatically creates tables as needed, I 
wonder why it didn't work here?  Or maybe I'm on the wrong trail?

Any hints would be greatly appreciated!!

-erich