Need help on bash script

blason · 08-16-2017, 05:18 AM

Hi Guys,

I have a Zimbra server and need to store the username and password using the zmpov command. I am getting the output like below but later I need to convert that into the step provided in no. 2

/tmp/user
abc@xyz.com
pqr@xyz.com
qwe@xyz.com

cat /tmp/user | while read line;do zmprov -l ga $line userPassword;done

I am getting below output

# name abc@xyz.com
userPassword: {SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF

# name pqr@xyz.com
userPassword: {SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF

# name qwe@xyz.com
userPassword: {SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF

2) Then that needs to be converted to like below; so user name will be picked up from first line and password from second line.

zmprov ma abc@xyz.com userPassword '{SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF'

zmprov ma pqr@xyz.com userPassword '{SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF'

zmprov ma qwe@xyz.com userPassword '{SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF'

can someone please help.

Turbocapitalist · 08-16-2017, 05:37 AM

1) I'd rearrange the first part a little since the cat is unnecessary.

Code:

while read line; do zmprov -l ga "$line" userPassword; done < /tmp/user;

2) Then sed can merge matching lines and clean up the contents a little:

Code:

sed -n -e "/^#/!d; s/^.* //; N; s/[[:space:]]/ /g; s/: */'/; s/[^[:alnum:]]*$/'/; p"

The N pushes the next line into the pattern space.

See "man sed"

grail · 08-16-2017, 09:05 AM

You could do it all in 1:

Code:

while read -r email
do
  zmprov ma "$email" userPassword "$(zmprov -l ga "$email" userPassword | grep -o '{.*')"
done</tmp/user

blason · 08-16-2017, 01:40 PM

Unfortunately both the tricks did not work

here is the error I got for first one

cat /tmp/pass | sed -n -e "/^#/!d; s/^.* //; N; s/[[:space:]]/ /g; s/: */'/; s/[^[:alnum:]]*$/'/; p"
-bash: !d: event not found

And here is the output for second one

while read -r email;do zmprov ma "$email" userPassword "$(zmprov -l ga "$email" userPassword | grep -v '^$' |tail -n 1 |awk '{print $NF}')";done< /tmp/pass
ERROR: account.NO_SUCH_ACCOUNT (no such account: # name 1@xxx.com)
ERROR: account.NO_SUCH_ACCOUNT (no such account: # name 1@xxx.com)
ERROR: account.NO_SUCH_ACCOUNT (no such account: userPassword: {SSHA}CuBH3js8XM2PJ3/980hAMi8F+yhz/zp3)
ERROR: account.NO_SUCH_ACCOUNT (no such account: userPassword: {SSHA}CuBH3js8XM2PJ3/980hAMi8F+yhz/zp3)
ERROR: account.NO_SUCH_ACCOUNT (no such account: )

Turbocapitalist · 08-16-2017, 01:52 PM

Ok. sed has trouble with the single quotes in the substitution. It works fine in a script, but manually in the shell you'll have to hide them:

Code:

sed -n -e '/^#/!d; s/^.* //; N; s/[[:space:]]/ /g; s/: */\x27/; s/[^[:alnum:]]*$/\x27/; p' < /tmp/pass.txt

danielbmartin · 08-16-2017, 02:10 PM

I don't fully understand the problem... but this might help.

With this InFile ...

Code:

# name abc@xyz.com
userPassword: {SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF
# name pqr@xyz.com
userPassword: {SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF
# name qwe@xyz.com
userPassword: {SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF

... this awk ...

Code:

awk '{ol="zmprov ma " $3" "$4;
      getline;
      print ol $1,"\47"$2"\47"}'  \
$InFile >$OutFile

... produced this OutFile ...

Code:

zmprov ma abc@xyz.com userPassword: '{SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF'
zmprov ma pqr@xyz.com userPassword: '{SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF'
zmprov ma qwe@xyz.com userPassword: '{SSHA}QfN0yApdHJHWNSm+AgFGoC8ozcBWDrnF'

Daniel B. Martin

grail · 08-17-2017, 03:31 AM

Quote:

Originally Posted by blason

And here is the output for second one

while read -r email;do zmprov ma "$email" userPassword "$(zmprov -l ga "$email" userPassword | grep -v '^$' |tail -n 1 |awk '{print $NF}')";done< /tmp/pass
ERROR: account.NO_SUCH_ACCOUNT (no such account: # name 1@xxx.com)
ERROR: account.NO_SUCH_ACCOUNT (no such account: # name 1@xxx.com)
ERROR: account.NO_SUCH_ACCOUNT (no such account: userPassword: {SSHA}CuBH3js8XM2PJ3/980hAMi8F+yhz/zp3)
ERROR: account.NO_SUCH_ACCOUNT (no such account: userPassword: {SSHA}CuBH3js8XM2PJ3/980hAMi8F+yhz/zp3)
ERROR: account.NO_SUCH_ACCOUNT (no such account: )

Firstly, any reason why it all has to be on 1 line?

Second, if you are going to introduce additional commands, it is hard to fix anything, hence I take no responsibility for your errors.

So why did you add:

Code:

| grep -v '^$' |tail -n 1

blason · 08-17-2017, 01:24 PM

Quote:

Originally Posted by grail

Firstly, any reason why it all has to be on 1 line?

Second, if you are going to introduce additional commands, it is hard to fix anything, hence I take no responsibility for your errors.

So why did you add:

Code:

| grep -v '^$' |tail -n 1

That is added to remove whiteline and picked last line which contains the interesting string.

astrogeek · 08-17-2017, 02:39 PM

Please place your code and runtime message snippets inside [CODE]...[/CODE] tags for better readability. You may type those yourself or click the "#" button in the edit controls.

grail · 08-18-2017, 12:22 AM

Quote:

Originally Posted by blason

That is added to remove whiteline and picked last line which contains the interesting string.

And what I am saying is that none of that is needed as the grep will only return the string required.