dbatools

1.1.54

functions/Invoke-DbaAdvancedInstall.ps1

                                function Invoke-DbaAdvancedInstall {

    <#

    .SYNOPSIS

        Designed for internal use, implements parallel execution for Install-DbaInstance.

    .DESCRIPTION

        Invokes an install process for a single computer and restarts it if needed

    .PARAMETER ComputerName

        Target computer with SQL instance or instances.

    .PARAMETER Port

        After successful installation, changes SQL Server TCP port to this value. Overrides the port specified in -SqlInstance.

    .PARAMETER InstallationPath

        Path to setup.exe

    .PARAMETER ConfigurationPath

        Path to Configuration.ini on a local machine

    .PARAMETER ArgumentList

        Array of command line arguments for setup.exe

    .PARAMETER Version

        Canonic version of SQL Server, e.g. 10.50, 11.0

    .PARAMETER InstanceName

        Instance name to be used for the installation

    .PARAMETER Configuration

        A hashtable with custom configuration items that you want to use during the installation.

        Overrides all other parameters.

        For example, to define a custom server collation you can use the following parameter:

        PS> Install-DbaInstance -Version 2017 -Configuration @{ SQLCOLLATION = 'Latin1_General_BIN' }

        Full list of parameters can be found here: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt#Install

    .PARAMETER Restart

        Restart computer automatically after a successful installation of Sql Server and wait until it comes back online.

        Using this parameter is the only way to chain-install more than 1 instance, since every single patch will require a restart of said computer.

    .PARAMETER Credential

        Windows Credential with permission to log on to the remote server.

        Must be specified for any remote connection if installation media is located on a network folder.

    .PARAMETER Authentication

        Chooses an authentication protocol for remote connections.

        If the protocol fails to establish a connection

        Defaults:

        * CredSSP when -Credential is specified - due to the fact that repository Path is usually a network share and credentials need to be passed to the remote host to avoid the double-hop issue.

        * Default when -Credential is not specified. Will likely fail if a network path is specified.

    .PARAMETER PerformVolumeMaintenanceTasks

        Allow SQL Server service account to perform Volume Maintenance tasks.

    .PARAMETER SaveConfiguration

        Save installation configuration file in a custom location. Will not be preserved otherwise.

    .PARAMETER SaCredential

        Securely provide the password for the sa account when using mixed mode authentication.

    .PARAMETER NoPendingRenameCheck

        Disables pending rename validation when checking for a pending reboot.

    .PARAMETER WhatIf

        Shows what would happen if the command were to run. No actions are actually performed.

    .PARAMETER Confirm

        Prompts you for confirmation before executing any changing operations within the command.

    .PARAMETER EnableException

        By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.

        This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.

        Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.

    .NOTES

        Tags: Deployment, Install, Patching

        Author: Chrissy LeMaire (@cl), netnerds.net

        Website: https://dbatools.io

        Copyright: (c) 2018 by dbatools, licensed under MIT

        License: MIT https://opensource.org/licenses/MIT

    .LINK

    https://dbatools.io/Invoke-DbaAdvancedInstall

    .EXAMPLE

    PS C:\> Invoke-DbaAdvancedUpdate -ComputerName SQL1 -Action $actions

    Invokes update actions on SQL1 after restarting it.

    #>

    [CmdletBinding()]

    Param (

        [string]$ComputerName,

        [string]$InstanceName,

        [nullable[int]]$Port,

        [string]$InstallationPath,

        [string]$ConfigurationPath,

        [string[]]$ArgumentList,

        [version]$Version,

        [hashtable]$Configuration,

        [bool]$Restart,

        [bool]$PerformVolumeMaintenanceTasks,

        [string]$SaveConfiguration,

        [ValidateSet('Default', 'Basic', 'Negotiate', 'NegotiateWithImplicitCredential', 'Credssp', 'Digest', 'Kerberos')]

        [string]$Authentication = 'Credssp',

        [pscredential]$Credential,

        [pscredential]$SaCredential,

        [switch]$NoPendingRenameCheck,

        [switch]$EnableException

    )

    Function Get-SqlInstallSummary {

        # Reads Summary.txt from the SQL Server Installation Log folder

        Param (

            [DbaInstanceParameter]$ComputerName,

            [pscredential]$Credential,

            [parameter(Mandatory)]

            [version]$Version

        )

        $getSummary = {

            Param (

                [parameter(Mandatory)]

                [version]$Version

            )

            $versionNumber = "$($Version.Major)$($Version.Minor)".Substring(0, 3)

            $rootPath = "$([System.Environment]::GetFolderPath("ProgramFiles"))\Microsoft SQL Server\$versionNumber\Setup Bootstrap\Log"

            $summaryPath = "$rootPath\Summary.txt"

            $output = [PSCustomObject]@{

                Path              = $null

                Content           = $null

                ExitMessage       = $null

                ConfigurationFile = $null

            }

            if (Test-Path $summaryPath) {

                $output.Path = $summaryPath

                $output.Content = Get-Content -Path $summaryPath

                $output.ExitMessage = ($output.Content | Select-String "Exit message").Line -replace '^ *Exit message: *', ''

                # get last folder created - that's our setup

                $lastLogFolder = Get-ChildItem -Path $rootPath -Directory | Sort-Object -Property Name -Descending | Select-Object -First 1 -ExpandProperty FullName

                if (Test-Path $lastLogFolder\ConfigurationFile.ini) {

                    $output.ConfigurationFile = "$lastLogFolder\ConfigurationFile.ini"

                }

                return $output

            }

        }

        $params = @{

            ComputerName = $ComputerName.ComputerName

            Credential   = $Credential

            ScriptBlock  = $getSummary

            ArgumentList = @($Version.ToString())

            ErrorAction  = 'Stop'

            Raw          = $true

        }

        return Invoke-Command2 @params

    }

    $isLocalHost = ([DbaInstanceParameter]$ComputerName).IsLocalHost

    $output = [pscustomobject]@{

        ComputerName      = $ComputerName

        Version           = $Version

        SACredential      = $SaCredential

        Successful        = $false

        Restarted         = $false

        Configuration     = $Configuration

        InstanceName      = $InstanceName

        Installer         = $InstallationPath

        Port              = $Port

        Notes             = @()

        ExitCode          = $null

        ExitMessage       = $null

        Log               = $null

        LogFile           = $null

        ConfigurationFile = $null

    }

    $restartParams = @{

        ComputerName = $ComputerName

        ErrorAction  = 'Stop'

        For          = 'WinRM'

        Wait         = $true

        Force        = $true

    }

    if ($Credential) {

        $restartParams.Credential = $Credential

    }

    $activity = "Installing SQL Server ($Version) components on $ComputerName"

    try {

        $restartNeeded = Test-PendingReboot -ComputerName $ComputerName -Credential $Credential -NoPendingRename:$NoPendingRenameCheck

    } catch {

        $restartNeeded = $false

        Stop-Function -Message "Failed to get reboot status from $computer" -ErrorRecord $_

    }

    if ($restartNeeded -and $Restart) {

        # Restart the computer prior to doing anything

        $msgPending = "Restarting computer $($ComputerName) due to pending restart"

        Write-ProgressHelper -ExcludePercent -Activity $activity -Message $msgPending

        Write-Message -Level Verbose $msgPending

        try {

            $null = Restart-Computer @restartParams

            $output.Restarted = $true

        } catch {

            Stop-Function -Message "Failed to restart computer" -ErrorRecord $_

        }

    }

    # save config if needed

    if ($SaveConfiguration) {

        try {

            $null = Copy-Item $ConfigurationPath -Destination $SaveConfiguration -ErrorAction Stop

        } catch {

            $msg = "Could not save configuration file to $SaveConfiguration"

            Stop-Function -Message $msg -ErrorRecord $_

            $output.Notes += $msg

        }

    }

    $connectionParams = @{

        ComputerName = $ComputerName

        ErrorAction  = "Stop"

        UseSSL       = (Get-DbatoolsConfigValue -FullName 'PSRemoting.PsSession.UseSSL' -Fallback $false)

    }

    if ($Credential) { $connectionParams.Credential = $Credential }

    # need to figure out where to store the config file

    if ($isLocalHost) {

        $remoteConfig = $ConfigurationPath

    } else {

        try {

            Write-ProgressHelper -ExcludePercent -Activity $activity -Message "Copying configuration file to $ComputerName"

            $session = New-PSSession @connectionParams

            $chosenPath = Invoke-Command -Session $session -ScriptBlock { (Get-Item ([System.IO.Path]::GetTempPath())).FullName } -ErrorAction Stop

            $remoteConfig = Join-DbaPath $chosenPath.TrimEnd('\') (Split-Path $ConfigurationPath -Leaf)

            Write-Message -Level Verbose -Message "Copying $($ConfigurationPath) to remote machine into $chosenPath"

            $null = Send-File -Path $ConfigurationPath -Destination $chosenPath -Session $session -ErrorAction Stop

            $session | Remove-PSSession

        } catch {

            Stop-Function -Message "Failed to copy file $($ConfigurationPath) to $remoteConfig on $($ComputerName), exiting" -ErrorRecord $_

            return

        }

    }

    $installParams = $ArgumentList

    $installParams += "/CONFIGURATIONFILE=`"$remoteConfig`""

    Write-Message -Level Verbose -Message "Setup starting from $($InstallationPath)"

    $execParams = @{

        ComputerName   = $ComputerName

        ErrorAction    = 'Stop'

        Authentication = $Authentication

    }

    if ($Credential) {

        $execParams.Credential = $Credential

    } else {

        if (Test-Bound -Not Authentication) {

            # Use Default authentication instead of CredSSP when Authentication is not specified and Credential is null

            $execParams.Authentication = "Default"

        }

    }

    try {

        Write-ProgressHelper -ExcludePercent -Activity $activity -Message "Installing SQL Server on $ComputerName from $InstallationPath"

        $installResult = Invoke-Program @execParams -Path $InstallationPath -ArgumentList $installParams -Fallback

        $output.ExitCode = $installResult.ExitCode

        # Get setup log summary contents

        try {

            $summary = Get-SqlInstallSummary -ComputerName $ComputerName -Credential $Credential -Version $Version

            $output.ExitMessage = $summary.ExitMessage

            $output.Log = $summary.Content

            $output.LogFile = $summary.Path

            $output.ConfigurationFile = $summary.ConfigurationFile

        } catch {

            Write-Message -Level Warning -Message "Could not get the contents of the summary file from $($ComputerName). Related properties will be empty" -ErrorRecord $_

        }

    } catch {

        Stop-Function -Message "Installation failed" -ErrorRecord $_

        $output.Notes += $_.Exception.Message

        return $output

    } finally {

        try {

            # Cleanup remote temp

            Write-ProgressHelper -ExcludePercent -Activity $activity -Message "Cleaning up temporary files on $ComputerName"

            if (-not $isLocalHost) {

                $null = Invoke-Command2 @connectionParams -ScriptBlock {

                    if ($args[0] -like '*\Configuration_*.ini' -and (Test-Path $args[0])) {

                        Remove-Item -LiteralPath $args[0] -ErrorAction Stop

                    }

                } -Raw -ArgumentList $remoteConfig

            }

            # cleanup local temp config file

            Remove-Item $ConfigurationPath

        } catch {

            Stop-Function -Message "Temp cleanup failed" -ErrorRecord $_

        }

    }

    if ($installResult.Successful) {

        $output.Successful = $true

    } else {

        $msg = "Installation failed with exit code $($installResult.ExitCode). Expand 'ExitMessage' and 'Log' property to find more details."

        $output.Notes += $msg

        Stop-Function -Message $msg

        return $output

    }

    # perform volume maintenance tasks if requested

    if ($PerformVolumeMaintenanceTasks) {

        $null = Set-DbaPrivilege -ComputerName $ComputerName -Credential $Credential -Type IFI -EnableException:$EnableException

    }

    # change port after the installation

    if ($Port) {

        $null = Set-DbaTcpPort -SqlInstance "$($ComputerName)\$($InstanceName)" -Credential $Credential -Port $Port -EnableException:$EnableException -Confirm:$false

        try {

            $null = Restart-DbaService -ComputerName $ComputerName -InstanceName $InstanceName -Credential $Credential -Type Engine -Force -EnableException:$EnableException -Confirm:$false

        } catch {

            $output.Notes += "Port for $($ComputerName)\$($InstanceName) has been changed, but instance restart failed ($_). Restart of instance is necessary for the new settings to become effective."

        }

    }

    # restart if necessary

    try {

        $restartNeeded = Test-PendingReboot -ComputerName $ComputerName -Credential $Credential -NoPendingRename:$NoPendingRenameCheck

    } catch {

        $restartNeeded = $false

        Stop-Function -Message "Failed to get reboot status from $($ComputerName)" -ErrorRecord $_

    }

    if ($installResult.ExitCode -eq 3010 -or $restartNeeded) {

        if ($Restart) {

            # Restart the computer

            $restartMsg = "Restarting computer $($ComputerName) and waiting for it to come back online"

            Write-ProgressHelper -ExcludePercent -Activity $activity -Message $restartMsg

            Write-Message -Level Verbose -Message $restartMsg

            try {

                $null = Restart-Computer @restartParams

                $output.Restarted = $true

            } catch {

                Stop-Function -Message "Failed to restart computer $($ComputerName)" -ErrorRecord $_ -FunctionName Install-DbaInstance

                return $output

            }

        } else {

            $output.Notes += "Restart is required for computer $($ComputerName) to finish the installation of Sql Server version $Version"

        }

    }

    $output | Select-DefaultView -Property ComputerName, InstanceName, Version, Port, Successful, Restarted, Installer, ExitCode, LogFile, Notes

    Write-Progress -Activity $activity -Completed

}

# SIG # Begin signature block

# MIIZewYJKoZIhvcNAQcCoIIZbDCCGWgCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUCnwOge6xMWd1B8ZN0lZRL9qz

# YL2gghSJMIIE/jCCA+agAwIBAgIQDUJK4L46iP9gQCHOFADw3TANBgkqhkiG9w0B

# AQsFADByMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYD

# VQQLExB3d3cuZGlnaWNlcnQuY29tMTEwLwYDVQQDEyhEaWdpQ2VydCBTSEEyIEFz

# c3VyZWQgSUQgVGltZXN0YW1waW5nIENBMB4XDTIxMDEwMTAwMDAwMFoXDTMxMDEw

# NjAwMDAwMFowSDELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMu

# MSAwHgYDVQQDExdEaWdpQ2VydCBUaW1lc3RhbXAgMjAyMTCCASIwDQYJKoZIhvcN

# AQEBBQADggEPADCCAQoCggEBAMLmYYRnxYr1DQikRcpja1HXOhFCvQp1dU2UtAxQ

# tSYQ/h3Ib5FrDJbnGlxI70Tlv5thzRWRYlq4/2cLnGP9NmqB+in43Stwhd4CGPN4

# bbx9+cdtCT2+anaH6Yq9+IRdHnbJ5MZ2djpT0dHTWjaPxqPhLxs6t2HWc+xObTOK

# fF1FLUuxUOZBOjdWhtyTI433UCXoZObd048vV7WHIOsOjizVI9r0TXhG4wODMSlK

# XAwxikqMiMX3MFr5FK8VX2xDSQn9JiNT9o1j6BqrW7EdMMKbaYK02/xWVLwfoYer

# vnpbCiAvSwnJlaeNsvrWY4tOpXIc7p96AXP4Gdb+DUmEvQECAwEAAaOCAbgwggG0

# MA4GA1UdDwEB/wQEAwIHgDAMBgNVHRMBAf8EAjAAMBYGA1UdJQEB/wQMMAoGCCsG

# AQUFBwMIMEEGA1UdIAQ6MDgwNgYJYIZIAYb9bAcBMCkwJwYIKwYBBQUHAgEWG2h0

# dHA6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAfBgNVHSMEGDAWgBT0tuEgHf4prtLk

# YaWyoiWyyBc1bjAdBgNVHQ4EFgQUNkSGjqS6sGa+vCgtHUQ23eNqerwwcQYDVR0f

# BGowaDAyoDCgLoYsaHR0cDovL2NybDMuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl

# ZC10cy5jcmwwMqAwoC6GLGh0dHA6Ly9jcmw0LmRpZ2ljZXJ0LmNvbS9zaGEyLWFz

# c3VyZWQtdHMuY3JsMIGFBggrBgEFBQcBAQR5MHcwJAYIKwYBBQUHMAGGGGh0dHA6

# Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBPBggrBgEFBQcwAoZDaHR0cDovL2NhY2VydHMu

# ZGlnaWNlcnQuY29tL0RpZ2lDZXJ0U0hBMkFzc3VyZWRJRFRpbWVzdGFtcGluZ0NB

# LmNydDANBgkqhkiG9w0BAQsFAAOCAQEASBzctemaI7znGucgDo5nRv1CclF0CiNH

# o6uS0iXEcFm+FKDlJ4GlTRQVGQd58NEEw4bZO73+RAJmTe1ppA/2uHDPYuj1UUp4

# eTZ6J7fz51Kfk6ftQ55757TdQSKJ+4eiRgNO/PT+t2R3Y18jUmmDgvoaU+2QzI2h

# F3MN9PNlOXBL85zWenvaDLw9MtAby/Vh/HUIAHa8gQ74wOFcz8QRcucbZEnYIpp1

# FUL1LTI4gdr0YKK6tFL7XOBhJCVPst/JKahzQ1HavWPWH1ub9y4bTxMd90oNcX6X

# t/Q/hOvB46NJofrOp79Wz7pZdmGJX36ntI5nePk2mOHLKNpbh6aKLzCCBRowggQC

# oAMCAQICEAMFu4YhsKFjX7/erhIE520wDQYJKoZIhvcNAQELBQAwcjELMAkGA1UE

# BhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2lj

# ZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElEIENvZGUg

# U2lnbmluZyBDQTAeFw0yMDA1MTIwMDAwMDBaFw0yMzA2MDgxMjAwMDBaMFcxCzAJ

# BgNVBAYTAlVTMREwDwYDVQQIEwhWaXJnaW5pYTEPMA0GA1UEBxMGVmllbm5hMREw

# DwYDVQQKEwhkYmF0b29sczERMA8GA1UEAxMIZGJhdG9vbHMwggEiMA0GCSqGSIb3

# DQEBAQUAA4IBDwAwggEKAoIBAQC8v2N7q+O/vggBtpjmteofFo140k73JXQ5sOD6

# QLzjgija+scoYPxTmFSImnqtjfZFWmucAWsDiMVVro/6yGjsXmJJUA7oD5BlMdAK

# fuiq4558YBOjjc0Bp3NbY5ZGujdCmsw9lqHRAVil6P1ZpAv3D/TyVVq6AjDsJY+x

# rRL9iMc8YpD5tiAj+SsRSuT5qwPuW83ByRHqkaJ5YDJ/R82ZKh69AFNXoJ3xCJR+

# P7+pa8tbdSgRf25w4ZfYPy9InEvsnIRVZMeDjjuGvqr0/Mar73UI79z0NYW80yN/

# 7VzlrvV8RnniHWY2ib9ehZligp5aEqdV2/XFVPV4SKaJs8R9AgMBAAGjggHFMIIB

# wTAfBgNVHSMEGDAWgBRaxLl7KgqjpepxA8Bg+S32ZXUOWDAdBgNVHQ4EFgQU8MCg

# +7YDgENO+wnX3d96scvjniIwDgYDVR0PAQH/BAQDAgeAMBMGA1UdJQQMMAoGCCsG

# AQUFBwMDMHcGA1UdHwRwMG4wNaAzoDGGL2h0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNv

# bS9zaGEyLWFzc3VyZWQtY3MtZzEuY3JsMDWgM6Axhi9odHRwOi8vY3JsNC5kaWdp

# Y2VydC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDBMBgNVHSAERTBDMDcGCWCG

# SAGG/WwDATAqMCgGCCsGAQUFBwIBFhxodHRwczovL3d3dy5kaWdpY2VydC5jb20v

# Q1BTMAgGBmeBDAEEATCBhAYIKwYBBQUHAQEEeDB2MCQGCCsGAQUFBzABhhhodHRw

# Oi8vb2NzcC5kaWdpY2VydC5jb20wTgYIKwYBBQUHMAKGQmh0dHA6Ly9jYWNlcnRz

# LmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFNIQTJBc3N1cmVkSURDb2RlU2lnbmluZ0NB

# LmNydDAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBCwUAA4IBAQCPzflwlQwf1jak

# EqymPOc0nBxiY7F4FwcmL7IrTLhub6Pjg4ZYfiC79Akz5aNlqO+TJ0kqglkfnOsc

# jfKQzzDwcZthLVZl83igzCLnWMo8Zk/D2d4ZLY9esFwqPNvuuVDrHvgh7H6DJ/zP

# Vm5EOK0sljT0UQ6HQEwtouH5S8nrqCGZ8jKM/+DeJlm+rCAGGf7TV85uqsAn5JqD

# En/bXE1AlyG1Q5YiXFGS5Sf0qS4Nisw7vRrZ6Qc4NwBty4cAYjzDPDixorWI8+FV

# OUWKMdL7tV8i393/XykwsccCstBCp7VnSZN+4vgzjEJQql5uQfysjcW9rrb/qixp

# csPTKYRHMIIFMDCCBBigAwIBAgIQBAkYG1/Vu2Z1U0O1b5VQCDANBgkqhkiG9w0B

# AQsFADBlMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYD

# VQQLExB3d3cuZGlnaWNlcnQuY29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVk

# IElEIFJvb3QgQ0EwHhcNMTMxMDIyMTIwMDAwWhcNMjgxMDIyMTIwMDAwWjByMQsw

# CQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cu

# ZGlnaWNlcnQuY29tMTEwLwYDVQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQg

# Q29kZSBTaWduaW5nIENBMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA

# +NOzHH8OEa9ndwfTCzFJGc/Q+0WZsTrbRPV/5aid2zLXcep2nQUut4/6kkPApfmJ

# 1DcZ17aq8JyGpdglrA55KDp+6dFn08b7KSfH03sjlOSRI5aQd4L5oYQjZhJUM1B0

# sSgmuyRpwsJS8hRniolF1C2ho+mILCCVrhxKhwjfDPXiTWAYvqrEsq5wMWYzcT6s

# cKKrzn/pfMuSoeU7MRzP6vIK5Fe7SrXpdOYr/mzLfnQ5Ng2Q7+S1TqSp6moKq4Tz

# rGdOtcT3jNEgJSPrCGQ+UpbB8g8S9MWOD8Gi6CxR93O8vYWxYoNzQYIH5DiLanMg

# 0A9kczyen6Yzqf0Z3yWT0QIDAQABo4IBzTCCAckwEgYDVR0TAQH/BAgwBgEB/wIB

# ADAOBgNVHQ8BAf8EBAMCAYYwEwYDVR0lBAwwCgYIKwYBBQUHAwMweQYIKwYBBQUH

# AQEEbTBrMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20wQwYI

# KwYBBQUHMAKGN2h0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydEFz

# c3VyZWRJRFJvb3RDQS5jcnQwgYEGA1UdHwR6MHgwOqA4oDaGNGh0dHA6Ly9jcmw0

# LmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcmwwOqA4oDaG

# NGh0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RD

# QS5jcmwwTwYDVR0gBEgwRjA4BgpghkgBhv1sAAIEMCowKAYIKwYBBQUHAgEWHGh0

# dHBzOi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwCgYIYIZIAYb9bAMwHQYDVR0OBBYE

# FFrEuXsqCqOl6nEDwGD5LfZldQ5YMB8GA1UdIwQYMBaAFEXroq/0ksuCMS1Ri6en

# IZ3zbcgPMA0GCSqGSIb3DQEBCwUAA4IBAQA+7A1aJLPzItEVyCx8JSl2qB1dHC06

# GsTvMGHXfgtg/cM9D8Svi/3vKt8gVTew4fbRknUPUbRupY5a4l4kgU4QpO4/cY5j

# DhNLrddfRHnzNhQGivecRk5c/5CxGwcOkRX7uq+1UcKNJK4kxscnKqEpKBo6cSgC

# PC6Ro8AlEeKcFEehemhor5unXCBc2XGxDI+7qPjFEmifz0DLQESlE/DmZAwlCEIy

# sjaKJAL+L3J+HNdJRZboWR3p+nRka7LrZkPas7CM1ekN3fYBIM6ZMWM9CBoYs4Gb

# T8aTEAb8B4H6i9r5gkn3Ym6hU/oSlBiFLpKR6mhsRDKyZqHnGKSaZFHvMIIFMTCC

# BBmgAwIBAgIQCqEl1tYyG35B5AXaNpfCFTANBgkqhkiG9w0BAQsFADBlMQswCQYD

# VQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGln

# aWNlcnQuY29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVkIElEIFJvb3QgQ0Ew

# HhcNMTYwMTA3MTIwMDAwWhcNMzEwMTA3MTIwMDAwWjByMQswCQYDVQQGEwJVUzEV

# MBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29t

# MTEwLwYDVQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQgVGltZXN0YW1waW5n

# IENBMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvdAy7kvNj3/dqbqC

# mcU5VChXtiNKxA4HRTNREH3Q+X1NaH7ntqD0jbOI5Je/YyGQmL8TvFfTw+F+CNZq

# FAA49y4eO+7MpvYyWf5fZT/gm+vjRkcGGlV+Cyd+wKL1oODeIj8O/36V+/OjuiI+

# GKwR5PCZA207hXwJ0+5dyJoLVOOoCXFr4M8iEA91z3FyTgqt30A6XLdR4aF5FMZN

# JCMwXbzsPGBqrC8HzP3w6kfZiFBe/WZuVmEnKYmEUeaC50ZQ/ZQqLKfkdT66mA+E

# f58xFNat1fJky3seBdCEGXIX8RcG7z3N1k3vBkL9olMqT4UdxB08r8/arBD13ays

# 6Vb/kwIDAQABo4IBzjCCAcowHQYDVR0OBBYEFPS24SAd/imu0uRhpbKiJbLIFzVu

# MB8GA1UdIwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMBIGA1UdEwEB/wQIMAYB

# Af8CAQAwDgYDVR0PAQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMIMHkGCCsG

# AQUFBwEBBG0wazAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29t

# MEMGCCsGAQUFBzAChjdodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNl

# cnRBc3N1cmVkSURSb290Q0EuY3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8v

# Y3JsNC5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqg

# OKA2hjRodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURS

# b290Q0EuY3JsMFAGA1UdIARJMEcwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIB

# FhxodHRwczovL3d3dy5kaWdpY2VydC5jb20vQ1BTMAsGCWCGSAGG/WwHATANBgkq

# hkiG9w0BAQsFAAOCAQEAcZUS6VGHVmnN793afKpjerN4zwY3QITvS4S/ys8DAv3F

# p8MOIEIsr3fzKx8MIVoqtwU0HWqumfgnoma/Capg33akOpMP+LLR2HwZYuhegiUe

# xLoceywh4tZbLBQ1QwRostt1AuByx5jWPGTlH0gQGF+JOGFNYkYkh2OMkVIsrymJ

# 5Xgf1gsUpYDXEkdws3XVk4WTfraSZ/tTYYmo9WuWwPRYaQ18yAGxuSh1t5ljhSKM

# Ycp5lH5Z/IwP42+1ASa2bKXuh1Eh5Fhgm7oMLSttosR+u8QlK0cCCHxJrhO24XxC

# QijGGFbPQTS2Zl22dHv1VjMiLyI2skuiSpXY9aaOUjGCBFwwggRYAgEBMIGGMHIx

# CzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3

# dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJ

# RCBDb2RlIFNpZ25pbmcgQ0ECEAMFu4YhsKFjX7/erhIE520wCQYFKw4DAhoFAKB4

# MBgGCisGAQQBgjcCAQwxCjAIoAKAAKECgAAwGQYJKoZIhvcNAQkDMQwGCisGAQQB

# gjcCAQQwHAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwIwYJKoZIhvcNAQkE

# MRYEFJKXLUPb1zg7RI38SJtB9tPqrhyqMA0GCSqGSIb3DQEBAQUABIIBAKBvSyOH

# W9mS/oSVJDk4CowiC1RKMWV9qsHeNIBl2TGrjPpWFUHIOCefzpzUT96LXISVTa6g

# U+EwrpkEpmf+cICt1BenYGOp+YuFXDQwG+t2rv6vrxFSmbKeA/TeGtO/t4A/km4X

# XLJlKttJVR/L1V5H5P9BE/zuygI7nzWGvXXGkfjIYvY3SR/FBg50hG1L2PC54nRf

# AwZHvack2FJGft6pEp4nC7RgFnx4oO1UyT1EkNwX0APbx+Lf8Z3lSvNzk/rXBLY1

# vN0dvPaOS79z1c1QRnzIUTCe7KCOD9XOvQtVTfxfSTIVcBoSaZI2YniSGBCw5g9p

# Kz6czJ/Pcd2Ox6+hggIwMIICLAYJKoZIhvcNAQkGMYICHTCCAhkCAQEwgYYwcjEL

# MAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3

# LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElE

# IFRpbWVzdGFtcGluZyBDQQIQDUJK4L46iP9gQCHOFADw3TANBglghkgBZQMEAgEF

# AKBpMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTIy

# MDExNTEzMDU0OFowLwYJKoZIhvcNAQkEMSIEIKMeAjh4sbrXcUnt5xtCpEbDp83B

# 0E+RidS3rJxWkP/+MA0GCSqGSIb3DQEBAQUABIIBAC2kw3k5hLS0CHVwMXO03MR9

# h5PxeEXvKjXJ6tz2foRJyFwMBTMXogZBaILPapnFZRbNuVP2N4bXczC+kw46oPTF

# OtZyDC9dhXJ3qpllsqdHkH2oE95JsJNiz3E7YQHkY8iuAPOdV91asjlBDfWtwHfz

# y5LdWqg4fNicLRDfa6FE/hDJ7n6vYEU3t1R0GNQ/J4mOOdiXmuZ6T3X/81gnCQE2

# Hneeu+rgNhJ9zXX+LNwvneL8Cu0lzUwWTL2WCbjxP+NOJ0ltxKEUxjLect2nb++6

# 4nMZuA7F8bd7h1t2f5Exteymc+5SKNMGDIvWvgoZ8XOckfI6bc77sFmv/UOE0JI=

# SIG # End signature block