Error launching MSSQL in Windows- 0.8 snapshot

[Gowri LN <go...@gmail.com>]

Hello Team,


I was trying deployment of windows instance in Brooklyn 0.8 Snapshot

The windows instance with 7 zip (link - [1])   works fine but I am
struggling a bit with  the  MSSQL.yaml (link - [2]) . The deployment is
successful but when I connect to Windows instance remotely, I can see that
the MSSQL iso is copied and all configuration files, launchsql , install
sql etc are also created  but the service  is not installed

I see the following on terminal:

2015-07-28 06:49:56,444 INFO  Starting
VanillaWindowsProcessImpl{id=S1d6xmdb} on machine
JcloudsWinRmMachineLocation{id=oxgyC9af, name=172.31.2.155}
2015-07-28 06:49:56,445 WARN  Could not resolve on-box directory for
VanillaWindowsProcessImpl{id=S1d6xmdb} at
JcloudsWinRmMachineLocation{id=oxgyC9af, name=172.31.2.155}; using
/home/ubuntu/brooklyn-managed-processes, though this may not be accurate at
the target (and may fail shortly)
2015-07-28 06:50:20,693 INFO  Started application
BasicApplicationImpl{id=I5JsOL4N}
2015-07-28 06:51:35,886 INFO  Started application
BasicApplicationImpl{id=rkMOKKbh}
2015-07-28 06:53:23,124 WARN  Ignoring WinRM exception and retrying
(attempt 1 of 10)
org.python.core.PyException: null
at org.python.core.PyException.doRaise(PyException.java:226)
~[org.python-jython-standalone-2.7-b3.jar:na]
2015-07-28 07:06:32,852 WARN  Ignoring WinRM exception and retrying
(attempt 1 of 10)
org.python.core.PyException: null
at org.python.core.PyException.doRaise(PyException.java:226)
~[org.python-jython-standalone-2.7-b3.jar:na]
2015-07-28 07:15:49,388 WARN  Ignoring WinRM exception and retrying
(attempt 1 of 10)
org.python.core.PyException: null
at org.python.core.PyException.doRaise(PyException.java:226)
~[org.python-jython-standalone-2.7-b3.jar:na] ..............




Following is the blueprint I tried:


name: windows_mssql_iso
location:
  jclouds:aws-ec2:
    region: us-west-2
    imageId: us-west-2/ami-6d2a195d
    credential:*****************
    identity: ****************
    useJcloudsSshInit: false
    hardwareId:  m3.medium
services:
- type: brooklyn.entity.basic.VanillaWindowsProcess
  brooklyn.config:
    templates.install:
      classpath://brooklyn/entity/database/mssql/ConfigurationFile.ini:
"C:\\ConfigurationFile.ini"
      classpath://brooklyn/entity/database/mssql/installmssql.ps1:
"C:\\installmssql.ps1"
      classpath://brooklyn/entity/database/mssql/configuremssql.ps1:
"C:\\configuremssql.ps1"
      classpath://brooklyn/entity/database/mssql/launchmssql.bat:
"C:\\launchmssql.bat"
      classpath://brooklyn/entity/database/mssql/stopmssql.bat:
"C:\\stopmssql.bat"
    install.command: powershell -command "C:\\installmssql.ps1"
    customize.command: powershell -command "C:\\configuremssql.ps1"
    launch.command: "C:\\launchmssql.bat"
    stop.command: "C:\\stopmssql.bat"
    checkRunning.command: echo true

    mssql.download.url: http://path_to_iso
    mssql.download.user: my_username
    mssql.download.password: my_password
    mssql.sa.password: my_username
    mssql.instance.name: MSSQL

    ## The following is a list of *all* MSSQL features. Installation time
and footprint can be greatly
    ## reduced by removing unnecessary features
    mssql.features:
"SQLENGINE,REPLICATION,FULLTEXT,DQ,AS,RS,RS_SHP,DQC,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,DREPLAY_CTLR,DREPLAY_CLT,SNAC_SDK"
  provisioning.properties:
    required.ports: 1433
    osFamily: Windows


Can somebody help me with this ?

[2] -
https://github.com/apache/incubator-brooklyn/blob/master/software/database/src/main/resources/brooklyn/entity/database/mssql/mssql.yaml


Thanks,
Gowri