[PKG-Openstack-devel] Can't get LBaaSv2 to work on Sid

[Thomas Goirand]

On 06/25/2016 03:01 PM, Turbo Fredriksson wrote:
> I get the following when trying to enable LBaaSv2:
> 
> ----- s n i p -----
> 2016-06-25 13:52:22.559 29114 ERROR neutron.service ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'neutron.lbaas_loadbalancers' doesn't exist") [SQL: u'SELECT lbaas_loadbalancers.tenant_id AS lbaas_loadbalancers_tenant_id, lbaas_loadbalancers.id AS lbaas_loadbalancers_id, lbaas_loadbalancers.name AS lbaas_loadbalancers_name, lbaas_loadbalancers.description AS lbaas_loadbalancers_description, lbaas_loadbalancers.vip_subnet_id AS lbaas_loadbalancers_vip_subnet_id, lbaas_loadbalancers.vip_port_id AS lbaas_loadbalancers_vip_port_id, lbaas_loadbalancers.vip_address AS lbaas_loadbalancers_vip_address, lbaas_loadbalancers.provisioning_status AS lbaas_loadbalancers_provisioning_status, lbaas_loadbalancers.operating_status AS lbaas_loadbalancers_operating_status, lbaas_loadbalancers.admin_state_up AS lbaas_loadbalancers_admin_state_up, lbaas_loadbalancers.flavor_id AS lbaas_loadbalancers_flavor_id, lbaas_loadbalancer_statistics_1.loadbalancer_id AS lbaas_loadbalancer
>  _statistics_1_loadbalancer_id, lbaas_loadbalancer_statistics_1.bytes_in AS lbaas_loadbalancer_statistics_1_bytes_in, lbaas_loadbalancer_statistics_1.bytes_out AS lbaas_loadbalancer_statistics_1_bytes_out, lbaas_loadbalancer_statistics_1.active_connections AS lbaas_loadbalancer_statistics_1_active_connections, lbaas_loadbalancer_statistics_1.total_connections AS lbaas_loadbalancer_statistics_1_total_connections, providerresourceassociations_1.provider_name AS providerresourceassociations_1_provider_name, providerresourceassociations_1.resource_id AS providerresourceassociations_1_resource_id \nFROM lbaas_loadbalancers LEFT OUTER JOIN lbaas_loadbalancer_statistics AS lbaas_loadbalancer_statistics_1 ON lbaas_loadbalancers.id = lbaas_loadbalancer_statistics_1.loadbalancer_id LEFT OUTER JOIN providerresourceassociations AS providerresourceassociations_1 ON lbaas_loadbalancers.id = providerresourceassociations_1.resource_id']
> 2016-06-25 13:52:22.559 29114 ERROR neutron.service 
> ----- s n i p -----
> 
> My configuration(s):
> 
> ----- s n i p -----
> bladeA01b:~# grep service_plugins /etc/neutron/neutron.conf
> service_plugins = router,metering,neutron_lbaas.services.loadbalancer.plugin.LoadBalancerPluginv2
> bladeA01b:~# grep ^service_provider /etc/neutron/neutron_lbaas.conf
> service_provider = LOADBALANCERV2:Haproxy:neutron_lbaas.drivers.haproxy.plugin_driver.HaproxyOnHostPluginDriver:default
> bladeA01b:/etc/neutron# grep '^[a-z\[]' /etc/neutron/lbaas_agent.ini
> [DEFAULT]
> device_driver = neutron_lbaas.services.loadbalancer.drivers.haproxy.namespace_driver.HaproxyNSDriver
> interface_driver = neutron.plugins.services.agent_loadbalancer.plugin.LoadBalancerPluginv2
> debug = true
> [haproxy]
> ----- s n i p -----

After you get it installed, and get it configured, you need to do
another database sync:
neutron-db-manage --config-file /etc/neutron/neutron.conf upgrade head

This will create the missing tables.

Cheers,

Thomas Goirand (zigo)