Failed to connect to the host via ssh: /usr/bin/ksh: setfacl: not found

[Balkrushna Kamble]

Hi Team,

Kindly help me out, getting an error on the Aix server. 

error:

TASK [Get DB names on Server] **************************************************

task path: /tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/project/testing_oracle.yml:14

<10.10.10.15> ESTABLISH SSH CONNECTION FOR USER: ansible1

<10.10.10.15> SSH: EXEC ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="ansible1"' -o ConnectTimeout=120 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null '-oProxyCommand=ssh -i $JH2_SSH_PRIVATE_KEY -W %h:%p -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null -oProxyCommand="ssh -i $JH1_SSH_PRIVATE_KEY -W 15.15.15.15.22 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null ttap...@16.16.16.16" vilj...@172.18.134.225' -o ControlPath=/tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/cp/9df9078f38 10.10.10.15 '/bin/sh -c '"'"'echo ~ansible1 && sleep 0'"'"''

<10.10.10.15> (0, '/home/ansible1\\n', '')

<10.10.10.15> ESTABLISH SSH CONNECTION FOR USER: ansible1

<10.10.10.15> SSH: EXEC ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="ansible1"' -o ConnectTimeout=120 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null '-oProxyCommand=ssh -i $JH2_SSH_PRIVATE_KEY -W %h:%p -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null -oProxyCommand="ssh -i $JH1_SSH_PRIVATE_KEY -W 15.15.15.15.22 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null ttap...@16.16.16.16" vilj...@172.18.134.225' -o ControlPath=/tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/cp/9df9078f38 10.10.10.15 '/bin/sh -c '"'"'( umask 77 && mkdir -p "` echo /var/tmp `"&& mkdir "` echo /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922 `" && echo ansible-tmp-1679573242.05-7623-246315053334922="` echo /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922 `" ) && sleep 0'"'"''

<10.10.10.15> (0, 'ansible-tmp-1679573242.05-7623-246315053334922=/var/tmp/ansible-tmp-1679573242.05-7623-246315053334922\\n', '')

Using module file /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py

<10.10.10.15> PUT /var/lib/awx/.ansible/tmp/ansible-local-7594JLRh2y/tmp5sQhR5 TO /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py

<10.10.10.15> SSH: EXEC sftp -b - -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="ansible1"' -o ConnectTimeout=120 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null '-oProxyCommand=ssh -i $JH2_SSH_PRIVATE_KEY -W %h:%p -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null -oProxyCommand="ssh -i $JH1_SSH_PRIVATE_KEY -W 15.15.15.15.22 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null ttap...@16.16.16.16" vilj...@172.18.134.225' -o ControlPath=/tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/cp/9df9078f38 '[10.10.10.15]'

<10.10.10.15> (0, 'sftp> put /var/lib/awx/.ansible/tmp/ansible-local-7594JLRh2y/tmp5sQhR5 /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py\\n', '')

<10.10.10.15> ESTABLISH SSH CONNECTION FOR USER: ansible1

<10.10.10.15> SSH: EXEC ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="ansible1"' -o ConnectTimeout=120 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null '-oProxyCommand=ssh -i $JH2_SSH_PRIVATE_KEY -W %h:%p -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null -oProxyCommand="ssh -i $JH1_SSH_PRIVATE_KEY -W 15.15.15.15.22 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null ttap...@16.16.16.16" vilj...@172.18.134.225' -o ControlPath=/tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/cp/9df9078f38 10.10.10.15 '/bin/sh -c '"'"'setfacl -m u:oracle:r-x /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/ /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py && sleep 0'"'"''

<10.10.10.15> (127, '', '/bin/sh: setfacl:  not found.\\n')

<10.10.10.15> Failed to connect to the host via ssh: /bin/sh: setfacl:  not found.

<10.10.10.15> ESTABLISH SSH CONNECTION FOR USER: ansible1

<10.10.10.15> SSH: EXEC ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="ansible1"' -o ConnectTimeout=120 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null '-oProxyCommand=ssh -i $JH2_SSH_PRIVATE_KEY -W %h:%p -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null -oProxyCommand="ssh -i $JH1_SSH_PRIVATE_KEY -W 15.15.15.15.22 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null ttap...@16.16.16.16" vilj...@172.18.134.225' -o ControlPath=/tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/cp/9df9078f38 10.10.10.15 '/bin/sh -c '"'"'chmod u+x /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/ /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py && sleep 0'"'"''

<10.10.10.15> (0, '', '')

<10.10.10.15> ESTABLISH SSH CONNECTION FOR USER: ansible1

<10.10.10.15> SSH: EXEC ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="ansible1"' -o ConnectTimeout=120 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null '-oProxyCommand=ssh -i $JH2_SSH_PRIVATE_KEY -W %h:%p -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null -oProxyCommand="ssh -i $JH1_SSH_PRIVATE_KEY -W 15.15.15.15.22 -oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null ttap...@16.16.16.16" vilj...@172.18.134.225' -o ControlPath=/tmp/bwrap_3251838_yv_2f9qh/awx_3251838_ag26yp92/cp/9df9078f38 10.10.10.15 '/bin/sh -c '"'"'chown oracle /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/ /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py && sleep 0'"'"''

<10.10.10.15> (1, '', 'chown: /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/: Operation not permitted.\\nchown: /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py: Operation not permitted.\\n')

<10.10.10.15> Failed to connect to the host via ssh: chown: /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/: Operation not permitted.

chown: /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py: Operation not permitted.

fatal: [aieaidb08]: FAILED! => {

    "msg": "Failed to set permissions on the temporary files Ansible needs to create when becoming an unprivileged user (rc: 1, err: chown: /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/: Operation not permitted.\\nchown: /var/tmp/ansible-tmp-1679573242.05-7623-246315053334922/AnsiballZ_command.py: Operation not permitted.\\n}). For information on working around this, see https://docs.ansible.com/ansible/become.html#becoming-an-unprivileged-user"

}

My Playbook:

---
	- name: list of hosts
	hosts: "{{ IP_LIST }}"
	gather_facts: false
	tasks:
	- name: Get Database User
	shell: |
	ps -ef|grep ora_pmon | grep -v 'grep'| awk 'NR==1 || /^\/dev/' | awk '{print $1}'
	register: dbuser
	- debug: var=dbuser
	- debug:
	msg: "DBUser:{{dbuser.stdout}}"
	- name: Get DB names on Server
	shell: whoami
	# ps -ef | grep ora_pmon | grep -v grep | awk 'BEGIN{FS="_"}{print $NF}'
	become: yes
	become_user: "{{ dbuser.stdout }}"
	become_method: sudo
	register: dblist
	#when: "'ora' in dbuser.stdout
	- debug:
	msg: "DBList: {{dblist.stdout}}"