TASK [Check DB connection] ********************************************************************************************************************************************* fatal: [localhost]: FAILED! => {"changed": false, "msg": "unable to connect, chec

[Narmada Karthika]

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"}

[Abhijeet Kasurde]

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.

--
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/450d5ff6-1aba-45e3-ab89-555225d3db46n%40googlegroups.com.

--

Thanks,

Abhijeet Kasurde

[Narmada Karthika]

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 *"

[Narmada Karthika]

any other details needed?

[Narmada Karthika]

can some one shower some light here 

[Abhijeet Kasurde]

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?

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/5d81367f-380c-41c1-ae4d-092e27fd820cn%40googlegroups.com.

--

Thanks,

Abhijeet Kasurde

[Will McDonald]

Is {{ mssql_server }} pointing at:

1. your local machine localhost running SQL Server on Linux directly

2. or a remote machine running SQL Server on Linux

3. or a remote machine running SQL Server on Windows?

If your scenario is #2, have you installed pymssql on the target machine as well as your Ansible control node? (See: https://docs.ansible.com/ansible/latest/collections/community/general/mssql_script_module.html#notes)

If your scenarios is #3, see: https://github.com/ansible/ansible/issues/39612#issuecomment-597451375 (This is a different Ansible module but it's using the same Python under the covers.)

You might get more help if you can provide proper output (with passwords redacted) of an actual run with -v[vv], the inventory and as much more information as you possibly can.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/5d81367f-380c-41c1-ae4d-092e27fd820cn%40googlegroups.com.

[Narmada Karthika]

Thank you so much, I am able to fix the issue..   If your scenarios is #3, see: https://github.com/ansible/ansible/issues/39612#issuecomment-597451375 (This is a different Ansible module but it's using the same Python under the covers.)  this helped me