#!/usr/bin/expect
if { [llength $argv] < 4 } {
puts "Usage: $argv0 ip user passwd port commands timeout"
exit 1
}
match_max 600000
set ip [lindex $argv 0]
set user [lindex $argv 1]
set passwd [lindex $argv 2]
set port [lindex $argv 3]
set commands [lindex $argv 4]
set timeoutflag [lindex $argv 5]
set yesnoflag 0
set timeout $timeoutflag
for {} {1} {} {
# for is only used to retry when "Interrupted system call" occured
spawn /usr/bin/ssh -q -l$user -p$port $ip
expect {
"assword:" {
send "$passwd\r"
break;
}
"yes/no)?" {
set yesnoflag 1
send "yes\r"
break;
}
"FATAL" {
puts "\nCONNECTERROR: $ip occur FATAL ERROR!!!\n"
exit 1
}
timeout {
puts "\nCONNECTERROR: $ip Logon timeout!!!\n"
exit 1
}
"No route to host" {
puts "\nCONNECTERROR: $ip No route to host!!!\n"
exit 1
}
"Connection Refused" {
puts "\nCONNECTERROR: $ip Connection Refused!!!\n"
exit 1
}
"Connection refused" {
puts "\nCONNECTERROR: $ip Connection Refused!!!\n"
exit 1
}
"Host key verification failed" {
puts "\nCONNECTERROR: $ip Host key verification failed!!!\n"
exit 1
}
"Illegal host key" {
puts "\nCONNECTERROR: $ip Illegal host key!!!\n"
exit 1
}
"Connection Timed Out" {
puts "\nCONNECTERROR: $ip Logon timeout!!!\n"
exit 1
}
"Interrupted system call" {
puts "\n$ip Interrupted system call!!!\n"
}
}
}
if { $yesnoflag == 1 } {
expect {
"assword:" {
send "$passwd\r"
}
"yes/no)?" {
set yesnoflag 2
send "yes\r"
}
}
}
if { $yesnoflag == 2 } {
expect {
"assword:" {
send "$passwd\r"
}
}
}
expect {
"#" {send "$commands \r"}
">" {send "$commands \r"}
"$" {send "$commands \r"}
"assword:" {
send "$passwd\r"
puts "\nPASSWORDERROR: $ip Password error!!!\n"
exit 1
}
}
expect {
"#" {send "sleep 1 \r"}
">" {send "sleep 1 \r"}
"$" {send "sleep 1 \r"}
}
expect {
"#" {send "exit\r"}
">" {send "exit\r"}
"$" {send "exit\r"}
}
expect eof {
puts "OK_SSH: $ip\n"
exit 0;
}
[root@mydb1 home]# cat ndbstop.sh
#!/bin/bash
#mysql节点
mgmip1=192.168.1.91
mgmip2=192.168.1.94
ndbip1=192.168.1.91
ndbip2=192.168.1.94
mysqlip1=192.168.1.91
mysqlip2=192.168.1.94
#管理节点启动
#mgmstart="ndb_mgmd -f /var/lib/mysql-cluster/config.ini --initial"
sqlstop="service mysql stop"
mgmstop='ndb_mgm -e shutdown'
echo $mgmstop
/home/test.exp $mgmip1 root root001 22 "${mgmstop}" 10
/home/test.exp $mgmip2 root root001 22 "${mgmstop}" 10
#/home/test.exp $mgmip1 root root001 22 $ndbmtd 20
#/home/test.exp $mgmip2 root root001 22 $ndbmtd 20
/home/test.exp $mgmip1 root root001 22 "${sqlstop}" 20
/home/test.exp $mgmip2 root root001 22 "${sqlstop}" 20