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
ttaprxy1@16.16.16.16" viljpat1@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
ttaprxy1@16.16.16.16" viljpat1@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
ttaprxy1@16.16.16.16" viljpat1@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
ttaprxy1@16.16.16.16" viljpat1@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
ttaprxy1@16.16.16.16" viljpat1@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
ttaprxy1@16.16.16.16" viljpat1@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}}"

-- 
You received this message because you are subscribed to the Google Groups 
"Ansible Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ansible-devel+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-devel/CADUGrc82Zm6DVk8czh1aBDHemiQYvhK-3p58FsT6%3DQcqNDpVeA%40mail.gmail.com.

Reply via email to