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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp