Re: [Bacula-users] [Bacula-devel] Letter to the Bacula Community concerning Bareos

2013-12-17 Thread Rory Campbell-Lange
subcontractor of Bacula, and signed an NDA? Thanks Rory -- Rory Campbell-Lange -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application perfor

Re: [Bacula-users] Optimized mysql settings for CentOS 6 64bit

2011-10-05 Thread Rory Campbell-Lange
On 5 Oct 2011, at 14:23, Phil Stracchino wrote: > On 10/05/11 05:07, Uwe Schuerkamp wrote: >> Hi folks, >> >> I'm wondering about the best mysql settings for our new bacula >> installation which will be taking over from an older setup. >> >> Current bacula db size is 55G, we have around 14TB

Re: [Bacula-users] Bacula and Dell Powervault 124T

2011-07-28 Thread Rory Campbell-Lange
ick survey online. Come on, we don't ask for help often. > Plus, you'll get a chance to win $100 to spend on ThinkGeek. > http://p.sf.net/sfu/slashdot-survey > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net

Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Rory Campbell-Lange
On 19/07/11, Jason A. Kates (ja...@kates.org) wrote: > This is a restore that I have run as just a one off: > > restore client=clientname restoreclient=otherclient pool=Weekly > where=/mnt/restore select current all done yes > > so if you combine this with passing more in from the script (You can

Re: [Bacula-users] Scripting restores?

2011-07-19 Thread Rory Campbell-Lange
/example/for planners/Tiff/ordnance copy. /example/102__Binder.pdf /example/Thomas/rice yes EOF -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street L

Re: [Bacula-users] Web interface

2011-07-05 Thread Rory Campbell-Lange
The best interface in my view is psql and bconsole. These are 'web' accessible over ssh. -- Rory Campbell-Lange Director Campbell-Lange Workshop www.campbell-lange.net On 5 Jul 2011, at 17:20, Mauro Colorio wrote: >> I tried phpmyadmin, and webacula but I need somethin

Re: [Bacula-users] Financial article about Bacula Systems

2011-06-11 Thread Rory Campbell-Lange
On 11/06/11, Kern Sibbald (k...@sibbald.com) wrote: > http://finance.yahoo.com/news/Bacula-Systems-Receives-US5-prnews-1588890840.html?x=0&.v=1 This is great news for Bacula, its users, and hopefully Bacula Systems. Bravo! -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange W

[Bacula-users] Success [was Re: Mistaken append of job to media]

2011-06-09 Thread Rory Campbell-Lange
On 07/06/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > On 07/06/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > > On 07/06/11, Phil Stracchino (ala...@metrocast.net) wrote: > > > On 06/07/11 12:14, Rory Campbell-Lange wrote: > > > > Does de

Re: [Bacula-users] Mistaken append of job to media

2011-06-07 Thread Rory Campbell-Lange
On 07/06/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > On 07/06/11, Phil Stracchino (ala...@metrocast.net) wrote: > > On 06/07/11 12:14, Rory Campbell-Lange wrote: > > > Does deleting the job remove the data (in this case the data for job > > > 329) off th

Re: [Bacula-users] Mistaken append of job to media

2011-06-07 Thread Rory Campbell-Lange
On 07/06/11, Phil Stracchino (ala...@metrocast.net) wrote: > On 06/07/11 12:14, Rory Campbell-Lange wrote: > > Does deleting the job remove the data (in this case the data for job > > 329) off the tape? That is what I need to do. > > No, it doesn't. But you've al

Re: [Bacula-users] Mistaken append of job to media

2011-06-07 Thread Rory Campbell-Lange
On 07/06/11, John Drescher (dresche...@gmail.com) wrote: > On Tue, Jun 7, 2011 at 12:14 PM, Rory Campbell-Lange > wrote: > > Does deleting the job remove the data (in this case the data for job > > 329) off the tape? That is what I need to do. > > > No, it does not

Re: [Bacula-users] Mistaken append of job to media

2011-06-07 Thread Rory Campbell-Lange
On 07/06/11, Phil Stracchino (ala...@metrocast.net) wrote: > On 06/07/11 09:59, Rory Campbell-Lange wrote: > > I've written job 329 after job 315 on the same tape (CLW112L4). See below > > > > Two questions: > > > > * can I wipe the data pertaining to jo

[Bacula-users] Mistaken append of job to media

2011-06-07 Thread Rory Campbell-Lange
0 |83219 | 330633 |331218 -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -

[Bacula-users] Mistaken append of job to media

2011-06-07 Thread Rory Campbell-Lange
0 |83219 | 330633 |331218 -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -

Re: [Bacula-users] Tape backup only writes 1 GB

2011-04-20 Thread Rory Campbell-Lange
arently the 124Ts with IBM drives are more reliable. If you have an IBM drive you can use the IBM itdt utility to test it, otherwise btape or dd are the best bet. Naturally, you may also have tape errors. Good luck. -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.c

Re: [Bacula-users] Filename searching and case insensitivity

2011-04-06 Thread Rory Campbell-Lange
On 6 Apr 2011, at 02:37, Dan Langille wrote: > > On Apr 5, 2011, at 9:31 PM, Kernel Panic wrote: >> >> USE bacula; >> SELECT * FROM Filename WHERE name LIKE '%ZFS%'; >> SELECT * FROM Filename WHERE name LIKE '%zfs%'; >> >> Although the commands worked, they only returned case-sensitive >> m

Re: [Bacula-users] mtx and Dell PowerVault 124T Error

2011-04-05 Thread Rory Campbell-Lange
rsion > is 5.0.1 (24.Feb 2010 for ubuntu 10.4). The mtx (linux native) does > not seem to work nor does the mtx-changer script (obviously). Can you connect to the tape library and drive from the hypervisor? -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell

Re: [Bacula-users] can't create postgresql bacula database

2011-04-04 Thread Rory Campbell-Lange
eed to develop and > publish your website. http://p.sf.net/sfu/ms-webmatrix-sf > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Rory Campbell-Lange r...@campbell-lan

Re: [Bacula-users] mtx errors while Dell PV 124T calibrating

2011-03-04 Thread Rory Campbell-Lange
On 04/03/11, Alan Brown (a...@mssl.ucl.ac.uk) wrote: > On Thu, 3 Mar 2011, Rory Campbell-Lange wrote: > > > I've noticed the following error with a new tape library. > > While moving the tape with mtx the web gui shows the move as succeeded, > > but then moves to show

[Bacula-users] mtx errors while Dell PV 124T calibrating

2011-03-03 Thread Rory Campbell-Lange
: Request Sense: ILI=no mtx: Request Sense: Additional Sense Code = 44 mtx: Request Sense: Additional Sense Qualifier = 00 mtx: Request Sense: BPV=no mtx: Request Sense: Error in CDB=no mtx: Request Sense: SKSV=no MOVE MEDIUM from Element Address 256 to 32 Failed -- Rory Campbell-Lange r...@cam

Re: [Bacula-users] bacula bandwith usage

2011-03-02 Thread Rory Campbell-Lange
ding) for you, you should move down to the disk level. Watching iostat or iotop might be a good place to start. -- Rory Campbell-Lange r...@campbell-lange.net -- Free Software Download: Index, Search & Analyze Logs an

