Re: [Bacula-users] Problem backing up
2011/11/8 Luca Bertoncello : > Hi, list! > > This night the full backup did not work. > I'm trying to find the problem, but I can understand it... > > I think, the problem is somewhere in the changer... > If I give an "update slots" I get: > > Connecting to Director hal9000.netzing.intra:9101 > 1000 OK: hal9000-dir Version: 5.0.1 (24 February 2010) > Enter a period to cancel a command. > update slots > Automatically selected Catalog: Netzing > Using Catalog "Netzing" > Automatically selected Storage: changer1 > Connecting to Storage daemon changer1 at hal9000.netzing.intra:9103 ... > 3306 Issuing autochanger "slots" command. > Device "sata-changer" has 0 slots. > No slots in changer to scan. > You have messages. > quit > Date is not a known vacation day. > > I use an autochanger for SATA > (http://sourceforge.net/projects/vchanger/) which normally runs without > problem... > > Can you help me? Hi, Could you tell what returns command: /some/localization/bin/vchanger -u root -g root /some/localization/etc/vchanger.conf LISTMAGS Could you put also output from below command? /some/localization/bin/vchanger -u root -g root /some/localization/etc/vchanger.conf list (it needs complete vchanger files localization instead of /some/localization/...) If your vchanger is working on another user than "root" you should actualize above commands with correct username and group for vchanger (-u option for username and -g option for group). Regards, gani > > Thanks a lot! > -- > ___ > Luca Bertoncello > Entwicklung Mail: bertonce...@netzing.de > > > NETZING Solutions AG Tel.: 0351/41381 - 23 > Fröbelstr. 57, 01159 Dresden Fax: 0351/41381 - 12 > ___ > > Impressum: > NETZING Solutions AG - Fröbelstraße 57 - 01159 Dresden > Sitz der Gesellschaft Amtsgericht Dresden HRB 18926 > Vorstand Dieter Schneider - Aufsichtsratsvorsitzender Volker Kanitz > USt.Id DE211326547 Mail: netzing...@netzing.de > > -- > RSA(R) Conference 2012 > Save $700 by Nov 18 > Register now > http://p.sf.net/sfu/rsa-sfdev2dev1 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Catalog Backup failing
2011/11/8 Kenney, William P. (Information Technology Services) : > Hello All, > > > > Have been running Bacula 5.0.3 without any major problems, but the > BackupCatalog job is failing. > > Bacula-director is running. > > MySql is up and I can log in from the console with no problem. > Hi, Did you look into "/etc/bacula/scripts/make_catalog_backup.pl" script? Could you confirm that variable $dir_conf at the begining of the script contains a correct localization "dbcheck" script? For example: my $dir_conf='/usr/local/bacula/sbin/dbcheck -B -c /usr/local/bacula/etc/bacula-dir.conf'; If it does not point to correct localization then you can correct it. You can also run command included in the $dir_conf variable with -C 'MyCatalog' option at the end of command. Regards, gani > > > The error message follows: > > *** > > 08-Nov 16:40 ecsu-bk3-dir JobId 970: shell command: run BeforeJob > "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog" > > 08-Nov 16:40 ecsu-bk3-dir JobId 970: BeforeJob: Can't find your catalog > (MyCatalog) in director configuration > > 08-Nov 16:40 ecsu-bk3-dir JobId 970: Error: Runscript: BeforeJob returned > non-zero status=1. ERR=Child exited with code 1 > > 08-Nov 16:40 ecsu-bk3-dir JobId 970: Error: Bacula ecsu-bk3-dir 5.0.2 > (28Apr10): 08-Nov-2011 16:40:39 > > Build OS: x86_64-pc-linux-gnu ubuntu 10.10 > > JobId: 970 > > Job: BackupCatalog.2011-11-08_16.40.37_03 > > Backup Level: Full > > Client: "ecsu-bk3-fd" 5.0.2 (28Apr10) > x86_64-pc-linux-gnu,ubuntu,10.10 > > FileSet: "Catalog" 2011-05-06 23:10:00 > > Pool: "File" (From Job resource) > > Catalog: "MyCatalog" (From Client resource) > > Storage: "File1" (From Job resource) > > Scheduled time: 08-Nov-2011 16:40:34 > > Start time: 08-Nov-2011 16:40:39 > > End time: 08-Nov-2011 16:40:39 > > Elapsed time: 0 secs > > Priority: 11 > > FD Files Written: 0 > > SD Files Written: 0 > > FD Bytes Written: 0 (0 B) > > SD Bytes Written: 0 (0 B) > > Rate: 0.0 KB/s > > Software Compression: None > > VSS: no > > Encryption: no > > Accurate: no > > Volume name(s): > > Volume Session Id: 0 > > Volume Session Time: 0 > > Last Volume Bytes: 0 (0 B) > > Non-fatal FD errors: 1 > > SD Errors: 0 > > FD termination status: > > SD termination status: > > Termination: *** Backup Error *** > > * > > Any help will be appreciated. > > > > Bill > > > > William P. Kenney > > Unix Systems Administrator > > (860) 465-4688 > > > > -- > RSA(R) Conference 2012 > Save $700 by Nov 18 > Register now > http://p.sf.net/sfu/rsa-sfdev2dev1 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Catalog Backup failing
Hello All, Have been running Bacula 5.0.3 without any major problems, but the BackupCatalog job is failing. Bacula-director is running. MySql is up and I can log in from the console with no problem. The error message follows: *** 08-Nov 16:40 ecsu-bk3-dir JobId 970: shell command: run BeforeJob "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog" 08-Nov 16:40 ecsu-bk3-dir JobId 970: BeforeJob: Can't find your catalog (MyCatalog) in director configuration 08-Nov 16:40 ecsu-bk3-dir JobId 970: Error: Runscript: BeforeJob returned non-zero status=1. ERR=Child exited with code 1 08-Nov 16:40 ecsu-bk3-dir JobId 970: Error: Bacula ecsu-bk3-dir 5.0.2 (28Apr10): 08-Nov-2011 16:40:39 Build OS: x86_64-pc-linux-gnu ubuntu 10.10 JobId: 970 Job:BackupCatalog.2011-11-08_16.40.37_03 Backup Level: Full Client: "ecsu-bk3-fd" 5.0.2 (28Apr10) x86_64-pc-linux-gnu,ubuntu,10.10 FileSet:"Catalog" 2011-05-06 23:10:00 Pool: "File" (From Job resource) Catalog:"MyCatalog" (From Client resource) Storage:"File1" (From Job resource) Scheduled time: 08-Nov-2011 16:40:34 Start time: 08-Nov-2011 16:40:39 End time: 08-Nov-2011 16:40:39 Elapsed time: 0 secs Priority: 11 FD Files Written: 0 SD Files Written: 0 FD Bytes Written: 0 (0 B) SD Bytes Written: 0 (0 B) Rate: 0.0 KB/s Software Compression: None VSS:no Encryption: no Accurate: no Volume name(s): Volume Session Id: 0 Volume Session Time:0 Last Volume Bytes: 0 (0 B) Non-fatal FD errors:1 SD Errors: 0 FD termination status: SD termination status: Termination:*** Backup Error *** * Any help will be appreciated. Bill William P. Kenney Unix Systems Administrator (860) 465-4688 -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Delete disc file after job migrated to tape
Dear All I am using the new option in 5.2.1 "Purge Migrated Job". I have Bacula writing Full backups to disc and then later I migrate the Full backups to tape. Has anyone has a script to check there are no jobs in a disc volume and then delete the disc volume BUT not remove it from the catalog. You may ask why - reason - these volumes are large 100-200 GB. Thanking you Stephen Carr -- Stephen Carr School of Civil, Environmental & Mining Engineering The University of Adelaide Adelaide, South Australia, 5005 Australia Tel +618-8303-4313 Fax +618-8303-4359 Email sgc...@civeng.adelaide.edu.au CRICOS Provider Number 00123M --- This email message is intended only for the addressee(s) and contains information that may be confidential and/or copyright. If you are not the intended recipient please notify the sender by reply email and immediately delete this email. Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient. -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] how to multiplex two jobs using two different tape pools
All my backup jobs spool to disk before going to tape. I have a small set of jobs that can take several days to complete and it locks up the use of the tape drive. I would like to have the drive freed while the long job is spooling to disk so that the smaller jobs can run. I realize that there will be some amount of extra tape changing between pools. I have successfully run multiple jobs together when they use the same pool, but when I try to specify different pools I get the "waiting to reserve a device" message on the job. I am running an older version of bacula - 2.0.3. Am planning on upgrading soon to a later version. If this was Files, I know that I could create a second Device, but the documentation indicates that this should not be done with tapes. Thanks. Richard -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula and tls. Can't get that working
Verify the keyUsage of your certs.. Try to create a cert with all usages: keyUsage = digitalSignature, nonRepudiation, keyEncipherment, dataEncipherment, keyAgreement, keyCertSign, cRLSign, encipherOnly, decipherOnly 2011/11/8 Oliver Hoffmann > Hi all, > > > it is such a hassle to get that running. Could someone guide me please? > > 1. What I did > > I made my own CA using this guide: > https://help.ubuntu.com/community/OpenSSL > Now I have a CA and self-signed keys. So there are server_crt.pem, > server_key.pem and cacert.pem. The common name is always > ba-server.some.domain. I altered the file index.txt.attr. Now it reads > unique_subject = no. > > Of course I read this one: > http://www.bacula.org/de/dev-manual/Bacula_TLS_Communication.html > and then that one: > http://www.devco.net/pubwiki/Bacula/TLS/ > which was quite helpful. I tried to have an encrypted communication > between the director and bconsole as a first attempt but it doesn't > work. > > bconsole.conf looks like: > > Director { > Name = ba-server-dir > DIRport = 9101 > address = ba-server.some.domain > Password = "mypw" > TLS Enable = yes > TLS Require = yes > TLS CA Certificate File = /etc/bacula/certs/cacert.pem > TLS Certificate = /etc/bacula/certs/server_crt.pem > TLS Key = /etc/bacula/certs/server_key.pem > } > > bacula-dir.conf (just the upper part): > > Director {# define myself > Name = ba-server-dir > DIRport = 9101# where we listen for UA connections > QueryFile = "/etc/bacula/scripts/query.sql" > WorkingDirectory = "/var/lib/bacula" > PidDirectory = "/var/run/bacula" > Password = "mypw" > Messages = Daemon > DirAddress = ba-server.some.domain > Heartbeat Interval = 60 > Maximum Concurrent Jobs = 20 > > TLS Enable = yes > TLS Require = yes > # TLS Verify Peer = yes > # TLS Allowed CN = "ba-server.some.domain" > TLS CA Certificate File = /etc/bacula/certs/cacert.pem > TLS Certificate = /etc/bacula/certs/server_crt.pem > TLS Key = /etc/bacula/certs/server_key.pem > } > > I used TLS Verify Peer and TLS Allowed CN as well before. > > > 2. What I got: > > Connecting to Director ba-server.some.domain:9101 > TLS negotiation failed > Director authorization problem. > Most likely the passwords do not agree. > If you are using TLS, there may have been a certificate validation > error during the TLS handshake. Please see > > http://www.bacula.org/en/rel-manual/Bacula_Freque_Asked_Questi.html#SECTION00376 > for help. > > In the log file I see: > > 08-Nov 17:16 ba-server-dir JobId 0: Error: tls.c:92 Error with > certificate at depth: 0, issuer > = /CN=ba-server.some.domain and so on > ERR=26:unsupported certificate purpose > > Thus I searched for "unsupported certificate purpose" and found out > that nsCertType was set to "server". Means both certs have a purpose > called "server". I made a new crt/key with "client". No success. > > I couldn't find either how to set nsCertType to nothing or if bacula is > able to ignore such a setting. > > Thanks for help! > > Greetings, > > Oliver > > > > > > > -- > RSA(R) Conference 2012 > Save $700 by Nov 18 > Register now > http://p.sf.net/sfu/rsa-sfdev2dev1 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- William Felipe Welter -- Consultor em Tecnologias Livres william.wel...@4linux.com.br www.4linux.com.br -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] (no subject)
http://dorsetcarwindowtinting.co.uk/wp-content/uploads/fgallery/work.php?ac -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] VSS reporting files corrupted or unreadable
The answers will make more sense if I rearrange the questions: On Tue, 2011-11-08 at 08:07 -0500, Avery Ceo wrote: > On Tue, 2011-11-08 at 10:17 +1100, James Harper wrote: > Create a snapshot manually. This guy blogs about how to do it > http://blogs.msdn.com/b/adioltean/archive/2005/01/20/357836.aspx and map > > it to a drive letter. The vshadow tool that he talks about is part of > > the VSS SDK... newer versions are available but I assume this version > > http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=2349 > > 0 might do the trick on 2003. Once you've created the snapshot, see if > > you can access the files just by copying them to somewhere else. At > > least then you'll know if you have a general VSS problem or if it is > > specific to Bacula. > > Definitely a promising approach. I will let you know what I find. No question now - this is a VSS issue with Windows, not Bacula. I ran his other script to copy individual files out of the VSS instead of mapping a persistent snapshot, first against one of the .rar files and then against one of the .MYD files - both came up corrupt. > > Is the MySQL very heavily used? VSS likes to try and find a period of > > 'idle time' to do its work. Whatever happens, the outcome should never > > be a corrupt snapshot but maybe you've discovered a bug. Is it possible > > to make MySQL idle (or stop it altogether but ideally you'd test with > > the files still in use) and see if the problem persists? > I stopped the MySQL service and reran the copy against both files. Both reported as corrupt. > > > > Are there any other messages in the event logs about the vss snapshot > > process? > > > > I didn't see anything else significant, but I will look again in a few > hours. > Only the standard messages about the service starting and stopping. > > While the backup is running, does the command 'vssadmin list writers' > > show any writers with errors? The way Bacula uses VSS is fairly > > simplistic and doesn't involve the writers, but it does give a 'crash > > consistent' copy of the drive. A writer in an error status would be an > > indication of a problem though. > > Didn't notice any, but will retest. > I modified the script to pause and hold the shadow copy in place. No writers report errors. > > Do a chkdsk /f on the drive where the database is. Probably best to do > > it on reboot rather than force a dismount of the drive. Obviously the > > volume is working well enough but there could be some latent corruption > > or something that only comes out in the snapshot. > > Already tried this one. > Ran it again anyway, and chkdsk found no errors. Boy, this is a stumper. > > > Good luck! > > > > James > -- Regards, Avery Ceo Systems Administrator Enterprise Hosting -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacula and tls. Can't get that working
Hi all, it is such a hassle to get that running. Could someone guide me please? 1. What I did I made my own CA using this guide: https://help.ubuntu.com/community/OpenSSL Now I have a CA and self-signed keys. So there are server_crt.pem, server_key.pem and cacert.pem. The common name is always ba-server.some.domain. I altered the file index.txt.attr. Now it reads unique_subject = no. Of course I read this one: http://www.bacula.org/de/dev-manual/Bacula_TLS_Communication.html and then that one: http://www.devco.net/pubwiki/Bacula/TLS/ which was quite helpful. I tried to have an encrypted communication between the director and bconsole as a first attempt but it doesn't work. bconsole.conf looks like: Director { Name = ba-server-dir DIRport = 9101 address = ba-server.some.domain Password = "mypw" TLS Enable = yes TLS Require = yes TLS CA Certificate File = /etc/bacula/certs/cacert.pem TLS Certificate = /etc/bacula/certs/server_crt.pem TLS Key = /etc/bacula/certs/server_key.pem } bacula-dir.conf (just the upper part): Director {# define myself Name = ba-server-dir DIRport = 9101# where we listen for UA connections QueryFile = "/etc/bacula/scripts/query.sql" WorkingDirectory = "/var/lib/bacula" PidDirectory = "/var/run/bacula" Password = "mypw" Messages = Daemon DirAddress = ba-server.some.domain Heartbeat Interval = 60 Maximum Concurrent Jobs = 20 TLS Enable = yes TLS Require = yes # TLS Verify Peer = yes # TLS Allowed CN = "ba-server.some.domain" TLS CA Certificate File = /etc/bacula/certs/cacert.pem TLS Certificate = /etc/bacula/certs/server_crt.pem TLS Key = /etc/bacula/certs/server_key.pem } I used TLS Verify Peer and TLS Allowed CN as well before. 2. What I got: Connecting to Director ba-server.some.domain:9101 TLS negotiation failed Director authorization problem. Most likely the passwords do not agree. If you are using TLS, there may have been a certificate validation error during the TLS handshake. Please see http://www.bacula.org/en/rel-manual/Bacula_Freque_Asked_Questi.html#SECTION00376 for help. In the log file I see: 08-Nov 17:16 ba-server-dir JobId 0: Error: tls.c:92 Error with certificate at depth: 0, issuer = /CN=ba-server.some.domain and so on ERR=26:unsupported certificate purpose Thus I searched for "unsupported certificate purpose" and found out that nsCertType was set to "server". Means both certs have a purpose called "server". I made a new crt/key with "client". No success. I couldn't find either how to set nsCertType to nothing or if bacula is able to ignore such a setting. Thanks for help! Greetings, Oliver -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] HELP : MySQL database lost - how best to restore data
On Sun, 6 Nov 2011 13:55:31 -0500, Win Htin wrote: > Hi folks, > > If the bacula database is completely blown away but I still have the > bootstrap file (*.bsr) what is the best method to re-install the > bacula database? I think "bscan" is the way to go but am a bit > confused with the explanations in the howto guide. The bare database > has been re-created and I can get to the "bconsole" but of course > commands like "update" or "list" will come back empty. Why bscan? You're trying to restore the last database backup, not to rebuild the database from the archives. If you have the bootstrap file of the last db backup, and the backup volume itself, you can simply restore the database dump file with bextract; then you just need to reload the file using mysql and you're good to go. If you also lost the db backup volumes, then you must use bscan -- but in that case you have no use for bootstrap files. andrea -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] compression
Hi, Has anyone changed from GZIP compression to LZO for disk backups and tracked the performance / disk space usage difference? Any advocates out there? Anyone of the opinion it is the only way to go. Any hints appreciated thanks, Randy Katz -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] VSS reporting files corrupted or unreadable
On Tue, 2011-11-08 at 10:17 +1100, James Harper wrote: > > Are there any other messages in the event logs about the vss snapshot > process? > I didn't see anything else significant, but I will look again in a few hours. > What you describe would indicate that the problem is Windows rather than > Bacula. Can you try the following suggestions, in no particular order: > > While the backup is running, does the command 'vssadmin list writers' > show any writers with errors? The way Bacula uses VSS is fairly > simplistic and doesn't involve the writers, but it does give a 'crash > consistent' copy of the drive. A writer in an error status would be an > indication of a problem though. Didn't notice any, but will retest. > Is the MySQL very heavily used? VSS likes to try and find a period of > 'idle time' to do its work. Whatever happens, the outcome should never > be a corrupt snapshot but maybe you've discovered a bug. Is it possible > to make MySQL idle (or stop it altogether but ideally you'd test with > the files still in use) and see if the problem persists? Most of our backups are of VMs, so we cloned a production machine for our test and put it on its own VLAN. With no outside traffic, the database should be pretty quiet. I do not have the DB password to flush_tables_with_read_lock, but I should be able to stop the DB. > Do a chkdsk /f on the drive where the database is. Probably best to do > it on reboot rather than force a dismount of the drive. Obviously the > volume is working well enough but there could be some latent corruption > or something that only comes out in the snapshot. Already tried this one. > Create a snapshot manually. This guy blogs about how to do it > http://blogs.msdn.com/b/adioltean/archive/2005/01/20/357836.aspx and map > it to a drive letter. The vshadow tool that he talks about is part of > the VSS SDK... newer versions are available but I assume this version > http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=2349 > 0 might do the trick on 2003. Once you've created the snapshot, see if > you can access the files just by copying them to somewhere else. At > least then you'll know if you have a general VSS problem or if it is > specific to Bacula. Definitely a promising approach. I will let you know what I find. > Good luck! > > James -- Regards, Avery Ceo Systems Administrator Enterprise Hosting -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] VSS reporting files corrupted or unreadable
On Tue, 2011-11-08 at 01:13 +, Joseph L. Casale wrote: > >Yes, MySQL is running on this server. To the best of my knowledge, no > >VSS writer exists for MySQL. > > MySQL? How the heck is windows VSS supposed to quiesce MySQL? > > Methinks you are sol with that approach, you'd probably have better luck > using a run before script and a "mysql" supported method... > -- > RSA(R) Conference 2012 > Save $700 by Nov 18 > Register now > http://p.sf.net/sfu/rsa-sfdev2dev1 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users I don't expect MySQL to be in a quiesced state. The client is responsible for scheduling mysqldumps. What I do expect is that the inconsistent database files be read rather than causing the remainder of the backup to fail. If it were our server rather than a client's, then running a mysqldump in the run before is exactly how I would handle consistent database backups, but that still doesn't solve the problem of the unreadable snapshots. -- Regards, Avery Ceo Systems Administrator Enterprise Hosting -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Protokoll mysql backup
Sehr geehrte Damen und Herren. Ich sichere die mysql Datenbanken unserer Linux Systeme mit Bacula 5.0.3 und dem Plugin Bpipe.so. Nach dem das Backup gelaufen ist und ich eine Kontrolle wie folgt mache: SHELL> echo "list files jobid=156" | bconsole >job156.log Sehe ich die geischerten mysql Datenbanken mit dem definierten Pseudo Dateinamen /var/lib/mysql/mysql.sql Wenn ich allerdings im BAT den Versions Browser starte und nach diesen Pseudo Dateien suche, sehe ich diese im BAT nicht. Ist das so definiert, dass man diese Pseudo Dateien im BAT nicht kontrollieren kann? Lg Robert -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Problem backing up
Hi, list! This night the full backup did not work. I'm trying to find the problem, but I can understand it... I think, the problem is somewhere in the changer... If I give an "update slots" I get: Connecting to Director hal9000.netzing.intra:9101 1000 OK: hal9000-dir Version: 5.0.1 (24 February 2010) Enter a period to cancel a command. update slots Automatically selected Catalog: Netzing Using Catalog "Netzing" Automatically selected Storage: changer1 Connecting to Storage daemon changer1 at hal9000.netzing.intra:9103 ... 3306 Issuing autochanger "slots" command. Device "sata-changer" has 0 slots. No slots in changer to scan. You have messages. quit Date is not a known vacation day. I use an autochanger for SATA (http://sourceforge.net/projects/vchanger/) which normally runs without problem... Can you help me? Thanks a lot! -- ___ Luca Bertoncello Entwicklung Mail: bertonce...@netzing.de NETZING Solutions AG Tel.: 0351/41381 - 23 Fröbelstr. 57, 01159 Dresden Fax: 0351/41381 - 12 ___ Impressum: NETZING Solutions AG - Fröbelstraße 57 - 01159 Dresden Sitz der Gesellschaft Amtsgericht Dresden HRB 18926 Vorstand Dieter Schneider - Aufsichtsratsvorsitzender Volker Kanitz USt.Id DE211326547 Mail: netzing...@netzing.de signature.asc Description: PGP signature -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users