Hi,

I am new to Ansible and happy to find this site. All works fine for other 
activities with Ansible except when I try to run a very simple playbook to 
create database, below are the errors. I believe I gave all permission 
right to the sql user.

[WARNING]: FATAL ERROR DURING FILE TRANSFER:
TASK [Creat blank db on remote host] 
*********************************************************************************************************************************************
task path: /opt/dbuild/ansible/playbooks/createdb.yml:5
Using module file 
/usr/lib/python2.7/site-packages/ansible/modules/database/mssql/mssql_db.py
<tsun.crd.com> ESTABLISH WINRM CONNECTION FOR USER: [email protected] on 
PORT 5985 TO user1.domain.com
EXEC (via pipeline wrapper)
fatal: [xxx.xxx.com]: FAILED! => {
    "msg": "winrm send_input failed; \nstdout: Unable to initialize device 
PRN\r\nUnable to initialize device PRN\r\nUnable to initialize device 
PRN\r\n\nstderr ANSIBALLZ_WRAPPER : The term 'ANSIBALLZ_WRAPPER' is not 
recognized as the name of a cmdlet, function, script file, or \r\noperable 
program. Check the spelling of the name, or if a path was included, verify 
that the path is correct and try \r\nagain.\r\nAt line:1 char:1\r\n+ 
ANSIBALLZ_WRAPPER = True # For test-module script to tell this is a A 
...\r\n+ ~~~~~~~~~~~~~~~~~\r\n    + CategoryInfo          : ObjectNotFound: 
(ANSIBALLZ_WRAPPER:String) [], 

------- here is the content of the playbook--------------

---
- hosts: all
  gather_facts: no
  tasks:
    - name: Creat blank db on remote host
      mssql_db:
        name: test
        login_user: test_dev
        login_password: test_dev
        state: present
        delegate_to: 127.0.0.1


Thanks very much

-- 
You received this message because you are subscribed to the Google Groups 
"Ansible Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to