Re: [Bacula-users] 124t users?

2011-02-28 Thread Rory Campbell-Lange
ased read and write test for LTO3 and LTO4 tapes. This seems like a fairly good way of narrowing down a drive or interconnect problem. Is something like the following correct? mt -f /dev/nst0 rewind dd if=/dev/sd of=/dev/nst0 bs=64512 count=1 # about 300GB mt -f /dev/nst0 rewin

Re: [Bacula-users] 124t users?

2011-02-28 Thread Rory Campbell-Lange
TUM ' Product ID: 'ULTRIUM 4 ' Revision: '2210' Attached Changer API: No SerialNumber: 'JN0823AMJ50251' -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Stree

Re: [Bacula-users] 124t users?

2011-02-28 Thread Rory Campbell-Lange
"sh -c 'tapeinfo -f %c |grep TapeAlert|cat'" } On 28/02/11, Jeremiah D. Jester (jj...@u.washington.edu) wrote: > I'm using a 124t w/ LT04 tapes. I would appreciate if I could see your > conf files for comparison. -- Rory Campbell-Lange r...@campbell-lange.

Re: [Bacula-users] DebianSqueeze Installation Issue

2011-02-28 Thread Rory Campbell-Lange
e: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL and http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html We use Postgresql for a number of large web applications and we have found it very robust and easily upgradeable over several versions. We also make extensive use

