yahoo-eng-team team mailing list archive

[Csaba Kallai <kallaics@xxxxxxxxxxx>]

Public bug reported:

Hi guys,
U
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.

Please help. Many thanks!

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: fwaas

-- 
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):
  New

Bug description:
  Hi guys,
  U
  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.

  Please help. Many thanks!

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