trove user-delete API can use periods in user names in fact

Bug #1652889 reported by liuqing
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Fix Released
Undecided
liuqing

Bug Description

In the Users(user) delete user API: "DELETE /v1.0/{accountId}/instances/{instanceId}/users/{name}", the details describe as follows:

"Do not use periods in user names. A bug in a Python library that Rackspace uses that can cause incorrect user deletions to occur if you use a period (.) in the user name. In this case, the bug in the library truncates the user name to the portion from the beginning up to the period. For example, for the my.userA user, the bug truncates the user name to my, and if the user exists, that user is incorrectly deleted."

However, I can create and delete a user named "mytest.abc" correctly both with mysql-5.6 and mongodb-3.0, not as the details describe.

In addition, in order to create a mongodb database user in trove, its format must be as "DBName.UserName". And, I can delete the users correctly!

So, I think maybe the bug mentioned as the details describe above has been fixed, and the tip paragraph should be removed from the API details.

-----------------------------------
Release: 7.0.0.0b3.dev30 on 'Mon Dec 26 18:17:36 2016, commit 7275349'
SHA:
Source: http://git.openstack.org/cgit/openstack/trove/tree/api-ref/source/index.rst
URL: http://developer.openstack.org/api-ref/database/

Tags: api-ref
liuqing (liuqing123)
Changed in trove:
assignee: nobody → liuqing (liuqing123)
liuqing (liuqing123)
Changed in trove:
status: New → In Progress
liuqing (liuqing123)
description: updated
description: updated
liuqing (liuqing123)
summary: - make corrections: trove user-delete API can use periods in user names
+ trove user-delete API can use periods in user names in fact
liuqing (liuqing123)
description: updated
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/416163

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/416163
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=0427f2ef00024fa0cc9235b07541b4e8bf887282
Submitter: Jenkins
Branch: master

commit 0427f2ef00024fa0cc9235b07541b4e8bf887282
Author: liuqing <email address hidden>
Date: Tue Jan 3 15:10:05 2017 +0800

    Trove user-delete API can use periods in user names in fact

    I can create and delete a user named "mytest.abc" correctly both
    with mysql-5.6 and mongodb-3.0, not as the details describe that
    "Do not use periods in user names".

    In addition, in order to create a mongodb database user in trove,
    its format must be as "DBName.UserName". And, I can delete the users correctly!

    Closes-Bug: #1652889
    Change-Id: I2316943475b0bcfdb498733e221d2021b8a827a0

Changed in trove:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/trove 8.0.0.0b3

This issue was fixed in the openstack/trove 8.0.0.0b3 development milestone.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.