Error when trying to initialize the DB

[geerlingguy]

Error when trying to initialize the DB

[jbilbro]

Ah, this was my bad. I misunderstood the line in sudoers.

I had:

devops ALL=NOPASSWD: ALL

but needed:

devops ALL=(ALL) NOPASSWD: ALL

to allow the devops user to run any command as any user instead of just as root.

[geerlingguy]

It's saying your sudo use requires a password, so you'll need to supply the ansible remote user's sudo password when you run your playbook, e.g. by setting the --ask-become-pass (-K for short) flag on the command line. Then when you run the playbook, it will prompt you for your sudo password.

[jbilbro]

The confusing part is the user I'm running this as has full sudo with nopasswd and all other tasks before this run with no problems.

[jbilbro]

When I try with a sudo password for the remote_user I get the following error:

TASK [geerlingguy.postgresql : Ensure PostgreSQL databases are present.] *******
failed: [dc1-devops-db] (item={u'name': u'bamboo_db'}) => {"failed": true, "item": {"name": "bamboo_db"}, "module_stderr": "Sorry, user devops is not allowed to execute '/bin/sh -c echo BECOME-SUCCESS-ikltotafdcrssvxqdvbfruhgrxbsdgmf; /usr/bin/python' as postgres on dc1-devops-db.domain.com.\n", "module_stdout": "", "msg": "MODULE FAILURE"}

Note, if I SSH to the host as the remote_user and run sudo I am not prompted for a password.

[geerlingguy]

@jbilbro hmm... you may be running into ansible/ansible#16048

[geerlingguy]

Great! Closing for now, then.