Re: [Bacula-users] Having difficulty mounting curlftpfs on bacula : "Device is BLOCKED waiting for mount of volume"

[Michel Figgins]

I notice in your config you have:
/mnt/my_backup/backup/bacula/archive
But the logs keep showing:
/mnt/khapbackup/backup/bacula/archive

Have you made a change to the sd conf and not restarted the SD?
Or how about creating a symlink from /mnt/khapbackup to /mnt/my_backup ?

- Michel

From: MylesDearBusiness via Bacula-users 
Sent: Wednesday, November 29, 2023 2:48 AM
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] Having difficulty mounting curlftpfs on bacula : 
"Device is BLOCKED waiting for mount of volume"


Hello, Bacula experts.

Due to message length limitations of this mailing list, I have been unable to 
post the majority of necessary details, which is why I was using my github gist 
system to store, apologies for the confusion or inconvenience this caused.  I 
just thought it would be more confusing to break up the details into multiple 
messages.

The latest after following up on some of Bill's suggestions, I added a second 
device in my File Changer and now bconsole shows I am being asked to execute 
the "label" command, which is failing.

As a reminder, I'm running bacula-dir under user "bacula" (which does not have 
access to the storage mount /mnt/my_backup).
I'm running bacula-sd and bacula-fd under user "backupuser" which has sole 
permission to read/write files under this mount.

Please see https://gist.github.com/mdear/99ed7d56fd5611216ce08ecff6244c8b for 
more, I just added a new comment with additional details.

Thanks,




___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Overlapping scheduled jobs

[Michel Figgins]

If you're just wanting to delay the second job until the first one finishes, 
then maybe setting Maximum Concurrent Jobs = 1 in the client definition will 
help? 
https://www.bacula.org/11.0.x-manuals/en/main/Client_File_daemon_Configur.html
Although I can see if there's no good Full backup and it is in the process of 
making one, and a second job starts then that job will get elevated to Full 
regardless of schedule.

Unless I misunderstand the question.

- Michel
-Original Message-
From: Márcio (Departamento de Informática - PMI) 
[mailto:marcio.mendo...@indaiatuba.sp.gov.br] 
Sent: Monday, August 23, 2021 12:18 PM
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] Overlapping scheduled jobs

Hi Pedro, thanks for help!

What I want is not to cancel the job, but to delay the entire Saturday
schedule while the Friday scheduled jobs don't finish.

Márcio

Em 23/08/2021 15:21, Pedro Oliveira escreveu:
> Hi Márcio,
>
> Please check "Cancel Lower Level Duplicates" Configuration options on
> Bacula Manual.
>
> Best Regards
>
> P
>
> Às 19:12 de 23/08/21, Márcio (Departamento de Informática - PMI)
> escreveu:
>> Hi, greetings everyone.
>>
>> I searched for this subject in other posts in this list, but I didn't
>> find something that was similar, so I decided to post my question.
>> Is there any way to prevent jobs scheduled on a certain day from
>> overlapping jobs that were previously scheduled and are still in the
>> execution queue, even if the priority number of new jobs is lower?
>> On Friday the FULL backups are started, and often the differential
>> backup that starts on Saturday is merged with the one on Friday.
>> Grateful for any help.
>>
>> Márcio
>>
>>
>>
>> ___
>>
>> Prefeitura Municipal de Indaiatuba
>> Telefone: (19) 3834-9000
>> Site: http://www.indaiatuba.sp.gov.br/
>>
>> Antes de imprimir pense no seu compromisso com o meio ambiente.
>>
>>
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
> ___
>
> Prefeitura Municipal de Indaiatuba
> Telefone: (19) 3834-9000
> Site: http://www.indaiatuba.sp.gov.br/
>
> Antes de imprimir pense no seu compromisso com o meio ambiente.

-- 


___

Prefeitura Municipal de Indaiatuba
Telefone: (19) 3834-9000
Site: http://www.indaiatuba.sp.gov.br/

Antes de imprimir pense no seu compromisso com o meio ambiente.


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Errors migrating from mysql to postgres

[Michel Figgins]

