owncloud-ansible / playground Goto Github PK

Restructure:

• remove distribution references from inventories, to avoid confusion
• rename ubuntu-minimal to minimal
• find other uses for other inventories, e.g suse to wnd-example

Documentation

• clearly state that this an example repo
• explain the different inventories their goal and usage

These PRs, please change them into PRs on docs:
#7
#8
#11

Let me know if you need help with that.

we are using ubuntu-minimal on:
ubuntu 22.04
php reverted to 7.4. a
mariadb 10.6.12

TASK [mariadb : Ensure MariaDB users are present]

failed: [db1] (item=owncloud) => {"ansible_loop_var": "item", "changed": false, "item": {"host": "localhost", "name": "owncloud", "password": "owncloud", "priv": "owncloud.:ALL"}, "msg": "Error granting privileges, invalid priv string: ALL , params: ('', 'localhost'), query: GRANT ALL ON *****. TO %s@%s , exception: (1044, "Access denied for user 'root'@'localhost' to database '***'")."}

We fixed it by adding state = present to database.yml inside of the inventory

we are using ubuntu-minimal on:
ubuntu 22.04
php reverted to 7.4.
mariadb 10.6.12

TASK [mariadb : Get list of hosts for the root user]

fatal: [db1]: FAILED! => {"changed": false, "cmd": ["/usr/bin/mysql", "-NBe", "SELECT Host FROM mysql.user WHERE User = 'root' ORDER BY (Host='localhost') ASC"], "delta": "0:00:00.012417", "end": "2023-02-28 15:25:21.588737", "msg": "non-zero return code", "rc": 1, "start": "2023-02-28 15:25:21.576320", "stderr": "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)", "stderr_lines": ["ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"], "stdout": "", "stdout_lines": []}

We worked around it by setting the root password for mariadb to empty.

To be able to test ownCloud's ansible scripts, I've got a local Vagrant setup with "ansible_local".

Would it make sense to check these in as it could help other people to get more quickly setup for developing and testing ?

With #1 I've added the following config file locally ansible.cfg:

[defaults]
fact_caching = jsonfile
fact_caching_connection = /tmp/ansible-facts
fact_caching_timeout = 86400

I did see in the log that this is being used.

However after provisioning there are no mentions of Apache or PHP inside the cached JSON files.
And the only mention of ownCloud is for bits of config.php.

So the provisioning is still very slow. This is cumbersome when testing configurations settings as it takes a while to get results.

@xoxys

we are using ubuntu-minimal on:
ubuntu 22.04
php reverted to 7.4.
mariadb 10.6.12

TASK [mariadb : Ensure dependencies are installed]

failed: [db1] (item=centos-release-scl) => {"ansible_loop_var": "item", "changed": false, "item": "centos-release-scl", "msg": "No package matching 'centos-release-scl' is available"}

removing centos-release-scl from database.yml seems to fix this issue