Subscribe

SC SMSQL Issue (Powershell?)

[ Edited ]

Hi,

I'm testing the use of Snap Creator to run SnapManager for SQL Backups.  I've got the configuration in place, and the server seems to happily talk to the agent.  The backup jo (snapshot) runs and says it's completed succesfully, but the snapshot has not been created.  On the SQL Server, the SCAgent Debug log file shows the following (Basics are: Windows Server 2008 R2, SQL 2008 SP3, SMSQL 5.2):

[Thu Aug  2 15:37:33 2012] DEBUG: Executing command [%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1" -command "&{new-backup –svr 'SRV-SCA1'  -d  'SRV-SCA1', '1', 'Testing123' -ver  –verInst 'SRV-SCA1' -mp –mpdir 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 8 -rudays 7 –mgmt standard; exit $lastexitcode}" <NUL]

[Thu Aug  2 15:37:33 2012] INFO: Starting watchdog with [-2464], forced unquiesce timeout [905] second(s)

[Thu Aug  2 15:37:34 2012] DEBUG: Command [%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1" -command "&{new-backup –svr 'SRV-SCA1'  -d  'SRV-SCA1', '1', 'Testing123' -ver  –verInst 'SRV-SCA1' -mp –mpdir 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 8 -rudays 7 –mgmt standard; exit $lastexitcode}" <NUL] finished with

exit code: [0]

stdout: []

stderr: []

[Thu Aug  2 15:37:34 2012] DEBUG: Executing of external script finished successfully

[Thu Aug  2 15:37:34 2012] INFO: Quiescing databases finished successfully

[Thu Aug  2 15:37:39 2012] INFO: Skipping unquiesce, nothing needed for SMSQL integration

Which looks fine, except that the command doesn't seem to have done anything!  If I take the same command above, and copy and paste it into a command prompt (minus the "<NUL" - to run the command manually ... it works fine!  I figured maybe my agent needed to run under a different user account - tried it, no dice.  Tried running the agent manually (ie, not as a service) under an elevated command line whilst logged in as an administrator ... still didn't work (ran the agent with verbose output, and the same output was shown as was written into the log file above when running as a service.

So - I can run the command manually, works fine - running it through SCAgent seems to cause an issue.  Any thoughts?

My config file is below:Many thanks, Mark Lomas

================

#################################################
### Snap Creator Framework Configuration File ###
#################################################

##############################
### Referencing a Variable ###
##############################
#########################################################################################
# Reference previously assigned variables or variables                                  #
# assigned within Snap Creator itself by prepending                                     #
# the variable name with "%".                                                           #
#                                                                                       #
# For example)  If you want to reference a VARIABLE:                                    #
#               BLAH=/usr/local/bin/foo %USER_DEFINED                                   #
# Below is a list of all the built in referenceable variables:                          #
# %SNAP_TYPE - The Snapshot Schedule: daily, monthly, etc                               #
#           #
# %SNAP_TIME - An epoch time stamp associated with the snapshot                         #
#           #
# %ACTION - Could be -snap,-clone_vol, or -clone_lun, -arch, -list depending on which  #
#     Action you used         #
#           #
# %MSG - Used to send the error message to other monitoring tools or email. Can only #
#  be used with SENDTRAP function       #
#           #
# %USER_DEFINED - Pass a user defined argument to the script, a good example would be   #
#                 in order to integrate with a backup application like netbackup,       #
#                 you may need to pass into configuration file the netbackup schedule   #
#                 desired in the case where you have multiple schedules                 #
#########################################################################################

#############################
### Snap Creator Settings ###
#############################
#################################################################################################################
# CONFIG_TYPE (required) - (PLUGIN|STANDARD) We can have two types of configuration in Snap Creator app or   #
#  standard. We can use multiple app configs to build up complex quiesce and unquiesce workflows.  #
#              #
# SNAME - (required) Your snapshot naming convention, should be unique, snapshots on storage will be deleted    #
#          according to this naming convention                                                                  #
#              #
# SNAP_TIMESTAMP_ONLY - (Y|N) Setting to set snapshot naming convention "N" will create _recent, "Y" will #
#   use a human readable time stamp        #
#              #
# VOLUMES - (required) List of primary storage controllers and volumes you want to snapshot                     #
#           ie: controller1:vol1,vol2,vol3;controller2:vol1;controller3:vol2,vol3                               #
#              #
# SNAPMIROR_VOLUMES - List of primary storage controller and volumes you want to perform a snapmirror update on #
#           ie: controller1:vol1,vol2,vol3;controller2:vol1;controller3:vol2,vol3                               #
#              #
# SNAPVAULT_VOLUMES - List of primary storage controllers and volumes you want to perform a snapvault update on #
#           ie: controller1:vol1,vol2,vol3;controller2:vol1;controller3:vol2,vol3                               #
#              #
# SNAPVAULT_QTREE_INCLUDE - List of primary storage controllers and qtree paths which should be included  #
#   in snapvault update. Without this option all qtrees under a volume will be backed up #
#   qtrees listed here will be backed up, the rest will be ignored.    #
#   ie: controller1:/vol/qtree/qtree1,/vol/volume/qtree2;controller2:/vol/volume/qtree1 #  
#              #
# SNAPMIRROR_CASCADING_VOLUMES List of secondary storage controllers and volumes where you want to perform  #
#   snapmirror update from snapvault source volume (snapshot->snapvault->snapmirror) #
#   ie: sec-controller1:vol1-sec,vol2-sec       #
#              #
# NTAP_USERS - (required) List of primary/secondary storage controller and their corresponding    #
#   usernames/passwords          #
#   ie: controller1:joe/password1;controller2:bob/password2;controller3:ken/password3       #
#              #
# CMODE_CLUSTER_USERS - (required for c-mode) List of primary/secondary c-mode clusters and their corresponding #
#   usernames/passwords ie: cluster1:joe/password1;cluster2:bob/password2   #
#              #
# CMODE_CLUSTER_NAME -(required for c-mode) Name of the primary c-mode cluster     #
#              #
# CMODE_SNAPSHOT_FORCE_DELETE - (Y|N) Setting which forces deletion of snapshots which should be deleted based #
#    on snapshot policy        #
#              #
# SECONDARY_INTERFACES - List of primary storage controllers or vfilers and there secondary interfaces   #
#   source/destination for snapvault and snapmirror relationships    #
#   ie: controller1:controller1-source/controller2-destination    #
#              #
# USE_PROXY - (Y|N) Setting which allows API calls to go through DFM proxy instead of storage controller  #
#  directly. If this option is used NTAP_USERS is no longer required.    #
#              #
# MANAGEMENT_INTERFACES - List of primary storage controller and their management interfaces used   #
#   for communications         #
#   ie: conroller1:controller1-mgmt;controller2:controller2-mgmt    #
#              #
# ALLOW_IP_ADDR - (Y|N) Setting which allows IP address to be used for storage system. This applies to  #
#   snapvault, snapmirror, and protection manager. Using IPs can create problems and should #
#   only be used under certain conditions       #
#              #
# NTAP_PWD_PROTECTION - (Y|N) Setting for enabling password protection, you must first create a scrambled #
#   password and then save that password in config file     #
#              #
# TRANSPORT - (HTTP|HTTPS) Setting to use either HTTP or HTTPS to connect to storage controller   #
#              #
# PORT - (80|443) Setting which configures which port number on the storage controller to use   #
#              #
# NTAP_TIMEOUT - (seconds) Setting which sets timeout for all storage controller zapi calls. Default is 60 secs #
#              #
# LOG_NUM - The number of logs .debug and .out for Snap Creator to keep                                         #
#              #
# LOG_TRACE_ENABLE - (Y|N) Setting which enables trace messages. Trace messages are an extra level of debug #
#              #
# SC_TMP_DIR - The directory used for storing temporary created files                                           #
#              The directory must exists and must be writable.                                                  #
#              If not specified, the system default will be used.                                               #
#              #
# SNAPDRIVE - (Y|N) Setting which allows you to use snapdrive instead of ZAPI for snapshot creation             #
#              #
# SNAPDRIVE_DISCOVERY - (Y|N) Setting which enables use of snapdrive for storage discovery, required in SAN #
#   or iSAN environment when using VOLUME_VALIDATION     #
#              #
# NTAP_SNAPSHOT_DISABLE - (Y|N) Setting which tells Snap Creator to not take a snapshot. The idea of the option #
#     is that Snap Creator can handle SnapVault or SnapMirror for SnapManager. In order for #
#     that to work the SnapManager snapshots need to follow this naming convention   #
#     <snapshot name>-<policy>_recent       #
#              #
# NTAP_SNAPSHOT_CREATE_CMD<#> - SnapDrive command to create a snapshot and flush the file system buffers        #
#                               where "#" is a number 01-xx                                                     #
#              #
# NTAP_SNAPSHOT_RETENTIONS - (required) Setting which determines the number of snapshots you want to      #
#                            retain for a given policy ie: daily:7,weekly:4,monthly:1                           #
#              #
# NTAP_SNAPVAULT_RETENTIONS - Setting which determines the number of snapshots on the snapvault           #
#                             secondary you want to retain for a given policy                                   #
#                            ie: daily:21,weekly:12,monthly:3                                                   #
#              #
# NTAP_SNAPVAULT_SNAPSHOT - (Y|N) Setting which enables creation of snapvault snapshot. A snapshot compatible #
#    with the storage controller snapvault scheduler. Snapshots are named  #
#    sv_<policy>.<#> and deletion is handled by the storage controller  #
#              #
# NTAP_SNAPSHOT_RETENTION_AGE - Setting in (days) which allows you to define a retention age for snapshots. If #
#           configured snapshots will only be deleted if there are more than defined in #
#           SNAPSHOT Retentions and if they are older than retention age (days)  #
#              #
# NTAP_SNAPVAULT_RETENTION_AGE - Setting in (days) which allows you to define a retention age for snapvault  #
#     snapshots. If configured snapvault snapshots will only be deleted if   #
#     there are more than defined in SNAPVAULT Retentions and if they are older #
#     than retention age (days)       #
#              #
# NTAP_SNAPSHOT_NODELETE - Setting which will override NTAP_SNAPSHOT_RETENTIONS and ensure no snapshots are     #
#                          deleted, leaving this on can cause your volume to fill up                      #
#              #
# NTAP_SNAPVAULT_NODELETE - Setting which will override NTAP_SNAPVAULT_RETENTIONS and ensure no snapshots are   #
#                          deleted, leaving this on can cause your volume to fill up                      #
#              #
# NTAP_SNAPVAULT_RESTORE_WAIT - (Y|N) Setting which waits for snapvault restore to complete. This is  #
#    recommended since after restore is complete user will be prompted to delete the #
#    baseline snapshot which gets created on the primary volume   #
#              #
# NTAP_SNAPMIRROR_UPDATE - (Y|N) Setting which allows you to turn off and on the snapmirror update function     #
#              #
# NTAP_SNAPMIRROR_CASCADING_UPDATE - (Y|N) Setting which allows you to turn off and on the cascading snapmirror #
#        function (snapshot->snapvault->snapmirror)    #
#              #
# NTAP_SNAPVAULT_UPDATE - (Y|N) Setting which allows you to turn off and on the snapvault update function       #
#              #
# NTAP_PM_UPDATE - (Y|N) Setting which allows you to turn off and on the protection manager update function #
#              #
# NTAP_SNAPVAULT_WAIT - Time in minutes where we will wait for snapvault update process to complete before      #
#                       taking a snapshot on the snapvault secondary                                            #
#              #
# NTAP_SNAPMIRROR_WAIT - Time in minutes where we will wait for snapmirror update process to complete  #
#              #
# NTAP_SNAPMIRROR_USE_SNAPSHOT - (Y|N) Setting which determines if the snapshot will be sent with the  #
#     snapmirror update        #
#              #
# NTAP_SNAPVAULT_MAX_TRANSFER - Maximum bandwidth for snapvault to consume in kbps, if left blank snapvault #
#    will consume as much bandwidth as possible     #
#              #
# NTAP_SNAPMIRROR_MAX_TRANSFER - Maximum bandwidth for snapmirror to consume in kbps, if left blank snapmirror #
#    will consume as much bandwidth as possible     #
#              #
# NTAP_VOL_CLONE_RESERVE - (none|file|volume) Space Guarantee for cloned volume                                 #
#              #
# NTAP_LUN_CLONE_RESERVATION - (true|false) If true will reserve space for cloned luns if false will not        #
#              #
# NTAP_CLONE_IGROUP_MAP - List of controller(s), source volume(s), and the Igroups used to map cloned   #
#   volumes and luns.            #
#                       IE: controller1:src_volume1/igroup1;controller2:src_volume2/igroup2                     #
#              #
# NTAP_CLONE_FOR_BACKUP - (Y|N) Setting which determines when the clone is deleted. "Y" will delete clone #
#    after it is created, "N" will delete clone before snapshot occurs so during #
#    the next run of Snap Creator for the given policy and config.   #
#              #
# NTAP_CLONE_SECONDARY - (Y|N) Setting which determines where to perform a clone. If "Y" is selected  #
#          the snapmirror destination will be cloned. This only works with snapmirror #
#          and you must set NTAP_SNAPMIRROR_USE_SNAPSHOT=Y     #
#              #
# NTAP_CLONE_SECONDARY_VOLUMES - Mapping of primary storage controllers and their secondary controller/volume #
#     ie: controller1:secondaryFiler1/vol1;controller2:secondaryFiler2/vol2  #
#              #
# NTAP_NUM_VOL_CLONES - Setting which configures how many volume clones Snap Creator will keep   #
#              #
# NTAP_NFS_EXPORT_HOST - (honstname|ip) The hostname or IP address of the server where cloned volume should be #
#   exported          #
#              #
# NTAP_NFS_EXPORT_ACCESS - (root|read-write|read-only) Setting which controls access permission to cloned vol #
#              #
# NTAP_NFS_EXPORT_PERSISTENT -(true|false) Setting which allows for export permissions of cloned vol to be #
#    saved in the /etc/exports file on the storage controller.   #
#              #
# NTAP_CIFS_EXPORT_ENABLE - (Y|N) Setting to share a cloned volume using cifs     #
#              #
# NTAP_DFM_DATA_SET - List of storage controllers and their protection manager to volume correlations  #
#        ie: controller1:dataset1/vol1,vol2;controller1:dataset2/vol3    #
#              #
# NTAP_PM_RUN_BACKUP - (Y|N) Setting which enables starting the Protection Manager backup as soon as the #
#   snapshot registration process is complete. Eliminates need to schedule secondary #
#   backup in Protection Manager.         #
#              #
# NTAP_DFM_SNAPSHOT_FORMAT - Optional setting for the format of the secondary snapshots when using PM. This #
#        option requires DFM 5.0 or higher. You also must specify %T (timestamp). Other #
#        variables are %R (retention type), %L (dataset label), %H (storage controller), #
#        %N (volume name), and %A (application specific data). If this option is not set  #
#        then the default PM naming convention will be used. The naming convention can only #
#        be set at the time of dataset creation.      #
#              #
# NTAP_CONSISTENCY_GROUP_SNAPSHOT - (Y|N) Setting which enables use of consistency groups for creating  #
#        consistent snapshot across multiple volumes ie: IO Fencing   #
#              #
# NTAP_CONSISTENCY_GROUP_TIMEOUT - (urgent|medium|relaxed) Setting which defines how long controller will  #
#    wait for consistently group snapshot (urgent=2sec,medium=7sec,relaxed=20sec) #
#              #
# NTAP_CONSISTENCY_GROUP_WAFL_SYNC - (Y|N) Setting which can improve performance of the CG snapshot by forcing  #
#     a CP through a wafl-sync before the cg-start    #
#              #
# NTAP_SNAPSHOT_DELETE_BY_AGE_ONLY - {PRIMARY|SECONDARY|BOTH|N} Setting which allows the deletion of outdated   #
#              snapshots, regardless of the retention count                                                     #
#              #
# NTAP_SNAPSHOT_DEPENDENCY_IGNORE - (Y|N) Setting which allows for ignoring snapshot dependencies when   #
#     prompted for deletion using the "--action delete" option  #
#              #
# NTAP_SNAPSHOT_RESTORE_AUTO_DETECT - (Y|N) Setting which if disabled will always force a SFSR when doing a  #
#     single file restore       #
#              #
# NTAP_SNAPSHOT_CLEANUP - (Y|N) Setting which in the event of backup failure will remove any snapshots taken #
#              #
# NTAP_USE_EXTERNAL_SNAPSHOT - (Y|N) Setting which allows for import of non Snap Creator snapshot, most recent #
#    snapshot is matched        #
#              #
# NTAP_EXTERNAL_SNAPSHOT_REGEX - A regular expression for matching imported snapshots, requires the  #
#    NTAP_USE_EXTERNAL_SNAPSHOT option      #
#              #
# NTAP_OSSV_ENABLE - (Y|N) Setting which enables the Open Systems Snapvault (OSSV) integration. This option  #
#      must be used in combination with the NTAP_OSSV_HOMEDIR parameter. OSSV is also  #
#      required on the host running Snap Creator      #
#              #
# NTAP_OSSV_HOMEDIR - The path to the OSSV home directory IE: /usr/snapvault     #
#              #
# NTAP_OSSV_FS_SNAPSHOT - (Y|N) Setting which enables ability to create file system snapshot. The file system #
#   snapshot command must be provided using the NTAP_OSSV_FS_SNAPSHOT_CREATE_CMD<#>  #
#   parameter          #
#              #
# NTAP_OSSV_FS_SNAPSHOT_CREATE_CMD<#> - Script or command that takes a file system snapshot in use with ossv #
#     backup, where "#" is a number between 01-xx    #
#              #
# OM_HOST - Name or IP Address of your Operations Manager system      #
#              #
# OM_USER - User name of an Operations Manager user which has privileges to create events   #
#              #
# OM_PWD - Password of the above Operations Manager User       #
#              #
# OM_EVENT_GENERATE - (Y|N) Setting which will enable event creation in Operations Manager   #
#              #
# APP_QUIESCE_CMD<#> - Script or command that puts your application into backup mode, where "#" is a  #
#       number between 01-xx                              #
#              #
# APP_UNQUIESCE_CMD<#> - Script or command that takes your application out of backup mode, where "#" is a #
#     number between 01-xx                              #
#              #
# ARCHIVE_CMD<#> - The archive command command where "#" is a number 01-xx                        #
#              #
# MOUNT_CMD<##> - Mount commands to be used to mount file system for cloning or mount actions where "#" is a #
#   number 01-xx          #
#              #
# UMOUNT_CMD<##> - Umount commands to be used to mount file system for cloning or mount actions where "#" is a  #
#   number 01-xx          #
#              #
# PRE_APP_QUIESCE_CMD<#> - The pre application quiesce command where "#" is a number 01-xx                      #
#              #
# PRE_NTAP_CMD<#> - The pre command where "#" is a number 01-xx                                           #
#              #
# PRE_APP_UNQUIESCE_CMD<#> - The pre application unquiesce command where "#" is a number 01-xx                  #
#              #
# PRE_NTAP_CLONE_DELETE_CMD<#> - The pre clone delete command where "#" is a number 01-xx                 #
#              #
# PRE_RESTORE_CMD<#> - The pre restore command where "#" is a number 01-xx     #
#              #
# PRE_EXIT_CMD<#> - Command which will run before Snap Creator exists due to an error                           #
#                   ie: you want to return application or backup into normal mode before Snap Creator exist     #
#                   due to an error. Where "#" is a number between 01-xx                                        #
#              #
# PRE_CLONE_CREATE_CMD<#> - The pre clone create command, where "#" is a number 01-xx                           #
#              #
# POST_APP_QUIESCE_CMD<#> - The post application quiesce command where "#" is a number 01-xx                    #
#              #
# POST_NTAP_CMD<#> - The post command where "#" is a number 01-xx                                         #
#              #
# POST_APP_UNQUIESCE_CMD<#> - The post application unquiesce command where "#" is a number 01-xx                #
#              #
# POST_NTAP_DATA_TRANSFER_CMD<#> - The post data transfer command runs after SnapVault or SnapMirror transfer  #
#                                  Where "#" is a number 01-xx.                                                 #
#              #
# POST_RESTORE_CMD<#> - The post restore command where 2#" is a number 01-xx                                    #
#              #
# POST_CLONE_CREATE_CMD<#> - The post clone create command, where "#" is a number 01-xx                         #
#              #
# NTAP_ASUP_ERROR_ENABLE - (Y|N) Setting which enables Snap Creator error messages to also log an auto support  #
#      message on the storage controller. Snap Creator will always create an info auto  #
#      support message when the backup has started and completed    #
#              #
# SENDTRAP - Command which interfaces with your monitoring software or email, allows you to pass alerts         #
#            generated from Snap Creator into your own monitoring infrastructure. The %MSG variable is the #
#      message sent from Snap Creator                                     #
#              #
# SUCCESS_TRAP - Command which interfaces with your monitoring software or email, allows you to pass the  #
#   success message generated from Snap Creator into your own monitoring infrastructure   #
#   The %SUCCESS_MSG variable is the success message for Snap Creator    #
#              #
# SUCCESS_MSG - Upon Snap Creator success will log the message you define and also send it to SENDTRAP, if #
#  SENDTRAP is defined          #
#################################################################################################################

########################
### Required Options ###
########################
CONFIG_TYPE=STANDARD
SNAME=SRV_SCA1SMSQL_
SNAP_TIMESTAMP_ONLY=Y
VOLUMES=fas-ico1b:SRV_SCA1,SRV_SCA_Snapinfo
NTAP_SNAPSHOT_RETENTIONS=hourly:7
NTAP_USERS=fas-ico1a:icomm/<REMOVED>;fas-ico1b:icomm/<REMOVED>
NTAP_PWD_PROTECTION=Y
TRANSPORT=HTTPS
PORT=443
NTAP_TIMEOUT=60
LOG_NUM=30
LOG_TRACE_ENABLE=Y
SC_TMP_DIR=

##########################
### Connection Options ###
##########################
MANAGEMENT_INTERFACES=
SECONDARY_INTERFACES=
USE_PROXY=N
ALLOW_IP_ADDR=N

######################
### CMODE Settings ###
######################
CMODE_CLUSTER_USERS=
CMODE_CLUSTER_NAME=
CMODE_SNAPSHOT_FORCE_DELETE=Y

########################
### Snapshot Options ###
########################
NTAP_SNAPSHOT_RETENTION_AGE=
SNAPDRIVE=N
SNAPDRIVE_DISCOVERY=N
NTAP_SNAPSHOT_DISABLE=N
NTAP_SNAPSHOT_NODELETE=Y
NTAP_CONSISTENCY_GROUP_SNAPSHOT=N
NTAP_CONSISTENCY_GROUP_TIMEOUT=medium
NTAP_CONSISTENCY_GROUP_WAFL_SYNC=N
NTAP_SNAPSHOT_DELETE_BY_AGE_ONLY=N
NTAP_SNAPSHOT_DEPENDENCY_IGNORE=N
NTAP_SNAPSHOT_RESTORE_AUTO_DETECT=N
NTAP_SNAPSHOT_CLEANUP=N
NTAP_USE_EXTERNAL_SNAPSHOT=N
NTAP_EXTERNAL_SNAPSHOT_REGEX=

#########################
### SnapVault Options ###
#########################
NTAP_SNAPVAULT_UPDATE=N
SNAPVAULT_VOLUMES=
SNAPVAULT_QTREE_INCLUDE=
NTAP_SNAPVAULT_RETENTIONS=
NTAP_SNAPVAULT_RETENTION_AGE=
NTAP_SNAPVAULT_SNAPSHOT=N
NTAP_SNAPVAULT_NODELETE=N
NTAP_SNAPVAULT_RESTORE_WAIT=N
NTAP_SNAPVAULT_WAIT=60
NTAP_SNAPVAULT_MAX_TRANSFER=

##########################
### SnapMirror Options ###
##########################
NTAP_SNAPMIRROR_UPDATE=N
NTAP_SNAPMIRROR_CASCADING_UPDATE=N
SNAPMIRROR_VOLUMES=
SNAPMIRROR_CASCADING_VOLUMES=
NTAP_SNAPMIRROR_WAIT=60
NTAP_SNAPMIRROR_USE_SNAPSHOT=N
NTAP_SNAPMIRROR_MAX_TRANSFER=

#######################
### Cloning Options ###
#######################
NTAP_VOL_CLONE_RESERVE=none
NTAP_LUN_CLONE_RESERVATION=false
NTAP_CLONE_IGROUP_MAP=
NTAP_CLONE_FOR_BACKUP=Y
NTAP_CLONE_SECONDARY=N
NTAP_CLONE_SECONDARY_VOLUMES=
NTAP_NUM_VOL_CLONES=1
NTAP_NFS_EXPORT_HOST=
NTAP_NFS_EXPORT_ACCESS=
NTAP_NFS_EXPORT_PERSISTENT=false
NTAP_CIFS_EXPORT_ENABLE=N

##################################
### Protection Manager Options ###
##################################
NTAP_PM_UPDATE=Y
NTAP_DFM_DATA_SET=fas-ico1b:snapcreator_TestSQL/SRV_SCA1,SRV_SCA_Snapinfo
NTAP_PM_RUN_BACKUP=N
NTAP_DFM_SNAPSHOT_FORMAT=

####################
### OSSV Options ###
####################
NTAP_OSSV_ENABLE=N
NTAP_OSSV_HOMEDIR=
NTAP_OSSV_FS_SNAPSHOT=N
NTAP_OSSV_FS_SNAPSHOT_CREATE_CMD01=

###################################
### Operations Manager Settings ###
###################################
OM_HOST=srv-fs4
OM_USER=county\vmwareservice
OM_PWD=53616c7465645f5f6eee83dcfd3cb9af2de2eb9722e69b76328dd6d2e2249c9b
OM_PORT=8488
OM_EVENT_GENERATE=N

####################
### APP Commands ###
####################
ARCHIVE_CMD01=
MOUNT_CMD01=
UMOUNT_CMD01=

####################
### Pre Commands ###
####################
PRE_APP_QUIESCE_CMD01=
PRE_NTAP_CMD01=
PRE_NTAP_CLONE_DELETE_CMD01=
PRE_APP_UNQUIESCE_CMD01=
PRE_RESTORE_CMD01=
PRE_CLONE_CREATE_CMD01=

#####################
### Post Commands ###
#####################
POST_APP_QUIESCE_CMD01=
POST_NTAP_CMD01=
POST_NTAP_DATA_TRANSFER_CMD01=
POST_APP_UNQUIESCE_CMD01=
POST_RESTORE_CMD01=
POST_CLONE_CREATE_CMD01=

###########################
### Event Configuration ###
###########################
NTAP_ASUP_ERROR_ENABLE=N
SENDTRAP=
SUCCESS_TRAP=
SUCCESS_MSG=INFO: Snap Creator finished successfully ( Action: %ACTION )

###################################
### Client/Server Configuration ###
###################################
##################################################################################################################
# SC_AGENT - <hostname or ip>:<port>                                                                             #
#   Snap Creator has the capability to perform tasks on remote hosts. A task is either a defined module          #
#   (parameter APP_NAME) or a command specified with the parameters *_CMD*, e. g. NTAP_SNAPSHOT_CREATE_CMD01     #
#                                                                                                                #
#   To specify a remote host, enter it's name or ip address followed by a colon and the port, the Snap Creator   #
#   Agent listening on.                                                                                          #
#   On the remote host, start the Snap Creator Agent                                                             #
#      <path to Snap Creator>/snapcreator --start-agent <port>                                                   #
#                                                                                                                #
#   If running in local mode, the parameter must be left blank.                                                  #
#                                                                                                                #
# SC_CLONE_TARGET - <hostname or ip of the clone target>:<port>                                                  #
#   Snap Creator has the capability to perform clone operations. Using the action 'clone_vol' in combination     #
#   with {PRE|POST}_CLONE_CREATE_CMDxx to handle the storage objects on the remote side                          #
#   (e. g. mounting/unmounting filesytems), either the module is enabled to perform all the necessary            #
#   activities to                                                                                                #
#                                                                                                                #
#   To specify a clone target, enter it's name or ip address followed by a colon and the port, the Snap Creator  #
#   Agent listening on.                                                                                          #
#                                                                                                                #
# SC_AGENT_TIMEOUT - Number, timeout in seconds                                                                  #
#   The implemented client/server architecture uses a timeout mechanism. This means, if the client does not      #
#   respond in the specified interval, the server fails with a timeout message. However, the task on the client  #
#   is left untouched (will not be aborted) and needs further investigation.                                     #
#                                                                                                                #
#   On server with high load or known, long running tasks like own scripts or complex SnapDrive operations       #
#   it might be necessary to extend the timeout and adapt this value on your own needs.                          #
#                                                                                                                #
#   Per default, a timeout of 300 seconds is used.                                                               #
#                                                                                                                #
# SC_AGENT_WATCHDOG_ENABLE - (Y|N)                                                                               #
#   Snap Creator starts a watchdog process while quiescing the database. After the period specified with         #
#   SC_AGENT_UNQUIESCE_TIMEOUT, the database will be brought into normal operation automatically.                #
#                                                                                                                #
# SC_AGENT_UNQUIESCE_TIMEOUT - Number, timeout in seconds                                                        #
#   Time to wait after a database quiesce operation to bring back the database into normal operation mode again. #
#   This is only available in combination with SC_AGENT_WATCHDOG_ENABLE=Y                                        #
#                                                                                                                #
#   Per default, SC_AGENT_TIMEOUT + 5 is used.                                                                   #
#               #
# SC_AGENT_LOG_ENABLE - (Y|N) Setting which enables logging on agent. The Snap Creator server sends operations  #
#   to the agent. If something happens before agent sends callback to server it is possible  #
#   messages could be lost. This allows agent messages to be logged on agent so they are  #
#   never lost.           #
##################################################################################################################
SC_AGENT=srv-sca1:9090
SC_AGENT_TIMEOUT=900
SC_AGENT_UNQUIESCE_TIMEOUT=
SC_CLONE_TARGET=
SC_AGENT_WATCHDOG_ENABLE=Y
SC_AGENT_LOG_ENABLE=Y

#############################
### Plugin Module Options ###
#############################
##################################################################################################################################
# APP_NAME - (oracle|db2|mysql|domino|vibe|smsql|sme|sybase|maxdb|kvm|xen|<plugin>) Setting which determines which plug-in   #
# is being used. Snap Creator has built-in support for the listed applications. A community plug-in can be used    #
# or you can configure APP_QUIESCE_CMD01, APP_UNQUIESCE_CMD01, and PRE_EXIT_CMD01         #
#                 #
# FS_NAME - (<plugin>) Setting which determines which plug-in is being used for file system operations. Currently no plug-ins  #
# exist for file system operations but we should start seeing community based plug-ins for integrating file systems soon  #
#                 #
# APP_IGNORE_ERROR - (Y|N) Will cause Snap Creator to not exit when encountering an application error. An error     #
#     message will be sent if SENDTRAP is configured but Snap Creator will not exit. This may be useful if you   #
#     are backing up multiple databases and dont want a single database failure to stop the backup      #
#                 #
# APP_DEFINED_BACKUP - (Y|N) The application plugin will be expected to perform entire backup operation including quiesce,  #
#   snapshot, and unquiesce. The built-in plugins do not support this kind of backup.    #
#                 #
# VALIDATE_VOLUMES - (DATA) Snap Creator validates that all volumes where the database resides are in fact part of the backup.  #
# Currently, there are some limitations. Only NFS is supported and only for db2, maxdb, mysql, and Oracle.   #
# Currently, this option only checks data files only for the above databases. Going forward, support for more data   #
# types like LOG will be added.             #
#                 #
# META_DATA_VOLUME - Allows for snapshot of specified volume to occur after unquiesce. This can be valuable for certain plugins  #
#       where data snapshot should occur at different times. The meta data volume must not be only volume specified #
#       ie: controller1:volume1            #
#                  #
# APP_DEFINED_RESTORE - (Y|N) The normal cli restore interface will not be shown. Instead the plug-in is responsible for   #
#  handling all restore activities including the restore of the snapshot. The built-in plug-ins do not support  #
#  this type of a restore             #
#                 #
# APP_DEFINED_CLONE - (Y|N) The built-in cloning abilities of Snap Creator will be ignored. Instead the plug-in is responsible  #
#  for handling all clone activities including vol or lun clone creation and deletion. The built-in plug-ins do not #
#  support this type of clone.            #
#                 #
# APP_DEFINED_MOUNT - (Y|N) The built-in mount abilities of Snap Creator will be ignored. Instead the plug-in is responsible  #
#  for handling all mount activities including vol or lun clone creation. The built-in plug-ins do not support  #
#  this type of mount.              #
#                 #
# APP_DEFINED_UMOUNT - (Y|N) The built-in umount abilities of Snap Creator will be ignored. Instead the plug-in is responsible  #
#  for handling all umount activities including vol or lun clone deletion. The built-in plug-ins do not support  #
#  this type of umount.              #
#                 #
# APP_AUTO_DISCOVERY - (Y|N) Similar to APP_DEFINED _RESTORE this parameter allows the plug-in to handle application discovery.  #
#  As with restore the plug-in must handle this operation itself        #
#                 #
# APP_CONF_PERSISTENCY - (Y|N) If APP_AUTO_DISCOVERY is used configuration parameters can be changed dynamically. This setting  #
#  allows any changes to be saved, meaning the configuration file updated dynamically.     #
#                 #
# JAVA_HOME - (Text) Setting which points to the Java Virtual Machine which should be used for executing .class and .jar files.  #
#                    If set, $JAVA_HOME/bin/java will be used, otherwise just java to run the .class/.jar file                   #
#                 #
# JVM_ARGS - (Text) Setting for controlling the Java Virtual Machine when executing native Java .class or .jar files. The        #
#                   default setting is "-Xms32M -Xmx128M"                                                                        #
#                 #
# JAVA_CLASSPATH - (Text) Setting which defines the Java classpath. Per default, plugins/native is configured and can be         #
#                         completed with this environment variable, which will be appended to the default.                       #
#                 #
# PERL_HOME - (Text) Setting which points to the Perl interpreter which should be used for executing .pl files.                  #
#                    If set, $PERL_HOME/bin/perl will be used, otherwise just perl to run the .pl file                           #
#                 #
# PERL_OPTS - (Text) Setting for controlling the Perl interpreter when executing native Perl files.                              #
#                    Options for settings additional include directories (-I) etc. can be passed to the Perl interpreter.        #
#                  #
# PYTHON_HOME - (Text) Setting which points to the Python interpreter which should be used for executing .py files.              #
#                      If set, $PYTHON_HOME/python will be used, otherwhise just python to run the .py file                      #
#                 #
# PYTHON_OPTS - (Text) Setting for controlling the Python interpreter when executing native Python files.                        #
##################################################################################################################################
APP_NAME=smsql
FS_NAME=

APP_IGNORE_ERROR=N

APP_DEFINED_BACKUP=N
APP_DEFINED_RESTORE=N
APP_DEFINED_CLONE=N
APP_DEFINED_MOUNT=N
APP_DEFINED_UMOUNT=N

APP_AUTO_DISCOVERY=N
APP_CONF_PERSISTENCE=Y

VALIDATE_VOLUMES=
META_DATA_VOLUME=

JAVA_HOME=
JVM_ARGS=
JAVA_CLASSPATH=

PERL_HOME=
PERL_OPTS=

PYTHON_HOME=
PYTHON_OPTS=

############################
### Archive Log Settings ###
############################
##########################################################################################
# ARCHIVE_LOG_ENABLE - (Y|N|policy:age) Setting which Enables Archive Log Management   #
#  (deletion of old archive logs)        #
#            #
# ARCHIVE_LOG_RETENTION - Retention in Days for how long archive logs should be kept  #
#            #
# ARCHIVE_LOG_DIR - Path to where the archive logs are stored     #
#            #
# ARCHIVE_LOG_EXT - File Extension for the archive logs, must be <something>.<extension> #
#  ie: 109209011.log in which case you would enter "log"     #
#            #
# ARCHIVE_LOG_RECURSIVE_SEARCH - (Y|N) Setting which allows for managing archive logs  #
#     within subdirs. If archive logs are located under  #
#     subdirs this option should be used.    #
##########################################################################################
ARCHIVE_LOG_ENABLE=N
ARCHIVE_LOG_RETENTION=
ARCHIVE_LOG_DIR=
ARCHIVE_LOG_EXT=
ARCHIVE_LOG_RECURSIVE_SEARCH=N

###############################
### General Plugin Settings ###
###############################

####################
### DB2 Settings ###
####################
#################################################################################################################
# DB2_DATABASES - List of database(s) and their username separated by a comma                                   #
#              #
#   DB2_DATABASES=db1:user1;db2:user2          #
#              #
# DB2_CMD - Path to the db2 command, for connecting to the database(s).                                         #
#           If not specified, sqllib/db2 will be used.                                                          #
#                                                                                                               #
#################################################################################################################
DB2_DATABASES=
DB2_CMD=/path/to/db2
#######################
### MYSQL Settings  ###
#######################
#################################################################################################################
# MYSQL_DATABASES - List of database(s) and their username/password separated by a comma of which you       #
#              #
#   MYSQL_DATABASES=db1:user1/password;db2:user2/password       #
#              #
# HOST - Name of Host where the database(s) are running, ie: localhost      #
# PORTS - List of Database(s) and the ports they are listening on      #
#              #
#   PORTS=db1:3307;db2:3308           #
#              #
# MASTER_SLAVE - (Y|N)If the Database(s) are part of a MASTER or SLAVE Environment    #
#################################################################################################################
MYSQL_DATABASES=
HOST=
PORTS=
MASTER_SLAVE=N
#######################
### Oracle Settings ###
#######################
#################################################################################################################
# ORACLE_DATABASES - A list of Database(s) and the username ie: db1:user1;db2:user2    #
#              #
#   ORACLE_DATABASES=db1:user1;db2:user2         #
#              #
# SQLPLUS_CMD - PATH to the sqlplus command         #
# CNTL_FILE_BACKUP_DIR - Path to the directory where we should store backup cntl files     #
#  (must be owned by oracle user)          #
# ORA_TEMP - Path to a directory for storing temp files ie: /tmp (oracle user must have permissions)  #
# ARCHIVE_LOG_ONLY - (Y|N|policy:<Y|N>) Tells Oracle Module to only do a switch log, useful if you are handling #
#  archive logs separate from data backup          #
# ORACLE_HOME - PATH to the Oracle home directory        #
# ORACLE_HOME_<SID> - PATH to Oracle home directory for a given SID. When backing up multiple databases it #
# may be important to specify more than one Oracle home       #
# ORACLE_EXPORT_PARAMETERS - (Y|N) The ORACLE_HOME and ORACLE_SID environment parameters will be exported using #
#   the export command. This only applies to Unix systems     #
# ORACLE_BACKUPMODE - Option to configure offline or online backups using a Snap Creator policy,  #
# default behavior if left blank is online backups       #    #
#              #
#   ORACLE_BACKUPMODE=hourly:online,daily:offline        #
#################################################################################################################
ORACLE_DATABASES=
SQLPLUS_CMD=/path/to/sqlplus
CNTL_FILE_BACKUP_DIR=/path/to/cntl_files
ORA_TEMP=/path/to/oratemp
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=/path/to/orahome
ORACLE_EXPORT_PARAMETERS=Y

# New
ORACLE_BACKUPMODE=
#####################################
### SnapManager Exchange Settings ###
#####################################
#################################################################################################################
# SME_PS_CONF - Path to the powershell configuration file for SME                               #
#              #
#   SME_PS_CONF="C:\Program Files\SnapManager for Exchange\smeShell.psc1"     #
#              #
# SME_BACKUP_OPTIONS - SME backup options, Snap Creator uses a powershell new-backup cmdlet     #
#              #
# SME_BACKUP_OPTIONS=-Server 'EX2K10-DAG01' -GenericNaming -ManagementGroup 'Standard' -NoTruncateLogs $False  #
#                    -RetainBackups 8 -StorageGroup 'dag01_db01' -BackupCopyRemoteCCRNode $False  #
#              #
# SME_SERVER_NAME - SME server name                                                                #
# SME_32bit - (Y|N) Setting to enable use of 32bit version of powershell                           #
#################################################################################################################
SME_PS_CONF=
SME_BACKUP_OPTIONS=
SME_SERVER_NAME=servername
SME_32bit=N
###################################
### Sybase Settings (unix only) ###
###################################
#################################################################################################################
#                                                                                                               #
# GLOBAL (CORE) SNAP CREATOR CONFIGURATION (external to the SYBABE module)                                      #
#                                                                                                               #
# - Set 'APP_NAME=SYBASE'                                                                                 #
# - If you want to validate configuration then set 'VALIDATE_VOLUMES=DATA,OFFLINE_LOG,EXTERNAL_FILES'     #
#  - DATA - logs and data as reported by sp_helpdb                                                 #
#  - OFFLINE_LOG - Dump location, extracted from SYBASE_TRAN_DUMP                                  #
#  - EXTENAL_FILE - Manifest files, extracted from SYBASE_MANIFEST                                 #
# - If you want to auto discovery storage then set "APP_AUTO_DISCOVERY=Y" as NFS based filer volumes      #
#   which will override the "VOLUMES" option                                                              #
# - If you want to permanently update the configuration file with the results of the storage auto         #
#   discovery then set "APP_CONF_PERSISTENCE=Y"                                                           #
# - If you want to use encrypted password then set "NTAP_PWD_PROTECTION=Y".  NOTE this also sets          #
#   encryption on filer passwords.                                                                        #
#                                                                                                               #
# LOCAL (SYBASE module) SNAP CREATOR CONFIGURATION (internal to the SYBASE module)                              #
#                                                                                                               #
# - SYBASE_SERVER the sybase dataserver name (-S option on isql)                                          #
#  example: SYBASE_SERVER=p_test                                                                   #
# - SYBASE_DATABASES the list of databases within the instance to backup.  Format is                      #
#   "DB1:USER:PASSWD;DB2:USER:PASSWD" The master database is added as a matter of course.  If a database  #
#   called "+ALL" is used then database autodiscovery will be used and excludes the sybsyntax,            #
#   sybsystemdb, sybsystemprocs and tempdb databases. The password are used are passwd to isql as -P.     #
#   encrypted passwords are supported if NTAP_PWD_PROTECTION is set.                                      #
#  example: SYBASE_DATABASES=DBAtest2:sa/53616c7465645f5f76881b465ca8ce3745c239b60e04351e          #
#  example: SYBASE_DATABASES=+ALL:sa/53616c7465645f5f76881b465ca8ce3745c239b60e04351e              #
# - SYBASE_DATABASES_EXCLUDE allows databases to be excluded if the +ALL construct is used use ';'        #
#   to allow multiple databases to be used.                                                               #
#  example: SYBASE_DATABASES_EXCLUDE=pubs2;test_db1.                                               #
# - SYBASE_TRAN_DUMP allows post snapshot sybase transaction dump to be performed.  Each database         #
#   requiring a txn dump needs to be specified.  Format is "DB1:PATH;DB2:PATH" where path is a            #
#   directory.                                                                                            #
#  example: SYBASE_TRAN_DUMP=pubs2:/sybasedumps/pubs2                                              #
# - SYBASE_TRAN_DUMP_FORMAT Allows the dump naming convention to use specified to match site              #
#   specific formats.  Three "keys" can be specified, %S = Instance name from SYBASE_SERVER               #
#   %D is database from SYBASE_DATABASES and %T is a unique timestamp.  Default format is %S_%D_%T.cmn    #
#  example: SYBASE_TRAN_DUMP_FORMAT=%S_%D_%T.log                                                   #
# - SYBASE_TRAN_DUMP_COMPRESS Allows native sybase transaction dump compression to be enabled.            #
#  example: SYBASE_TRAN_DUMP_COMPRESS=Y                                                            #
# - SYBASE_ISQL_CMD defines the path to the "isql" command to use.                                        #
#  example: SYBASE_ISQL_CMD=/opt/sybase/OCS-15_0/bin/isql                                          #
# - SYBASE the location of the sybase install                                                             #
#  example: SYBASE=/sybase                                                                         #
# - SYBASE_LOGDIR defines the directory where snap creator logs will be placed                            #
#  example: SYBASE_LOGDIR=/usr/local/ntap/scServerX.X.X/logs                                       #
# - SYBASE_MANIFEST allows those databases where a manifest file should be created and the location       #
#   where they should be placed.  Needed for database mount to be supported.                              #
#  example: SYBASE_MANIFEST=DBAtest2:/t_inf_nzl_devs/                                              #
# - SYBASE_MANIFEST_FORMAT Allows the manifest naming convention to use specified to match site           #
#   specific formats.  Three "keys" can be specified, %S = Instance name from SYBASE_SERVER               #
#   %D is database from SYBASE_DATABASES and %T is a unique timestamp which is the same as used for       #
#   snapshot naming.  Default format is %S_%D_%T.manifest                                                 #
#  example: SYBASE_MANIFEST_FORMAT=%S_%D_%T.manifest                                               #
# - SYBASE_MANIFEST_DELETE allows the manifest to be deleted once the snapshot has been performed.  The   #
#   manifest file should be captured within the snapshot so it is always available with the backup.       #
#  example: SYBASE_MANIFEST_DELETE=Y                                                               #
#                                                                                                               #
#################################################################################################################
SYBASE_SERVER=
SYBASE_DATABASES=
SYBASE_DATABASES_EXCLUDE=
SYBASE_TRAN_DUMP=
SYBASE_TRAN_DUMP_FORMAT=
SYBASE_TRAN_DUMP_COMPRESS=Y
SYBASE_ISQL_CMD=/path/to/isql
SYBASE=/path/to/sybase
SYBASE_LOGDIR=/path/to/logs
SYBASE_MANIFEST=
SYBASE_MANIFEST_FORMAT=
SYBASE_MANIFEST_DELETE=Y
############################
### VIBE Custom Settings ###
############################
#####################################################################################################
# AUTHENTICATION PARAMETERS                                                                         #
# -------------------------                                                                         #
# VIBE_VCLOUD_IPADDR     - IP address(es) of the vCloud Director to log into (vCloud ONLY)          #
# VIBE_VCLOUD_USER       - Username to use when logging into the vCloud Director (vCloud ONLY),     #
#                          and you must set @<org> or @system (top level vCloud database)           #
#                                                                                                   #
# Example:                                                                                          #
#                                                                                                   #
#   VIBE_VCLOUD_USER=administrator@system                                                           #
#                                                                                                   #
# VIBE_VCLOUD_PASSWD     - Password associated to the VCLOUD_USER specified (vCloud ONLY)           #
# VIBE_VCENTER_USER      - Username to use when logging into vCenter                                #
# VIBE_VCENTER_PASSWD    - Password associated to the VCENTER_USER specified                        #
#                                                                                                   #
# OBJECT PARAMETERS                                                                                 #
# -----------------                                                                                 #
# VIBE_VCLOUD_NAMES      - list of Organization, vDC and vApp object names to backup (vCloud ONLY)  #
#                                                                                                   #
# Example:                                                                                          #
#                                                                                                   #
#   VIBE_VCLOUD_NAMES=ORG:VDC1,VDC2:VAPP1,VAPP2;ORG2:VDC3:;ORG3::VAPP6                              #
#                                                                                                   #
# VIBE_VSPHERE_NAMES       - list of Datastores and VMs to backup per vCenter (vSphere ONLY)        #
# VIBE_TRIM_VSPHERE_NAMES  - list of VMs to remove from backup per vCenter (vSphere ONLY)           #
#                                                                                                   #
# Example:                                                                                          #
#                                                                                                   #
#   VIBE_VSPHERE_NAMES=VCENTER1Smiley Very HappyS1:VM1;VCENTER2;DS2,DS3:;VCENTER3::VM4                             #
#   VIBE_TRIM_VSPHERE_NAMES=VCENTER1:VM99;VCENTER2:VM5,VM12                                         #
#                                                                                                   #
# RESTORE PARAMETERS                                                                                #
# ------------------                                                                                #
# VIBE_RESTORE_INTERVAL    - time between each restore check (default: 30 seconds)                  #
# VIBE_RESTORE_TIME        - total time to wait for complete restore (default: 3600 seconds)        #
# VIBE_VMWARE_SNAPSHOT     - take a VMware snapshot during backup (default: Y)                      #
#                                                                                                   #
# ALTERNATE PARAMETERS                                                                              #
# --------------------                                                                              #
# VIBE_NOPING                 - do not ICMP ping VMware or storage controllers (default: N)         #
# VIBE_DYNAMIC_VOLUMES_UPDATE - if set to 'N', does not perform dynamic volume update, which means  #
#                               you have to set VOLUMES, SNAPVAULT_VOLUMES, SNAPMIRROR_VOLUMES and  #
#                               NTAP_DFM_DATA_SET manually (default: not set)                       #
#####################################################################################################
VIBE_VCLOUD_IPADDR=
VIBE_VCLOUD_USER=
VIBE_VCLOUD_PASSWD=
VIBE_VCENTER_USER=
VIBE_VCENTER_PASSWD=

VIBE_VCLOUD_NAMES=
VIBE_VSPHERE_NAMES=

VIBE_VMWARE_SNAPSHOT=Y

# VIBE_TRIM_VSPHERE_NAMES=

# VIBE_RESTORE_INTERVAL=30
# VIBE_RESTORE_TIME=3600
# VIBE_NOPING=Y
################################
### SnapManager SQL Settings ###
################################
##################################################################################################
# SMSQL_PS_CONF - Path to the powershell configuration file for SMSQL                            #
#             #
#   SMSQL_PS_CONF="C:\Program Files\SnapManager for SQL Server\smsqlShell.psc1"     #
#             #
# SMSQL_BACKUP_OPTIONS - SMSQL backup options, Snap Creator uses a powershell new-backup cmdlet  #
#             #
#   SMSQL_BACKUP_OPTIONS=-svr 'SQL'  -d  'SQL\SHAREPOINT', '1', 'WSS_Content' -RetainBackups  7  #
#                        -lb -bksif -RetainSnapofSnapInfo 8 -trlog  -gen -mgmt standard   #
#             #
# SMSQL_SERVER_NAME - SMSQL server name                                                          #
# SMSQL_32bit - (Y|N) Setting to enable use of 32bit version of powershell                       #
##################################################################################################
SMSQL_PS_CONF="C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1"
SMSQL_BACKUP_OPTIONS=–svr 'SRV-SCA1'  -d  'SRV-SCA1', '1', 'Testing123' -ver  –verInst 'SRV-SCA1' -mp –mpdir 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 8 -rudays 7 –mgmt standard
SMSQL_SERVER_NAME=srv-sca1
SMSQL_32bit=N
#############################
### Lotus Domino Settings ###
#############################
###################################################################################
#                                                                                 #
# DOMINO_DATA_PATH - Path to Domino Data directory        #
#    eg:/notes/notesdata         #
# DOMINO_INI_PATH - Path to notes.ini file (include notes.ini in path)     #
#    eg:/notes/notesdata/notes.ini        #
# DOMINO_CHANGE_INFO_PATH - Path where change info files should be saved.         #
#                        Use a different volume than Domino Data or Log paths     #
#    eg:/notes/changeinfo         #
# DOMINO_DATABASE_TYPE - Can be any of the following values                       #
#                        0 = Backup everything ( 1+2+3 below)                     #
#                        1 = Backup only for *.BOX files.                         #
#                        2 = Backup only for *.NSF, *.NSG and  *.NSH files.       #
#                        3 = Backup only for *.NTF files.                         #
# LOTUS - Path where Domino is installed       #
#          eg:/opt/ibm/lotus              #
# Notes_ExecDirectory - Path that contains Domino shared object(.so or .dll)    #
#    files eg:/opt/ibm/lotus/notes/latest/linux/    #        
# DOMINO_RESTORE_DATA_PATH - Path to restored lotus data directory                #
#                        Use the same volume as the Domino Data path      #
#    Use the same path as DOMINO_DATA_PATH if restoring to   #
#    the same location eg:/notes/notesdata                    #
#            #
###################################################################################
DOMINO_DATA_PATH=
DOMINO_INI_PATH=
DOMINO_CHANGE_INFO_PATH=
DOMINO_DATABASE_TYPE=0
LOTUS=
Notes_ExecDirectory=
DOMINO_RESTORE_DATA_PATH=
#######################
### MAXDB Settings  ###
#######################
#################################################################################################################
# XUSER_ENABLE - (Y|N) Enables the use of an xuser for maxdb so password is not required for db user            #
# HANDLE_LOGWRITER - (Y|N) Executes suspend logwriter/resume logwriter if set to Y                              #
# DBMCLICMD - The path to the MaxDB dbmcli command, if not set dbmcli on the search path is used                #
# SQLCLICMD - The path to the MaxDB sqlcli command, if not set sqlcli on the search path is used                #
# MAXDB_UPDATE_HIST_LOG - (Y|N) Tells the maxdbbackup program if it should update maxdb hostory log             #
# MAXDB_DATABASES - List of database(s) and their username/password separated by a comma of which you           #
#             want to backup                                                                                    #
#                                                                                                               #
# MAXDB_DATABASES=db1:user1/password;db2:user2/password       #
#              #
# MAXDB_CLONE_META -                                                                                            #
#   source_sid - Database SID used on the source side                                                           #
#   target_sid - Database SID used on the target side                                                           #
#   target_db_path - top level directory of the MaxDB installation                                              #
#   dbm_user       - Target Database Management User                                                            #
#   dbm_passwd     - Password or authentication key of dbm_user                                                 #
#   dbadmin_user   - Target SQL User with DBA privileges                                                        #
#   dbadmin_passwd - Password or authentication key of dbadmin_user                                             #
#   os_user        - Target operating system user                                                               #
#   os_group       - Primary group of os_user                                                                   #
#                                                                                                               #
#   MAXDB_CLONE_META=PRD:QAS,/sapdb/QAS,dbm/secret,dbadmin/secret,sdb/sdba                                      #
#                                                                                                               #
# MAXDB_CLONE_ADAPT_FS -                                                                                        #
#   target_sid     - Database SID used on the target side                                                       #
#   path           - full qualified path, file access permissions will be changed recursively                   #
#                    wildcards are allowed                                                                      #
#                    multiple paths can be specified, separated by a comma                                      #
#                                                                                                               #
#   MAXDB_CLONE_ADAPT_FS=QAS:/sapdb/QAS/sapdata*                                                                #
#                                                                                                               #
# MAXDB_CLONE_RENAME_USER -                                                                                     #
#   target_sid     - Database SID used on the target side                                                       #
#   source_username- Schema/Table owner on the source side                                                      #
#   target_username- Schema/Table owner on the target side                                                      #
#                    Multiple source/target user can be specified, separated by a comma                         #
#                                                                                                               #
#   MAXDB_CLONE_RENAME_USER=QAS:sapprd/sapqas,sapprddb/sapqasdb                                                 #
#                                                                                                               #
# MAXDB_CLONE_RESIZE_LOG -                                                                                      #
#   target_sid     - Database SID used on the target side                                                       #
#   new log size   - log size in pages                                                                          #
#                                                                                                               #
#   MAXDB_CLONE_RESIZE_LOG=QAS:2000                                                                             #
#                                                                                                               #
# MAXDB_SOURCE_PRESERVE_PARAM -                                                                                 #
#   source_sid     - Database SID used on the source side                                                       #
#   parameter      - Parameter on the source that should be enabled on the target                               #
#                    Multiple Parameters can be specified, separated by a comma                                 #
#                                                                                                               #
#   MAXDB_SOURCE_PRESERVE_PARAM=PRD:MaxLogVolumes,MaxDataVolumes                                                #
#                                                                                                               #
# MAXDB_BACKUP_TEMPLATES - specifies for each database a backup template                                        #
#   template       - must be an existing backup template of type external                                       #
#                                                                                                               #
# MAXDB_BG_SERVER_PREFIX - prefix for naming the background server                                              #
#   <prefix>       - the prefix will be suffixed with the database id, if not specified, na_bg is being used    #
#                                                                                                               #
# MAXDB_CHECK_SNAPSHOT_DIR - setting to check, if a SC snapshot operation was successful and the snapshot       #
#                            has been taken.                                                                    #
#                            NFS only. directory must point to the directory which contains the .snapshot       #
#                               directory.                                                                      #
#                            Multiple directories can be specified as a comma separated list.                   #
#                            Multiple databases can be specified as a semicolon separated list.                 #
#                                                                                                               #
#                            In case of MaxDB 7.8 and newer, the database backup request will be marked as      #
#                               failed in the backup history. The shown error code identifies the number of     #
#                               missing snapshots.                                                              #
#                                                                                                               #
#   MAXDB_CHECK_SNAPSHOT_DIR=SID:directory[,directory...][SID2:directory[,directory...]                         #
#                                                                                                               #
#                                                                                                               #
#################################################################################################################
XUSER_ENABLE=N
HANDLE_LOGWRITER=Y
DBMCLICMD=/path/to/dbmcli
SQLCLICMD=/path/to/sqlcli
MAXDB_UPDATE_HIST_LOG=N
MAXDB_DATABASES=
MAXDB_CHECK_SNAPSHOT_DIR=
####################
### KVM Settings ###
####################

##################################################################################################################
# KVM_RESTORE_VM_LIST - (required only during restore) List of VMs to be restored.                               #
#                       ie: RHEL5U6,RHEL5U7                                                                      #
#                                                                                                                #
# KVM_VM_MAPPING - (required) List of mapping b/w VM and its associated storage controller, lun/file path.       #
#                  This param will be updated dynamically during discovery process.                              #
#                  ie: RHEL5U6:fas3170-201-76:/vol/vol_KVM/RHEL5U6;RHLE5U7:fas3170-201-76:/vol/vol_KVM/RHEL5U7;  #
#                                                                                                                #
# KVM_VM_CONFIG_DIR - (optional) Path to the directory where all the VM's XML configuration files will be stored.#
#                     Default value: /etc/libvirt/qemu                                                           #
#                                                                                                                #
# KVM_CMD_RETRY_COUNT - (optional) The number of times the command will be re-tried when failed in KVM plug-in.  #
#                       Default value: 3                                                                         #
#                                                                                                                #
##################################################################################################################
KVM_RESTORE_VM_LIST=
KVM_VM_MAPPING=
KVM_VM_CONFIG_DIR=
KVM_CMD_RETRY_COUNT=
################################
### XEN Config Settings ###
################################
##################################################################################################
# XEN_VMS - comma separated <hostname:vmname> pair.                             #
# XEN_HOST_USERS -comma seperated <hostname:username/password>           #
# XEN_BIN_PATH - Path of xe binary.
# XEN_METADATA_PATH - Path on the server where we can download the vm metadata information   #
# XEN_VM_SNAPSHOT - Turn off VM consistency snapshot. Applicable values are Y/N     #
##################################################################################################

XEN_VMS=
XEN_HOST_USERS=
XEN_BIN_PATH=
XEN_METADATA_PATH=
XEN_VM_SNAPSHOT=Y
###############################
### CACHE Plugin Settings   ###
###############################
##########################################################################################
# CACHE_BIN_PATH - Path to where the CACHE binaries are stored                           #
#                       defaults to '/usr/bin'                                           #
# CACHE_INSTANCE - the name of the CACHE instance                                        #
#                       defaults to 'CACHE'                                              #
# CACHE_USER - User Name for user executing freeze/thaw of the CACHE instance            #
#                       defaults to 'SCBackup'                                           #
# CACHE_VERBOSE - (1|0) 1 to turn on verbosity, 0 to turn off verbosity                  #
#                       defaults to 0  (ie verbose off)                                  #
# CACHE_SWITCH_JOURNAL - (1|0) 1 to switch journal on freeze, 0 to not switch journal    #
#                        defaults to 1 (ie switch journal)                               #
##########################################################################################
CACHE_BIN_PATH=
CACHE_INSTANCE=
CACHE_USER=
CACHE_VERBOSE=
CACHE_SWITCH_JOURNAL=
#########################
### Informix Settings ###
#########################
#########################################################################################################
# INFORMIX_USER - The username who has access to the informix database and onstat/onmode commands #
#             #
#   INFORMIX_USER=root           #
#             #
# ONSTAT_CMD - The path to the onstat command used to retrieve informix version    #
#             #
#   ONSTAT_CMD=onstat -           #
#             #
# ONMODE_CMD - The Path to the onmode command used to quiesce/unquiesce the informix database  #
#             #
#   ONMODE_CMD=onmode           #
#########################################################################################################
INFORMIX_USER=
ONSTAT_CMD=
ONMODE_CMD=

Re: SC SMSQL Issue (Powershell?)

Strange indeed

powershell or the cmdlet should not just return 0 and do nothing. What version of SC? If this is 3.6, try 3.5 agent. You maybe have to toggle the 32bit toggle on for 3.5 since it was backwards. Otherwise I dont see anything that jumps out at me. If you tell us what SC version we can have QA look at this and see if they can reproduce issue.

Regards,

Keith

Re: SC SMSQL Issue (Powershell?)

Hi Keith;

The version of both Server and Agent is 3.6.  I've already tried toggling the Powershell 32 bit option (Incidentally, when I did this, the path for running the powershell command as reported in the agent logs was identical to when I had the 32bit option turned off (ie, it ran powershell off of a system32 directory ... the 32bit version of powershell is in a directory off of the sysWOW64 directory).

I can try downgrading the agent side to 3.5 if you think this is worth trying?

--

Mark Lomas

Re: SC SMSQL Issue (Powershell?)

Yeah try downgrading agent to 3.5, in meantime I will have QA look at this. Also can you share the --debug output from the SC Server?

Keith

Re: SC SMSQL Issue (Powershell?)

Hi marklomas,

Can you please check your snapmanager service is running or not in your windows machine ?

Also it would be great if you can provide us the SC Server/Scagent debug outputs.

Regards

Hari

Re: SC SMSQL Issue (Powershell?)

Hi Mark,

Can you please try by increasing the Agent timeout to 2000, Because in this case you are taking backup as well as verifying the same so we need to double the agent timeout.

Thanks,

Nilesh

Re: SC SMSQL Issue (Powershell?)

I've downgraded the agent to 3.5.  Now I can see that the pwoershell command no longer executes with a '<NUL' on the end, and this means I'm getting some output in the 'stderr' log on the agent.  The output is:

new-backup : A positional parameter cannot be found that accepts argument '¶-sv

r'.

At line:1 char:11

+ new-backup <<<<  ¶-svr 'SRV-SCA1'  -d  'SRV-SCA1', '1', 'Testing123' -ver  ¶-

verInst 'SRV-SCA1' -mp ¶-mpdir 'C:\Program Files\NetApp\SnapManager for SQL Ser

ver\SnapMgrMountPoint' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 8 -ru

days 7 ¶-mgmt standard

    + CategoryInfo          : InvalidArgument: (Smiley Happy [new-backup], ParameterBind

   ingException

    + FullyQualifiedErrorId : PositionalParameterNotFound,SMSQLPSSnapIn.SMSQLB

   ackup

So - this looks like some problem with the power shell command, but according to the debug log of the agent, it's executing the following:

[Fri Aug  3 09:55:55 2012] DEBUG: Executing command [%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1" -command "new-backup –svr 'SRV-SCA1'  -d  'SRV-SCA1', '1', 'Testing123' -ver  –verInst 'SRV-SCA1' -mp –mpdir 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 8 -rudays 7 –mgmt standard"]

[Fri Aug  3 09:55:56 2012] INFO: Starting watchdog with [-3580], forced unquiesce timeout [905] second(s)

any thoughts?

--

Mark Lomas

Re: SC SMSQL Issue (Powershell?)

Made some progress - it seems that the problem of the command not being parsed properley (as with my last post) was that the wrong type of hyphen (no, seriously) had somehow crept into my powershell parameters!.  With that corrected, the command now runs, however I'm encountering another problem now.

I'm trying to get it to update my Protection Manager server, and during the process, I get the following error;

82 ########## Running Protection Manager Backup Version Create for dataset snapcreator_SQL1 ##########

83 [Mon Aug  6 16:29:01 2012] INFO: Registering snapshot SQL_SNAP_SCA-hourly_20120806162527 with Protection Manager dataset snapcreator_SQL1

84 [Mon Aug  6 16:29:01 2012] ERROR: [scf-00013] snapshot-unique-id must be specified in version-member-info. (code = 13001)

Now, the snapshot name it thinks it needs to use with protection manager, is not in-fact the one SnapManager has created when the PowerShell command executed.  This was a known issue (see https://communities.netapp.com/message/68739#68739 ) -however, the thread is from late last year, and there are numerous references to this being fixed in version 3.6.  Is this the case, or should I still go ahead and try using the community release (3.6c)?  Or is there some configuration option I need to be setting or changing to make it work?

Any help appreciated!!

--

Mark Lomas

Re: SC SMSQL Issue (Powershell?)

Hi Mark,

I'm having the same issue by the looks of it with SC not calling the SMSQL backup command, but if I manually run the command displayed in the agent log from the command prompt it completes successfully in ~30 secs (my SC_AGENT_TIMEOUT is currently at 300 - tried 900 but it didn't make any difference).

I've tried replacing all the hyphens in the powershell parameters in the config file but still no dice - here are my key SMSQL settings:

SMSQL_PS_CONF="C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1"

SMSQL_BACKUP_OPTIONS=-server 'VM-JOHNH-W2K3' -d 'VM-JOHNH-W2K3', '2', 'AdventureWorks', 'JHtest' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 7 -trlog  -gen -mgmt standard

On top of this, port 9090 for the agent appears to get stuck in CLOSE_WAIT status and I need to restart the agent service to clear it before trying again. I have these problems with both SC 3.5 and 3.6.

Here is the output from the server debug log:

=====================================================

[Fri Aug 17 08:26:05 2012] DEBUG: GMT - Thu Aug 16 22:26:05 2012
[Fri Aug 17 08:26:05 2012] DEBUG: Version: NetApp Snap Creator Framework 3.5.0
[Fri Aug 17 08:26:05 2012] DEBUG: Profile: test_profile
[Fri Aug 17 08:26:05 2012] DEBUG: Config Type: STANDARD
[Fri Aug 17 08:26:05 2012] DEBUG: Action: snap
[Fri Aug 17 08:26:05 2012] DEBUG: Application Plugin: smsql
[Fri Aug 17 08:26:05 2012] DEBUG: File System Plugin: null
[Fri Aug 17 08:26:05 2012] DEBUG: Policy: hourly
[Fri Aug 17 08:26:05 2012] DEBUG: Snapshot Name: sc_smsqltest-hourly_recent
[Fri Aug 17 08:26:05 2012] INFO: Logfile timestamp: 20120817082605

########## Parsing Environment Parameters ##########
[Fri Aug 17 08:26:05 2012] DEBUG: Parsing VOLUMES - controller: 10.10.150.93 volume: jhsql_db_1
[Fri Aug 17 08:26:05 2012] DEBUG: Parsing VOLUMES - controller: 10.10.150.93 volume: jhsql_log_1
[Fri Aug 17 08:26:05 2012] DEBUG: Parsing VOLUMES - controller: 10.10.150.93 volume: jhsql_snapinfo_1
[Fri Aug 17 08:26:05 2012] DEBUG: Parsing NTAP_USERS - controller: 10.10.150.93 user: sc_user
[Fri Aug 17 08:26:05 2012] DEBUG: Parsing NTAP_SNAPSHOT_RETENTIONS - policy: hourly retention: 4

########## PRE APPLICATION QUIESCE COMMANDS ##########
[Fri Aug 17 08:26:05 2012] INFO: No commands defined

########## PRE APPLICATION QUIESCE COMMANDS FINISHED SUCCESSFULLY ##########

########## Application quiesce ##########
[Fri Aug 17 08:31:06 2012] ERROR: 500 read timeout at /<C:\Program Files\Netapp\NetApp_Snap_Creator_Framework35\scServer3.5.0\snapcreator.exe>SnapCreator/Agent/Remote.pm line 474

[Fri Aug 17 08:31:06 2012] [10.10.150.158:9090(3.5.0.1)] ERROR: [scf-00053] Application quiesce for plugin smsql failed with exit code 1, Exiting!

########## Application unquiesce ##########
[Fri Aug 17 08:36:06 2012] ERROR: No valid response
[Fri Aug 17 08:36:06 2012] ERROR: [scf-00054] Application unquiesce for plugin smsql failed with exit code 1, Exiting!

########## PRE EXIT COMMANDS ##########
[Fri Aug 17 08:36:06 2012] INFO: No commands defined

########## PRE EXIT COMMANDS FINISHED SUCCESSFULLY ##########
[Fri Aug 17 08:36:06 2012] DEBUG: Exiting with error code - 2

=====================================================

And here is the agent debug log:

====================================================

[Fri Aug 17 08:26:06 2012] DEBUG: Executing command [%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1" -command "new-backup -server 'VM-JOHNH-W2K3' -d 'VM-JOHNH-W2K3', '2', 'AdventureWorks', 'JHtest' -RetainBackups  7 -lb -bksif -RetainSnapofSnapInfo 7 -trlog  -gen -mgmt standard"]

[Fri Aug 17 08:26:06 2012] INFO: Starting watchdog with [-3964], forced unquiesce timeout [305] second(s)

[Fri Aug 17 08:31:12 2012] INFO: Skipping unquiesce, nothing needed for SMSQL integration

====================================================

Was it only the hyphens in the SMSQL_BACKUP_OPTIONS field you replaced?

Cheers,

John

Re: SC SMSQL Issue (Powershell?)

Yeah, just the hyphens.  In the end though I had to create a new SC job not using the SQL plugin, and execute the SMSQL as a 'pre-quiesce' command.  You might want to give that a try.

--

Mark Lomas