sync openstack-common cookbook from upstream 9.6.1

We require some changes for trove:
- proper endpoint path
- storing passwords as attributes
Merge pull request #6 from mapleoin/update-common-to-9-6-1

sync openstack-common cookbook from upstream 9.6.1