Re: [Bacula-users] DebianSqueeze Installation Issue

2011-02-28 Thread Rory Campbell-Lange
"pgsql". The other errors you report have to do with Mysql configuration. If you haven't got a database configured yet, it may be worth moving to Postgresql in any event. -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 63

Re: [Bacula-users] Help in decoding hardware error

2011-02-17 Thread Rory Campbell-Lange
On 17/02/11, Alan Brown (a...@mssl.ucl.ac.uk) wrote: > Rory Campbell-Lange wrote: > >I'm having a frustrating time trying to work out why our Dell PV124T (LTO4 > >autoloader with a Quantum drive) is not working well at present. > > Check all your scsi cables, termin

Re: [Bacula-users] Help in decoding hardware error

2011-02-17 Thread Rory Campbell-Lange
On 17/02/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > I'm having a frustrating time trying to work out why our Dell PV124T (LTO4 > autoloader with a Quantum drive) is not working well at present. > > Kernel 2.6.33-2-amd64 on Debian > Bacula 5.0.2-1~bpo50 (customi

[Bacula-users] Help in decoding hardware error

2011-02-17 Thread Rory Campbell-Lange
st bt 0x5). Can anyone tell me what this means, apart from "your restore job just failed"? Many thanks Rory -- Rory Campbell-Lange r...@campbell-lange.net -- The ultimate all-in-one performance toolkit: Inte

[Bacula-users] Append to end of Full Backup following tape failure machine

2011-02-09 Thread Rory Campbell-Lange
n-fatal FD errors:0 SD Errors: 1 FD termination status: Error SD termination status: Error Termination:*** Backup Error *** -- Rory Campbell-Lange r...@campbell-lange.net -- The ult

Re: [Bacula-users] IBM 3573-TL, LTO5, speed

