Re: [Bacula-users] mysqldump not working due to missing password

2017-01-05 Thread Martin Simmons
I think the job will fail if the script returns a non zero exit status. The problem is that shell backquote doesn't return an exit status, but you could do something like if test -z "$databases"; then exit 1; else for db ... done; fi __Martin > On Thu, 5 Jan 2017 13:55:41 +0100, Stefan Kieh

Re: [Bacula-users] mysqldump not working due to missing password

2017-01-05 Thread Stefan Kiehne
You're right I messed up missing to pass the --defaults-extra-file in the mysql command and thus it would fail trying to get the list of databases. Messed around in a VM an got to the same conslusion. I changed the config now I'll see tomorrow how it went. Thanks for the tips. Still is there a way

Re: [Bacula-users] mysqldump not working due to missing password

2017-01-05 Thread Martin Simmons
> 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