Open Stack

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 at stackhpc.com> 写道：





On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh at 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 !



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/5763151d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 2938 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/5763151d/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 95768 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/5763151d/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 2508 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/5763151d/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 22016 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/5763151d/attachment-0007.png>