On 5/13/21 12:05 PM, ystk hmsk wrote:
> Hi, dick
> Thanks for reply.
>
> I'm sorry, I might be wrong.
> I checked the ansible job message again, and it was oracle error.
> The parameter "OracleHomeUserPassword" and variable was in install.rsp file
> made by ansible.
> But when specific character "#" in the password was passed to the setup.exe
> of oracle installer, it failure.
>
> So, I wrote , adding double quate to install.rsp.j2 like below.
> And I'll try.
> oracleHomeUserPassword="{{ oracle_home_user_password| escape() }}" #
> double quate
> or
> oracleHomeUserPassword=""{{ oracle_home_user_password| escape() }}"" #
> double quate x2
> or
> oracleHomeUserPassword='{{ oracle_home_user_password| escape() }}' #
> single quate
> or
> oracleHomeUserPassword=''{{ oracle_home_user_password| escape() }}'' #
> single quate x2
> or other.
>
> It'll take for a little time.
> I'll share the result later.
> So this is only related to Ansible when you know how the specific characters are supposed to escaped in the configuration file. The escape filter is meant to apply to HTML strings: https://jinja.palletsprojects.com/en/3.0.x/templates/#jinja-filters.escape Regards Racke > Thanx > > > > 2021年5月13日木曜日 18:18:52 UTC+9 [email protected]: > > what does "it failed" mean? > > - ansible run fails? > - ansible runs OK but batch file fails? > - ?? > > is the install.rsp file OK? > > > On Thu, 13 May 2021 at 10:06, ystk hmsk <[email protected]> wrote: > > > > I'm using ansible tower. > > And I made workflow to install Oracle on the virtual server. > > > > The way to install oracle is ... > > 1. copy Oracle installer.exe file to the virtual server. > > > > 2. make response file(install.rsp.j2 jinjer2 template) on the virtual > server. > > install.rsp includes below > > > > OracleHomeUserPassword={{ oracle_home_user_password }} > > > > and oracle_home_user_password is passed from inventory > > > > 3. make install command bat file(run.bat.j2 jinjer2 template) on the > virtual server. > > run.bat is below > > setup.exe -silent -noconfig -waitforcompletion -nowait -responseFile > C:\Work\db_install.rsp > > > > 4. run.bat on the virtual server. > > > > It always worked, but one day it failed. > > It was because password included specific characters like "$", "#","%" > .... > > > > I thought that variable oracle_home_user_password in inventory or jinjer2 must be escaped but I don't know. > > > > I tried these... > > 1) In install.rsp.j2 , > > OracleHomeUserPassword={{ oracle_home_user_password | escape }} > > 2) in install.rsp.j2, > > OracleHomeUserPassword={{ oracle_home_user_password| regex_escape }} > > 3) In install.rsp.j2 , > > OracleHomeUserPassword={{ oracle_home_user_password | escape() }} > > 4) in install.rsp.j2, > > OracleHomeUserPassword={{ oracle_home_user_password| regex_escape() }} > > > > They were all failed.......(T_T > > > > Anyone know how to escape specific character in jinjer2 or any other > better way? > > > > -- > > 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 view this discussion on the web visit > > https://groups.google.com/d/msgid/ansible-project/2ed855a4-14ec-48a1-b741-e4f4c2f55cfen%40googlegroups.com > > <https://groups.google.com/d/msgid/ansible-project/2ed855a4-14ec-48a1-b741-e4f4c2f55cfen%40googlegroups.com>. > > > > -- > Dick Visser > Trust & Identity Service Operations Manager > GÉANT > > -- > 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] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/e0e1f712-da67-4fcc-b156-ef9b82a7ad77n%40googlegroups.com > <https://groups.google.com/d/msgid/ansible-project/e0e1f712-da67-4fcc-b156-ef9b82a7ad77n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- Ecommerce and Linux consulting + Perl and web application programming. Debian and Sympa administration. Provisioning with Ansible. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/aecf885c-30c3-736a-0485-deac5d716325%40linuxia.de.
OpenPGP_signature
Description: OpenPGP digital signature
