na...@vn.fujitsu.com wrote:

Hi everyone,

I am trying to fix a bug that created two subnets on *one* network with
overlap CIDR [1]. My solution is to focus on Database interaction [2].

I am encountering/facing a problem with Postgresql
(There is no problem with MySQL).

For Postgresql, I used a feature called GiST that I strong believe
it can fix this bug. However, this feature needs to be created
an extension "btree_gist" that we have to need "root" permission.
In my point of view, we cannot do this on Neutron
because it only has normal user permission.

Currently, There are two ways that may be fix this issue in my opinion:

1. I will try to find a solution to let Neutron can create an extension
in Postgresql with normal user. But I'm not sure about this yet.

2. I will try to implement a create an extension "btree_gist" during
Postgresql Database setting up when deploying OpenStack.
If so, an "Installation Guide" section must be included.

How do you think about that or do you have any advice?
Any help is very appreciated!

[1] https://bugs.launchpad.net/neutron/+bug/1532695
[2] https://review.openstack.org/#/c/314054/

That’s an interesting precedent. I understand that since we gate on postgresql and mysql only, the solution is good enough to pass in the gate. But are we ok fixing a bug just for those two backends, knowing that it’s left exposed for other backends? Could you think of a solution that would be backend agnostic?

Ihar

__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to