2011-02-02 Thread Rory Campbell-Lange
lf. You'll need to bring down the source packages for 5.0.2 and then update the source, and then compile the deb files. I'm running a custom version of Bacula and that is what I did. You may find Cowbuilder (http://wiki.debian.org/cowbuilder) useful. -- Rory Campbell-Lange r...@cam

Re: [Bacula-users] IBM 3573-TL, LTO5, speed

2011-02-02 Thread Rory Campbell-Lange
as been "freeze", it should not be going to update to > the bacula v5.0.3... shouldn't it ? > I do not want really to compile it handly with v5.0.3... You may want to refer to http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg44130.html -- Rory Campbe

Re: [Bacula-users] HP LTO3 tapes reference

2011-02-01 Thread Rory Campbell-Lange
<< EOF list media poolid=6 EOF (I'm not sure of the syntax of the second example -- please check). Rory -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in Eng

Re: [Bacula-users] Problems writing backups to tapes

2011-01-30 Thread Rory Campbell-Lange
dev.c:1745 ioctl MTWEOF error on "LTO4-Drive1" (/dev/nst0). ERR=Input/output error. Any thoughts? Rory On 28/01/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > I'm having problems writing to tapes in my DELL PV124T tape library, > which has been running fine for 6

[Bacula-users] Problems writing backups to tapes

2011-01-28 Thread Rory Campbell-Lange
ent] kernel: [212500.667971] Info fld=0x0 kernel: [212500.667973] st0: Add. Sense: Write error kernel: [212595.537383] st0: Sense Key : Medium Error [current] kernel: [212595.537389] st0: Add. Sense: Write error I'd be very grateful for some advice about what might be going wrong. T

Re: [Bacula-users] Choice of DB for catalog

2011-01-17 Thread Rory Campbell-Lange
the Postgresql wiki about the differences between MySQL and Postgresql here: http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 which is a little out of date. -- Rory Campbell-Lange -- Protect Your Site

Re: [Bacula-users] LTO-3 tape Not Compressing data and speed

2011-01-14 Thread Rory Campbell-Lange
lementation and the data being provided to the tape system. Some data can grow in size after attempting to compress it. It is difficult to know how well any particular data will compress. We achieve about 30% compression on our LTO4 tape drive system using hardware compression. -- Rory Campbell

Re: [Bacula-users] LTO-3 tape Not Compressing data and speed

2011-01-14 Thread Rory Campbell-Lange
Try something along the lines of man mt or mt -f /dev/nst0 compression 1 http://www.oreillynet.com/linux/cmd/cmd.csp?path=m/mt On 14/01/11, Jose Antonio Rodriguez Martin (jarodrig...@cgi.es) wrote: > nobody can make any comments? > The truth is that he thought there were people on the l

Re: [Bacula-users] Slow backup even with a dedicated line

2011-01-07 Thread Rory Campbell-Lange
I connected one client via crosslink (1Gbit on > both sides) to the server. But I still have the same transfer rate. Why > is that? What sort of backups are you doing? Are you writing to tape? Are you using spooling? -- Rory Campbell-Lange r.

Re: [Bacula-users] 1st post ... general user question b4 install

2011-01-06 Thread Rory Campbell-Lange
ervices" section. You may then wish to jump to the tutorial at http://www.bacula.org/5.0.x-manuals/en/main/main/Brief_Tutorial.html which runs through how to setup multiple clients. -- Rory Campbell-Lange r...@campbell-lange.net --

Re: [Bacula-users] [Bacula-5.0.3] Error when granting privileges with PostgreSQL-9.0.1

2011-01-04 Thread Rory Campbell-Lange
On 04/01/11, Craig Ferguson (cferguso...@gmail.com) wrote: > psql:-:38: ERROR: relation "jobhisto_jobid_seq" does not exist I don't think this is anything to worry about. See http://www.mail-archive.com/bacula-devel@lists.sourceforge.net/msg06272.html and responses. -- Ror

Re: [Bacula-users] [Bacula-devel] Bacula Project will Die

2010-11-07 Thread Rory Campbell-Lange
t a support or development contract with Bacula Systems. That seems pretty clear to me. I've just made a modest donation of money. Thanks for the great backup system. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lang

Re: [Bacula-users] reread an old tape

2010-10-22 Thread Rory Campbell-Lange
bscan -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- Nokia and AT&T present the 2010 C

Re: [Bacula-users] Multiple catalogs - initialisation?

2010-10-22 Thread Rory Campbell-Lange
te, populate, and give permissions for the database, then run them. Or, as the postgresql superuser, do the following on the psql command line: create database bacula- template bacula owner bacula; -- Rory Campbell-Lange r...@campbell-lange.net --

Re: [Bacula-users] Live backup

2010-10-21 Thread Rory Campbell-Lange
quot; folder which is constantly changing?? You may want to try Data Spooling. http://www.bacula.org/fr/dev-manual/Data_Spooling.html -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham

Re: [Bacula-users] Multiple catalogs - initialisation?

2010-10-21 Thread Rory Campbell-Lange
d in that. Following a brief discussion with Avi Rozen, who has developed the baculafs "catalog file system" I'm thinking of working on this more to make per-job sqlite dumps from Postgres to make entirely self-contained job catalogues, and to provide a facility to make a boo

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

2010-10-18 Thread Rory Campbell-Lange
ows > 1) { Mmsg1(mdb->errmsg, _("get_file_record want 1 got rows=%d\n"), <--- error mdb->num_rows); } Bacula is getting 2 records for the database records for the specified paths and files. It may be that you have inadvert

