Ask Your Question
0

Devstack + Neutron + Floodlight - ProgrammingError: Table restproxy_neutron.agents does not exist

asked 2013-12-19 11:41:38 -0500

muehsi gravatar image

Hi folks, I am trying to use a Two-Node Setup with Devstack, Neutron and Floodlight - latest release. Floodlight-Controller is running on 172.16.150.6. I tried to install (fresh install) like this tutorial: https://wiki.openstack.org/wiki/Neutron/FloodlightPluginSetup

When using ./stack.sh, I do get the following errors on the controller:

...
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2013-12-19 18:29:49     raise errorclass, errorvalue
2013-12-19 18:29:49 sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1146, "Table restproxy_neutron.agents doesn't exist") 'ALTER TABLE agents ADD CONSTRAINT uniq_agents0agent_type0host UNIQUE (agent_type, host)' ()

This issued from the first ./stack.sh. Full Log: https://gist.github.com/amuessig/8043143 Oviously some MySQL-Error.

Localrc on this Controller:

# localrc for the controller node
MULTI_HOST=true
HOST_IP=172.16.34.11

# add n-novnc if you want to run nova-compute on the controller node too
ENABLED_SERVICES=g-api,g-reg,key,n-api,n-crt,n-obj,n-sch,n-cauth,horizon,mysql,rabbit,sysstat,n-cond,n-novnc,n-xvnc,n-cpu
disable_service c-api c-sch c-vol cinder
enable_service n-vol

disable_service n-net
enable_service q-svc
enable_service q-dhcp
enable_service q-meta
enable_service neutron

Q_PLUGIN=bigswitch_floodlight
BS_FL_CONTROLLERS_PORT=172.16.150.6:8080
Q_OVS_USE_VETH=true

DATABASE_PASSWORD=password
RABBIT_PASSWORD=password
SERVICE_TOKEN=password
SERVICE_PASSWORD=password
ADMIN_PASSWORD=password


#Download ubuntu-Image
IMAGE_URLS="https://cloud-images.ubuntu.com/precise/current/precise-server-cloudimg-amd64-disk1.img"

#Logging

LOGFILE=/opt/stack/logs/stack.sh.log
VERBOSE=True
LOG_COLOR=True
SCREEN_LOGDIR=/opt/stack/logs

Can anyone help me?

edit retag flag offensive close delete

Comments

Has been solved: https://review.openstack.org/#/c/61663

muehsi ( 2013-12-23 07:26:31 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
0

answered 2014-01-10 03:16:48 -0500

MarcoC gravatar image

Hello,

I'm using devstack stable/havana version and I'm downloading stable/havana packages by setting XYZ_BRANCH variables to stable/havana in localrc (e.g. NEUTRON_BRANCH = stable/havana, NOVA_BRANCH = stable/havana, etc...)

I'm not experimenting the problem BUT I've probably found the cause of the problem reported here. When I tried to make a real installation with apt-get etc., I found out that the nuetron DB is created in two steps.

In the first step, when command "neutron-db-manage --config-file $NEUTRON_CONF --config-file /$Q_PLUGIN_CONF_FILE upgrade head" is called by stack.sh, some tables are created. Not all the table that you need, unfortunately. For example this command does NOT create agents table as well as other 10 tables.

Those tables are created by neutron-server daemon when it is called for the first time provided that the daemon receives the following parameters:

--config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini

Hope it helps.

edit flag offensive delete publish link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

Follow
1 follower

Stats

Asked: 2013-12-19 11:41:38 -0500

Seen: 260 times

Last updated: Jan 10