ssh connection and remote output in local shell

Question

I would like to run a local command file remotely and get the output locally in my shell window.

Actually the command executes remotely but I do not see the results in my local shell/console window.

Any idea on how to implement the following command?

ssh user@host 'bash -s' < /Users/daniel/bin/bash/fz_multiple_db_connections.sh

Where fz_multiple_db_connections.sh contains:

#!/bin/bash
connections=(
             'mysql -u dbuser__name      --password=passw   dbname ' 
             'mysql -u dbuser__name1     --password=passw1  dbname1')

for f in "${connections[@]}"
do
    echo `${f}`
    echo `mysql show tables`
    echo `mysql exit`
done
exit

twalberg · Accepted Answer · 2012-08-24 14:42:25Z

1

I think you'll probably need to do ssh -t .... to allocate a tty. Programs that strictly write to stdout or std::cout should work fine without the -t, but if the program you're running needs access to /dev/tty (or any of it's equivalents), for example, to ask for a password or something, you need the -t option to ssh.

answered Aug 24, 2012 at 14:42

twalberg

63k12 gold badges95 silver badges88 bronze badges

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

Comments

James Kirkby · Accepted Answer · 2012-08-24 13:54:05Z

0

-v verbose output

http://docstore.mik.ua/orelly/networking_2ndEd/ssh/ch07_03.htm

answered Aug 24, 2012 at 13:54

James Kirkby

1,8345 gold badges26 silver badges46 bronze badges

Collectives™ on Stack Overflow

ssh connection and remote output in local shell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related