yahoo-eng-team team mailing list archive

[Sergey Vilgelm <svilgelm@xxxxxxxxxxxx>]

** Changed in: neutron
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1463830

Title:
  FWaaS has a missing table

Status in OpenStack Neutron (virtual network service):
  Invalid

Bug description:
  Hi guys,

  I Installed under Openstack Kilo the FWaaS. I am using the offical Ubuntu cloud repository. Every component is on the latest version.
  I configure everything and I added rules, and I assigned to policy, but I can not create a firewall on horizon and CLI as well.

  I checked, the neutron-server.log and it was the result:

  2015-06-10 15:05:49.114 10628 TRACE neutron.api.v2.resource     raise errorclass, errorvalue
  2015-06-10 15:05:49.114 10628 TRACE neutron.api.v2.resource ProgrammingError: (ProgrammingError) (1146, "Table 'neutron.firewall_router_associations' doesn't exist") 'SELECT firewall_router_associations.router_id AS firewall_router_associations_router_id \nFROM firewall_router_associations \nWHERE firewall_router_associations.router_id IN (%s) AND firewall_router_associations.fw_id IS NOT NULL' ('30d71169-18ff-4c88-8a7b-e0521549c067',)

  It seems be missing the firewall_router_associations  table from neutron db.
  I tried to neutron-manage-db command upgrade the db (with upgrade head argument), but it not solved the problem.

  I checked it manually and it doesn't exist in the db.

  Please help. Many thanks!

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1463830/+subscriptions