topic Re: Need help with ssh to multiple hosts with pipe in Operating System - HP-UX

Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 06:44:13 GMT

Hi!

I have the following command which is NOT working, the way I want it to.

The intention is to ssh to a list of servers from an admin box and issue a command against a list of PID and find out the name of the PID.

for i in `cat /tmp/list`; do echo "-------------------$i----------------" ; ssh $i "lsof |grep db|grep EST|awk '{print $2}'|sort|uniq | while read i ;do ps -ef|grep $i;done " ; done

Please help!

Thanks,

Allan.

Re: Need help with ssh to multiple hosts with pipe

Dennis Handly — Thu, 29 Nov 2012 06:59:04 GMT

>which is NOT working, the way I want it to.

How is it failing?

for i in $(< /tmp/list); do

echo "-------------------$i----------------"

ssh $i "lsof | grep db | grep EST| awk '{print $2}' | sort | uniq | while read i ; do ps -ef | grep $i; done"

done

I can think of one thing. The "grep $i" is expanded from the outer for loop variable. Better to use different descriptive names and also quote the remote variable: (And don't put it all on one line. :-) Test it first though.

for node in $(< /tmp/list); do

echo "-------------------$node----------------"

ssh $node "lsof | grep db | grep EST | awk '{print $2}' | sort -u |

while read file; do

ps -ef | grep \$file

done"

done

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 07:44:46 GMT

Thanks Dennis, but I am getting:-

Invalid null command.
while: Expression Syntax.
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
done: Command not found.

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 07:45:45 GMT

Is there a way to make it work using xargs instead of while ?

Re: Need help with ssh to multiple hosts with pipe

Dennis Handly — Thu, 29 Nov 2012 08:37:49 GMT

>but I am getting: Invalid null command. while: Expression Syntax.

Ah, one more "$" to quote:

awk '{print \$2}' | sort -u |

>Is there a way to make it work using xargs instead of while?

Why bother? Use vector methods:

ssh $node "lsof | grep db | grep EST | awk '{print $2}' | sort -u > /var/tmp/fflist.\$\$;

ps -ef | grep -f /var/tmp/fflist.\$\$; rm -f /var/tmp/fflist.\$\$"

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 08:39:54 GMT

Problem is that other machines have a different shell than what I am using on the admin box and its not accepting while loop.

The other boxes have t-csh.

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 08:41:49 GMT

tried giving ssh $i "bash|lsof ... " didnt work.

Re: Need help with ssh to multiple hosts with pipe

Dennis Handly — Thu, 29 Nov 2012 11:52:52 GMT

>The other boxes have t-csh.

Any reason you are using a real shell and trying to talk to machines with scummy C shell? ;-)

>tried giving ssh $node "bash | lsof ... " didn't work.

You need either:

1) bash -c "lsof ... " Which play havoc with your existing quotes and quoted "$".

2) echo "lsof ..." | bash

3) Or a here doc variant of 2).

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 18:22:11 GMT

Thanks for your continued support , i tried #2 and getting -

while: Expression Syntax.
bash: line 1: 1: command not found

also, #1 is also not working as expected.

Is there room for xargs?

Thanks,
Allan.

Re: Need help with ssh to multiple hosts with pipe

Dennis Handly — Thu, 29 Nov 2012 18:33:37 GMT

>I tried #2 and getting - also, #1 is also not working as expected.

Unfortunately I no longer know exactly what you have, please provide examples.

>Is there room for xargs?

Have you tried my vector method with grep -f? No loops there, just an extra temp file to clean up.

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 19:12:43 GMT

The vector method seems to be working when I actually run it by sshing into the box but remote from admin box it return no output.

Thought?

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 20:19:30 GMT

The existing issue is with awk '{print $2}' not working with the remote ssh.

Re: Need help with ssh to multiple hosts with pipe

allanm77 — Thu, 29 Nov 2012 20:24:56 GMT

Its working now after escaping the \$2.

Thanks so much for the vector method!

Re: Need help with ssh to multiple hosts with pipe

Dennis Handly — Fri, 30 Nov 2012 04:02:59 GMT

>Thanks so much for the vector method!

It would be nice if you would assign some kudos.