How execut script sql on port 1433

[Ryad karkar]

Hy,

I have Ansible on my debian 8.11 and i have on script my_script.sql

I have install tool mssql-cli and i can with this tool execut my_script.sql on my database MSSQL.

I have on server Windows  database MSSQL.

I want that Ansible communicate with database only on the port 1433, i try to use ansible_port=1433 and ansible_ssh_port=1433 but not works.

So i want that Ansible use only port 1433 so protocol sql

Someone have some idea please ??

Thanks very much community ansible !! ;)

Regards,

[Stefan Hornburg (Racke)]

On 6/11/19 2:16 PM, Ryad karkar wrote:
> Hy,
>
> I have Ansible on my debian 8.11 and i have on script my_script.sql
>
> I have install tool mssql-cli and i can with this tool execut my_script.sql on my database MSSQL.
>
> I have on server Windows  database MSSQL.
>

> I want that Ansible communicate with database *only on the port 1433*, i try to use ansible_port=1433 and
> ansible_ssh_port=1433 but not works.
>
> *So i want that Ansible use only port 1433 so protocol sql*

It is unclear to me why you want to use Ansible at all for simple communicating with the database.
There are tons of tools and support for many programming languages to do this standalone.

Regards
Racke

>
> Someone have some idea please ??
>
> Thanks very much community ansible !! ;)
>
> Regards,
>

> --
> 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 post to this group, send email to ansible...@googlegroups.com <mailto:ansible...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/eaef5fba-c38b-4667-960e-7f8b58ce5280%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eaef5fba-c38b-4667-960e-7f8b58ce5280%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.


--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

[Ryad karkar]

Hi,

Thanks for answer :)

Because Ansible can deploy application ? and Who say application say database ? Say update database ? Saye script sql ?

I donc't understand why there not a lot of module for database mssql i'm very nervous !!!!!

Sorry,

Regards,

Le mardi 11 juin 2019 15:00:28 UTC+2, Stefan Hornburg (Racke) a écrit :

On 6/11/19 2:16 PM, Ryad karkar wrote:
> Hy,
>
> I have Ansible on my debian 8.11 and i have on script my_script.sql
>
> I have install tool mssql-cli and i can with this tool execut my_script.sql on my database MSSQL.
>
> I have on server Windows  database MSSQL.
>
> I want that Ansible communicate with database *only on the port 1433*, i try to use ansible_port=1433 and
> ansible_ssh_port=1433 but not works.
>
> *So i want that Ansible use only port 1433 so protocol sql*

It is unclear to me why you want to use Ansible at all for simple communicating with the database.
There are tons of tools and support for many programming languages to do this standalone.

Regards
          Racke

>
> Someone have some idea please ??
>
> Thanks very much community ansible !! ;)
>
> Regards,
>
> --
> 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>.