sync openstack-common cookbook from upstream 9.6.1

We require some changes for trove:
- proper endpoint path
- storing passwords as attributes