Re: [Bacula-users] Question about the database structure of Bacula
Il 28/09/2011 20:47, Stefan Michael Guenther ha scritto: Hello, the table Status contains the long and the short form of the job status messages. When I have a look at the table JobHisto, it has a field named JobStatus, but most of the values are 54. How do get the real job status message out of the table JobHisto? Thanks, Stefan -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users jobstatus is char(1), can't hold values like '54'. For example on my installation I find: bacula= select distinct jobstatus from jobhisto; jobstatus --- A E f T (4 rows) bacula-dir Version: 5.0.2 (28 April 2010) i486-pc-linux-gnu debian 5.0.4 Anyway, if you're asking for an sql query you can try this: SELECT h.jobid, h.job, s.jobstatuslong FROM jobhisto h JOIN status s ON h.jobstatus=s.jobstatus; HTH -- Marcello Romani -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Question about the database structure of Bacula
Am 28.09.2011 19:47, schrieb Stefan Michael Guenther: Hello, the table Status contains the long and the short form of the job status messages. When I have a look at the table JobHisto, it has a field named JobStatus, but most of the values are 54. How do get the real job status message out of the table JobHisto? It's possible whatever you use to display the table is showing you hex values for that column. 0x54 is T in ASCII. TT -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Performance with latent networks
Hello. I saw this post recently http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg47393.html and it seems I'm affected by this problem too. Bacula shows extremely low performance in networks with high rtt. I have sd in Germany and client in USA. Bacula can make backups on speeds between 5 to 10 Mbit/s which is too slow as backups are up to 600 GB. With simple iperf test I can achieve transfer rates about 100-120 Mbit/s. Why bacula cannot do the same? Compression does not affect transfer speed. Client has plenty of free CPU/memory. I've made ssh tunnel between hosts and set Address = 127.0.0.1 in Storage section. With this configuration I can see backups are running at speeds about 100 Mbit/s. Bacula version is 5.0.2 from Debian Lenny backports. +-- |This was sent by rea...@lmn.name via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Performance with latent networks
On Thu, 2011-09-29 at 04:20 -0700, reaper wrote: Hello. I saw this post recently http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg47393.html and it seems I'm affected by this problem too. Bacula shows extremely low performance in networks with high rtt. I have sd in Germany and client in USA. Bacula can make backups on speeds between 5 to 10 Mbit/s which is too slow as backups are up to 600 GB. With simple iperf test I can achieve transfer rates about 100-120 Mbit/s. Why bacula cannot do the same? Compression does not affect transfer speed. Client has plenty of free CPU/memory. I've made ssh tunnel between hosts and set Address = 127.0.0.1 in Storage section. With this configuration I can see backups are running at speeds about 100 Mbit/s. Bacula version is 5.0.2 from Debian Lenny backports. hi reaper, sounds like your sysctl.conf needs tweaking? have you tried something like this on both sides? kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 68719476736 kernel.shmall = 4294967296 # long fat pipes net.core.wmem_max = 8388608 net.core.rmem_max = 8388608 cheers m -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] disk backup
Dear all, I need some help about a little issue. At the momento I am backing up to several devices but the problem is that i am running out of space in my hard disk. Is possible to burn up some backups into dvd´s in order to erase the backups in the hard drive?. If possible , when I need to perform a restore bacula will know where is the file? Thanks in advance! Don't hesitate in contact me for further information. -- -- Gracias! Saludos!´ Ignacio Ariel Cardona. IT Consultant. (SAN NAS Specialist) -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] disk backup
2011/9/29 Ignacio Cardona ignaciocard...@gmail.com: Dear all, I need some help about a little issue. At the momento I am backing up to several devices but the problem is that i am running out of space in my hard disk. Is possible to burn up some backups into dvd´s in order to erase the backups in the hard drive?. Yes but you need 4GB disk volumes. If possible , when I need to perform a restore bacula will know where is the file? When bacula does not find a volume it will ask you to mount it. At that time you will have to copy the volume to the disk. John -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] disk backup
On 9/29/2011 10:35 AM, John Drescher wrote: 2011/9/29 Ignacio Cardonaignaciocard...@gmail.com: Dear all, I need some help about a little issue. At the momento I am backing up to several devices but the problem is that i am running out of space in my hard disk. Is possible to burn up some backups into dvd´s in order to erase the backups in the hard drive?. Yes but you need 4GB disk volumes. Also, consider that a 250 GB USB external drive can be had for little more than the price of a stack of DVD-R media. If possible , when I need to perform a restore bacula will know where is the file? When bacula does not find a volume it will ask you to mount it. At that time you will have to copy the volume to the disk. John -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] disk backup
On Thu, Sep 29, 2011 at 10:53 AM, Josh Fisher jfis...@pvct.com wrote: On 9/29/2011 10:35 AM, John Drescher wrote: 2011/9/29 Ignacio Cardonaignaciocard...@gmail.com: Dear all, I need some help about a little issue. At the momento I am backing up to several devices but the problem is that i am running out of space in my hard disk. Is possible to burn up some backups into dvd´s in order to erase the backups in the hard drive?. Yes but you need 4GB disk volumes. Also, consider that a 250 GB USB external drive can be had for little more than the price of a stack of DVD-R media. And a lot less work. I was thinking of that after my first post.. John -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacula/etc folder contents gone - any way to fix?
So, the contents of my ../bacula/etc/ folder are gone. Same place where bacula-dir.conf, bacula-sd.conf, etc, is stored. Nothing else has been lost. Volumes (including backups of the bacula server) are still in place, all other folders in ../bacula (such as lib, sbin, scripts, working, etc) are present. Besides not having the bacula-dir.conf, bacula-sd.conf, and bacula-fd.conf files, is there any way to restore the contents of this folder so I can still work with what I had? Or am I totally screwed here? Is it possible to reinstall bacula from source just to repair the contents of the ../bacula/etc folder? Please help! -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula/etc folder contents gone - any way to fix?
2011/9/29 R. Leigh Hennig rlh1...@gmail.com: So, the contents of my ../bacula/etc/ folder are gone. Same place where bacula-dir.conf, bacula-sd.conf, etc, is stored. Nothing else has been lost. Volumes (including backups of the bacula server) are still in place, all other folders in ../bacula (such as lib, sbin, scripts, working, etc) are present. Besides not having the bacula-dir.conf, bacula-sd.conf, and bacula-fd.conf files, is there any way to restore the contents of this folder so I can still work with what I had? Or am I totally screwed here? Is it possible to reinstall bacula from source just to repair the contents of the ../bacula/etc folder? Please help! Reinstalling will put back the base configuration files which may be a start but you would still have to reconstruct your settings yourself. If you know you have backups of your /etc/bacula folder you should be able to use the bls and bextract programs to get your files back. http://www.bacula.org/5.1.x-manuals/en/utility/utility/index.html John -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula/etc folder contents gone - any way to fix?
Just tried and I'm getting this: # ./bextract /export/bacula-saves/clients/ /export/morebacula/ bextract: butil.c:277 Could not find device /export/bacula-saves/clients in config file bacula-sd.conf. 29-Sep 11:46 bextract JobId 0: Fatal error: butil.c:167 Cannot find device /export/bacula-saves/clients in config file bacula-sd.conf. /export/bacula-saves/clients/ contains about 50 different volumes and /export/morebacula/ is just an empty directory where everything can be restored to...am I doing this wrong? On Thu, Sep 29, 2011 at 11:30 AM, John Drescher dresche...@gmail.comwrote: 2011/9/29 R. Leigh Hennig rlh1...@gmail.com: So, the contents of my ../bacula/etc/ folder are gone. Same place where bacula-dir.conf, bacula-sd.conf, etc, is stored. Nothing else has been lost. Volumes (including backups of the bacula server) are still in place, all other folders in ../bacula (such as lib, sbin, scripts, working, etc) are present. Besides not having the bacula-dir.conf, bacula-sd.conf, and bacula-fd.conf files, is there any way to restore the contents of this folder so I can still work with what I had? Or am I totally screwed here? Is it possible to reinstall bacula from source just to repair the contents of the ../bacula/etc folder? Please help! Reinstalling will put back the base configuration files which may be a start but you would still have to reconstruct your settings yourself. If you know you have backups of your /etc/bacula folder you should be able to use the bls and bextract programs to get your files back. http://www.bacula.org/5.1.x-manuals/en/utility/utility/index.html John -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fwd: disk backup
-- Forwarded message -- From: John Drescher dresche...@gmail.com Date: Thu, Sep 29, 2011 at 12:09 PM Subject: Re: [Bacula-users] disk backup To: Ignacio Cardona ignaciocard...@gmail.com On Thu, Sep 29, 2011 at 11:43 AM, Ignacio Cardona ignaciocard...@gmail.com wrote: John , has to be something like this? Pool { Name = Turnos Pool Type = Backup Recycle = yes # Bacula can automatical006Cy recycle Volumes AutoPrune = yes # Prune expired volumes Volume Retention = 365 days # one year Maximum Volume Bytes = 10G # Limit Volume size to something reasonable LabelFormat = TurnosN Maximum Volumes = 100 # Limit number of Volumes in Pool Maximum Volume Size = 4G } is that correct? Thanks a lot! I am sorry. I said Maximum Volume Size instead of Maximum Volume Bytes. http://bacula.org/5.0.x-manuals/en/main/main/Configuring_Director.html#SECTION001815 It should be Pool { Name = Turnos Pool Type = Backup Recycle = yes # Bacula can automatical006Cy recycle Volumes AutoPrune = yes # Prune expired volumes Volume Retention = 365 days # one year Maximum Volume Bytes = 4G # Limit Volume size to something reasonable LabelFormat = TurnosN Maximum Volumes = 100 # Limit number of Volumes in Pool } However remember that the pool resource is only used when creating new volumes. So if you already have volumes created they will not get the new size limit when they recycle. To fix this open up bconsole and update pool from resource and then update all volumes in pool. An example of this is here: http://old.nabble.com/Re%3A-How-does-a-change-to-Volume-Use-Duration-take-effect--p15765197.html John -- John M. Drescher -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Performance with latent networks
sounds like your sysctl.conf needs tweaking? have you tried something like this on both sides? kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 68719476736 kernel.shmall = 4294967296 # long fat pipes net.core.wmem_max = 8388608 net.core.rmem_max = 8388608 Yes, I tried to tweak kernel first with no effect. BTW wouldn't badly tuned network stack affect other programs such as iperf and ssh? +-- |This was sent by rea...@lmn.name via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] SD does not create a volume file
On 29.09.2011 08:48, Silver Salonen wrote: Hi. I use Bacula DIR 5.0.3 on FreeBSD and Bacula SD 5.0.3 on Debian. I use file-based volumes, one job per volume. The SD just got migrated from the same FreeBSD to Debian a while ago and Debian SD has different MediaType directive in Device resource, so every time the backup runs, it starts prompting for an appendable volume. That's OK, because I've got a cron job in place that just deletes the oldest volume from the pool. The problem is that now should SD create a new volume file and use it, but it does not. SD gives this error: Warning: mount.c:221 Open device device-consus (/mnt/backup/bacula) Volume catalog-full-5458 failed: ERR=dev.c:549 Could not open: /mnt/backup/bacula/catalog-full-5458, ERR=No such file or directory I've checked that the directory and file permissions are all OK. Once I touch the file with correct owner and mount the storage in bconsole, the job starts running. Any idea why can't SD create the volume file? Hmm.. it seems that the problem still was that not enough volumes got deleted from the pool and pool was still full. The weird thing is that the error above came from SD, not from DIR which could saying that the pool is full or smth. -- Silver -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users