Create module mssql_query Error port

Archives Ansible Project
1

Hello,

I have create this module mssql_query.py in ansible in /library/mssql_query.py :

https://github.com/melmorabity/ansible-mssql-query/blob/master/mssql_query.py

I have this error :

The error was: TypeError: connect() got an unexpected keyword argument ‘port’

when i execut this task :

  • local_action:
    module: mssql_query
    login_host: my_host
    login_user: my_user
    login_password: my_password
    query: SELECT * FROM dbo.my_table_1
    db: my_database
    autocommit: True
    as_dict: false
    delegate_to: localhost

Like without port: 1433 i have the same error…

I don’t know why ?

Can you help me please !!

Best Regards,

Karther

2

Hello,

I have create this module mssql_query.py in ansible in /library/mssql_query.py :

https://github.com/melmorabity/ansible-mssql-query/blob/master/mssql_query.py

I have this error :

The error was: TypeError: connect() got an unexpected keyword argument 'port'

when i execut this task :

- local_action:
module: mssql_query
login_host: my_host
login_user: my_user
login_password: my_password
query: SELECT * FROM dbo.my_table_1
db: my_database
autocommit: True
as_dict: false
delegate_to: localhost

Like without port: 1433 i have the same error....

I don't know why ?

Can you help me please !!

This is now really off topic, but I suppose port should be an integer instead of a string.

Regards
           Racke

3

Hello,

I have the same error like with port int in my programme python

The creation module Ansible in well in contexte “Ansible project” … :confused:

Thanks you

Karther