PROBLEM DESCRIPTION:
Messages are stuck in the outgoing queue on an MSMQ Sender, and cannot be sent the cluster.
RESOLUTION:
Once we determined that public queues were being used, we found that MSMQ was associated with the wrong site. Most likely this was due to the cluster having multiple IPs, and MSMQ choosing the incorrect IP to determine site membership. Implementing the BindInterfaceIP registry key should avoid this from happening in the future.
$TargetDCName = "servername"
[array]$logDeviceIDList = @()
[array]$LogDriveLetters = "H","I","J","K","L","M","N","O","P","Q","R","S"
[array]$LogDiskNumbers = @()
[array]$dbDeviceIDList = @()
[array]$DBDiskNumbers = @()
$sgprefix = (hostname).Substring((hostname).Length - 4,4) + "-SG"
$logdiskpartInputFile = (get-childitem env:TMP).Value + "\logdiskpart.in"
$dbdiskpartinputfile = (get-childitem env:TMP).Value + "\DBdiskpart.in"
$logformatbatchFile = (get-childitem env:TMP).Value + "\logformatVolumes.bat"
$dbFormatBatchFile = (get-childitem env:TMP).Value + "\DBformatVolumes.bat"
Function Delete-IfExists
{cn
if (test-path $args[0])
{
write-warning "Deleting existing $args[0] file"
(get-childitem $args[0]).Delete()
}
}
Function Get-SGNumber
{#determine if the SG number is 9 or less. If so, add a leading zero for clarity and admin view in the console and powershell.
if ($i+1 -lt 10)
{
$SG = "0"+[string]($i+1)
}
else
{
$SG = [string]($i+1)
}
return $SG
}
#delete batch/script files if they exist in %tmp%
delete-IfExists $logDiskPartInputFile
delete-ifexists $dbdiskpartinputfile
delete-ifexists $logformatbatchfile
delete-ifexists $dbformatbatchfile
################################
#DEFINE LOG DRIVES
$LogDrives = get-wmiobject win32_diskdrive | where {[math]::Round($_.size/1024/1024/1024,0) -eq 89}
if ($LogDrives.Count -eq 12)
{
foreach ($logdrive in $logdrives)
{
if ($logdrive.DeviceID.Length -eq 18)
{
$logDeviceIDList = $logDeviceIDList + ($LogDrive.DeviceID -replace ("DRIVE","DRIVE0"))
}
else
{
$logDeviceIDList = $logDeviceIDList + $LogDrive.DeviceID
}
}
}
#generate the array of disk numbers for diskpart's "SELECT DISK " command
$logDeviceIDList | sort | foreach {
$logDiskNumbers = $logDiskNumbers + $_.Substring($_.Length - 2,2)
}
#generate the logdiskpart.in file in %TMP% for logfiles
for ($i=0; $i -lt 12; $i++)
{
$SGNumber = Get-SGNumber
add-content -path $logdiskpartInputFile -value ("select disk " + $LogDiskNumbers[$i])
add-content -path $logdiskpartInputFile -value ("create partition primary align = 1024")
add-content -path $logdiskpartInputFile -value ("assign letter " + $logDriveLetters[$i] + ":")
add-content -path $logformatbatchFile -value ("format " + $logDriveLetters[$i] + ": /a:64K /FS:NTFS /v:" + $SGPrefix + $SGNumber + " /q /y")
}
$i = $null #reset the counter for later use
write-warning "In 5 seconds, the below dispart script will run. To cancel, press Ctrl-C NOW"
sleep 1
gc $logdiskpartInputFile
sleep 5
write-host "Running diskpart..."
diskpart.exe /s $logdiskpartinputfile
write-warning "In 5 seconds, the below format script will run. To cancel, press Ctrl-C NOW"
sleep 1
gc $logformatbatchFile
sleep 5
write-host "Running format..."
cmd.exe /c $logformatbatchFile
#Create mount point placeholder folders and log folders
for ($i=0; $i -lt 12; $i++)
{
$SGNumber = Get-SGNumber
new-item -path ($logdriveletters[$i] + ":") -name ($sgprefix + $SGNumber + "-DB" + $SGNumber) -type directory
new-item -path ($logdriveletters[$i] + ":") -name ($sgprefix + $SGNumber + "-Logs") -type directory
}
$i = $null
#################################
#DEFINE DB MOUNT POINTS
$DBDrives = get-wmiobject win32_diskdrive | where {[math]::Round($_.size/1024/1024/1024,0) -eq 132}
if ($DBDrives.Count -eq 12)
{
foreach ($DBdrive in $DBdrives)
{
if ($DBdrive.DeviceID.Length -eq 18)
{
$DBDeviceIDList = $DBDeviceIDList + ($DBDrive.DeviceID -replace ("DRIVE","DRIVE0"))
}
else
{
$DBDeviceIDList = $DBDeviceIDList + $DBDrive.DeviceID
}
}
}
#generate the array of disk numbers for diskpart "SELECT DISK" command
$DBDeviceIDList | sort | foreach {
$DBDiskNumbers = $DBDiskNumbers + $_.Substring($_.Length - 2,2)
}
for ($i=0; $i -lt 12; $i++)
{
$SGNumber = Get-SGNumber
add-content -path $DBdiskpartInputFile -value ("select disk " + $DBDiskNumbers[$i])
add-content -path $DBdiskpartInputFile -value ("create partition primary align = 1024")
add-content -path $DBdiskpartInputFile -value ("assign mount " + $logdriveletters[$i] + ":\" + $sgPrefix + $SGNumber + "-DB" + $SGNumber)
add-content -path $DBformatbatchFile -value ("format " + $logdriveletters[$i] + ":\" + $sgPrefix + $SGNumber + "-DB" + $SGNumber + " /a:64K /FS:NTFS /v:" + $SGPrefix + $SGNumber + "-DB" + $SGNumber + " /q /y")
}
$i = $null #reset the counter for later use
write-warning "In 5 seconds, the below dispart script will run. To cancel, press Ctrl-C NOW"
sleep 1
gc $DBdiskpartInputFile
sleep 5
write-host "Running diskpart..."
diskpart.exe /s $DBdiskpartinputfile
write-warning "In 5 seconds, the below format script will run. To cancel, press Ctrl-C NOW"
sleep 1
gc $DBformatbatchFile
sleep 5
write-host "Running format..."
cmd.exe /c $DBformatbatchFile
#################################################
# CREATE STORAGE GROUPS AND DATABASES
write-warning "To skip the storage group and database provisioning, press CTRL+C NOW"
sleep 5
for ($i=0; $i -lt 12; $i++)
{
$SGNumber = Get-SGNumber
$SGFilesPath = $logdriveletters[$i] + ":\" + $sgprefix + $SGNumber + "-Logs"
$DatabaseFilePath = $logdriveletters[$i] + ":\" + $sgPrefix + $SGNumber + "-DB" + $SGNumber
new-StorageGroup -Name ("SG" + $SGNumber) -LogFolderPath $SgFilesPath -SystemFolderPath $sgFilesPath -DomainController $TargetDCName | foreach {new-mailboxdatabase -StorageGroup $_.Name -Name ("DB" + $SGNumber) -DomainController $targetDCName}
if ($args.count -ne 2){
write-host "usage: installcluster.ps1 10.0.0.1(virtual ip of the cluster) PRBMSGHUB001(file share wittness name)"
break}
else{
$clusterVname = ((hostname).substring(0,(hostname).Length - 1)+'v') -replace "PRB","PRC"
$clusterBname = (hostname).substring(0,(hostname).Length - 1)+'b'
$creds = get-credential
$ClusterSvc = $creds.Username
$ClusterPwd = $creds.Password
$clusterVIPAddress = $args[0]
$fswName = $args[1]
write-host""
write-host "Cluster Configuration Parameters:"
write-host "=================================================="
write-host ""
write-host "Virtual cluster name: " $clusterVName
write-host "Cluster IP address: " $clusterVIPAddress
write-host "Cluster service account: " $clusterSvc
write-host "=================================================="
write-host ""
write-host "The cluster configuration will execute in 10 seconds. To cancel, press Ctrl-C"
start-sleep -s 10
Cluster.exe /cluster:$clustervname /create /node:(hostname) /ipaddress:$clusterVIPAddress /user:$ClusterSvc /min
Cluster.exe $clusterVName res "Majority Node Set" /create /group:`"Cluster Group`" /type:`"Majority Node Set`"
Cluster.exe $clusterVName res `"Majority Node Set`" /online
Cluster.exe $clusterVName /quorum:`"Majority Node Set`"
Cluster.exe $clusterVName res `"Local Quorum`" /offline
Cluster.exe $clusterVName res `"Local Quorum`" /delete
write-host "================================================="
write-host "Completed the cluster configuration for node A."
write-host ""
write-host "WARNING: Node $clusterbname will be added in 10 seconds. To cancel, press Ctrl+C"
start-sleep -s 10
cluster.exe $clusterVName /add:$clusterbname /min
write-host "================================================="
write-host "Completed the cluster configuration for node B."
write-host "Creating File Share Witness share:"
new-item \\$fswname\c$\MNS_FSW_$clusterVName -type directory
$Class = "Win32_Share"
$Method = "Create"
$MC = [WmiClass]"\\$FSWName\ROOT\CIMV2:$Class"
$InParams = $mc.psbase.GetMethodParameters($Method)
$InParams.Access = $null
$InParams.Description = "$clusterVName file share witness"
$InParams.MaximumAllowed = 10
$InParams.Name = [string]"MNS_FSW_$clusterVname"
$InParams.Password = $null
$InParams.Path = "C:\MNS_FSW_$clusterVname"
$InParams.Type = [uint32]0
$result = $mc.PSBase.InvokeMethod($Method, $inParams, $Null)
if ($result.ReturnValue -ne 0) {
write-host "Failed to create MNS Share"
}
else
{
write-host "Created MNS share succesfully. Please set appropriate security ACLs on the share (by default, everyone has full access = VERY BAD)."
cluster.exe $clusterVName res `"Majority Node Set`" /priv MNSFIleShare=\\$fswName\MNS_FSW_$clusterVName
cluster.exe $clusterVName group `"Cluster Group`" /move
cluster.exe $clusterVName res `"Majority Node Set`" /priv
cluster.exe $clustervName /priv HeartBeatLostInterfaceTicks=10:DWORD
cluster.exe $clustervName /priv HeartBeatLostNodeTicks=10:DWORD
cluster.exe $clusterVname network "Heartbeat" /prop Role=1
cluster.exe $clusterVname /setnetpri:"Heartbeat","Team"
write-host "Please reboot each cluster node to complete configuration."
write-host "It is also necessary to change share permissions on the MNS FSW"
}
