Activity log for bug #1652889

Date Who What changed Old value New value Message
2016-12-28 06:46:54 liuqing bug added bug
2016-12-28 07:49:42 liuqing trove: assignee liuqing (liuqing123)
2016-12-29 05:03:52 liuqing trove: status New In Progress
2016-12-29 05:09:12 liuqing description ----------------------------------- 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/ 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 tried to created a user named "mytest.abc" both with mysql-5.6 and mongodb-3.0, and I deleted it correctly using the API: "DELETE /v1.0/{accountId}/instances/{instanceId}/users/{name}", not as the details describe. In addition, in order to create a mongodb database user in trove, its format must be as "DBName.UserName", or it will fail. So, I think maybe the bug mentioned in the details 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/ 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". Also, I can often delete the user 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.
2016-12-29 05:12:06 liuqing description ----------------------------------- 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/ 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". Also, I can often delete the user 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/ 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.
2016-12-29 12:16:01 liuqing 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
2017-01-03 07:22:23 liuqing description ----------------------------------- 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/ 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. 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/
2017-06-17 15:46:15 OpenStack Infra trove: status In Progress Fix Released