Hello,
Yes my task is this :
- name: "Execut script python"
shell: ./myscript.py
delegate_to: localhost
I want to get statut of my command line in my script for get message error.
Thanks very much Community Ansible :)
Best Regards,
Karther
Le mardi 28 janvier 2020 17:54:58 UTC+1, Stefan Hornburg (Racke) a écrit :
>
> On 1/28/20 5:13 PM, Karther wrote:
> > Hello Varsha,
> >
> > For exemple if in my script sql "real.sql" there is commande line toto
> > I have this error :
> >
> > Traceback (most recent call last):
> > File "./script_sql_4.py", line 19, in <module>
> > cur.execute(f.read().decode('utf-8'))
> > File "/usr/lib/pymodules/python2.7/pymssql.py", line 196, in execute
> > raise OperationalError, e[0]
> > pymssql.OperationalError: SQL Server message 2812, severity 16, state
> 62, line 1:
> > Could not find stored procedure 'toto'.
> > DB-Lib error message 2812, severity 16:
> > General SQL Server error: Check messages from the SQL Server
> >
> >
> > I want get statut of my command
> "*cur.execute(f.read().decode('utf-8'))*" in python after this command is
> execute
> > for after get log message error with this value.
>
> So you want the error message from your script in your Ansible playbook?
> How does your task looks like right now?
>
> Regards
> Racke
>
>
> >
> > Someone have any idea please ?
> >
> > Thanks very much Community Ansible !! :)
> >
> > Best Regards,
> >
> >
> > Le mardi 28 janvier 2020 12:33:03 UTC+1, P. Varsha a écrit :
> >
> > can you please share what actually error log you are getting.
> >
> > On Tue, Jan 28, 2020 at 4:13 PM Karther <ryadmo...@gmail.com
> <javascript:>> wrote:
> >
> > Hello,
> >
> > I have one script python script.py with this content :
> >
> > *#!/usr/bin/python*
> > *
> > *
> > *import pymssql*
> > *
> > *
> > *conn = pymssql.connect(host="ihospisql02", user="sa_ofs",
> password="#Adm!n0fS1", database="my_database")*
> > *cur = conn.cursor()*
> > *
> > *
> > *with open('real.sql') as f:*
> > * cur.execute(f.read().decode('utf-8'))*
> > * conn.commit()*
> > *
> > *
> > *cur.close()*
> >
> >
> >
> > i want that when i execut this script in ansible, i have log
> error in file or windows if there is error in this
> > script ?
> >
> > Can you help me please ?
> >
> > Thanks very much guy !!
> >
> > Best Regards,
> >
> > Karther
> >
> > --
> > 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 ansible...@googlegroups.com
> > <javascript:>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/f6435c57-b9f1-4f7b-9a7d-4209cbac5f0f%40googlegroups.com
>
> > <
> https://groups.google.com/d/msgid/ansible-project/f6435c57-b9f1-4f7b-9a7d-4209cbac5f0f%40googlegroups.com?utm_medium=email&utm_source=footer>.
>
>
> >
> > --
> > 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
> > ansible...@googlegroups.com <javascript:> <mailto:
> ansible-project+unsubscr...@googlegroups.com <javascript:>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/38aa9485-37df-4b9b-872c-9befad489b08%40googlegroups.com
>
> > <
> https://groups.google.com/d/msgid/ansible-project/38aa9485-37df-4b9b-872c-9befad489b08%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 ansible-project+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/75211581-5901-45e1-823b-2de1ec25f80c%40googlegroups.com.
