Hi Narmada, Seems like you have an exception in the mssql_script module. Can you please try this Python script https://gist.github.com/Akasurde/b848017c027c71e6e5fd80d5f0f01a8b since module is swallowing the exception?
On Thu, Jul 6, 2023 at 11:40 AM Narmada Karthika <[email protected]> wrote: > can some one shower some light here > > On Wednesday, July 5, 2023 at 9:30:23 AM UTC-7 Narmada Karthika wrote: > >> any other details needed? >> >> On Monday, July 3, 2023 at 1:56:09 PM UTC-7 Narmada Karthika wrote: >> >>> pymssql-2.2.7 >>> I am just trying to make a sql connection by checking the connectivity >>> to sql server, if this is successfully I have to get some select and update >>> statements working >>> this is my playbook >>> --- >>> - name: Execute sql commands >>> hosts: localhost >>> gather_facts: false >>> become: true >>> user: root >>> vars_files: >>> - group_vars/mssqlpass.yml >>> tasks: >>> - name: Check DB connection >>> community.general.mssql_script: >>> login_user: "{{ mssql_login_user }}" >>> login_password: "{{ mssql_login_password }}" >>> login_host: "{{ mssql_server }}" >>> login_port: "{{ mssql_port }}" >>> db: dbname >>> script: "SELECT *" >>> >>> On Monday, July 3, 2023 at 1:18:28 PM UTC-7 Abhijeet Kasurde wrote: >>> >>>> Hi Narmada, >>>> >>>> Could you please provide more context like playbooks used, collections >>>> used, modules used, ultimate aim to achieve etc? Without this information, >>>> it is really difficult to debug. >>>> >>>> On Mon, Jul 3, 2023 at 1:07 PM Narmada Karthika <[email protected]> >>>> wrote: >>>> >>>>> Any idea about this error, the username and password are correct those >>>>> are dbo creds. I am able to connect through ssms with the same creds but >>>>> not working through ansible >>>>> also I don't see @sysconfdir@/freetds.conf / ${HOME}/.freetds.conf" >>>>> on my linux node... >>>>> >>>>> >>>>> TASK [Check DB connection] >>>>> ********************************************************************************************************************************************* >>>>> fatal: [localhost]: FAILED! => {"changed": false, "msg": "unable to >>>>> connect, check login_user and login_password are correct, or alternatively >>>>> check your @sysconfdir@/freetds.conf / ${HOME}/.freetds.conf"} >>>>> >>>>> -- >>>>> 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/450d5ff6-1aba-45e3-ab89-555225d3db46n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/ansible-project/450d5ff6-1aba-45e3-ab89-555225d3db46n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Abhijeet Kasurde >>>> >>> -- > 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/5d81367f-380c-41c1-ae4d-092e27fd820cn%40googlegroups.com > <https://groups.google.com/d/msgid/ansible-project/5d81367f-380c-41c1-ae4d-092e27fd820cn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Thanks, Abhijeet Kasurde -- 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/CAFwWkHrYJc%2BB_u7C5TAQFbAheNwvFN1nR7Pd5GnTXBAQofc1Pw%40mail.gmail.com.
