Re: [Bacula-users] Tape mount problem with autochanger
I have a quite fresh install of Bacula 2.03 on CentOS5 (~RHEL5) Tape drive is Exabyte VXA-320 w/ 10-slot autochanger. Now, when there is a need for the autochanger to jump to another tape (because of eg. expired volume duration, that was set to only 15 mins for this debugging) Bacula properly calls mtx-changer script, unloads and loads the tapes, but the new tape won't get mounted. Manual mount command solves this, but the need to execute it effectively eliminates the benefits of an autochanger anyway... Any idea what causes this behaviour, and how to fix it? Autochanger { Name = Exabyte Autoloader Device = VXA320 Changer Command = /etc/bacula/mtx-changer %c %o %S %a %d Changer Device = /dev/sg2 } Try adding AutomaticMount = yes to the changer section. Results in: Config error: Keyword AutomaticMount not permitted in this resource. So it obviously needs to be only in the Device resource. Btw, is this line documented somewhere, saying what it really does, where it should be used, if there is some default value, etc? Using Acrobat Readers's find- command, I only found config file examples in the Bacula 2.0.3 manual, but no explanation at all. Also check line 167ff in the mtx-changer script and increase the sleep time if necessary. Now I increased this by a factor of 4. Should be enough, I guess. I'm getting an idea that maybe the problem had something to do with a forced system shutdown that took place earlier the same day due to exceptionally long power outage (The Power Company had messed with a 110 kV line, it hadn't been unpowered yet as they thought before grounding it for some maintenance work...) Anyway, it looks to me like Bacula had gotten a little bit confused with something after the next power-up. I'll try to debug that further some day, the problem with this is that the only autochanger I have is in a file server that can't be shut down whenever I'd like to test something... -- TiN - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] can't load library: libmysqlclient_r.so.15
On 2007.08.10. 01:29, Jarrod Lewis-Peacock wrote: ... /etc/bacula/bin/bacula-dir: error while loading shared libraries: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory how did you install bacula (that is, did you compile it yourself or from packages) ? do you have a file named libmysqlclient_r.so.15 anywhere at all ? I searched the archives manual to find the solution of setting the LD_LIBRARY_PATH to the appropriate mysql library, and also hard coding this in /etc/ld.so.conf. LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib/ export LD_LIBRARY_PATH I did this and still get the linking problem. I verified that /usr/local/mysql/lib/ is accessible which it is, and it has the file libmysqlclient_r.a in there, which I assume is what is needed for libmysqlclient_r.so.15. Any further suggestions? Thanks, Jarrod -- Rich - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] I/O error
Hi, I've installed Bacula on Solaris 10 machine and have been using it with an Exabyte VXA tape library. I get this error and then Bacula continues with the next tape. I can still use the tapes for restore (tried it) but why is this going wrong? I tried the btape test and it ran without any errors. 01-Jul 01:26 chet-dir: Start Backup JobId 715, Job=Mail_Job. 2007-07-01_00.05.01 01-Jul 01:31 chet-sd: Mail_Job.2007-07-01_00.05.01 Error: block.c:569 Write error at 194:12946 on device Exabyte VXA-2 Drive (/dev/rmt/ 0cbn). ERR=I/O error. 01-Jul 01:32 chet-sd: Mail_Job.2007-07-01_00.05.01 Error: Error writing final EOF to tape. This Volume may not be readable. dev.c:1687 ioctl MTWEOF error on Exabyte VXA-2 Drive (/dev/rmt/ 0cbn). ERR=I/O error. 01-Jul 01:32 chet-sd: End of medium on Volume A005 Bytes=77,950,752,768 Blocks=1,208,313 at 01-Jul-2007 01:32. Thanks, Martijn - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] thanks!
Hello, I'm copying this to the lists, because they will probably be interested in this. On Monday 13 August 2007 03:50, Bachman Kharazmi wrote: Hi Kern First I would like to thank you for good software! I've been a bacula user for a few days, and I'm really impressed so far. It's very well documented (like obsd where I come from). Thanks. :-) I've been playing around with 1.38.10 which is the version coming with debian :/ With debian running(director) 1.38 I had poor transfer rates backing up a XPhost, something like Bytes/s=250 and now when I compiled 2.2.0 from source I've Bytes/sec=2,797,999 ;) I donno why, but it's quite a good improvement. Yes, there are a very good number of performance enhancements in 2.2.0 compared to prior versions. I cannot say exactly why you have such a big difference, but I'm very pleased that it is in the right direction, though I admit such a big change is a bit surprising. If you are using SQLite3, you will have at least a 30 times speedup on 2.2.0 compared to other versions, with a small additional risk of database corruption if your disk fills or your OS crashes. PostgreSQL (and probably MySQL) should have at least a factor of 10 improvement for Full backups. For Win32 systems, one of the big problems has been Ethernet cards/OS that do not gracefully handle comm buffer sizes greater than 32K. I cannot exactly remember, but I think I reduced the default on Win32 to 32K, while on Unix, it is typically 64K. Anyhow, I sent a message to the bacula-user ML admin below, about that I couldn't register with my gmail account, but I haven't heard anything from him. Do you know if he's on vacation or something? Well, it is possible that he is on vacation as most of Europe shuts down in August :-). In any case, I regret there is nothing he can do for you. Source Forge does not accept complaints about individual problems from us -- they require the person concerned to file a support request. I suggest before filing a support request you look at the email documentation on their site -- they have a lot of anti-spam requirements, but their documentation is quite complete. Best regards, Kern have a nice day! /Bachman Ursprungligt meddelande Ämne: bacula-users Datum:Sat, 11 Aug 2007 02:35:14 +0200 Från: Bachman Kharazmi [EMAIL PROTECTED] Till: [EMAIL PROTECTED] Why don't I get any confirmation email when I try to subscribe to bacula-users ML? Please check if you can help me with this. /Bachman - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Tapes are not rewinded
Hi, I'm trying to setup a backup server and face the following problem. I already setup a Bacula system using a Exabyte VXA tape library. This system is using a Seagate LTO library and I get this error when using the tapes (only a small amount of data is written on the tape). The tapes are before with another system (a windows backup system) and I cleaned them all using the following script: ### begin cleanalltapes ### #!/usr/bin/bash ### Where are the binaries MTXCHANGER=/opt/csw/etc/bacula/mtx-changer MTX=/opt/csw/sbin/mtx MT=/usr/bin/mt CHANGER=/dev/scsi/changer/c3t5d0 DRIVE=/dev/rmt/0 SVCADM=/usr/sbin/svcadm SVCNAME=cswbacula TIME=time -p ### The script echo Disabling Bacula $SVCADM disable $SVCNAME echo Unloading current tape $TIME $MTX -f $CHANGER unload for i in 1 2 3 4 5 6 7 8 do echo Loading tape $i $TIME $MTXCHANGER $CHANGER load $i $DRIVE 0 echo Retension the tape $TIME $MT -f $DRIVE retension echo Writing 2 eof marks to remove the label $TIME $MT -f $DRIVE weof 2 echo Rewinding the tape $TIME $MT -f $DRIVE rewind echo Unloading tape $i $TIME $MTXCHANGER $CHANGER unload $i $DRIVE 0 done echo Enabling Bacula $SVCADM enable $SVCNAME ### end cleanalltapes ### I replaced the first rewind with a retension command but that doesn't help. loading the tape takes about 56.16 seconds retension takes about 289.94 seconds writing 2 eof takes about 7.19 seconds rewinding takes about 0.02 seconds unloading the tape takes about 36.72 seconds I don't get any errors with this script. this is the error when running a backup: 12-Aug 16:37 popa-dir: No prior Full backup Job record found. 12-Aug 16:37 popa-dir: No prior or suitable Full backup found in catalog. Doing FULL backup. 12-Aug 16:37 popa-dir: Start Backup JobId 42, Job=YoungGuns_Linux. 2007-08-12_16.37.47 12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: block.c:569 Write error at 1:15157 on device Certance LTO Drive (/ dev/rmt/0cbn). ERR=I/O error. 12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: Error writing final EOF to tape. This Volume may not be readable. dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 0cbn). ERR=I/O error. 12-Aug 16:45 popa-sd: End of medium on Volume TAPE0017 Bytes=977,937,408 Blocks=15,158 at 12-Aug-2007 16:45. 12-Aug 16:46 popa-sd: 3307 Issuing autochanger unload slot 1, drive 0 command. 12-Aug 16:47 popa-sd: 3304 Issuing autochanger load slot 2, drive 0 command. 12-Aug 16:48 popa-sd: 3305 Autochanger load slot 2, drive 0, status is OK. 12-Aug 16:48 popa-sd: 3301 Issuing autochanger loaded? drive 0 command. 12-Aug 16:48 popa-sd: 3302 Autochanger loaded? drive 0, result is Slot 2. 12-Aug 16:48 popa-sd: Labeled new Volume TAPE0018 on device Certance LTO Drive (/dev/rmt/0cbn). 12-Aug 16:49 popa-sd: Wrote label to prelabeled Volume TAPE0018 on device Certance LTO Drive (/dev/rmt/0cbn) 12-Aug 16:49 popa-sd: New volume TAPE0018 mounted on device Certance LTO Drive (/dev/rmt/0cbn) at 12-Aug-2007 16:49. 12-Aug 17:06 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: block.c:569 Write error at 0:9205 on device Certance LTO Drive (/ dev/rmt/0cbn). ERR=I/O error. 12-Aug 17:06 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: Error writing final EOF to tape. This Volume may not be readable. dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 0cbn). ERR=I/O error. 12-Aug 17:06 popa-sd: End of medium on Volume TAPE0018 Bytes=593,832,960 Blocks=9,204 at 12-Aug-2007 17:06. 12-Aug 17:08 popa-sd: 3307 Issuing autochanger unload slot 2, drive 0 command. 12-Aug 17:08 popa-sd: 3304 Issuing autochanger load slot 3, drive 0 command. 12-Aug 17:09 popa-sd: 3305 Autochanger load slot 3, drive 0, status is OK. 12-Aug 17:09 popa-sd: 3301 Issuing autochanger loaded? drive 0 command. 12-Aug 17:09 popa-sd: 3302 Autochanger loaded? drive 0, result is Slot 3. 12-Aug 17:10 popa-sd: Labeled new Volume TAPE0019 on device Certance LTO Drive (/dev/rmt/0cbn). 12-Aug 17:10 popa-sd: Wrote label to prelabeled Volume TAPE0019 on device Certance LTO Drive (/dev/rmt/0cbn) 12-Aug 17:10 popa-sd: New volume TAPE0019 mounted on device Certance LTO Drive (/dev/rmt/0cbn) at 12-Aug-2007 17:10. 12-Aug 17:11 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: block.c:569 Write error at 0:2760 on device Certance LTO Drive (/ dev/rmt/0cbn). ERR=I/O error. 12-Aug 17:11 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: Error writing final EOF to tape. This Volume may not be readable. dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 0cbn). ERR=I/O error. 12-Aug 17:11 popa-sd: End of medium on Volume TAPE0019 Bytes=178,053,120 Blocks=2,759 at 12-Aug-2007 17:11. 12-Aug 17:11 popa-sd: 3307 Issuing autochanger unload slot 3, drive 0 command. - This SF.net email is
[Bacula-users] SQL Query
Had a failure occur that prevented the usual running of Full backups. Looking for a 'how to' query to find the most recent Full backup of all clients to see how far off we are into Incrementals / Diffs from an actual Full. Any SQL gurus on the list that can help? Erich - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] can't load library: libmysqlclient_r.so.15
On 8/10/07, Jarrod Lewis-Peacock [EMAIL PROTECTED] wrote: Hello, I'm re-installing Bacula using MySQL instead of SQLite. I'm having problems linking with a mysql shared library. ./bacula start Starting the Bacula Storage daemon Starting the Bacula File daemon Starting the Bacula Director daemon /etc/bacula/bin/bacula-dir: error while loading shared libraries: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory Hi, have you tried to check with 'ldd /etc/bacula/bin/bacula-dir' whether the binary has a problem finding that library? In my (Debian) installation that library is actually in /usr/lib/. What if at least as a test you try to manually copy it there? -- Maxx - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Tapes are not rewinded
On 8/13/07, Martijn de Munnik [EMAIL PROTECTED] wrote: Hi, I'm trying to setup a backup server and face the following problem. I already setup a Bacula system using a Exabyte VXA tape library. This system is using a Seagate LTO library and I get this error when using the tapes (only a small amount of data is written on the tape). The tapes are before with another system (a windows backup system) and I cleaned them all using the following script: ### begin cleanalltapes ### #!/usr/bin/bash ### Where are the binaries MTXCHANGER=/opt/csw/etc/bacula/mtx-changer MTX=/opt/csw/sbin/mtx MT=/usr/bin/mt CHANGER=/dev/scsi/changer/c3t5d0 DRIVE=/dev/rmt/0 SVCADM=/usr/sbin/svcadm SVCNAME=cswbacula TIME=time -p ### The script echo Disabling Bacula $SVCADM disable $SVCNAME echo Unloading current tape $TIME $MTX -f $CHANGER unload for i in 1 2 3 4 5 6 7 8 do echo Loading tape $i $TIME $MTXCHANGER $CHANGER load $i $DRIVE 0 echo Retension the tape $TIME $MT -f $DRIVE retension echo Writing 2 eof marks to remove the label $TIME $MT -f $DRIVE weof 2 echo Rewinding the tape $TIME $MT -f $DRIVE rewind echo Unloading tape $i $TIME $MTXCHANGER $CHANGER unload $i $DRIVE 0 done echo Enabling Bacula $SVCADM enable $SVCNAME ### end cleanalltapes ### I replaced the first rewind with a retension command but that doesn't help. loading the tape takes about 56.16 seconds retension takes about 289.94 seconds writing 2 eof takes about 7.19 seconds rewinding takes about 0.02 seconds unloading the tape takes about 36.72 seconds I don't get any errors with this script. I am very confused at what exactly you are trying to do. I know for a fact that you do not have to rewind LTO media because this media has one spool on the drive and a second on the tape so for the drive to physically unload the tape the drive performs a rewind. this is the error when running a backup: 12-Aug 16:37 popa-dir: No prior Full backup Job record found. 12-Aug 16:37 popa-dir: No prior or suitable Full backup found in catalog. Doing FULL backup. 12-Aug 16:37 popa-dir: Start Backup JobId 42, Job=YoungGuns_Linux. 2007-08-12_16.37.47 12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: block.c:569 Write error at 1:15157 on device Certance LTO Drive (/ dev/rmt/0cbn). ERR=I/O error. 12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: Error writing final EOF to tape. This Volume may not be readable. dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 0cbn). ERR=I/O error. 12-Aug 16:45 popa-sd: End of medium on Volume TAPE0017 Bytes=977,937,408 Blocks=15,158 at 12-Aug-2007 16:45. snip Have you tested the backup by restoring the data somewhere else or run a Verify job with job level set at VolumeToCatalog? These errors may not actually be errors. For me just as labeling a brand new tape always produces a read error as os gives an error when you try to read past the end of the written media and since the tape is blank you can not read anything. John John - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Problems building BAT
Hi there, i got some problems while building BAT from source. During make i encounter the following errors: [...] Makefile:1340: Warnung: Die Befehle für das Ziel »moc/moc_help.cpp« werden überschrieben Makefile:1268: Warnung: Alte Befehle für das Ziel »moc/moc_help.cpp« werden ignoriert /usr/share/qt3/bin/uic run/estimate.ui -o ui/estimate.h uic: File generated with too recent version of Qt Designer (4.0 vs. 3.3.7) make[1]: *** [ui/estimate.h] Fehler 1 make[1]: Leaving directory `/usr/src/bacula-2.2.0/src/qt-console' I use a Debian Etch i386 and tried both with the Debian qt4/qwt Packages and the depkgs-qt-30Jul07.tar.gz from sourceforge. -- Florian Schürfeld [EMAIL PROTECTED] nunet AG - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] configuration weirdness
first, generic problem - --enable-client-only parameter for configure. as far as i understand, this switch is supposed to disable building of director sd. it's pretty unintuitive, as it would have been much better if all three components had individual switches with identical behaviour (each switch would enable that particular component). second - bacula 2.2.0. running configure with --enable-client-only shows at the end of the configuration : client-only:yes build-dird: yes build-stored: yes it seems that either the parameter is incorrectly named or not working ? -- Rich - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problems building BAT
* Florian Schürfeld schrieb am 13.08.07 um 15:29 Uhr: Hi there, i got some problems while building BAT from source. During make i encounter the following errors: [...] Makefile:1340: Warnung: Die Befehle für das Ziel »moc/moc_help.cpp« werden überschrieben Makefile:1268: Warnung: Alte Befehle für das Ziel »moc/moc_help.cpp« werden ignoriert /usr/share/qt3/bin/uic run/estimate.ui -o ui/estimate.h uic: File generated with too recent version of Qt Designer (4.0 vs. 3.3.7) make[1]: *** [ui/estimate.h] Fehler 1 make[1]: Leaving directory `/usr/src/bacula-2.2.0/src/qt-console' I use a Debian Etch i386 and tried both with the Debian qt4/qwt Packages and the depkgs-qt-30Jul07.tar.gz from sourceforge. Hi Florian, it is very likely that your system uses the wrong (== old 3.x) versions of qmake and friends. See update-alternatives to make it use the qt4 versions. -Marc -- begin LOVE-LETTER-FOR-YOU.txt.vbs I am a signature virus. Distribute me until the bitter end - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] SQL Query
On Mon, 13 Aug 2007, Erich Prinz wrote: Had a failure occur that prevented the usual running of Full backups. Looking for a 'how to' query to find the most recent Full backup of all clients to see how far off we are into Incrementals / Diffs from an actual Full. Any SQL gurus on the list that can help? I don't have exactly what you're after (A bit of guru attention would solve that) but these should do as a starting point... Just append them to /etc/bacula/query.sql If you want to only see sucessful backups, uncomment the # AND JobStatus = 'T' lines - I commented those out in order to see how much tape was being eaten by failure. #20 :List Volumes by Jobs: SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes FROM Job,JobMedia,Media WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime ORDER by JobName, Start; # 21 :List Volumes for a jobname: *Enter Job name: SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes FROM Job,JobMedia,Media WHERE Job.Name='%1' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime ORDER by JobName, Start; #22 :List all Full backups SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId AND Level='F' #AND JobStatus = 'T' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.Name,Job.StartTime #23 :List all Full + Differential backups SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' AND ( Level='F' or Level=D ) AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.Name,Job.StartTime #24 :List all Full backups for a particular Job *Enter JobName: SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' AND Level='F' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Job.Name='%1' ORDER BY Job.Name,Job.StartTime #25 :List all Full + Differential backups for a particular Job *Enter JobName: SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' AND ( Level='F' or Level=D ) AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Job.Name='%1' ORDER BY Job.Name,Job.StartTime #26 :List all backups for a particular Job *Enter JobName: SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' # AND ( Level='F' or Level=D ) AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Job.Name='%1' ORDER BY Job.Name,Job.StartTime - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] i need help in performing partial backups of /usr/home
It looks like your whole directory is being copied because of the File = /mnt/san/usr/home/ Try removing this Cheers, Kris Jordi Moles wrote: hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- View this message in context: http://www.nabble.com/i-need-help-in-performing-partial-backups-of--usr-home-tf4262132.html#a12129242 Sent from the Bacula - Users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] i need help in performing partial backups of /usr/home
hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] i need help in performing partial backups of /usr/home
Hi, what you told me makes an empty backup, it doesn't backup anything at all, 0 files. However it doesn't say it failed, it doesn't send any error message. any other idea? thank you. En/na Monstad ha escrit: It looks like your whole directory is being copied because of the File = /mnt/san/usr/home/ Try removing this Cheers, Kris Jordi Moles wrote: hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] i need help in performing partial backups of /usr/home
Hi there, Whenever I've used the wilddir option Ive had use an include = yes line in the Options section. I use an earlier version of bacula however, but it might work for you. ie: FileSet { Name = sanab Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* include = yes } } } Hope that works for you -Kris Jordi Moles wrote: Hi, what you told me makes an empty backup, it doesn't backup anything at all, 0 files. However it doesn't say it failed, it doesn't send any error message. any other idea? thank you. En/na Monstad ha escrit: It looks like your whole directory is being copied because of the File = /mnt/san/usr/home/ Try removing this Cheers, Kris Jordi Moles wrote: hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- View this message in context: http://www.nabble.com/i-need-help-in-performing-partial-backups-of--usr-home-tf4262132.html#a12129583 Sent from the Bacula - Users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] i need help in performing partial backups of /usr/home
hi again and thanks for you help. i doesn't work either. i tried include=yes and other things like exclude = no. actually, with include=yes, bacula throws the following message: Config error: Keyword include not permitted in this resource En/na Monstad ha escrit: Hi there, Whenever I've used the wilddir option Ive had use an include = yes line in the Options section. I use an earlier version of bacula however, but it might work for you. ie: FileSet { Name = sanab Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* include = yes } } } Hope that works for you -Kris Jordi Moles wrote: Hi, what you told me makes an empty backup, it doesn't backup anything at all, 0 files. However it doesn't say it failed, it doesn't send any error message. any other idea? thank you. En/na Monstad ha escrit: It looks like your whole directory is being copied because of the File = /mnt/san/usr/home/ Try removing this Cheers, Kris Jordi Moles wrote: hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] i need help in performing partial backups of /usr/home
Jordi Moles wrote: hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, try adding the following options-block in addition to your current one: Options { regexdir = .* exclude = yes } This should exclude every directory except the ones you have explicitly included in the first options-block. Hope that helps, Jan - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] finding qt for Bat on FreeBSD
I'm trying to build Bat on FreeBSD. What configure options did you use? I have: --enable-bat --with-qwt=/usr/lib I have qt4-4.3.0 installed. -- Dan Langille - http://www.langille.org/ Available for hire: http://www.freebsddiary.org/dan_langille.php - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] SQL Query
Wonderful. This is a good start. Thanks Alan. Erich On Aug 13, 2007, at 10:40 AM, Alan Brown wrote: On Mon, 13 Aug 2007, Erich Prinz wrote: Had a failure occur that prevented the usual running of Full backups. Looking for a 'how to' query to find the most recent Full backup of all clients to see how far off we are into Incrementals / Diffs from an actual Full. Any SQL gurus on the list that can help? I don't have exactly what you're after (A bit of guru attention would solve that) but these should do as a starting point... Just append them to /etc/bacula/query.sql If you want to only see sucessful backups, uncomment the # AND JobStatus = 'T' lines - I commented those out in order to see how much tape was being eaten by failure. #20 :List Volumes by Jobs: SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes FROM Job,JobMedia,Media WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime ORDER by JobName, Start; # 21 :List Volumes for a jobname: *Enter Job name: SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes FROM Job,JobMedia,Media WHERE Job.Name='%1' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime ORDER by JobName, Start; #22 :List all Full backups SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId AND Level='F' #AND JobStatus = 'T' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.Name,Job.StartTime #23 :List all Full + Differential backups SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' AND ( Level='F' or Level=D ) AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.Name,Job.StartTime #24 :List all Full backups for a particular Job *Enter JobName: SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' AND Level='F' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Job.Name='%1' ORDER BY Job.Name,Job.StartTime #25 :List all Full + Differential backups for a particular Job *Enter JobName: SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' AND ( Level='F' or Level=D ) AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Job.Name='%1' ORDER BY Job.Name,Job.StartTime #26 :List all backups for a particular Job *Enter JobName: SELECT DISTINCT Job.JobId,Job.Name,Job.Level AS L,Job.JobStatus as S, StartTime,JobBytes/1024/1024/1024 as Gb FROM Client,Job,JobMedia,Media WHERE Client.ClientId=Job.ClientId # AND JobStatus = 'T' # AND ( Level='F' or Level=D ) AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Job.Name='%1' ORDER BY Job.Name,Job.StartTime -- --- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] i need help in performing partial backups of /usr/home
On Mon, 13 Aug 2007 18:45:01 +0200, Jordi Moles said: hi again and thanks for you help. i doesn't work either. i tried include=yes and other things like exclude = no. actually, with include=yes, bacula throws the following message: Config error: Keyword include not permitted in this resource I suggest reading the Fileset Example section at http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION00149 in particular the /home/a* example. __Martin En/na Monstad ha escrit: Hi there, Whenever I've used the wilddir option Ive had use an include = yes line in the Options section. I use an earlier version of bacula however, but it might work for you. ie: FileSet { Name = sanab Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* include = yes } } } Hope that works for you -Kris Jordi Moles wrote: Hi, what you told me makes an empty backup, it doesn't backup anything at all, 0 files. However it doesn't say it failed, it doesn't send any error message. any other idea? thank you. En/na Monstad ha escrit: It looks like your whole directory is being copied because of the File = /mnt/san/usr/home/ Try removing this Cheers, Kris Jordi Moles wrote: hi, i would like to backup just something like /usr/home/a* reading bacula's documentation, i came up with this fileset: FileSet { Name = sanab Include { Options { wilddir = /mnt/san/usr/home/a* wilddir = /mnt/san/usr/home/b* } File = /mnt/san/usr/home/ } } this is exactly the example that they show you, except that i replaced /usr/home with /mnt/san/usr/home cause it's my situation. /mnt/san/usr/home is a mounted device through nfs. does that have any effect on the backup wilddir rules? well.. .that doens't work, it just makes a backup of the whole /mnt/san/usr/home. I'm using version 2.0.3 of bacula dir. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] finding qt for Bat on FreeBSD
On Mon, 13 Aug 2007 13:37:28 -0400, Dan Langille said: I'm trying to build Bat on FreeBSD. What configure options did you use? I have: --enable-bat --with-qwt=/usr/lib I have qt4-4.3.0 installed. Note: (equal qt qwt) = nil __Martin - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] configuration weirdness
On Mon, 13 Aug 2007 17:47:36 +0300, Rich said: first, generic problem - --enable-client-only parameter for configure. as far as i understand, this switch is supposed to disable building of director sd. it's pretty unintuitive, as it would have been much better if all three components had individual switches with identical behaviour (each switch would enable that particular component). I think it was written like that to match common usage, i.e. server backups require all components, subsequent client backups only the client components. Also, both the dird and stored components require a database, so it doesn't make much difference (to the prerequisites) whether both are built or only one is built. second - bacula 2.2.0. running configure with --enable-client-only shows at the end of the configuration : client-only:yes build-dird: yes build-stored: yes it seems that either the parameter is incorrectly named or not working ? It is working, but the configure output is wrong :-) __Martin - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to get SRPM
Hi all, I would like to try Bacula 2.2.0 however there are no RPMS on sourceforge yet and I prefer RPMs to direct installation. I do not mind compiling my own packages from tarball or SRPM but there is no SRPM anywhere and tarball contains only bacula.spec.in file. How can I convert this file into proper spec file so I can use: rpmbuild -tb bacula.2.2.0.tar.gz ? Or is there any other way how to create SRPM or RPM packages? Sorry if this is lame question :-) Radek - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Tapes are not rewinded
12-Aug 16:45 popa-sd: YoungGuns_Linux.2007-08-12_16.37.47 Error: Error writing final EOF to tape. This Volume may not be readable. dev.c:1688 ioctl MTWEOF error on Certance LTO Drive (/dev/rmt/ 0cbn). ERR=I/O error. 12-Aug 16:45 popa-sd: End of medium on Volume TAPE0017 Bytes=977,937,408 Blocks=15,158 at 12-Aug-2007 16:45. snip Bacula starts on the first tape with the backup but soon it needs the second tape and so on. The total size of the job is only about 60GB but al 8 tapes are needed and the job still is not completed. As you can see only about 1GB is written to the tape. Oh, sorry. I see that now. Then there is some serious problem with the tape handling. I see in another thread that you are running Solaris. Have you tried filling the tape with dd or tar to see if it errors under these as well? Have you run bscan? John - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] single error = tape useless
On Sun, 12 Aug 2007 15:57:54 +0200, Carsten Ralle said: Hi Martin, 1. Even with brand new tapes, on two different tape drives, using continuous cleaning cycles, the tapes that used to store between 11.5 and 13 GB uncompressed data on a windows machine only take about 8 GB using bacula (same drive, same tapes). Following the advice to switch off software compression when hardware compression is enabled, we run tests with following results (always the same fileset of 23 GB uncompressed data) hw-compress sw-compress spool size data/tape total # of tapes used on on 14 GB 8.2 GB 1.7 on off 23 GB 12.9 GB 1.8 so we use the installation with both sw and hw compression turned on, as it gives us better performance and less tapes/backup. Why is it impossible to store more then 8 GB on a 12/24GB tape. Again: we ran the tests on multiple different drives (HP15xx and Sony DDS3-drives). The problem is that DDS hw compression is not very good. In particular, when you use sw compression as well, the data written to tape actually gets expanded by the hw compression so your 8.2 GB of input gets written as 12 GB on the tape! Have you tried with hw compression off and sw compression on? Yes we've tried. On the Sony drives there's a tool that reports compression as disabled, but there where no changes in tape capacity, though. According to the manual the drive switches are set to control compression via software and if we turn off compression on a windows box, it's enabled after pluggin the unit back into the Linux box. So far we haven't noticed any difference with compression reported ON or OFF. Have you tried setting defcompression? I.e. mt -f /dev/... defcompression 0 mt -f /dev/... compression 0 Also, I suggest that you erase the tape after doing this, i.e. mt -f /dev/... rewind mt -f /dev/... weof to prevent the drive from picking up the old compression state from the tape. __Martin - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] finding qt for Bat on FreeBSD
On Monday 13 August 2007 21:06, Martin Simmons wrote: On Mon, 13 Aug 2007 13:37:28 -0400, Dan Langille said: I'm trying to build Bat on FreeBSD. What configure options did you use? I have: --enable-bat --with-qwt=/usr/lib I have qt4-4.3.0 installed. Note: (equal qt qwt) = nil Which translated Lispian to Computerese means that the qwt package is different from the qt libraries. You most likely do not have qwt loaded on your system. See the --with-qwt section of the Install chapter of the manual for more details (possibly the README of the src/qt-console file has something too). __Martin - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/bacula-devel - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Random tape capacity figures
Hi, I am running bacula 1.36.1 with Qualstar RLS-4445 autochanger and a single DDS tape drive installed. The tapes used are all Sony SDX3-100C (100GB native/260GB compressed capacity). I have noticed that VolBytes and VolFiles values vary widely for tapes marked as Full in media list command (see attached listing). E.g., volume with MediaId 146 have only 30MB VolBytes and 0 (sic!) VolFiles reported but still marked as Full, pretty strange. Another one listed as Full has about 600MB and also 0 files. Someone can suggest any plausible explanation or is it more likely that something is wrong with the catalog records? How I can check the actual tape usage? Thanks, Ivan The information transmitted in this electronic communication is intended only for the person or entity to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this information in error, please contact the Compliance HelpLine at 800-856-1983 and properly dispose of this information. +-+--+---+-+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | VolBytes| VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-+--+---+-+--+--+-+--+---+---+-+ | 74 | Mutation0017 | Recycle | 1 |0 | 15,552,000 | 1 | 12 | 1 | SDX700-C | 2007-02-08 09:42:03 | | 75 | Mutation0018 | Full | 126,481,428,324 | 184 | 15,552,000 | 1 | 17 | 1 | SDX700-C | 2007-08-11 09:52:04 | | 125 | Mutation0019 | Full | 168,438,772,847 | 269 | 15,552,000 | 1 | 18 | 1 | SDX700-C | 2007-03-19 14:24:03 | | 128 | Mutation0021 | Full | 162,310,533,731 | 297 | 15,552,000 | 1 | 20 | 1 | SDX700-C | 2007-03-02 03:36:07 | | 138 | Mutation0022 | Full | 141,488,133,324 | 245 | 15,552,000 | 1 | 19 | 1 | SDX700-C | 2007-07-04 01:20:28 | | 139 | Mutation0023 | Full | 135,611,484,198 | 209 | 15,552,000 | 1 |9 | 1 | SDX700-C | 2007-06-11 01:31:51 | | 140 | Mutation0024 | Full | 149,275,192,825 | 190 | 15,552,000 | 1 | 10 | 1 | SDX700-C | 2007-07-14 07:08:41 | | 145 | Mutation0026 | Full | 601,703,410 |0 | 15,552,000 | 1 |4 | 1 | SDX700-C | 2007-07-14 08:11:21 | | 146 | Mutation0027 | Full | 30,578,689 |0 | 15,552,000 | 1 | 12 | 0 | SDX700-C | 2007-07-14 08:13:42 | | 147 | Mutation0028 | Full | 51,807,004,964 | 51 | 15,552,000 | 1 | 13 | 1 | SDX700-C | 2007-07-14 08:07:34 | | 148 | Mutation0029 | Full | 146,737,757,815 | 205 | 15,552,000 | 1 | 14 | 1 | SDX700-C | 2007-07-31 01:20:07 | | 168 | Mutation0030 | Full | 138,498,653,248 | 293 | 15,552,000 | 1 | 15 | 1 | SDX700-C | 2007-05-24 05:14:13 | | 169 | Mutation0031 | Full | 163,567,868,856 | 330 | 15,552,000 | 1 | 11 | 1 | SDX700-C | 2007-04-17 13:05:24 | +-+--+---+-+--+--+-+--+---+---+-+ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] finding qt for Bat on FreeBSD
On 13 Aug 2007 at 20:06, Martin Simmons wrote: On Mon, 13 Aug 2007 13:37:28 -0400, Dan Langille said: I'm trying to build Bat on FreeBSD. What configure options did you use? I have: --enable-bat --with-qwt=/usr/lib Offlist, and I discovered myself, that this needs to be /usr/local/lib I have qt4-4.3.0 installed. Note: (equal qt qwt) = nil Thanks. Fixed. I'm now using qwt, not qt. cheers. Does this error mean anything to anyone? ==Entering directory /usr/home/dan/src/bacula-bat/work/bacula- 2.2.0/src/qt-console make: don't know how to make depend. Stop *** Error code 1 Stop in /usr/home/dan/src/bacula-bat/work/bacula-2.2.0. Creating bat Makefile QMAKESPEC has not been set, so configuration cannot be deduced. Error processing project file: /usr/home/dan/src/bacula- bat/work/bacula-2.2.0/src/qt-console/bat.pro -- Dan Langille - http://www.langille.org/ Available for hire: http://www.freebsddiary.org/dan_langille.php - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Random tape capacity figures
I am running bacula 1.36.1 with Qualstar RLS-4445 autochanger and a single DDS tape drive installed. The tapes used are all Sony SDX3-100C (100GB native/260GB compressed capacity). I have noticed that VolBytes and VolFiles values vary widely for tapes marked as Full in media list command (see attached listing). Getting between 126GB and 168GB on your 100GB tapes is absolutely normal (the other 3 tapes are a problem) assuming that you are not backing up the exact data every time. This compression rate is not outside the range of compression that I and of lot of others see. Remember compressed data will not compress a second time so reaching the magical 2.0 or 2.6 compression rate the manufacturer will assume that you have no compressed files (.zip, .jpeg, .mpg ...) in your backup or that if you do have some of these files then the bulk of your data is plain text files which are generally highly compressible. E.g., volume with MediaId 146 have only 30MB VolBytes and 0 (sic!) VolFiles reported but still marked as Full, pretty strange. Another one listed as Full has about 600MB and also 0 files. I agree with that. There is something wrong there. My first thought is that you had a setting that expired the volume after the fist job but then there would be at least 1 volfile written so this does not make sense. Have you ran the btape tests that are in the manual? http://www.bacula.org/dev-manual/Testing_Your_Tape_Drive.html#btape1 Someone can suggest any plausible explanation or is it more likely that something is wrong with the catalog records? I doubt that as if your database were corrupt I would expect to see some really weird numbers. How I can check the actual tape usage? I am not aware of a non destructive and reliable way of doing that. In normal operation Bacula writes to a tape until it either hits the end of the tape or an error. John - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] can't load library: libmysqlclient_r.so.15
Thanks for the suggestion Maxx. I have since completely removed the bacula install, and the mysql install, and re-intalled both fresh. Somehow, magically, the library linking works now. One of those cases where I don't know precisely what the problem was, but it resolved itself with fresh installs, so be it. Jarrod On 8/13/07, MaxxAtWork [EMAIL PROTECTED] wrote: On 8/10/07, Jarrod Lewis-Peacock [EMAIL PROTECTED] wrote: Hello, I'm re-installing Bacula using MySQL instead of SQLite. I'm having problems linking with a mysql shared library. ./bacula start Starting the Bacula Storage daemon Starting the Bacula File daemon Starting the Bacula Director daemon /etc/bacula/bin/bacula-dir: error while loading shared libraries: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory Hi, have you tried to check with 'ldd /etc/bacula/bin/bacula-dir' whether the binary has a problem finding that library? In my (Debian) installation that library is actually in /usr/lib/. What if at least as a test you try to manually copy it there? -- Maxx - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users