perl: replace string over ssh from a bash script

Question

I need to replace a string in a file on a remote server with this:

ssh username@${TARGETSERVER} -i /path/to/ssh-key perl -p -i -e "s#\$user = \'${SDBUSER}\'\;#\$user = \'${TDBUSER}\'\;#g"  ${TARGETDIR}/configuration.php

That would replace the db user on a remote server in a joomla installation, btw.

If I execute that interactively on the remote server with all the variables filled, it IS working.

If I put the above line in a bash script, I get this message and no replacement takes place:

"Substitution pattern not terminated at -e line 1."

Any clue how I can make this work? I've already tried several escapes like \\' and so forth, but I didn't succeed.

Thanks in advance.

I've tried this: REPLOLD="\$user = \'${SDBUSER}\'\;#"; REPLNEW="\$user = \'${TDBUSER}\'\;#"; ssh username@${TARGETSERVER} -i /path/to/ssh-key perl -p -i -e 's{'"$REPLOLD"'}{'"$REPLNEW"'}g' ${TARGETDIR}/configuration.php .... but didn't work :( ==> Substitution pattern not terminated at -e line 1. — Michael
– Michael, Commented Feb 18, 2015 at 21:23

Michael · Accepted Answer · 2015-02-18 21:35:00Z

1

BINGO - Got it working:

ssh -T username@${TARGETSERVER} -i /path/to/ssh-key <<EOI
  perl -p -i -e "s#\$user = \'${SDBUSER}\'\;#\$user = \'${TDBUSER}\'\;#g"  ${TARGETDIR}/configuration.php
  exit
EOI

From there, I could add several perl commands so I wouldn't have to have the payload of sshing in each time.

answered Feb 18, 2015 at 21:35

Michael

4605 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

perl: replace string over ssh from a bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related