Yes please on the explanation.
When I use mysqldump –hex-blob , the RestoreObject field/column has the null 
byte equivalents (i.e. it starts with 0x3C0042004100 which is “>:
Hello,

2017-11-28 11:55 GMT+01:00 Wanderlei Huttel 
>:
Hello Michel

I've created some scripts to do this job.
https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql

I only had some troubles with the Log table, but I've changed some registries 
manually and everything worked fine.
A guy in Brazil with a database with 6gb used these scripts and had no problems

I have migrated a Bacula 5.x to 7.x from MySQL into a PostgreSQL and I had the 
same problem with RestoreObjects table. The solution was to use: --hex-blob 
parameter to mysqldump and use a decode() function from PostgreSQL.
The Restore Objects table is populated when Bacula run a Windows VSS backup. If 
you backup all but Windows VSS you will have no problem with above script. :)

The next problem I encountered was an ' character in some filenames which 
mysqldump is unable to proper escape, even with --compatible=postgresql option. 
So I had to escape it manually (with an additional script).

Finally the migration was successful but due to above errors it took more time 
then expected.

best regards
--
Radosław Korzeniewski
rados...@korzeniewski.net

--
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

Re: [Bacula-users] Errors migrating from mysql to postgres

[Michel Figgins]

Yes, it is:
postgres=# \l
  List of databases
   Name|  Owner   | Encoding  |   Collate   |Ctype|   Access 
privileges
---+--+---+-+-+---
 bacula| bacula   | SQL_ASCII | C   | C   | =Tc/bacula  
 +
   |  |   | | | 
bacula=C*T*c*/bacula

-Original Message-
From: Dan Langille [mailto:d...@langille.org] 
Sent: Monday, November 27, 2017 1:29 PM
To: Michel Figgins
Cc: bacula-users
Subject: Re: [Bacula-users] Errors migrating from mysql to postgres

> On Nov 27, 2017, at 2:13 PM, Michel Figgins <mfigg...@atlasallied.com> wrote:
> 
> Hello,
>   I'm trying to migrate from a mysql backend to a postgresql backend and 
> I'm getting an error importing the RestoreObject table.  Specifically I'm 
> getting :
> ERROR:  invalid input syntax for type bytea LINE 1: 
> ...bjectCompression) VALUES (1588,'job_metadata.xml','<B\0A\0C\...
>   Googling around leads me to believe that Postgres isn't liking the 
> format of RestoreObject field, but I'm stumped as to how to change it.
>   So my questions: Can anyone suggest a way to modify the INSERT 
> statement to one Postgres will understand? Do I actually need to import this 
> table, or will the entries get re-populated as successful backups are 
> completed?
> Additional Info:
> This is on Fedora 27, Bacula version is 9.0.5, the MySQL database is MariaDB 
> 10.2.9, the PostgreSQL database is 9.6.6.  The mysqldump command used to 
> generate the import file is :
> mysqldump -t -n -c -e --compatible=postgresql --skip-quote-names --skip-opt 
> --disable-keys --lock-tables -u bacula -pX bacula   | grep -v "INSERT 
> INTO Status"   | sed -e 's/-00-00 00:00:00/1970-01-01 00:00:00/g'   | sed 
> -e 's/\\0//' | sed -e "s#\\\'#\'\'#g" > bacula-export.sql
> The pqsl command used to import the dump is:
> psql -Ubacula bacula < bacula-export.sql

Can you confirm your PostgreSQL is SQL_ASCII?

$ psql -l 
 List of databases
   Name   |  Owner   | Encoding  | Collate | Ctype |   Access 
privileges   
--+--+---+-+---+
--+--+---+-+---+---
 bacula   | bacula   | SQL_ASCII | C   | C | 




--
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

[Bacula-users] Errors migrating from mysql to postgres

[Michel Figgins]

Hello,
I'm trying to migrate from a mysql backend to a postgresql backend and 
I'm getting an error importing the RestoreObject table.  Specifically I'm 
getting :
ERROR:  invalid input syntax for type bytea
LINE 1: ...bjectCompression) VALUES (1588,'job_metadata.xml',' bacula-export.sql
The pqsl command used to import the dump is:
psql -Ubacula bacula < bacula-export.sql

Thanks,
Michel




--
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