Re: [bareos-users] backup large number of SQL databses

[damjan jancic]

Dear Brock,


It is the backup of MS SQL server databases(not mysql).
When I remove database name from the file set I got an error:

"Fatal error: An object or column name is missing or empty. For SELECT INTO 
statements, verify each column has a name. For other statements, look for 
empty alias names. Aliases defined as "" or [] are not allowed. Change the 
alias to a valid name"

When I remove all part databases=<$databsename> I got an error:

"Fatal error: An object or column name is missing or empty. For SELECT INTO 
statements, verify each column has a name. For other statements, look for 
empty alias names. Aliases defined as "" or [] are not allowed. Change the 
alias to a valid name."

File set:

Fileset {
Name = "testowt-sql-fileset"
Enable VSS = No
Include {
Options {
   Signature = MD5
   compression = gzip
}
Plugin = 
"mssqlvdi:instance=default:database=testowt:username=btest:password=**"
}
}
Kind regards,
Damjan



On Wednesday, February 26, 2020 at 11:05:06 PM UTC+1, Brock Palen wrote:
>
>
>
> > On Feb 26, 2020, at 4:51 PM, damjan jancic  > wrote: 
> > 
> > 
> > 
> > Hello, 
> > 
> > 
> > We need to backup SQL server with more than 600 databases. 
> > 
> > according to bareos documentation for each database instance you need to 
> define a exclusive backup job and fileset. 
> > 
> > Are there any options other than creating more than 600 backup jobs and 
> filesets? 
>
> Is this one database instance with multiple ‘databases’  eg;  mysql> use 
> database1; use database2;  etc? 
> If it’s all on once host you can connect to the database server with 
> multiple databases your good.  You would need one entry per host not 
> database. 
>
> If it is you are able to use the plugins here: 
> https://docs.bareos.org/Appendix/Howtos.html#backup-of-a-mysql-database 
>
> I use the python plugin,  it’s straggly slow but I like it better than my 
> old way.  In my case I use a job like: 
>
> # 
> http://doc.bareos.org/master/html/bareos-manual-main-reference.html#x1-613000H.2.3
>  
> FileSet { 
> Name = "mlds-mysql" 
> Include { 
>   Options { 
> signature = MD5 
> compression = GZIP6 
>   } 
>   Plugin = 
> "python:module_path=/usr/lib/bareos/plugins:module_name=bareos-fd-mysql:mysqlhost=mlds:mysqluser=root:mysqlpassword="
>  
>
> } 
> } 
>
> By not passing in a database name it just backups them all. 
>
> You can also use scripts to just invoke the dump command of your choice 
> and then make a fileset that backups the dumped files. 
>
> https://docs.bareos.org/Configuration/Director.html#config-Dir_Job_RunScript 
>
> The included bareos backup catalog job has an example of how to call an 
> external script and backup the dump for exactly that. 
>
> > 
> > 
> > Kind regards, 
> > Damjan 
> > 
> > -- 
> > You received this message because you are subscribed to the Google 
> Groups "bareos-users" group. 
> > To unsubscribe from this group and stop receiving emails from it, send 
> an email to bareos...@googlegroups.com . 
> > To view this discussion on the web visit 
> https://groups.google.com/d/msgid/bareos-users/c526ec73-60bc-498f-a66a-c1e83a31f9eb%40googlegroups.com.
>  
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/7cf137fc-cd21-4e01-98ae-bfbe5d1b8e9c%40googlegroups.com.

[bareos-users] Director messages not consistent with actions

[Bruce Eckstein]

I changed my fileset for one of my clients last night. The director did 
what that fileset indicated. OK great,

but when I look at the director messages for last night it says the 
following:

FileSet:"Full_Laptop_Set" 2020-01-01 10:03:02

so what is the date really indicating. I would have thought the date would be 
2020-02-27 18:21:xx (or the UTC version of that date) as that is the date on 
the Full_Laptop_Set.conf file in my configuration directories 

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/4c43d5bb-6da6-4aae-86c0-5659082ef4ab%40googlegroups.com.

