If you wanted to do it purely with an SQL hack you might be able to set distributed to False in the router_extra_attributes table. Additionally you would need to delete any entries from the routerports table with the type 'network:router_centralized_snat' and update any with the type 'network:router_interface_distributed' to 'network:router_interface'. You'll want to do that while all of the L3 and L2 agents are offline. Then delete all of the router namespaces using the netns cleanup tool and restart the agents. That *might* do the trick, but I haven't tested this any time recently so unfortunately I can't guarantee that it will be enough. :/ On Wed, Sep 20, 2017 at 6:12 AM, Turbo Fredriksson <turbo at bayour.com> wrote: > On 18 Sep 2017, at 21:19, Turbo Fredriksson <turbo at bayour.com> wrote: > > > No way I can convince someone to do it, for a (small) monetary donation? > > No-one? > > > Any SQL query hack I could use to get rid of it? > > _______________________________________________ > Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/ > openstack > Post to : openstack at lists.openstack.org > Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/ > openstack > > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack/attachments/20170920/5e2d2ea3/attachment.html>