Results 1 to 3 of 3

Thread: Output of command mysqlhotcopy is Host key verification failed

  1. #1

    Question Output of command mysqlhotcopy is Host key verification failed

    Hi,

    My setup is MySQL server (node1) and ZRM server (zrm). I have the following status error message.

    Code:
    Phase: Creating raw backup
    Message:
    ERRORS:
    -  Output of command: 'mysqlhotcopy' is [
          -  Host key verification failed.
    
          -   Could not create directory /tmp/pOxrtclwE5 on host node1 at /usr/share/mysql-zrm/plugins/ssh-copy.pl line 324.
    ]      
    -  mysqlhotcopy did not succeed. Command used is /usr/share/mysql-zrm/plugins/ssh-copy.pl --mysqlhotcopy=/usr/bin --user=\"dbuser1\" --password=\"*****\" --host=\"node1\" --port=\"3308\" --quiet appsdb2 \"/var/lib/mysql-zrm/backup-mysql-node1/20100420181944\" > /tmp/N6xtlATWWO 2>&1 Return value is 65280
    When I do Logical mode for backup, it's smoothly working. Only "raw" mode of backup is giving error. I try to use mysqlhotcopy command from ZRM server to MySQL server and this is what happen.

    Code:
    [root@zrm]# mysqlhotcopy -u dbuser1 -p ***** -h node1 -P 3308 appsdb2 /tmp/
    Cannot open dir '/var/lib/mysql/appsdb2': No such file or directory at /usr/bin/mysqlhotcopy line 289.
    
    [root@zrm]# mkdir /var/lib/mysql/appsdb2 && chown mysql.mysql /var/lib/mysql/appsdb2/ && chmod 700 /var/lib/mysql/appsdb2/
    
    [root@zrm]# mysqlhotcopy -u dbuser1 -p ***** -h node1 -P 3308 --allowold --keepold appsdb2 /tmp/
    'appsdb2' is an empty database
    Deleting previous 'old' hotcopy directory ('/tmp//appsdb2_old')
    Existing hotcopy directory renamed to '/tmp//appsdb2_old'
    Locked 21 tables in 0 seconds.
    Flushed tables (`appsdb2`.`images`, `appsdb2`.`mj_categories`, `appsdb2`.`mj_comments`, `appsdb2`.`mj_linkcategories`, `appsdb2`.`mj_links`, `appsdb2`.`mj_options`, `appsdb2`.`mj_post2cat`, `appsdb2`.`mj_postmeta`, `appsdb2`.`mj_posts`, `appsdb2`.`mj_usermeta`, `appsdb2`.`mj_users`, `appsdb2`.`wp_categories`, `appsdb2`.`wp_comments`, `appsdb2`.`wp_linkcategories`, `appsdb2`.`wp_links`, `appsdb2`.`wp_onlinecounter`, `appsdb2`.`wp_options`, `appsdb2`.`wp_post2cat`, `appsdb2`.`wp_postmeta`, `appsdb2`.`wp_posts`, `appsdb2`.`wp_users`) in 0 seconds.
    Unlocked tables.
    mysqlhotcopy copied 21 tables (0 files) in 0 seconds (0 seconds overall).
    
    [root@zrm]# ls -l /tmp/appsdb2
    total 0
    The "dbuser1" mysql user has full privilege in MySQL server. How to fix this problem?

    Thanks.
    James

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    ssh copy plugin failed with "Host Key verification failed". You should either

    1. Provide ssh access to MySQL server as mysql user w/o password.

    or

    2. Use socket copy plugin. Change copy-plugin parameter in mysql-zrm.conf

    Paddy

  3. #3

    Default

    Hi Paddy,

    It's working. Thanks.

    James

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •