How to do a sequential SSH to a server using a batch of commands

Question

I'm working on a db server but I must ssh many times to access to it. Something like this:

step1) ssh [email protected]
pw: xxx

step2) ssh [email protected]
pw:yyy

step3) sudo mysqlsh
pw:zzzz

step4) mysql -u root -paaaa
use mydb;

How to run these commands in a sequence? I want to create a script batch to do it. How to do it?

Update: Itried to do this but doesn't work. It just log in the first time.

#!/usr/local/bin/expect

spawn ssh xxx@xxx
expect "*password:"
send "xxx\r";
interact

expect "*$ "
spawn ssh yyy@yyy
expect "*password:"
send "yyy\r";
interact

joeslice · Accepted Answer · 2011-12-07 02:42:48Z

3

Check out linux command "expect".

answered Dec 7, 2011 at 2:42

joeslice

3,4841 gold badge21 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Matt H Over a year ago

Ditto, I use expect for this.

emeraldhieu Over a year ago

Can you post the script to do the above 4 steps?

emeraldhieu Over a year ago

I read it and try hard. Your solution can't shh in sequence for sure because "expect" just do at the first level. After logging in xxx@xxx, it can't ssh continuously.

dstromberg · Accepted Answer · 2011-12-07 04:18:40Z

0

I usually see "expect" as giving up, though I have been known to essentially rewrite expect in python to wrap something I don't have source code to.

I'd suggest: Steps 1&2: Use passwordless, passphraseless DSA keys. Step 3: /etc/sudoers can be modified to make sudo not require a password. Step 4: Looks like you're already there.

answered Dec 7, 2011 at 4:18

dstromberg

7,2432 gold badges31 silver badges30 bronze badges

Collectives™ on Stack Overflow

How to do a sequential SSH to a server using a batch of commands

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related