← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1435873] [NEW] Debian - Openstack IceHouse - Neutron Error 1054, "Unknown column 'routers.enable_snat'

 

Public bug reported:

Im French my english is bad,

So im on Debian Wheezy 7 and Openstack IceHouse

I followed these tutorials :

• https://fosskb.wordpress.com/2014/06/02/openstack-icehouse-on-debian-
wheezy-single-machine-setup/comment-page-1/#comment-642

• http://docs.openstack.org/juno/install-guide/install/apt-debian
/openstack-install-guide-apt-debian-juno.pdf

And when i arrived on router configuration i have Error, when i try to
create router with this command : neutron router-create demo-router

I have "Request Failed: internal server error while processing your
request."

and when i show the log in /var/log/neutron-server.log i have this :

TRACE neutron.api.v2.resource OperationalError: (OperationalError)
(1054, "Unknown column 'routers.enable_snat' in 'field list'") 'SELECT
count(*) AS count_1 \nFROM (SELECT routers.tenant_id AS
routers_tenant_id, routers.id AS routers_id, routers.name AS
routers_name, routers.status AS routers_status, routers.admin_state_up
AS routers_admin_state_up, routers.gw_port_id AS routers_gw_port_id,
routers.enable_snat AS routers_enable_snat \nFROM routers \nWHERE
routers.tenant_id IN (%s)) AS anon_1'
('8348602c43c44c63b5f161a404afe1da',)


ANY ONE CAN HELP ME PLEASE

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: debian error icehouse neutron openstack routers

** Attachment added: "error in log"
   https://bugs.launchpad.net/bugs/1435873/+attachment/4354510/+files/Capture.JPG

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

Title:
  Debian - Openstack IceHouse - Neutron Error 1054, "Unknown column
  'routers.enable_snat'

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Im French my english is bad,

  So im on Debian Wheezy 7 and Openstack IceHouse

  I followed these tutorials :

  • https://fosskb.wordpress.com/2014/06/02/openstack-icehouse-on-
  debian-wheezy-single-machine-setup/comment-page-1/#comment-642

  • http://docs.openstack.org/juno/install-guide/install/apt-debian
  /openstack-install-guide-apt-debian-juno.pdf

  And when i arrived on router configuration i have Error, when i try to
  create router with this command : neutron router-create demo-router

  I have "Request Failed: internal server error while processing your
  request."

  and when i show the log in /var/log/neutron-server.log i have this :

  TRACE neutron.api.v2.resource OperationalError: (OperationalError)
  (1054, "Unknown column 'routers.enable_snat' in 'field list'") 'SELECT
  count(*) AS count_1 \nFROM (SELECT routers.tenant_id AS
  routers_tenant_id, routers.id AS routers_id, routers.name AS
  routers_name, routers.status AS routers_status, routers.admin_state_up
  AS routers_admin_state_up, routers.gw_port_id AS routers_gw_port_id,
  routers.enable_snat AS routers_enable_snat \nFROM routers \nWHERE
  routers.tenant_id IN (%s)) AS anon_1'
  ('8348602c43c44c63b5f161a404afe1da',)

  
  ANY ONE CAN HELP ME PLEASE

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


Follow ups

References