This article is for Zmanda Recovery Manager For MySQL (ZRM)
Issue Symptoms
- Output of command: '/usr/share/mysql-zrm/plugins/lvm-snapshot.pl --action get-vm-device-details --directory "/opt/zmc/mysql/data//zmc" --sname zrmZEvH6X 2>/tmp/AjfR1QlY3J' is [ - sudo: sorry, you must have a tty to run sudo - Failed to find database: /opt/zmc/mysql/data//zmc ] WARNINGS: - Error getting device details for "/opt/zmc/mysql/data//zmc" - Could not read file /tmp/AjfR1QlY3J
Issue Description
The sudo configuration is requiring the mysql user to run sudo only from a login shell.
Resolution
As root, run ‘visudo' and add the following lines to allow the mysql user to run sudo without requiring a TTY :
Defaults:%mysql !requiretty Defaults:mysql !requiretty