Re: [Bacula-users] Tuning for large (millions of files) backups?

2010-10-12 Thread Rory Campbell-Lange
batch insert with jobs of around 8 million files, and it works without any problems. Postgresql is tremendous at providing a smooth upgrade path too. We migrated a lot of services with few problems from each major release starting in the low 7.x release series. Regards Rory -- Rory Campbell-Lan

Re: [Bacula-users] Restore from a file listing

2010-10-07 Thread Rory Campbell-Lange
On 07/10/10, Dan Langille (d...@langille.org) wrote: > On 10/5/2010 2:53 PM, Rory Campbell-Lange wrote: > >> Is there a simple and accurate way of providing a list of files of this > >> sort to Bacula in order to mark them and proceed with a restore job? > > Have you tr

Re: [Bacula-users] Restore from a file listing

2010-10-05 Thread Rory Campbell-Lange
ugh SQL? I note that the file table has a markid column. Thanks Rory On 04/10/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > At present I am doing a restore job by using option 3 and entering the > job id as all our backups are full backups. Then I go into the restore > conso

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: > Rory Campbell-Lange schrieb: > > On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: > > > > All of the indexes are below; you seem to have the correct ones for the > > file table. > > > >

Re: [Bacula-users] Tuning Bacula

2010-10-04 Thread Rory Campbell-Lange
troller has caching enabled (you need a BBU for this to be safe) and that you have a good filesystem for your backup needs (the best one for us is XFS). Rory -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Rory Campbell-Lange
index | bacula | storage public | unsavedfiles_pkey | index | bacula | unsavedfiles -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928

Re: [Bacula-users] Restore from a file listing

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Graham Keeling (gra...@equiinet.com) wrote: > On Mon, Oct 04, 2010 at 12:00:12PM +0100, Rory Campbell-Lange wrote: ... > > At present I am doing a restore job by using option 3 and entering the > > job id as all our backups are full backups. Then I go into the rest

[Bacula-users] Restore from a file listing

2010-10-04 Thread Rory Campbell-Lange
K6HoyvYA ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_Construction issue southblock/Binder1.pdf : K/iqrW28Z+Lemk4osfrnCQ -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered

[Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
is removed I'm considering making an sqlite database from the temporary schema to obviate the need for the public schema file and file listing. This is fairly simple stuff, but if this functionality is useful to you, do let me know and I can share the programme with you. Regards Rory -- Rory C

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
o about 300MB with bzip2 -9). I'm a little suprised that the proportion of job 60 to the whole is so high. Job 60 is similar to job 1, but I don't expect they share much information. I'll have to look into that. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net Campb

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
On 04/10/10, Phil Stracchino (ala...@metrocast.net) wrote: > On 10/04/10 07:22, Rory Campbell-Lange wrote: > > I have developed a catalogue snapshot facility in python to snapshot one > > job's catalogue and dump it to disk. The snapshot provides a bacula > > database sc

Re: [Bacula-users] Catalogue snapshot utility : any interest?

2010-10-04 Thread Rory Campbell-Lange
ull pathid | integer | not null filenameid | integer | not null markid | integer | not null default 0 lstat | text| not null md5| text| not null -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Work

Re: [Bacula-users] bacula 5.0.3 backport for debian lenny?

2010-09-15 Thread Rory Campbell-Lange
ted sql queries will be dramatically slower! As John Goerzen notes in Tobias' linked bug report, one can recreate the index as follows: CREATE INDEX file_jpfid_idx on file (jobid, pathid, filenameid); -- Rory Campbell-Lange r..

Re: [Bacula-users] bacula 5.0.3 backport for debian lenny?

2010-09-14 Thread Rory Campbell-Lange
On 14/09/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: > Rory Campbell-Lange schrieb: > > On 14/09/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: > > > ...so I'd like to skip 5.0.2 which is available in lenny-backports > > > right now. > > > &g

Re: [Bacula-users] bacula 5.0.3 backport for debian lenny?

