Hi Mark :

I have read further on external-mariadb-guide.html .

if setting  "use_preconfigured_databases = yes" and  and "use_common_mariadb_user = yes " , 

people has to create the " new fresh " DB (nova , glance ,keystone etc) manually  .

the more openstack serivces  enabled , the more databases have to be created .

so why people will want to create the " new fresh " DB manually  rather than letting kolla-ansible to do it ?

what would be this case ?

IMHO, the blueprint (https://blueprints.launchpad.net/kolla-ansible/+spec/external-mariadb-support) maybe more likely to be:

people create ready-to-use mysql account , and apply  the mysql address/account  to  kolla-ansible , 

then kolla-ansible use  it as  a common user across databases

在 2020-09-02 16:35:24，"Mark Goddard" <mark@stackhpc.com> 写道：

On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh@126.com> wrote:

Hi list:

I want to use kolla-ansible to deploy openstack , but using external mysql. 

I am following these docs:  

https://docs.openstack.org/kolla-ansible/latest/user/quickstart.html

https://docs.openstack.org/kolla-ansible/latest/reference/databases/external-mariadb-guide.html.

Hi, could you start by telling us which version or branch of Kolla Ansible you are using?

I have some questions:

################

##  Question 1 ##

################

 According to the offical doc , if setting it  in inventory file(multinode), 

kolla-ansible -i ./multinode deploy will throw out error:

I guest when kolla-ansible running the playbook against myexternalmariadbloadbalancer.com , 

the """register: find_custom_fluentd_inputs""" in """TASK [common : Find custom fluentd input config files]"""  maybe null .

I think this could be an issue with a recent change to the common role, where the condition for the 'Find custom fluentd input config files' task changed slightly. I have proposed a potential fix for this, could you try it out and report back? https://review.opendev.org/749463

################

##  Question 2 ##

################

 According to the offical doc , If the MariaDB username is not root, set database_username in /etc/kolla/globals.yml file:  

But in kolla-ansible/ansible/roles/xxxxxx/tasks/bootstrap.yml  , they use  ''' login_user: "{{ database_user }}"  ''' ， for example :

You are correct, this is an issue in the documentation. I have proposed a fix here: https://review.opendev.org/749464

 

So at last  , I took the following steps:

1. """not""" setting [mariadb] in inventory file(multinode)   

2. set "database_user: openstack" for  "privillegeduser"

PS: 

My idea is that if using an external ready-to-use mysql (cluster),  

it is enough to tell kolla-ansible only the address/user/password of the external DB.

i.e. setting them in the file /etc/kolla/globals.yml and passwords.yml , no need to add it into inventory file(multinode)   

I agree, I did not expect to need to change the inventory for this use case.

Finally , it is successful to  deploy openstack via kolla-ansible . 

So far I have not found any problems.   

 Are the steps what I took  good ( enough ) ? 

Thank you !