[bareos-users] Re: Concurrent jobs and Consolidate Jobs

[Urban Persson]

Hi, 

Do you run this consolidation job with higher priority number so the job 
will wait until all other backup jobs finished?
Normally backupjobs is Priority 10 and Consolidate is Priority 11.

Can that be the issue?

// Urban


Den fredag 14 februari 2020 kl. 04:27:33 UTC+1 skrev Brock Palen:
>
> We backup/spool to disk volumes and copy/migrate jobs to tape.  We have 
> one tape drive.
>
> If we have Concurrent jobs allowed so we can backup more than one host at 
> a time to disk we run into issues with Consolidate jobs failing when jobs 
> were migrated to the tape drive.   If we only allow 1 job at a time it 
> works as no second job tries to grab the tape drive.  
>
> The specific error is:
> list joblog jobid=23422
>  2020-02-13 21:56:23 myth-dir JobId 23422: Start Virtual Backup JobId 
> 23422, Job=sch-hp-desktop-Users-Pictures.2020-02-13_21.56.19_07
>  2020-02-13 21:56:23 myth-dir JobId 23422: Consolidating JobIds 22736,23413
>  2020-02-13 21:56:23 myth-dir JobId 23422: Bootstrap records written to 
> /var/lib/bareos/myth-dir.restore.2.bsr
>  2020-02-13 21:56:23 myth-dir JobId 23422: Connected Storage daemon at 
> myth..com:9103, encryption: PSK-AES256-CBC-SHA
>  2020-02-13 21:56:23 myth-dir JobId 23422: Using Device "FileStorage" to 
> read.
>  2020-02-13 21:56:23 myth-dir JobId 23422: Created new Volume 
> "AI-Consolidated-1886" in catalog.
>  2020-02-13 21:56:23 myth-dir JobId 23422: Using Device "FileStorage3" to 
> write.
>  2020-02-13 21:56:23 myth-sd JobId 23422: stored/acquire.cc:159 Changing 
> read device. Want Media Type="LTO5" have="File"
>   device="FileStorage" (/mnt/bacula)
>  2020-02-13 21:56:23 myth-sd JobId 23422: Releasing device "FileStorage" 
> (/mnt/bacula).
>  2020-02-13 21:56:23 myth-sd JobId 23422: F*atal error: 
> stored/acquire.cc:219  No suitable device found to 
> read Volume "DA1391L5"*
>  2020-02-13 21:56:23 myth-sd JobId 23422: Releasing device "Tand-LTO5" 
> (/dev/nst1).
>  2020-02-13 21:56:24 myth-dir JobId 23422: Error: Bareos myth-dir 19.2.5 
> (03Feb20):
>   Build OS:   Linux-3.10.0-1062.9.1.el7.x86_64 ubuntu Ubuntu 
> 16.04 LTS
> 
>   SD Errors:  1
>   SD termination status:  Fatal Error
>   Accurate:   yes
>   Bareos binary info: bareos.org build: Get official binaries and 
> vendor support on bareos.com
>   Termination:*** Backup Error ***
>
>
> So when it swaps to the tape (which is busy with another Consolidate 
> VIrtualFull this job fails.
>
> The Tape Storage does have
>   Maximum Concurrent Jobs = 1
>
> Is there a way to make the job hold and wait for the drive to free up?
>
> I can use
>   Reschedule on Error = yes
>   Reschedule Times = 5
>   Reschedule Interval = 1800
>
> But this causes very long pauses as many consolidation jobs are very 
> short/fast, but can be long if it includes full.
>
> Thoughts?
>
> Brock Palen
> 1 (989) 277-6075
> bro...@mlds-networks.com 
> www.mlds-networks.com
> Websites, Linux, Hosting, Joomla, Consulting
>
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/e582785a-6fb3-4d88-9d77-bcf2beedb783%40googlegroups.com.

[bareos-users] Re: changing default location of bareos.sql

[Urban Persson]

Hi

I this case you need to change in the script that runs before and after the 
backupjob
In "/usr/lib/bareos/scripts/make_catalog_backup.pl" you find the following 
line: 
my $wd = "/var/lib/bareos";

wd = working directory

I guess you need to change even in the cleanup script running after job,
"/usr/lib/bareos/scripts/delete_catalog_backup"

Then, NOT to forget you need to change the backupjobs Fileset, and add yur 
new path to your database dumpfile here in File=:

FileSet {
  Name = "Catalog"
  Description = "Backup the catalog dump and Bareos configuration files."
  Include {
Options {
  signature = MD5
}
File = "/var/lib/bareos/bareos.sql" # database dump
File = "/etc/bareos"   # configuration
  }
}


Good luck!

// Urban



Den fredag 28 februari 2020 kl. 16:30:44 UTC+1 skrev birgit.ducarroz:
>
> Hi, 
>
> I would like to change the default location of the bareos.sql dump to 
> another share. 
>
> I changed in 
> /usr/lib/bareos/defaultconfigs/bareos-dir.d/fileset/Catalog.conf 
>
> and in 
> /etc/bareos/bareos-dir.d/fileset/Catalog.conf 
>
>
> and restarted the services. 
> But the dump is still writing into /var/lib/bareos 
>
> what am I missing? 
>
> Kind regards, 
> Birgit 
>

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/431e5593-cc17-497f-aae0-a8c35d0030ec%40googlegroups.com.

[bareos-users] Debian repo unsigned ?

[Marc Leforestier]

Hello

I can't upgrade Bareos anymore because repo are not signed anymore :

# apt 
update  
  

Réception de:6 http://download.bareos.org/bareos/release/latest/Debian_9.0  
InRelease [1 867 
B] 
Err:6 http://download.bareos.org/bareos/release/latest/Debian_9.0  InRelease
  Les signatures suivantes n'ont pas pu être vérifiées car la clé publique 
n'est pas disponible : NO_PUBKEY E5D882B28657AE28
Lecture des listes de paquets... Fait
W: Erreur de GPG : 
http://download.bareos.org/bareos/release/latest/Debian_9.0  
InRelease : Les signatures suivantes n'ont pas pu être vérifiées car la clé 
publique n'est pas disponible : NO_PUBKEY E5D882B28657AE28
E: The repository '
http://download.bareos.org/bareos/release/latest/Debian_9.0  InRelease' is 
no longer signed.
N: Updating from such a repository can't be done securely, and is therefore 
disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration 
details.

# wget -q http://download.bareos.org/bareos/release/latest/Debian_9.0 -O- | 
apt-key add -
gpg: aucune donnée OpenPGP valable n'a été trouvée.

Thanks for your help
Marc

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/91618b46-3866-45b9-8a4f-6deff456c046%40googlegroups.com.

[bareos-users] changing default location of bareos.sql

['DUCARROZ Birgit' via bareos-users]

Hi,

I would like to change the default location of the bareos.sql dump to 
another share.


I changed in
/usr/lib/bareos/defaultconfigs/bareos-dir.d/fileset/Catalog.conf

and in
/etc/bareos/bareos-dir.d/fileset/Catalog.conf


and restarted the services.
But the dump is still writing into /var/lib/bareos

what am I missing?

Kind regards,
Birgit

--
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/b6c6f8a9-c673-b3bf-6d0e-e8cb749aee9c%40unifr.ch.

Re: [bareos-users] Re: Webui Restore on version 19.2-6 fails to restore file

[Frank Bergkemper]

Yes, as a workaround it should help you out until the proposed patch has
been applied and new packages are available for download.

If you feel comfortable enough you can apply the patch yourself, see
https://github.com/bareos/bareos/pull/439/files .


Regards,
Frank

-- 
Frank Bergkemper   frank.bergkem...@bareos.com
Bareos GmbH & Co. KG   Phone: +49-221-630693-94
http://www.bareos.com

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/9db1f8d2-b1f2-661c-62ad-f87f377937f2%40bareos.com.

Re: [bareos-users] Re: Webui Restore on version 19.2-6 fails to restore file

[aeronex...@gmail.com]

Thanks Frank.

so my solution should be to delete all restore job definitions I 
currently have now and create a single one to get it working correctly now?


On 2/28/20 6:03 AM, Frank Bergkemper wrote:

I was able to reproduce the problem and opened a bug report, please see
https://bugs.bareos.org/view.php?id=1206 for more details.

Thanks for reporting the issue, Bruce.

Kind Regards,
Frank



--
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/3cf57cd8-6b70-30dc-f7c7-ec0538d83f2d%40gmail.com.

Re: [bareos-users] Re: Webui Restore on version 19.2-6 fails to restore file

[Frank Bergkemper]

I was able to reproduce the problem and opened a bug report, please see
https://bugs.bareos.org/view.php?id=1206 for more details.

Thanks for reporting the issue, Bruce.

Kind Regards,
Frank

-- 
Frank Bergkemper   frank.bergkem...@bareos.com
Bareos GmbH & Co. KG   Phone: +49-221-630693-94
http://www.bareos.com

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/f86c5571-3d33-7f2d-d782-49f2d2c7c93f%40bareos.com.

Re: [bareos-users] Fatal database error on restore with 18.2.

[Kai Zimmer]

Me too :-(

On 28.02.2020 10:46, Marcus Wagner wrote:
I have a problem with a 18.2 director. When I start a bconsole, type 
"restore" and any other option like "9", the bconsole crashes and ends 
without any error message.


--
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/dfabe695-796f-d802-a0e8-368e11f4fcbe%40bbaw.de.

[bareos-users] Fatal database error on restore with 18.2.

[Marcus Wagner]

Hello Bareos Team,

I have a problem with a 18.2 director. When I start a bconsole, type 
"restore" and any other option like "9", the bconsole crashes and ends 
without any error message.


When I start the director in foreground and with debug 400, I get the 
following output:



mq-bareos01 (100): lib/bsock.cc:81-0 Construct BareosSocket
mq-bareos01 (100): include/jcr.h:320-0 Construct JobControlRecord
mq-bareos01 (100): lib/tls_openssl_private.cc:57-0 Construct 
TlsOpenSslPrivate
mq-bareos01 (100): lib/tls_openssl_private.cc:536-0 Set tcp 
filedescriptor: <6>
mq-bareos01 (100): lib/tls_openssl_private.cc:482-0 Set ca_certfile:
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:488-0 Set ca_certdir: 
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:494-0 Set crlfile_:   
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:500-0 Set certfile_:  
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:506-0 Set keyfile_:   
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:518-0 Set pem_userdata to 
address: <0>
mq-bareos01 (100): lib/tls_openssl_private.cc:524-0 Set dhfile_:
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:542-0 Set cipherlist: 
<>
mq-bareos01 (100): lib/tls_openssl_private.cc:530-0 Set Verify Peer:

mq-bareos01 (50): lib/tls_openssl.cc:100-0 Preparing TLS_PSK SERVER 
callback
mq-bareos01 (100): lib/tls_openssl_private.cc:401-0 psk_server_cb. 
identitiy: R_CONSOLE *UserAgent*.
mq-bareos01 (100): lib/tls_openssl_private.cc:426-0 psk_server_cb. 
result: 32.

mq-bareos01 (50): lib/bnet.cc:150-0 TLS server negotiation established.
mq-bareos01 (110): dird/socket_server.cc:109-0 Conn: Hello *UserAgent* 
calling version 18.2.5

mq-bareos01 (100): include/jcr.h:320-0 Construct JobControlRecord
mq-bareos01 (100): dird/storage.cc:157-0 write_storage_list=mq-bareos01
mq-bareos01 (100): dird/storage.cc:166-0 write_storage=mq-bareos01 
where=Job resource
mq-bareos01 (100): dird/job.cc:1519-0 JobId=0 created 
Job=-Console-.2020-02-28_10.45.52_03
mq-bareos01 (50): lib/cram_md5.cc:69-0 send: auth cram-md5 
<382897422.1582883152@mq-bareos01> ssl=1
mq-bareos01 (100): lib/cram_md5.cc:116-0 cram-get received: auth 
cram-md5 <710744962.1582883152@bconsole> ssl=1
mq-bareos01 (99): lib/cram_md5.cc:135-0 sending resp to challenge: 
pT5rHH+hw9+rG4k765/oyB
mq-bareos01 (10): dird/ua_audit.cc:146-0 : Console [default] from 
[127.0.0.1] cmdline restore

mq-bareos01 (100): dird/ua_db.cc:155-0 UA Open database
mq-bareos01 (100): cats/sql_pooling.cc:61-0 DbSqlGetNonPooledConnection 
allocating 1 new non pooled database connection to database bareos, 
backend type postgresql
mq-bareos01 (100): cats/cats_backends.cc:81-0 db_init_database: Trying 
to find mapping of given interfacename postgresql to mapping 
interfacename dbi, partly_compare = true
mq-bareos01 (100): cats/cats_backends.cc:81-0 db_init_database: Trying 
to find mapping of given interfacename postgresql to mapping 
interfacename mysql, partly_compare = false
mq-bareos01 (100): cats/cats_backends.cc:81-0 db_init_database: Trying 
to find mapping of given interfacename postgresql to mapping 
interfacename postgresql, partly_compare = false

mq-bareos01 (100): cats/postgresql.cc:1255-0 db_init_database first time
mq-bareos01 (50): cats/postgresql.cc:247-0 pg_real_connect done
mq-bareos01 (50): cats/postgresql.cc:249-0 db_user=bareos db_name=bareos 
db_password=EpfEYTG5k3bS

mq-bareos01 (150): dird/ua_db.cc:188-0 DB bareos opened
mq-bareos01 (100): cats/sql_query.cc:96-0 called: void 
BareosDb::FillQueryVaList(PoolMem&, BareosDbQueryEnum::SQL_QUERY_ENUM, 
__va_list_tag*) with query name uar_del_temp (17)
mq-bareos01 (100): cats/sql_query.cc:102-0 called: void 
BareosDb::FillQueryVaList(PoolMem&, BareosDbQueryEnum::SQL_QUERY_ENUM, 
__va_list_tag*) query is now DROP TABLE temp
mq-bareos01 (100): cats/sql_query.cc:124-0 called: bool 
BareosDb::SqlQuery(const char*, int) with query DROP TABLE temp
mq-bareos01 (50): cats/postgresql.cc:687-0 Result status fatal: DROP 
TABLE temp
mq-bareos01 (10): cats/postgresql.cc:692-0 ERROR TERMINATION: Fatal 
database error

mq-bareos01: ERROR TERMINATION at cats/postgresql.cc:692
Fatal database error





I've had a look at the postgres database, there is no table "temp".


Can you give me a hint?


Thank you,
Marcus Wagner

--
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/emf14e7815-d8b3-451d-9b4c-79c72e8fc7dc%40mwx1c6.

Re: [bareos-users] Backing up WwebDAV

[Spadajspadaj]

With Bareos it's usually not a question whether it is possible but how 
to do it ;-)


But seriously - since WebDAV is not a storage as such, just a method of 
access, you have two options. Either you have access to the server from 
which the DAV share is served and you back it up locally. But I suspect 
it's not the case since you're asking here. Second option is to use a 
plugin to emulate a file for bareos fd. (you always need to have a fd 
from which you're performing a backup). Since there is no dedicated 
plugin for DAV connectivity, you'd need to either use bpipe or python 
plugin to back up/restore a data stream which you'll have to provide 
from a custom script retrieving data from DAV share. You have to have a 
"helper" host though so you'd connect to fd installed on host A from 
which you launch script connecting to host B which hosts the DAV share 
and downloading data from it.


Best Regards,

MK

On 28.02.2020 07:48, tklassen wrote:

Hello list,
i haven´t found a way to backup a WebDAV storage, is it even possible 
with Bareos?


Im trying to backup my voip system if possible.

Greetings!

--
You received this message because you are subscribed to the Google 
Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to bareos-users+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/3fb7c32b-07d7-04e5-187d-50cd58867fb9%40schokokeks.org 
.


--
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/dd8aa4ef-719c-f3e9-4f32-f6dfb9314e1b%40gmail.com.