>>>>> On Thu, 5 Jan 2017 08:47:08 +0100, Stefan Kiehne said: > > Hi guys, > > I have a ClientRunBeforeJob directive that makes a dump of each database > (using mysqldump) before the backup. > > ClientRunBeforeJob = "sh -c 'databases=`mysql -u root -e \"SHOW DATABASES;\" > | grep -Ev \"(Database|information_schema|performance_schema)\"`; rm -f > /var/spool/bacula/*.sql && for db in $databases; do mysqldump > --defaults-extra-file=/var/spool/bacula/.my.cnf --opt --events --databases > $db > /var/spool/bacula/$db.sql; done && unset databases'" > > I added the option --defaults-extra-file=/root/.my.cnf because it neede a > password but since the bacula user couldn't read the file in that directory > it failed. So I moved the file to /var/spool/bacula/.my.cnf and changed the > ClientRunBeforeJob accordingly. Just checked and it still didn't work > (ClientRunBeforeJob: ERROR 1045 (28000): Access denied for user 'x'@'y' > (using password: NO). I can log in to mysql as bacula with no problem > (using 'sudo -u bacula mysql') So what am I missing here?
Is the "ERROR 1045" coming from `mysql ...` or from mysqldump? I suspect confusion about users and defaults from your description. 1. The ClientRunBeforeJob runs in the bacula-fd. Are you really running that as the bacula user? Normally it runs as root. 2. You are passing '-u root' to mysql so this is not connecting as the bacula user and might be different from your tests with 'sudo -u bacula mysql'. 3. You are not passing --defaults-extra-file to mysql (only to mysqldump). 4. You are not passing '-u root' to mysqldump, so the user will either be specified in /var/spool/bacula/.my.cnf or defaulted to the user running the command (probably root in the ClientRunBeforeJob). __Martin ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
