Maria DB Fails on Apt signing key

adleviton · December 7, 2024, 9:50pm

On a new Digital Ocean droplet with Ubuntu 24.04, all apt packages updated, latest version of Trellis, ansible [core 2.14.3] … I’m getting the following error. Anyone have insight?

TASK [mariadb : Add an Apt signing key, uses whichever key is at the URL] ******
fatal: [production_host]: FAILED! => {"changed": false, "msg": "Failed to download key at https://mariadb.org/mariadb_release_signing_key.asc: An unknown error occurred: HTTPSConnection.__init__() got an unexpected keyword argument 'cert_file'"}

strarsis · December 7, 2024, 10:59pm

This appears to be an error with ansible, it should be fixed with a newer ansible version:

github.com/void-linux/void-packages

Ansible get_url does not work

opened 08:23AM - 29 Nov 23 UTC

closed 09:24PM - 02 Dec 23 UTC

jhe2

bug needs-testing

### Is this a new report? Yes ### System Info Void 6.5.11_1 x86_64 AuthenticA…MD uptodate rrmFFFFFFFFFF ### Package(s) Affected ansible-8.0.0_2 ### Does a report exist for this bug with the project's home (upstream) and/or another distro? _No response_ ### Expected behaviour When using the Ansible `get_url` module, the module should fetch the resource at the specified URL. ### Actual behaviour Instead of fetching the URL, it fails with an error message: "An unknown error occurred: HTTPSConnection.__init__() got an unexpected keyword argument 'cert_file'". The `cert_file` argument to `http.client.HTTPSConnection` was dropped in Python 3.12. The problem could possibly be caused by an outdated version of `python3-urllib`, which is used by the `get_url` module. ### Steps to reproduce With Ansible installed, try using the `get_url` module, e.g. ``` ansible -i inventory -m get_url -a '{ "dest": "/tmp", "url": "https://duck.com/"}' localhost ``` This results in the following error: ``` localhost | FAILED! => { "changed": false, "dest": "/tmp", "elapsed": 0, "gid": 0, "group": "root", "mode": "01777", "msg": "An unknown error occurred: HTTPSConnection.__init__() got an unexpected keyword argument 'cert_file'", "owner": "root", "size": 320, "state": "directory", "uid": 0, "url": "https://duck.com/" } ```

adleviton · December 7, 2024, 11:24pm

Thanks @strarsis. My issue now seems to be more about confusion between pip, homebrew, and ansible, since I only update ansible about once a year. I’m on mac and ran brew install ansible (which seems to be the command for both install and update/upgrade?).

I somehow missed and neglected to run brew link --overwrite ansible to actually utilize the latest version. With ansible 2.18 installed AND linked, I was able to complete the mariadb task.