2010-09-14 Thread Rory Campbell-Lange
rks well. http://packages.debian.org/lenny-backports/bacula http://wiki.debian.org/Backports#Findingbackports -- Rory Campbell-Lange r...@campbell-lange.net -- Start uncovering the many advantages of virtual applia

Re: [Bacula-users] python implementation of bacula md5

2010-09-12 Thread Rory Campbell-Lange
use them # http://support.microsoft.com/kb/191239 suggests trailing = signs should be # used for RFC 1521 compliance # wierdly, a newline seems to be added to be encodedstring too, so this also # needs to be stripped off. print b64.strip().rstrip('=') -- Rory Campbell-Lange r...@campbell

[Bacula-users] python implementation of bacula md5

2010-09-12 Thread Rory Campbell-Lange
it is done. Kind regards Rory -- Rory Campbell-Lange r...@campbell-lange.net -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to

Re: [Bacula-users] Unmount tape after all jobs run

2010-09-10 Thread Rory Campbell-Lange
robably want to run a cronjob to see if there has been a tape status change (i.e. mt -f /dev/nst0 status returns something rather than nothing) and then trigger the job through shell scripting bconsole. -- Rory Campbell-Lange r.

Re: [Bacula-users] Add pre-labeled volumes to a pool

2010-08-26 Thread Rory Campbell-Lange
new tapes, but > they're pre-labeled. I put them into the TapeLibrary magazines, after > the 4 tapes in use but i don't know how add them to my pool. Can > anybody help me? If you use the "label" command from bconsole, you are asked for which pool the relevant tape

Re: [Bacula-users] Spooling and backup concept

