Skip to content

Design flaw in mysql database password changing #2542

@jvonau

Description

@jvonau

Required reading:
https://docs.ansible.com/ansible/latest/modules/mysql_db_module.html
https://docs.ansible.com/ansible/latest/modules/mysql_user_module.html

The setup.yml in a role is where the passwords should be changed but setup.yml are now being called from within install.yml but were not prior to:

  1. f5180d9#diff-a45913a4ffde64b946e0db1c03591a25 for nextcloud Jan 29, 2020
  2. 0278328#diff-1460b7c549aa9ce1a2a72a38aed3cd65 for elgg Feb 4. 2020
  3. mediawiki lacks setup.yml
  4. wordpress has setup.yml in its main.yml

I believe these efforts above were pushed at that time to purposely suppress or attempt to sabotage my #1937 pi-gen branch work opened on Aug 25, 2019 then continuity updated with #2254 -> #2381 -> #2503 to stay current with master.

There is no easy way to update the passwords post-install without "reinstalling" the role while wordpress still has setup.yml in main.yml. Now #2503 attempts to bring the same standardization of operations that the *_installed effort has obtaining by:

    • Using setup.yml in the same way across the 4 popular apps above.
    • Ensure mysql is running and records the current running state of mysql.
    • Introduce *_provisioned for use with the setup.yml routines, like install.yml currently has.
    • Introduce the optional ability to suppress the running of setup.yml.

Now the stage is set to be able to more easily change the mysql passwords in the future, and allows any image builder an easy way to accommodate user changing passwords in local_vars on prefabricated images build with 'provision_active True'
at a later point in time.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions