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

Archives Ansible Project
1

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

2

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.

3

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 *”
4

any other details needed?

5

can some one shower some light here

6

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?

7

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.

8

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