2010-08-26 Thread Rory Campbell-Lange
ort) backups. (See Backup Levels: http://www.backupcentral.com/wiki/index.php/Bacula). You may find this helpful: http://www.bacula.org/fr/dev-manual/Backup_Strategies.html -- Rory Campbell-Lange r...@campbell-lange.net ---

Re: [Bacula-users] Maildir and mysql plugin

2010-08-24 Thread Rory Campbell-Lange
ticular folder and if not record its headers in a database. Note that many imap daemons change the name of the stored files to record mail flags. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net -- Sell apps to

Re: [Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-20 Thread Rory Campbell-Lange
On 20/08/10, Martin Simmons (mar...@lispworks.com) wrote: > >>>>> On Wed, 18 Aug 2010 23:15:59 +0100, Rory Campbell-Lange said: > > > > Can someone point me to the relationship between Media and File? ... > > This shows that each backup starts from 1 (0 for

Re: [Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-18 Thread Rory Campbell-Lange
1 | 1 13 | 1 | 1 17 | 1 | 1 19 | 1 | 1 This shows that each backup starts from 1 (0 for one of them?!), so there is no direct relationship between the jobmedia and file tables. Correct? -- Rory Campbel

[Bacula-users] Catalog MD5 not matching file MD5

2010-08-14 Thread Rory Campbell-Lange
e restored file's md5? -- Rory Campbell-Lange r...@campbell-lange.net -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf

[Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-14 Thread Rory Campbell-Lange
On 13/08/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > I'd like to write catalog information to CD/DVD to accompany my tape > sets, which will be between 1 and 15 LT04 tapes. I'm using Postgres > for the Catalog. The idea is to make it easy for people to restore fr

[Bacula-users] Catalog to accompany job tape sets

2010-08-13 Thread Rory Campbell-Lange
provide a human readable listing of the files. b.) does that, but is not readily usable for restores. c.) is readily usable for restores (I think), but might need b.) before someone knows how to proceed. Other thoughts gratefully received! Regards Rory -- Rory Campbell-Lange r...@cam

Re: [Bacula-users] Dell PV-124T with Ultrium TD4, Hardware or Software compression?

2010-08-12 Thread Rory Campbell-Lange
ce on a SAS card, and manage about 1.1TB on an LT04 tap. I'd be interested to hear other thoughts on this. Rory -- Rory Campbell-Lange r...@campbell-lange.net -- This SF.net email is sponsored by Make an app

Re: [Bacula-users] new bacula installation

2010-08-12 Thread Rory Campbell-Lange
t;Drive1" (/dev/nst0) is not a Bacula labeled Volume, > because: ERR=block.c:1016 Read error on fd=5 at file:blk 0:0 on device > "Drive1" (/dev/nst0). ERR=Input/output error. You haven't labelled the volume. Try this: http://www.bacula.org/manuals/en/install/install/Ge

Re: [Bacula-users] new bacula installation

2010-08-12 Thread Rory Campbell-Lange
't loaded the second magazine? The spec sheet shows that the loader may be supplied with 8 or 16 slots. My device has only 1 drive. > Also, if it does have two drives why wouldn't it show up in lsscsi? > I'm only seeing /dev/st0? Should I specify /dev/sg1 in my sd conf

Re: [Bacula-users] new bacula installation

2010-08-12 Thread Rory Campbell-Lange
ut 100MB/s throughput with hardware compression. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer C

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-09 Thread Rory Campbell-Lange
On 04/08/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > On 03/08/10, Dan Langille (d...@langille.org) wrote: > > On 8/3/2010 7:09 PM, Rory Campbell-Lange wrote: > > > > Yes, a batch insert is faster than a specfic insert, but the latter > > > should b

Re: [Bacula-users] Bacula Autochanger Questions

2010-08-04 Thread Rory Campbell-Lange
er command failing? -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in c

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-04 Thread Rory Campbell-Lange
y. Fair enough. Can restores run off marked columns in database tables? This exercise could be taken out of the main core of Bacula into a little Django app (perhaps) and not affect the main body of Bacula at all except for some way of executing restores. -- Rory Campbell-Lange r..

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-04 Thread Rory Campbell-Lange
t the > catalog is (for the tape part). And we have to be fast when inserting > there, there are some configurations with hundreds of client > spooling??? not juste one backup. Fair enough. Thanks for your comments. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net -

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-04 Thread Rory Campbell-Lange
On 03/08/10, Dan Langille (d...@langille.org) wrote: > On 8/3/2010 7:09 PM, Rory Campbell-Lange wrote: > > Yes, a batch insert is faster than a specfic insert, but the latter > > should be done at the "written-to-tape" transaction time, and could be > > done async

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-03 Thread Rory Campbell-Lange
console. I'm delighted to be using Bacula (particularly after our tribulations with Amanda) but it seems to me that Bacula could lean much more heavily on Postgresql. -- Rory Campbell-Lange r...@campbell-lange.net --

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-03 Thread Rory Campbell-Lange
it if you use --disable-batch-insert. ... > > Perhaps this is something the developers could consider? > > You can do that already by compiling with --disable-batch-insert and setting > Spool Attributes to NO. Thanks very much for your comments, Martin. I'm abo

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-03 Thread Rory Campbell-Lange
Thanks very much for your response, Martin. On 03/08/10, Martin Simmons (mar...@lispworks.com) wrote: > >>>>> On Tue, 3 Aug 2010 10:15:18 +0100, Rory Campbell-Lange said: > > I have 3.4GB free in /var where Postgresql is located. At the end of a > > large backup

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-03 Thread Rory Campbell-Lange
TB backup out, but I have to reconfigure Bacula to suit. Help much appreciated! Rory On 02/08/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > I turned off spooling and set the Spool Attributes directive to no and > reran the backup. The backup job completes but the d

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-08-02 Thread Rory Campbell-Lange
On 30/07/10, Dan Langille (d...@langille.org) wrote: > On 7/30/2010 3:53 AM, Rory Campbell-Lange wrote: > > > > Fatal error: sql_create.c:843 Batch end postgresql.c:748 error ending > > batch mode: ERROR: could not extend relation 1663/17472/17828: > > wrote

Re: [Bacula-users] Bacula + Postgres : copy batch problem

2010-07-30 Thread Rory Campbell-Lange
sts. Feedback will be appreciated. Thanks for the suggestion. I'm going to first try Dan Langille's suggestion of setting "Spool Attributes" to "no". -- Rory Campbell-Lange r...@campbell-lange.net -

[Bacula-users] Bacula + Postgres : copy batch problem

2010-07-30 Thread Rory Campbell-Lange
his large job to try and retrieve the set of data, or do I have to start again? -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to br

[Bacula-users] Recommended documents/programmes to include with a backup set

2010-07-29 Thread Rory Campbell-Lange
ww.bacula.org/en/dev-manual/main/main/What_is_Bacula.html I'd be grateful to learn what files people believe would be useful to put on each tape set's accompanying CD, and what sort of catalogue or bootstrap file we should include to help retrieve information in future. Regards Ro

Re: [Bacula-users] Backup windows client with accented characters in folder

2010-07-29 Thread Rory Campbell-Lange
al) UTF8. UTF8 has been the default encoding for postgres on Debian system from at least postgresql version 8.3. -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the P

Re: [Bacula-users] bconsole command to display jobs on volume

2010-07-27 Thread Rory Campbell-Lange
which are on which tapes and son on. I hope this helps. Rory -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps t

Re: [Bacula-users] bacula-fd slow? [was: Half-speed backup problem]

2010-07-22 Thread Rory Campbell-Lange
On 22/07/10, John Drescher (dresche...@gmail.com) wrote: > On Thu, Jul 22, 2010 at 7:07 AM, Rory Campbell-Lange > > I am now using a spool to see what is happening for the locally attached > > Coraid storage. The locally attached storage runs at a (contended) write > > of 77

Re: [Bacula-users] bacula-fd slow? [was: Half-speed backup problem]

2010-07-22 Thread Rory Campbell-Lange
On 21/07/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > On 21/07/10, Craig Miskell (craig.misk...@opus.co.nz) wrote: > > Rory Campbell-Lange wrote: > > >On 19/07/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > > > > I ran a full backup of a vol

Re: [Bacula-users] Half-speed backup problem

2010-07-20 Thread Rory Campbell-Lange
On 21/07/10, Craig Miskell (craig.misk...@opus.co.nz) wrote: > Rory Campbell-Lange wrote: > >On 19/07/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > > > I ran a full backup of a volume last week on Bacula v2.4.4 and I > > > have now upgraded to 5.0.2. I&#x

Re: [Bacula-users] Half-speed backup problem

2010-07-20 Thread Rory Campbell-Lange
On 19/07/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > I ran a full backup of a volume last week on Bacula v2.4.4 and I have > now upgraded to 5.0.2. I'm getting half the throughput last week as I am > now. > > Last week's test volume was a 2.1TB xfs vo

Re: [Bacula-users] Can't access tape device after upgrade from v2.4.4-1 to 5.0.2-1

2010-07-19 Thread Rory Campbell-Lange
it works to his satisfaction. Regards Rory -- Rory Campbell-Lange Managing Director r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 ---

[Bacula-users] Finding tape of file

2010-07-19 Thread Rory Campbell-Lange
File to Job. It isn't clear how one gets from there to Media. What is the SQL relationship from the File table to the Media table? Cheers Rory (sorry for the large number of recent postings) -- Rory Campbell-Lange r..

[Bacula-users] Half-speed backup problem

2010-07-19 Thread Rory Campbell-Lange
e's status client shows backup running at less than 30MB/s. Hardware compression has been enabled in both cases. Both volumes are RAID5 Coraid (ATA over Ethernet) devices. I'd be grateful for any pointers for getting to the bottom of this. Many thanks Rory -- Rory Campbell-Lange r..

Re: [Bacula-users] Can't access tape device after upgrade from v2.4.4-1 to 5.0.2-1

2010-07-19 Thread Rory Campbell-Lange
Hi Dan Thanks for your email. On 19/07/10, Dan Langille (d...@langille.org) wrote: > On 7/19/2010 4:21 AM, Rory Campbell-Lange wrote: > Oh your tapes should still be usable after the upgrade. I think > you need to concentrate on that problem first. Ignore all others. > > >

  1   2   >