creating multiple databases with same db username is not possible with puppet-openstacklib

[Venkata Mahesh Jonnalagadda]

creating multiple databases with same db username is not possible with puppet-openstacklib

I am trying to create multiple databases "designate" & "designate_pool_manager" with single db username in designate fuel plugin with multiple classes (mysql & mysql_pool_manager) and these classes make use of puppet-openstacklib (::openstacklib::db::mysql).

Due to this limitation, getting below error -

2016-08-10 11:34:43 +0000 Puppet (err): Duplicate declaration: Mysql_user[designate@localhost] is already declared in file /etc/puppet/modules/openstacklib/manifests/db/mysql/host_access.pp:33; cannot redeclare at /etc/puppet/modules/openstacklib/manifests/db/mysql/host_access.pp:33 on node node-8.domain.tld

It would be better, if puppet-openstacklib supports single db username for multiple databases for a openstack service. This needs to be fixed.

[zhouxing (melodyzhou)]

this problem has been fixed in related-bug: https://bugs.launchpad.net/tripleo/+bug/1649341
core code: reference links : https://review.openstack.org/#/c/409948/10/manifests/db/mysql_api.pp@72

[Venkata Mahesh Jonnalagadda (vj884x)]

zhouxing, gerrit review link provided is a fix done on puppet-nova, which is no way related to this bug.

This bug is related to have a single db username for multiple databases for a openstack service. This needs to be fixed in openstacklib.

[zhouxing (melodyzhou)]

with single username , create mysql user when create databse 'designate', and then not create user when create database "designate_pool_manager", cause puppet-openstacklib (::openstacklib::db::mysql)　has create_user and create_grant condition check. so the workround if meet your demand. kinds of regards.

[Venkata Mahesh Jonnalagadda (vj884x)]

Ok

[Takashi Kajinami (kajinamit)]

Now the module allows you to skip creating a user, and I believe this makes this usage possible.

https://review.opendev.org/c/openstack/puppet-openstacklib/+/409945