Re: [Bacula-users] Need help fixing configuration files.
Am 08.03.2011 um 21:59 schrieb Kenney, William P. (Information Technology Services): Several things. RH will update these via FasTrack Updates (stated in bugzilla entries). Some links (/usr/sbin/dbcheck, /usr/sbin/bscan) are wrong and the original 5.0.0 version has a wrong permissions argument in make_catalog_backup.pl. Try to set the symbolic links correctly e.g. /usr/sbin/bscan - /usr/ sbin/bscan.mysql and check line 92 in make_catalog_backup.pl ... Thanks Paulo, Does this mean that everything pointing to /etc/alternatives/filenames should be pointing to /usr/sbin/filenames.mysql ? Normally the link chain should look like ls -la /usr/sbin/dbcheck lrwxrwxrwx 1 root root 32 26. Nov 20:31 /usr/sbin/dbcheck - /etc/ alternatives/bacula-dbcheck ls -la /etc/alternatives/bacula-dbcheck lrwxrwxrwx 1 root root 23 26. Nov 20:31 /etc/alternatives/bacula- dbcheck - /usr/sbin/dbcheck.mysql ls -la /usr/sbin/bscan lrwxrwxrwx 1 root root 30 26. Nov 20:31 /usr/sbin/bscan - /etc/ alternatives/bacula-bscan ls -la /etc/alternatives/bacula-bscan lrwxrwxrwx 1 root root 21 26. Nov 20:31 /etc/alternatives/bacula- bscan - /usr/sbin/bscan.mysql Because die alternatives-links are organized in parent/child groups, it is better to leave the wrong alternatives-links alone (don't use the alternative command to alter) Instead change the wrong links directly / add the correct links directly /usr/sbin/dbcheck - /usr/sbin/dbcheck.mysql /usr/sbin/bscan - /usr/sbin/bscan.mysql During the install process I used the individual *.mysql files to insure I didn't pick up any postgresql scripts/links. Please keep replies on the list. Cheers PM -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Installing SD only
Hi, Is it possible to install storage daemon only from sources and in this case is the MySQL is needed? I've got director and catalog on different machine without connection to tabe library, and want to install SD on another host. -- Pozdrawiam, *Bartłomiej Syryjczyk* Sekcja TWD Zakład Analiz Statystycznych tel. +48 660675043 -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Installing SD only
On 03/09/2011 02:28 PM, Bartłomiej Syryjczyk wrote: Hi, Is it possible to install storage daemon only from sources and in this case is the MySQL is needed? I've got director and catalog on different machine without connection to tabe library, and want to install SD on another host. Yes, if you lounch ./configure --help you can see that using --disable-build-dird --without-mysql you should compile only the storage deamon. Anyway, I'have not try this on my installations. Simone PS: Sorry, I've replied only to Bartłomiej Syryjczyk -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula bandwith usage
Le Tuesday 08 March 2011 14:58:18 John Drescher, vous avez écrit : On Tue, Mar 8, 2011 at 8:24 AM, Laurent HENRY laurent.he...@ehess.fr wrote: Le Wednesday 02 March 2011 20:50:18 Mark, vous avez écrit : btw, i actually experience it with disk backups. Does this mean software compression limits deeply backup speed ? In my case, software compression was a _massive_ slowdown, to the point that my preference was to throw more disk space to bacula to keep my jobs completing in a reasonable time. This was backing up a server with a couple hundred gigs of large files, not tons of small files. Try your job without compression enabled at least once, to get yourself a good comparison. Mark Turning compression off on disk backup definitely improve the performance. I was at 17MB/s and now i am at 30 MB/s. On my network graphs i still see i don't often go beyond the 100Mb/s i don't find any explanation on the network side. Do you have attribute spooling enabled? If not enable that. John I tried to enable spooling (500 Gb spool) for the tape backup. The perf were worse. For disk backup, it seems to me spooling does not make sense. -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula bandwith usage
I tried to enable spooling (500 Gb spool) for the tape backup. The perf were worse. BTW, I use 5GB spool. I assume then you do not run concurrent jobs? For a single job the time will be longer because bacula does not concurrently spool and despool but with concurrent jobs and spooling with a few GB spool size bacula will maximize the performance of the tape drive when spooling is enabled. I get despool rates of 20 to 50MB/s for LTO2 which is about what the tape drive can handle. The rates vary because of compression. For disk backup, it seems to me spooling does not make sense. Attribute spooling makes sense for either though. -- John M. Drescher -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Installing SD only
On 03/09/11 09:55, Simone Martina wrote: On 03/09/2011 02:28 PM, Bartłomiej Syryjczyk wrote: Hi, Is it possible to install storage daemon only from sources and in this case is the MySQL is needed? I've got director and catalog on different machine without connection to tabe library, and want to install SD on another host. Yes, if you lounch ./configure --help you can see that using --disable-build-dird --without-mysql you should compile only the storage deamon. Anyway, I'have not try this on my installations. Actually, this is not correct. You still need to specify the correct catalog DB engine when building only the storage daemon, because the storage daemon includes the storage daemon tools - btape, bscan etc - and some of those tools (bscan in particular) need to be able to access the catalog database directly without going through the Director. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Should I use data spooling when writing to nfs mounted storage?
Il 03/03/2011 18:05, Phil Stracchino ha scritto: On 03/03/11 09:52, Fabio Napoleoni - ZENIT wrote: Il giorno 03/mar/2011, alle ore 04.52, Fabio Napoleoni - ZENIT ha scritto: I have my director using an external raid device which exports its filesystem with nfs protocol as storage. I just ended my bacula configuration and just launched my first remote job. I have this in the report JobId 3: Job write elapsed time = 00:14:23, Transfer rate = 1.182 M Bytes/second which seems a little poor to me (our network is currently on a 100M switch, we're planning to upgrade with something better in the near future). Currently data flows from bacula-fd on client to bacula-sd on bacula server and then the storage daemon writes data on a volume mounted in an nfs partition, so data goes on the wire at the same time. Is advisable to enable data spooling in the storage daemon in this situation? I made a try with this results JobId 7: Spooling data ... JobId 7: Job write elapsed time = 00:13:07, Transfer rate = 1.295 M Bytes/second JobId 7: Committing spooled data to Volume FullVolume-0004. Despooling 1,021,072,888 bytes ... JobId 7: Despooling elapsed time = 00:02:19, Transfer rate = 7.345 M Bytes/second JobId 7: Sending spooled attrs to the Director. Despooling 6,816,214 bytes ... There is only a little improvement of performances. So I'm asking you what is the transfer rate in your jobs? These rates are normal or are they slow compared to yours? Is there any way you can run your SD directly on the storage device, instead of the SD writing to storage mounted over NFS? Also, what about using a dedicated NIC to link SD with NFS storage ? That would avoid sharing bandwidth between nfs-traffic and client to storage daemon traffic. Just my 2 cents. -- Marcello Romani -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula restore to Windows 2008 R2
Greetings.. I had occasion today to do a restore to a Windows 2008 R2 server with Bacula.. everything went fine, except for some minor confusion because the restored c:/restore/c folder was created with the hidden and system attributes.. Obviously I normally have my explorer shell set so I can see hidden and system files, but on this particular box I didn't and it ended up stumping me for a few minutes.. So I guess my question is whether there is a good reason that the c folder ends up restored with hidden system attributes, and whether there is anything I can do about that? If not I'll just document it as part of our restore procedures, but I wanted to make sure there isn't a setting somewhere that I'm missing that would make peoples lives easier.. Thanks! Joe -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] authorization again
On Fri, 04 Mar 2011, ewan.br...@stfc.ac.uk might have said: The Windows file daemon doesn't use the C:\$WORKSTATION-fd.conf file. That's just put there as a convenience at install time. You should really be comparing the server password with the one in the Bacula program directory (e.g. C:\program files\bacula\bacula-fd.conf). EMB Ewan, There are two things I did wrong. I couldn't find my saved copy of winbacula so I downloaded a copy from the net. I need to use the same vesion as my bacula server. The second is looking at the properties for the service and seeing where the bacula-fd.conf file is read from. My setup has that file in the directory C:\Program Files\Bacula directory and not in C:\Documents and Settings\All Users\Application Data\Bacula. Making those two changes work.ed Thanks. Mike -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] file listing?
Afternoon, I just noticed one of my clients had a huge incremental (level 2) backup. I want to see what file caused the huge increase. I tried 'list files jobid=20097' and though I'm shown the files, I'm not shown the size of each file. Is there a command or query that shows me the size of the file? Mike -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] file listing?
Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be stored in the database. I don't think any size is mentioned until you get to the job level. James On 2011-03-09, at 12:51 PM, Mike Eggleston wrote: Afternoon, I just noticed one of my clients had a huge incremental (level 2) backup. I want to see what file caused the huge increase. I tried 'list files jobid=20097' and though I'm shown the files, I'm not shown the size of each file. Is there a command or query that shows me the size of the file? Mike -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] file listing?
2011/3/9 James Woodward james.woodw...@ualberta.ca: Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be stored in the database. I don't think any size is mentioned until you get to the job level. James I think its in the LStat. John -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] file listing?
On Wed, 09 Mar 2011, John Drescher might have said: 2011/3/9 James Woodward james.woodw...@ualberta.ca: Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be stored in the database. I don't think any size is mentioned until you get to the job level. James I think its in the LStat. John In my old version (v2.0.3) I don't see an 'lstat' command. Mike -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] file listing?
On Wed, Mar 9, 2011 at 4:52 PM, Mike Eggleston mikee...@mac.com wrote: On Wed, 09 Mar 2011, John Drescher might have said: 2011/3/9 James Woodward james.woodw...@ualberta.ca: Hello Mike, I'd have to say no based on the tables defined here http://bacula.org/5.0.x-manuals/en/developers/developers/Database_Tables.html. The file size does not appear to be stored in the database. I don't think any size is mentioned until you get to the job level. James I think its in the LStat. John In my old version (v2.0.3) I don't see an 'lstat' command. I meant that I believe the file size and attributes are in the database in the lstat column of the File table. I am not sure there is an easy way to list this. LStat tinyblobFile attributes in base64 encoding John -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] file listing?
Hi, Here you have SQL function for PostgreSQL (I took it from bweb): CREATE PROCEDURAL LANGUAGE plpgsql; BEGIN; CREATE OR REPLACE FUNCTION base64_decode_lstat(int4, varchar) RETURNS int8 AS $$ DECLARE val int8; b64 varchar(64); size varchar(64); i int; BEGIN size := split_part($2, ' ', $1); b64 := 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/'; val := 0; FOR i IN 1..length(size) LOOP val := val + (strpos(b64, substr(size, i, 1))-1) * (64^(length(size)-i)); END LOOP; RETURN val; END; $$ language 'plpgsql'; COMMIT; and this is a query which lists file path, filename and size in Bytes (in this example for jobid=8): SELECT Path.Path, Filename.Name, base64_decode_lstat(8,File.LStat) AS size FROM Filename, File, Path WHERE File.JobId=8 AND File.PathId=Path.PathId AND Filename.FilenameId=File.FilenameId ORDER BY size ASC; I tested it. It works. Regards gani 2011/3/9 Mike Eggleston mikee...@mac.com: Afternoon, I just noticed one of my clients had a huge incremental (level 2) backup. I want to see what file caused the huge increase. I tried 'list files jobid=20097' and though I'm shown the files, I'm not shown the size of each file. Is there a command or query that shows me the size of the file? Mike -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula bandwith usage
On 3/1/2011 8:40 AM, Laurent HENRY wrote: Is anyone know if there is a way to improve performances of network usage ? Bacula - Turn off software compression. Switch and Network Cards - If you are fully gigabit and your equipment supports it, turn on jumbo frames. -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users