Re: [Bacula-users] error about MySQL-dump file when using bpipe

Keep in mind that bpipe simply "executes" the "program" on the other end, which means that if you execute a binary it does not run under the shell. If you put the execution of the binary inside a file then execute it, normally you have a #!/bin/sh at the top of the file and hence the binary is exe

Re: [Bacula-users] error about MySQL-dump file when using bpipe

The error appears with accurate being both enabled or disabled. Fileset is: FileSet { Name = mysrv-mydb Ignore Fileset Changes = yes Include { Options { Compression = GZIP Signature = MD5 Verify = pins5 No atime= yes Check File Changes = yes

Re: [Bacula-users] error about MySQL-dump file when using bpipe

DIR is 7.0, FD was 5.2.6 originally, but then I upgraded it to 7.0. The error remained the same after upgrading. -- Silver On 28.01.2016 11:40, Wanderlei Huttel wrote: Hi Silver What version of bacula are you using? Best Regards Wanderlei 2016-01-28 7:27 GMT-02:00 Silver Salonen

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Hello Silver, Is this output with accurate enabled or disabled? Do you have configured File= /srv/mysqldump.sql in you job FileSet? Best regards, Ana On Fri, Jan 22, 2016 at 2:21 PM, Silver Salonen wrote: > Debug output concerning mysqldump from /opt/bacula/bin/bacula-fd -d 200 -c > bacula-f

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Hi Silver What version of bacula are you using? Best Regards Wanderlei 2016-01-28 7:27 GMT-02:00 Silver Salonen : > Any more ideas why this error appears sometimes? > > -- > Silver > > On 25.01.2016 10:42, Silver Salonen wrote: > > Yeah, so what can we conclude from this now? :) > > -- > Silver

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Any more ideas why this error appears sometimes? -- Silver On 25.01.2016 10:42, Silver Salonen wrote: Yeah, so what can we conclude from this now? :) -- Silver On 22.01.2016 17:55, Wanderlei Huttel wrote: Hi Silver I've made a test using your script and worked fine! I'm using bacula 7.4.0.

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Yeah, so what can we conclude from this now? :) -- Silver On 22.01.2016 17:55, Wanderlei Huttel wrote: Hi Silver I've made a test using your script and worked fine! I'm using bacula 7.4.0. - MySQL user has all privileges; grant all on *.* to 'user'@'localhost' identified by 'password'; - The

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Hi Silver I've made a test using your script and worked fine! I'm using bacula 7.4.0. - MySQL user has all privileges; grant all on *.* to 'user'@'localhost' identified by 'password'; - The directory and file /mnt/fifo/intranet.sql doesn't exists - Permission of script is 775

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Debug output concerning mysqldump from /opt/bacula/bin/bacula-fd -d 200 -c bacula-fd.conf -f job.c:1227-54555 P bpipe:/srv/mysqldump.sql:/bin/sh /etc/bacula/scripts/mysqldump.sh mydb:/etc/bacula/scripts/mysqldump.sh -R fd_plugins.c:329-54555 plugin cmd=bpipe:/srv/mysqldump.sql:/bin/sh /etc/bac

Re: [Bacula-users] error about MySQL-dump file when using bpipe

I know how bpipe works and my method using script is to work around an issue with bpipe erroring out with "Error closing stream for pseudo file" (no idea why, but running the same mysqldump command from inside script solves this). Contents of the script is really straight-forward and doesn't ch

Re: [Bacula-users] error about MySQL-dump file when using bpipe

> Hello Silver, Hello Silver [2], Please read: http://bacula.us/using-bpipe-to-stream-dumps-vm-clones-and-another-data-to-your-backup bpipe reads a command data that is directed to stdout and stores in backup with the name you put in the 2nd variable (fifo path) => I hope is what you are try

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Hello Silver, I´m quite sure that¨"/mysql/mysqldump.sql" should not exist in your filesystem. This is a "pseudo" path and filename that will appear in the restore file tree, but not in the host filesystem. Best regards, Ana On Fri, Jan 22, 2016 at 10:01 AM, Silver Salonen wrote: > The same err

Re: [Bacula-users] error about MySQL-dump file when using bpipe

The same error, yes. Permissions are not relevant as FD runs under root and the script generates the dump file just fine. I now changed the dump location to /srv, touched /srv/mysqldump.sql file too and now the error was: JobId 54542: Error: /srv/mysqldump.sql mtime changed during backup. Job

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Hello Silver, The same error? Have you checked permissions? Best regards, Ana On Fri, Jan 22, 2016 at 9:19 AM, Silver Salonen wrote: > After creating those folders, those errors still appeared. Any other ideas? > > -- > Silver > > On 21.01.2016 13:43, Silver Salonen wrote: > > Aha, I indeed di

Re: [Bacula-users] error about MySQL-dump file when using bpipe

After creating those folders, those errors still appeared. Any other ideas? -- Silver On 21.01.2016 13:43, Silver Salonen wrote: Aha, I indeed didn't have /mysql directory. Thanks a bunch! :) PS. Script permissions are correct as otherwise the dump wouldn't have been created. -- Silver On

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Aha, I indeed didn't have /mysql directory. Thanks a bunch! :) PS. Script permissions are correct as otherwise the dump wouldn't have been created. -- Silver On 21.01.2016 12:21, Heitor Faria wrote: Hello Silver, Does the /mysql directory exist? It must. Make sure also bacula-fd daemon OS

Re: [Bacula-users] error about MySQL-dump file when using bpipe

Hello Silver, Does the /mysql directory exist? It must. Make sure also bacula-fd daemon OS user has proper permissions to run the scripts Regards, === Heitor Medrado de Faria - LPIC-III | ITIL-F |  Bacula Systems Certified

[Bacula-users] error about MySQL-dump file when using bpipe

Hi. I'm backing up MySQL databases from several servers with Fileset line: Plugin = "bpipe:/mysql/mysqldump.sql:/etc/bacula/scripts/mysqldump.sh mydb:/etc/bacula/scripts/mysqldump.sh -R" FD on some of those servers give the following error: Warning: Cannot stat file /mysql/mysqldump.s