PDA

View Full Version : need ssh password for root ????



raid_fifa
October 15th, 2008, 01:40 AM
hi,
I login the linux as mysql,and executed the following command:
[mysql@ts3-167 62gpl]$ mysql-zrm-backup --user root --password 111111 --host 172.16.74.62 --mysql-binlog-path /usr/local/gpl5066a/data --database test --backup-level 1 --backup-mode logical --backup-type regular --ssh-user root --remote-mysql-binpath /usr/local/gpl5066a/bin --backup-set 62gpl

but it prompts me to input the root password:
......
62gpl:backup:INFO: PHASE START: Creating incremental backup
root@172.16.74.62's password:
Permission denied, please try again.
root@172.16.74.62's password:
root@172.16.74.62's password:
62gpl:backup:INFO: incremental=mysql-bin.[0-9]*
62gpl:backup:INFO: PHASE END: Creating incremental backup
62gpl:backup:INFO: PHASE START: Calculating backup size & checksums
62gpl:backup:INFO: next-binlog=mysql-bin.000018
......

I input the password, then the backup process works fine. BUT I had set up ssh with passwordless between the zrm server and mysql server.
I use ZRM enterprise version 2.2.

What's the matter?
Thanks a lot!!!

paddy
October 15th, 2008, 09:42 AM
hi,
I login the linux as mysql,and executed the following command:
[mysql@ts3-167 62gpl]$ mysql-zrm-backup --user root --password 111111 --host 172.16.74.62 --mysql-binlog-path /usr/local/gpl5066a/data --database test --backup-level 1 --backup-mode logical --backup-type regular --ssh-user root --remote-mysql-binpath /usr/local/gpl5066a/bin --backup-set 62gpl



but it prompts me to input the root password:



Are you able to run "ssh root@172.16.74.62" without a password request?

Please file a support request at Zmanda network. Support team will be happy
to help you.

Paddy

raid_fifa
October 15th, 2008, 11:09 PM
of course,I can ssh to 172.16.74.62 with no password, moreover, the reverse is also true.

OK. thanks.

paddy
October 16th, 2008, 09:43 AM
of course,I can ssh to 172.16.74.62 with no password, moreover, the reverse is also true.

OK. thanks.

Are you trying ssh to root@172.16.74.62 as mysql user? Please note that ZRM runs as "mysql" user not as root.

Paddy