On Monday, February 26, 2018 at 11:00:57 AM UTC-6, Raja Shekar wrote:
>
>
>
> On Monday, February 26, 2018 at 9:46:50 AM UTC-6, Kai Stian Olstad wrote:
>>
>> On Monday, 26 February 2018 07.15.27 CET Raja Shekar wrote:
>> > - debug: var=groups_out.stdout_lines
>> >
>> > - name: Update the Client Schema
>> > shell: source ~/.bash_profile && sqlplus -S '{{ item.1.groups_out
>> }}/{{
>> > item.2.groups_out }}@{{ item.4.groups_out }}'
>> > @"roles/oracle-sql/files/Scripts/client_hotfix.sql" {{
>> item.0.groups_out }}
>> > sudo: no
>> > with_items: "{{ groups_out.stdout_lines }}"
>> >
>> >
>> > Failing with below error message
>> >
>> > fatal: [10.202.98.198]: FAILED! => {"failed": true, "msg": "The task
>> > includes an option with an undefined variable. The error was: 'unicode
>> > object' has no attribute 'groups_out'\n\nThe error appears to have been
>> in
>> > '/etc/ansible/playbooks/database/roles/oracle-sql/tasks/main.yml': line
>> 57,
>> > column 5, but may\nbe elsewhere in the file depending on the exact
>> syntax
>> > problem.\n\nThe offending line appears to be:\n\n\n - name: Update the
>> > Schema info\n ^ here\n\nexception type: <class
>> > 'ansible.errors.AnsibleUndefinedVariable'>\nexception: 'unicode object'
>> has
>> > no attribute 'groups_out'"}
>>
>> It says item.X.groups_out do not exist.
>> You would need to show you the content of groups_out.stdout_lines
>>
>> g
>> --
>> Kai Stian Olstad
>>
>
> Hello Kai,
>
> Thanks for looking into this. here is the content of
> "groups_out.stdout_lines"
>
> "groups_out.stdout_lines": [
>
> "\"DB_SCHEMA\",\"SYSTEM_USER\",\"SYSTEM_PASSWORD\",\"TNS_NAME\",\"TNS_DESCRIPTION\"",
>
> "\"Client_Schema1\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
> "\"Client_Schema2\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
> "\"Client_Schema3\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
> "\"Client_Schema4\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
> "\"Client_Schema5\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
> "\"Client_Schema6\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
> ]
> }
>
and also I updated the code now
---
- name: Run sqlplus command on {{ Shared DB }}
shell: source ~/.bash_profile && sqlplus -S '{{ SharedDB_username }}/{{
SharedDB_password }}@{{ SharedDB_database_host }}:1521/{{
SharedDB_service_name }}'
@"/etc/ansible/playbooks/database/roles/oracle-sql/files/final_query.sql"
delegate_to: localhost
tags: clientSchema
- name: Run powershell script
script: files/DecryptCsv.ps1 -InputFilePath '{{ input_csv_path }}' \
-OutputFilePath '{{ output_csv_path }}' \
-PassPhrase '{{ pass_phrase }}' \
-SaltValue '{{ salt_value }}' \
-PasswordIterations {{ password_iterations }} \
-InitVector '{{ init_vector }}'
delegate_to: localhost
tags: clientSchema
- name: get CSV File Content
shell: source ~/.bash_profile && awk -F',' '!/^#/ && !/^$/ { print }'
"{{ output_csv_path }}"
register: groups_out
delegate_to: localhost
- debug: var=groups_out.stdout_lines
- name: Update the Client Schema
shell: source ~/.bash_profile && sqlplus -S '{{ item.1 }}/{{ item.2
}}@{{ item.4 }}' @"roles/oracle-sql/files/Scripts/client_hotfix.sql" {{
item.0 }}
with_items: "{{ groups_out.stdout_lines }}"
delegate_to: localhost
And getting below Output
> TASK [oracle-sql : Run sqlplus command on SharedDB]
>> ****************************************************************************************
>
> Monday 26 February 2018 16:43:11 -0600 (0:00:00.186) 0:00:00.186
>> *******
>
> changed: [10.202.98.146 -> localhost]
>
>
>> TASK [oracle-sql : Run powershell script]
>> ******************************************************************************************************************
>
> Monday 26 February 2018 16:43:12 -0600 (0:00:01.067) 0:00:01.254
>> *******
>
> changed: [10.202.98.146 -> localhost]
>
>
>> TASK [oracle-sql : get CSV File Content]
>> *******************************************************************************************************************
>
> Monday 26 February 2018 16:43:14 -0600 (0:00:01.524) 0:00:02.778
>> *******
>
> changed: [10.202.98.146 -> localhost]
>
>
>> TASK [oracle-sql : debug]
>> **********************************************************************************************************************************
>
> Monday 26 February 2018 16:43:14 -0600 (0:00:00.241) 0:00:03.019
>> *******
>
> ok: [10.202.98.146 -> localhost] => {
>
> "groups_out.stdout_lines": [
>
>
>> "\"DB_SCHEMA\",\"SYSTEM_USER\",\"SYSTEM_PASSWORD\",\"TNS_NAME\",\"TNS_DESCRIPTION\"",
>
>
>> "\"Client_Schema1\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> Client_Schema DB_Schema
>
>
>> "\"Client_Schema2\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
>
>> "\"Client_Schema3\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
>
>> "\"Client_Schema4\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
>
>> "\"Client_Schema5\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
>
>> "\"Client_Schema6\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>
> ]
>
> }
>
>
>> TASK [oracle-sql : Update the Client Schema]
>> ***************************************************************************************************************
>
> Monday 26 February 2018 16:43:14 -0600 (0:00:00.052) 0:00:03.072
>> *******
>
> failed: [10.202.98.146 -> localhost]
>> (item="DB_SCHEMA","SYSTEM_USER","SYSTEM_PASSWORD","TNS_NAME","TNS_DESCRIPTION")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'D/B@S'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.004017", "end": "2018-02-26 16:43:14.830389", "failed": true,
>> "item":
>> "\"DB_SCHEMA\",\"SYSTEM_USER\",\"SYSTEM_PASSWORD\",\"TNS_NAME\",\"TNS_DESCRIPTION\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:14.826372", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> failed: [10.202.98.146 -> localhost]
>> (item="Client_Schema1","user","password","TNS_NAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sandbox1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'C/l@e'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.003745", "end": "2018-02-26 16:43:15.008136", "failed": true,
>> "item":
>> "\"Client_Schema1\",\"user\",\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:15.004391", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> failed: [10.202.98.146 -> localhost]
>> (item="Client_Schema2","user","password","TNS_NAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sandbox1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'C/l@e'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.003985", "end": "2018-02-26 16:43:15.184393", "failed": true,
>> "item":
>> "\"Client_Schema2\",\"user\",\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:15.180408", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> failed: [10.202.98.146 -> localhost]
>> (item="Client_Schema3","user","password","TNS_NAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sandbox1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'C/l@e'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.003499", "end": "2018-02-26 16:43:15.359487", "failed": true,
>> "item":
>> "\"Client_Schema3\",\"user\",\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:15.355988", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> failed: [10.202.98.146 -> localhost]
>> (item="Client_Schema4","user","password","TNS_NAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sandbox1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'C/l@e'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.003757", "end": "2018-02-26 16:43:15.533251", "failed": true,
>> "item":
>> "\"Client_Schema4\",\"user\",\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:15.529494", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> failed: [10.202.98.146 -> localhost]
>> (item="Client_Schema5","user","password","TNS_NAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sandbox1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'C/l@e'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.003864", "end": "2018-02-26 16:43:15.709202", "failed": true,
>> "item":
>> "\"Client_Schema5\",\"user\",\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:15.705338", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> failed: [10.202.98.146 -> localhost]
>> (item="Client_Schema6","user","password","TNS_NAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sandbox1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))")
>>
>> => {"changed": true, "cmd": "source ~/.bash_profile && sqlplus -S 'C/l@e'
>> @\"roles/oracle-sql/files/Scripts/client_hotfix.sql\" \"", "delta":
>> "0:00:00.003533", "end": "2018-02-26 16:43:15.880787", "failed": true,
>> "item":
>> "\"Client_Schema6\",\"user\",\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
>>
>> "msg": "non-zero return code", "rc": 1, "start": "2018-02-26
>> 16:43:15.877254", "stderr": "/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'\n/bin/bash: -c: line 1: syntax error: unexpected
>> end of file", "stderr_lines": ["/bin/bash: -c: line 0: unexpected EOF while
>> looking for matching `\"'", "/bin/bash: -c: line 1: syntax error:
>> unexpected end of file"], "stdout": "", "stdout_lines": []}
>
> to retry, use: --limit @/home/user/.ansible/oracle_sql.retry
>
>
>
For some reason it's thinking that Item.0 as 1st position of line and
item.1 as second position of line. I am looking more like DB_SCHEMA as
item.0, SYSTEM_USER as item.1 and so on......
Am I doing something wrong here? and also Is that possible I can ignore
line 1 which contains Field information?
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/f6102f3d-340f-46ae-9546-61e134e9397d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
