Database changes can be scripted in SQL by DBAs. These SQL scripts can be executed from a command line. Good app config mgmt should require this as part of DevSecOps automated deployments and upgrades. It also serves to document changes to tables, indexes, etc. Database server configuration changes also should be scripted and configuration files placed under version control. We use GitLab CI/CD workflows for app deployments. We use ansible for server and infrastructure management.
Walter -- Walter Rowe, Division Chief Infrastructure Services, OISM Mobile: 202.355.4123 On Jan 4, 2023, at 3:27 AM, Norbert Klamann <[email protected]> wrote: Hello all, I use ansible to install software and do the first configuration and i like this very much. But I want to achieve that I can recreate the running systems as detailled as posible from the outside with scripts, with ansible for example. Maybe an example helps to clarify the problem: Consider necxtcloud. The software consists of a webserver, a bunch of php-software and a database. The **configuration** consists of * webserver configuration * php configuration * config.php (nextcloud) * tables in the database The **data** consists of * files in the filesystem * tables in the databas The webserver configuration and the php configuration can be defined in ansible and distributed, no problem there. The configuration tables in the database are changed via the web interface, i don't see a realistic chance to to handle them with ansible at all. The *config.php* can and will be changed via the web interface and If i overwrite the file with ansible I lose all these changes. How do peaople handle this kind of situation ? I try to be disciplined and change the ansible files synchronous to configuration changes on the running system, but I would like to make this process bullet-proof. Any ideas ? Thanks a lot Norbert -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/cc3b974b-3cdc-4d20-9198-9e00b9edfd98n%40googlegroups.com<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2Fcc3b974b-3cdc-4d20-9198-9e00b9edfd98n%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C932d352810c744753e6108daee2d8019%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638084176444101052%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2Bq%2Fjbz3rIH7zDJEak3yd7CfPh2ZOOyEYRKhTZ30qmdI%3D&reserved=0>. -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/9F24B85C-EF83-4B22-BEE9-C59EE0B412D4%40nist.gov.
