Results 1 to 2 of 2

Thread: mysql-zrm-scheduler fails with ERROR MESSAGE sh: mysqladmin: command not found

  1. #1

    Default mysql-zrm-scheduler fails with ERROR MESSAGE sh: mysqladmin: command not found

    Hi, my first post here.

    We have the following configuration:

    1 fedora with Zrm for Mysql 2.2 as the backup server with the mysql-zrm.conf configured. We can ping the debian by ip address.
    1 debian host (remote host) with Mysql server installed version 5.1.49-3. In this server we install the mysql client. ON this cliente with Mysql we can with root command use mysqldump to create backups with success.

    some the mysql-zrm.conf entries

    # Fully qualified domain name of the MySQL server.
    # This parameter is optional. If this parameter is not specified, values from
    # my.cnf configuration file.
    #
    host="172.30.7. MySQL database user used for backup and recovery of the backup set.
    # This parameter is optional. If this parameter is not specified, values from
    # my.cnf configuration file.
    #
    user="root"

    # MySQL database user password.
    # This parameter is optional. If this parameter is not specified, values from
    # my.cnf configuration file or no password is used.
    #
    password="xxxxxx"

    # Port to which the MySQL server is listening to. This parameter is optional
    # and default value is 3306
    #
    port=3306

    #Name of Socket file that can be used for connecting to MySQL
    #
    socket=/var/lib/mysql/mysql.sock


    # Directory where MySQL commands can be found. The parameter is optional.
    #
    mysql-binpath="/usr/bin"


    We run from the the fedora backup server to make a mysql backup from remote the debian client with the following command

    [root@qsrvbackup dailyrun]# mysql-zrm-scheduler --now --backup-set dailyrun
    schedule:INFO: ZRM for MySQL Community Edition - version 2.2.0
    Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
    backup:INFO: ZRM for MySQL Community Edition - version 2.2.0
    dailyrun:backup:INFO: START OF BACKUP
    dailyrun:backup:INFO: PHASE START: Initialization
    dailyrun:backup:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
    dailyrun:backup:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/dailyrun/tmpHCdEq.conf
    dailyrun:backup:INFO: {
    dailyrun:backup:INFO: quiet=0
    dailyrun:backup:INFO: verbose=1
    dailyrun:backup:INFO: backup-level=0
    dailyrun:backup:INFO: mysql-binpath=/usr/bin
    dailyrun:backup:INFO: all-databases=1
    dailyrun:backup:INFO: remote-mysql-binpath=/usr/bin
    dailyrun:backup:INFO: ssh-user=root
    dailyrun:backup:INFO: port=3306
    dailyrun:backup:INFO: socket=/var/lib/mysql/mysql.sock
    dailyrun:backup:INFO: host=172.30.7.43
    dailyrun:backup:INFO: mail-policy=always
    dailyrun:backup:INFO: backup-mode=logical
    dailyrun:backup:INFO: password=******
    dailyrun:backup:INFO: comment=Backup Full diario
    dailyrun:backup:INFO: backup-type=regular
    dailyrun:backup:INFO: user=root
    dailyrun:backup:INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
    dailyrun:backup:INFO: }
    dailyrun:backup:INFO: Getting mysql variables
    dailyrun:backup:INFO: "/usr/bin"/mysqladmin --user="root" --password="*****" --host="172.30.7.43" --port="3306" --socket="/var/lib/mysql/mysql.sock" variables
    dailyrun:backup:ERROR: Output of command: '"/usr/bin"/mysqladmin --user="root" --password="*****" --host="172.30.7.43" --port="3306" --socket="/var/lib/mysql/mysql.sock" variables' is {
    sh: /usr/bin/mysqladmin: No such file or directory
    }
    dailyrun:backup:ERROR: Cannot connect to mysql server!
    dailyrun:backup:INFO: PHASE START: Cleanup
    dailyrun:backup:INFO: PHASE END: Cleanup
    dailyrun:backup:INFO: END OF BACKUP
    ERROR: /usr/bin/mysql-zrm did not finish successfully



    We checked everyting. We have done ssh to the debian host with root. After remote connection we can do mysql -u root -pxxxxx to enter into mysql and doa show databases; with success. mysqladmin is in the /usr/bin folder. Also we can mysqldump with success.

    please help !!!
    thx in advance

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

    Default

    Is /usr/bin"/mysqladmin present on the ZRM server?

Posting Permissions

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