[Bacula-users] Migrating from MySQL to Postgres
Hi I try to migrate from am mysql db to postgres. I am failing to import thy mysql dump into the postrgres : (according to these instructions: http://www.bacula.org/7.0.x-manuals/en/main/Installing_Configuring_Post.html#SECTION00415 bacula 7.1 / CentOS ) lots of psql:/tmp/bacula-backup2pg.sql:46485014: invalid command \'].sublime-snippet'); psql:/tmp/bacula-backup2pg.sql:46485018: invalid command \'].sublime-snippet'); psql:/tmp/bacula-backup2pg.sql:46485025: invalid command \'].sublime-snippet'); psql:/tmp/bacula-backup2pg.sql:46485027: invalid command \'].sublime-snippet'); psql:/tmp/bacula-backup2pg.sql:46485042: invalid command \'].sublime-snippet'); psql:/tmp/bacula-backup2pg.sql:46485194: invalid command \'-Marker.sublime-snippet'); psql:/tmp/bacula-backup2pg.sql:62088431: out of memory The point is - I do not need really the big file table (33M+ rows) since we will start the migration - or better finish the migration with a new full backup and could keep the old mysql until no longer needed. But I would like to keep as much information as possible. e.g. the volume labels/pools. Is there a easy way to just do that? If any one had a good Idea or documentation how to do that I would depreciate any help. Timo ESET 11860 (20150629) The message was checked by ESET Mail Security. -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore director
Radosław Korzeniewski wrote on 06/29/2015 12:33 AM: No, you need a bextract command to restore all your configuration and your catalog database backup from archive volumes (do you have your bsr files somewhere, right?). no i don't know where those are but i was able to make some progress... i found my bacula.sql with bls and extracted that with bextract from most recent backup, then used mysql to import that data... now i can use restore command to restore my files. thank you for the help When you have a catalog database backup you can load it into your new and fresh database instance. Then with restored config files you can succesfully run your backup system. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore director
this is extremely frustrating! :( im reading the section about bscan[1], which is what i need to use right? i dont understand how this all works and its stressing me out. apparently i need to re-define my clients in the bacula-dir.conf? what does that consist of? there is already one Client defined by default, with a Name of system name-fd which is the Client that i want to restore from... am i supposed to re-define all of my clients? (i think i had 7) i found that the most recent volume written is Vol0038 so i tried running this command: bscan -c bacula-sd.conf -v -V Vol0038 /media/external/bacula but i am getting errors about Could not get Client record. ERR=Client record not found in Catalog so is it not defined correctly in bacula-dir.conf? so i'm just obviously lost and really need help to get back into my backups, then i need to know what to do to prevent this from happening again. it seems like i need to use another backup program to backup /etc/bacula and the database separately 1. http://www.bacula.org/5.0.x-manuals/en/utility/utility/Volume_Utility_Tools.html#SECTION0027 -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula causing high disk-io on clients
Hello, 2015-06-27 17:56 GMT+02:00 Heitor Faria hei...@bacula.com.br: I wonder if the thread starter (SPQR) solved his problem. The discussion became hot and he flew. lol As always on the Internet. :) all the best -- Radosław Korzeniewski rados...@korzeniewski.net -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Could not connect to server Director daemon ....
Hello Ana,
Have you checked if this address/port (tux64.home.lan:9101) is not being
used by another process? Your original bacula-dir.conf (the last post)
was configured to use locahost and not tux64.home.lan as your are trying
now.
this comes up from time to time - I see only one mail every two? days,
bacula it self (regardless the problem with the traymon) works. Anyway,
I will check it again.
Thanks you,
Olaf
Best regards,
Ana
On Sat, Jun 27, 2015 at 4:38 AM, olx69 ope-li...@gmx.de
mailto:ope-li...@gmx.de wrote:
Hello Ana,
I´m not sure about this, but I noticed something about the names for
your storage:
---bacula-traymon.conf--
Storage {
Name = bacula-tux64-sd
...
}
bacula-dir-full.conf
Storage {
Name = File
...
}
bacula-sd-full.conf-
Storage { # definition of myself
Name = bacula-tux64-sd
...
}
Could you try Name = bacula-tux64-sd in your bacula-dir-full.conf or
Name = File in your bacula-traymon.conf for the storage definition?
If I change this but 'bat' doesn't work any more (probably bconsole too
- not tested). Also it doesn't change the behaviour of traymonitor.
I had a look at the original bacula-dir.conf, e.g.
# Definition of a second file Virtual Autochanger device
# Possibly pointing to a different disk drive
Storage {
Name = File2
# Do not use localhost here
Address = localhost# N.B. Use a fully qualified
name here
SDPort = 9103
Password = @@SD_PASSWORD@@
Device = FileChgr2
Media Type = File2
Maximum Concurrent Jobs = 10# run up to 10 jobs a the
same time
}
so this seems to be correct.
Also I notice a warning:
26-Jun 19:36 bacula-tux64-dir: Warning: Cannot bind port 9101: ERR=Die
angeforderte Adresse kann nicht zugewiesen werden: Retrying ...
english: Can't assign requested address. Retrying ...
Maybe it's relevant.
This configuration did work with bacula 5.x, I was not aware of thise
changes in 7.x. Maybe v5.x was more sloppy with config files ...
Thank you,
Olaf
Best regards,
Ana
On Fri, Jun 26, 2015 at 2:36 AM, olx69 ope-li...@gmx.de
mailto:ope-li...@gmx.de
mailto:ope-li...@gmx.de mailto:ope-li...@gmx.de wrote:
Hello Ane,
Sorry I was out a few days Have you tested your Bacula with
these
fake passwords? Or you have just changed them for posting here?
I
found no errors in your passwords configurations, but I'm not
sure if
you are using these ones posted here. In the case you're not,
could you
verify your director to storage daemon password configuration
(not the
one for communicating with monitor)? The error message points to a
mismatch here.
No, these are my real passwords! I trust in my secure LAN ;-)
Thank you,
Olaf
On Tue, Jun 23, 2015 at 11:04 AM, olx69 ope-li...@gmx.de
mailto:ope-li...@gmx.de mailto:ope-li...@gmx.de
mailto:ope-li...@gmx.de
mailto:ope-li...@gmx.de mailto:ope-li...@gmx.de
mailto:ope-li...@gmx.de mailto:ope-li...@gmx.de wrote:
Am 18.06.2015 um 16:13 schrieb olx69:
Hello Ana,
Sorry I'm late in this post.
It seems there is still some password mismatching
problems.
Could you
post your resources definitions for monitor (in
bacula-dir.conf,
bacula-fd.conf and bacula-sd.conf) and your
tray-monitor.conf?
thank you for investigating! attached the files,
no idea? Here the reduced password related part. Imo
all is
correct,
isn't it?
---bacula-traymon.conf--
Monitor {
Name = bacula-tux64-mon
Password = MON_DIR_PASSWORD # password
for the
Directors
RefreshInterval = 3 seconds
}
Client {
Name = bacula-tux64-fd
Address = tux64.home.lan
Password = MON_FD_PASSWORD # password for
FileDaemon
}
Storage {
Name = bacula-tux64-sd
Address = tux64.home.lan
Password = MON_SD_PASSWORD # password for
StorageDaemon
}
Director {
Re: [Bacula-users] Compiling FD 7.0.5 on Solaris 11.2 x86_64
Hi Heitor, it looks like that download is for SPARC and not x86_64. Regards, Mark Hi Mark, we are attempting to compile Bacula FD 7.0.5 on Solaris 11.2 x86_64. When running the .configure we get the following error message: Did you tried to install this? It's for Solaris 10 but maybe it will help. It was a contribution from Uwe from this list: http://bacula.us/bacula-solaris-systems-10-sparc-download/ http://bacula.us/bacula-solaris-systems-10-sparc-download/ -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore director
I just read your first message. Are you sure you weren't dumping backing up the db dump already? Also you should only need to define the client from which you are trying to restore. On June 29, 2015 1:08:15 PM GMT+07:00, scar s...@drigon.com wrote: this is extremely frustrating! :( im reading the section about bscan[1], which is what i need to use right? i dont understand how this all works and its stressing me out. apparently i need to re-define my clients in the bacula-dir.conf? what does that consist of? there is already one Client defined by default, with a Name of system name-fd which is the Client that i want to restore from... am i supposed to re-define all of my clients? (i think i had 7) i found that the most recent volume written is Vol0038 so i tried running this command: bscan -c bacula-sd.conf -v -V Vol0038 /media/external/bacula but i am getting errors about Could not get Client record. ERR=Client record not found in Catalog so is it not defined correctly in bacula-dir.conf? so i'm just obviously lost and really need help to get back into my backups, then i need to know what to do to prevent this from happening again. it seems like i need to use another backup program to backup /etc/bacula and the database separately 1. http://www.bacula.org/5.0.x-manuals/en/utility/utility/Volume_Utility_Tools.html#SECTION0027 -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Sent from my Android device with K-9 Mail. Please excuse my brevity.-- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore director
Hello, 2015-06-29 8:08 GMT+02:00 scar s...@drigon.com: this is extremely frustrating! :( im reading the section about bscan[1], No, you need a bextract command to restore all your configuration and your catalog database backup from archive volumes (do you have your bsr files somewhere, right?). When you have a catalog database backup you can load it into your new and fresh database instance. Then with restored config files you can succesfully run your backup system. It should take about 15min to recover (excluding OS installation and configuration, as you already have one) depending on catalog database size. If you lot all your bsr files, you need to check where your config files and catalog database backups are located, which will take a lot of time. If you do not perform a catalog database backup then you will need to use bscan to populate all your backup metadata to catalog, which will take more time again. best regards -- Radosław Korzeniewski rados...@korzeniewski.net -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore director
Last I had to use bscan it worked fine by the simple docs...takes a long time though. As for backing up your conf and database that is defined in the example configurations. You should never rely on a backup tool you have not tested the restore procedures with. On June 29, 2015 1:08:15 PM GMT+07:00, scar s...@drigon.com wrote: this is extremely frustrating! :( im reading the section about bscan[1], which is what i need to use right? i dont understand how this all works and its stressing me out. apparently i need to re-define my clients in the bacula-dir.conf? what does that consist of? there is already one Client defined by default, with a Name of system name-fd which is the Client that i want to restore from... am i supposed to re-define all of my clients? (i think i had 7) i found that the most recent volume written is Vol0038 so i tried running this command: bscan -c bacula-sd.conf -v -V Vol0038 /media/external/bacula but i am getting errors about Could not get Client record. ERR=Client record not found in Catalog so is it not defined correctly in bacula-dir.conf? so i'm just obviously lost and really need help to get back into my backups, then i need to know what to do to prevent this from happening again. it seems like i need to use another backup program to backup /etc/bacula and the database separately 1. http://www.bacula.org/5.0.x-manuals/en/utility/utility/Volume_Utility_Tools.html#SECTION0027 -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Sent from my Android device with K-9 Mail. Please excuse my brevity.-- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Compiling FD 7.0.5 on Solaris 11.2 x86_64
Hi Gary,
I tried with SunStudio 12.3 but get the same error:
..
..
config.status: creating src/config.h
config.status: executing libtool commands
config.status: executing default-1 commands
config.status: creating po/POTFILES
config.status: creating po/Makefile
config.status: executing default commands
chmod: WARNING: can't access storage-ctl
chmod: WARNING: can't access bsg_persist
..
Configuration on Tue Jun 30 02:29:59 AEST 2015:
Host:i386-pc-solaris2.11 -- solaris 5.11
Bacula version: Bacula 7.0.5 (28 July 2014)
Source code location:.
Install binaries:/opt/bacula/sbin
Install libraries: /opt/bacula/lib
Install config files:/opt/bacula/etc
Scripts directory: /opt/bacula/etc
Archive directory: /tmp
Working directory: /opt/bacula/working
PID directory: /var/run
Subsys directory:/var/run/subsys
Man directory: ${datarootdir}/man
Data directory: /opt/bacula/share
Plugin directory:/opt/bacula/lib
C Compiler: cc
C++ Compiler:/opt/solarisstudio12.3/bin/CC
Compiler flags: -g -O
Linker flags:
Libraries: -lpthread -lresolv -lnsl -lsocket -lxnet -lintl
-lresolv -lrt
Statically Linked Tools: no
Statically Linked FD:no
Statically Linked SD:no
Statically Linked DIR: no
Statically Linked CONS: no
Database backends: None
Database port:
Database name: bacula
Database user: bacula
Regards,
Mark
I haven't gotten to my 11.2 boxes yes, this works on 11.0 x64:
./configure CC=cc CXX=CC CFLAGS=-g -O --prefix=/opt/bacula
--with-dir-password=password --with-fd-password=password
--with-sd-password=password --with-fd-user=root --with-fd-group=backup
--enable-smartalloc --enable-client-only
I used the SunStudio 12.2 compiler on this system.
I use Sunstudio, rather than gcc, for my Solaris systems, both SPARC and
x64, as it is free.
Cheers,
GaryB-)
--
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical virtual servers, alerts via email sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Loading file listings from old tapes
I have figured out at least part of my problem: a flawed understanding of what Bacula is doing. I *had* thought, that if I did a bscan, Bacula would find a dump of the database and restore the database records for the time period of the backup. But it does not; it only restores records for those jobs it finds on the tape. In order to restore other records I will need to bscan the appropriate media for the jobs that I'm missing. That's what I'm doing now. I've already scanned a tape and now I'm able to list files for the job in question. Thanks for the replies. *- Mike Schwager* * Linux Network Engineer, Mocho Trading LLC* * 312-646-4783 Phone312-637-0011 Cell312-957-9804 Fax* On Tue, Jun 23, 2015 at 1:33 PM, Michael Schwager mschwa...@mochotrading.com wrote: On Tue, Jun 23, 2015 at 12:20 PM, Heitor Faria hei...@bacula.com.br wrote: I have changed the retention periods to 12 months, and I have done some bscan's of some old tapes. I thought that would repopulate my database with the file names, but it has not. echo list jobs jobid=190 | bconsole returns No results to list. on a backup with 49,731 JobFiles. *- Mike Schwager* Any suggestions about how to perform this would be appreciated. Thanks. * Linux Network Engineer, Mocho Trading LLC* * 312-646-4783 Phone312-637-0011 Cell312-957-9804 Fax* -- This message is for the named person(s) use only. It may contain confidential proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Mocho Trading LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Running Bat on Win7 Pro SP1 64-bit
Hello, I've downloaded Bacula from https://sourceforge.net/projects/bacula/files/Win32_64/5.2.10/ and installed bat (only) using the bacula-win64-5.2.10.exe file. During the installation, at asked me about my Director information, and I believe I gave it the correct info. Now I go to c:Program Files\Bacula and try to run bat but I get the following error: The application was unable to start correctly (0xc07b). Click OK to close the application. I looked at the bin32\bat.conf file and it looks good. Am I missing something? Thanks. *- Mike Schwager* * Linux Network Engineer, Mocho Trading LLC* * 312-646-4783 Phone312-637-0011 Cell312-957-9804 Fax* -- This message is for the named person(s) use only. It may contain confidential proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Mocho Trading LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
