I have create a surebackup job and virtual lab for execute a script. This script use a SSH connection for executed MySQLCheck on remote Mysql server
(192.168.2.45) and send a repport by email.
Ive tested my script in my vLab and it's ok, however in production environnement with Veeam B/R it remain bloqued on surebackup script who include
SSH/MySQLCheck connection.
i'm sure my errors is in virtual lab configuration (Appliance IP, mask..). It must define static route or it not necessary ?
---------------------------------------------------------------------------------------------------
CONFIG VIRTUAL LAB
Appliance:
...
Production network name:VM Network
IP: DHCP
Subnet mask: 255.255.254.0
Default gateway: 192.168.2.254
Network configuration type: Advanced
Network options:
Isolated network: Virtual Lab tst VM Network
Masquerade IP: 192.255.254.0 (auto)
Appliance IP: 192.168.2.254
DHCP: enabled
Network mapping:
VM Network --> Virtual Lab tst VM Network
---------------------------------------------------------------------------------------------------
Rapport send by Veeam:
6/16/2015 6:52:16 PM Error Starting virtual lab routing engine
6/16/2015 6:52:16 PM Error Timed out waiting for proxy appliance to respond. Possible causes:
6/16/2015 6:52:16 PM Error 1. Appliance is configured to run on different network than backup server
6/16/2015 6:52:16 PM Error 2. Appliance is configured to obtain IP address automatically, but DHCP server is not available
6/16/2015 6:52:18 PM Error: The operation has timed out.
---------------------------------
SCHEMA VLAB NETWORK
CODE SCRIPT
Code: Select all
# SERVER CONNECT & MYSQLCHECK EXE
$command= "& 'C:\Users\Administrateur\Desktop\plink.exe' -ssh user@192.168.2.45 -pw test mysqlcheck -u user -ptest --all-databases"
$mysqlCheck= Invoke-Expression $command
$erreurMsg= $error[0].Exception
if([string]::IsNullOrEmpty($erreurMsg)) {
echo "not erreur"
send-mailmessage -to "user@local.com" -from "user@local.com" -subject "RESULT [SUREBACKUP JOB 1]" -BodyAsHtml "error" -priority High -dno onSuccess, onFailure -smtpServer smtp.local.com -UseSsl
}
else {
echo "error"
send-mailmessage -to "user@local.com" -from "user@local.com" -subject "RESULT [SUREBACKUP JOB 1]" -BodyAsHtml "no error" -priority High -dno onSuccess, onFailure -smtpServer smtp.local.com -UseSsl
}