Re: [ansible-project] Execut script with Ansible

Message has been deleted

P. Varsha

unread,

Jan 28, 2020, 6:33:03 AM1/28/20

to ansible...@googlegroups.com

can you please share what actually error log you are getting.

On Tue, Jan 28, 2020 at 4:13 PM Karther <ryadmo...@gmail.com> 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-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/f6435c57-b9f1-4f7b-9a7d-4209cbac5f0f%40googlegroups.com.

Karther

unread,

Jan 28, 2020, 11:13:04 AM1/28/20

to Ansible Project

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.

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> 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.

Stefan Hornburg (Racke)

unread,

Jan 28, 2020, 11:54:58 AM1/28/20

to ansible...@googlegroups.com

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-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.

> 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.

signature.asc

Karther

unread,

Jan 29, 2020, 3:22:59 AM1/29/20

to Ansible Project

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

> ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

Stefan Hornburg (Racke)

unread,

Jan 29, 2020, 4:06:31 AM1/29/20

to ansible...@googlegroups.com

On 1/29/20 9:22 AM, Karther wrote:
> 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.

Please try this (untested):

- name: "Execut script python"
shell: ./myscript.py

register: myscript
delegate_to: localhost
failed_when: false

- debug:
msg: "{{ myscript[stderr_lines] }}"

The failed_when condition is necessary to reach the debug task.

Regards
Racke

> <https://groups.google.com/d/msgid/ansible-project/f6435c57-b9f1-4f7b-9a7d-4209cbac5f0f%40googlegroups.com?utm_medium=email&utm_source=footer

> <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-proje...@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>
> >
> <https://groups.google.com/d/msgid/ansible-project/38aa9485-37df-4b9b-872c-9befad489b08%40googlegroups.com?utm_medium=email&utm_source=footer

> <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-proje...@googlegroups.com <mailto:ansible-proje...@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
> <https://groups.google.com/d/msgid/ansible-project/75211581-5901-45e1-823b-2de1ec25f80c%40googlegroups.com?utm_medium=email&utm_source=footer>.

signature.asc

Karther

unread,

Jan 29, 2020, 4:49:10 AM1/29/20

to Ansible Project

Hello,

Yes this register variable error works but i want to get status of execution of my python programme cur.execute :

I want to know from this programme python if cur.execute is success execute or not ...

#!/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()

Do you understand what i want please Community Ansible ?

Thanks very much

Best Regards,

Karther

> > ansible...@googlegroups.com <javascript:> <mailto:ansible-project+unsub...@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>
> >
> <https://groups.google.com/d/msgid/ansible-project/38aa9485-37df-4b9b-872c-9befad489b08%40googlegroups.com?utm_medium=email&utm_source=footer
> <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...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

Stefan Hornburg (Racke)

unread,

Jan 29, 2020, 4:56:26 AM1/29/20

to ansible...@googlegroups.com

On 1/29/20 10:49 AM, Karther wrote:
> Hello,
>

> Yes this register variable error works but i want to get status of execution of my python programme *cur.execute* :
> I want to know from this programme python if *cur.execute* is success execute or not ...
>

That's up to your script, really. In case *cur.execute* fails it should print the error to STDERR and exit
with exit code != 0.

Regards
Racke

> > > ansible...@googlegroups.com <javascript:> <mailto:ansible-proje...@googlegroups.com <javascript:>

> > ansible...@googlegroups.com <javascript:> <mailto:ansible-proje...@googlegroups.com <javascript:>>.

> > To view this discussion on the web visit

> > https://groups.google.com/d/msgid/ansible-project/75211581-5901-45e1-823b-2de1ec25f80c%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/75211581-5901-45e1-823b-2de1ec25f80c%40googlegroups.com>
> >
> <https://groups.google.com/d/msgid/ansible-project/75211581-5901-45e1-823b-2de1ec25f80c%40googlegroups.com?utm_medium=email&utm_source=footer

> <https://groups.google.com/d/msgid/ansible-project/75211581-5901-45e1-823b-2de1ec25f80c%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-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/ansible-project/dea89776-9310-4911-b266-24db183ac386%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/dea89776-9310-4911-b266-24db183ac386%40googlegroups.com?utm_medium=email&utm_source=footer>.

signature.asc

Reply all

Reply to author

Forward