Hello Dick, Below is the information.
[image: image.png] On Thu, Jan 14, 2021 at 5:31 AM Dick Visser <[email protected]> wrote: > what is the output of > > /usr/bin/Python 2.7.5 --version > > and: > > ansible --version > > On Thu, 14 Jan 2021 at 14:02, 'Praveen Kumar Singh' via Ansible > Project <[email protected]> wrote: > > > > Can someone please help me on this. > > > > Thanks and regards, > > Praveen Singh > > > > On Wed, Jan 13, 2021 at 11:32 AM Praveen Kumar Singh <[email protected]> > wrote: > >> > >> I removed the debug parameter and still get the error. I ran the below > simple playbook which should create a database in sql server but I am still > getting the error. > >> > >> --- > >> - hosts: SQLSERVER2 > >> vars: > >> ansible_python_interpreter: /usr/bin/Python 2.7.5 > >> tasks: > >> - mssql_db: > >> name: TestDB > >> state: present > >> > >> > >> > >> Thanks and Regards, > >> Praveen Singh > >> > >> On Tue, Jan 12, 2021 at 10:08 AM Dick Visser <[email protected]> > wrote: > >>> > >>> On Thu, 5 Nov 2020 at 19:13, 'Praveen Kumar Singh' via Ansible Project > >>> <[email protected]> wrote: > >>> > > >>> > ISSUE TYPE > >>> > > >>> > Feature Idea > >>> > > >>> > SUMMARY > >>> > > >>> > When I am using the SQL Server Module mssql_db to create a new > database on the microsoft SQL Server I am getting the below error. > Microsoft SQL Server is on windows server. I am using the below playbook to > create the database on SQL Server. > >>> > > >>> > Ansible Playbook : > >>> > > >>> > hosts: SQLSERVER > >>> > vars: > >>> > ansible_python_interpreter: /usr/bin/Python 2.7.5 > >>> > >>> Does this actually work without escaping the spaces? > >>> > >>> > >>> > tasks: > >>> > > >>> > mssql_db: > >>> > debug: var=ansible_host > >>> > >>> 'debug' isn't a parameter for the mssql_db module. Remove that and try > again. > >>> Also, try to post properly indented/copied code. Indentation in > >>> importantly, and the way you pasted it (using HTML disc?) makes it > >>> impossible to tell what went on. > >>> > >>> > login_host: ******* > >>> > login_user: Ansible > >>> > login_password: ******* > >>> > login_port: 1433 > >>> > name: TestDB > >>> > state: present > >>> > > >>> > ERROR : fatal: [SQLSERVER]: FAILED! => {"changed": false, > "module_stderr": "Exception calling "Create" with "1" argument(s): "At > line:4 char:21\r\n+ def _ansiballz_main():\r\n+ ~\r\nAn expression was > expected after '('.\r\nAt line:13 char:27\r\n+ except (AttributeError, > OSError):\r\n+ ~\r\nMissing argument in parameter list.\r\nAt line:15 > char:7\r\n+ if scriptdir is not None:\r\n+ ~\r\nMissing '(' after 'if' in > if statement.\r\nAt line:22 char:7\r\n+ if sys.version_info < (3,):\r\n+ > ~\r\nMissing '(' after 'if' in if statement.\r\nAt line:22 char:30\r\n+ if > sys.version_info < (3,):\r\n+ ~\r\nMissing expression after ','.\r\nAt > line:22 char:25\r\n+ if sys.version_info < (3,):\r\n+ ~\r\nThe '<' operator > is reserved for future use.\r\nAt line:27 char:34\r\n+ def > invoke_module(modlib_path, temp_path, json_params):\r\n+ ~\r\nMissing > argument in parameter list.\r\nAt line:28 char:40\r\n+ z = > zipfile.ZipFile(modlib_path, mode='a')\r\n+ ~\r\nMissing argument in > parameter list.\r\nAt line:31 char:33\r\n+ zinfo = zipfile.ZipInfo()\r\n+ > ~\r\nAn expression was expected after '('.\r\nAt line:34 char:25\r\n+ > z.writestr(zinfo, sitecustomize)\r\n+ ~\r\nMissing argument in parameter > list.\r\nNot all parse errors were reported. Correct the reported errors > and try again.\r\n"\r\nAt line:6 char:1\r\n+ $exec_wrapper = > [ScriptBlock]::Create($split_parts[0])\r\n+ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n + CategoryInfo : > NotSpecified: (:) [], MethodInvocationException\r\n + FullyQualifiedErrorId > : ParseException\r\n \r\nThe expression after '&' in a pipeline element > produced an object that was not \r\nvalid. It must result in a command > name, a script block, or a CommandInfo \r\nobject.\r\nAt line:7 char:2\r\n+ > &$exec_wrapper\r\n+ ~~~~~~~~~~~~~\r\n + CategoryInfo : InvalidOperation: > (:) [], RuntimeException\r\n + FullyQualifiedErrorId : BadExpression\r\n ", > "module_stdout": "", "msg": "MODULE FAILURE\nSee stdout/stderr for the > exact error", "rc": 1} > >>> > > >>> > ENVIRONMENT > >>> > > >>> > Ansible version: ansible 2.9.13 > >>> > Operating System: Linux > >>> > > >>> > -- > >>> > 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/49d93260-95a5-443d-bacc-102243e1afe0n%40googlegroups.com > . > >>> > >>> > >>> > >>> -- > >>> Dick Visser > >>> Trust & Identity Service Operations Manager > >>> GÉANT > >>> > >>> -- > >>> 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/CAL8fbwPyJX4HfakD8bxEAnN8tUzNYDPn3va%3DueCQd5HkS7R0qA%40mail.gmail.com > . > > > > -- > > 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/CAJK1W%3Dzk0TGeuQRb_YRS2xDhAgG_%3DNE9uB3sNUOudRWNpk55Cw%40mail.gmail.com > . > > > > -- > Dick Visser > Trust & Identity Service Operations Manager > GÉANT > > -- > 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/CAL8fbwOaaPKUfNsQ4ddpJM9r%3DoG5YoC%2BRcfzxKbm1NYxagB5_g%40mail.gmail.com > . > -- 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/CAJK1W%3Dy%2BPRkuof-%2BeogD78SWXH9z9tohiLynRHrEbseFubg3dw%40mail.gmail.com.
