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
On Thursday, July 6, 2023 at 12:12:41 PM UTC-7 Will McDonald wrote:
> 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.
>
> On Thu, 6 Jul 2023 at 19:40, 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>
>> .
>>
>
--
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/6d7111c9-b4de-4ccd-9818-80d266ef007dn%40googlegroups.com.
