Re: [Bacula-users] cancel job: job not found

2007-04-18 Thread Silver Salonen


On Tuesday 17 April 2007 22:59, Arno Lehmann wrote:
 Hi,
 
 On 4/17/2007 2:04 PM, Silver Salonen wrote:
  Hi.
  
  I'm using Bacula 2.0.1 on FreeBSD-4.9.
  
  In console status dir:
  =
  Running Jobs:
   JobId Level   Name   Status
  ==
7617 Fullrakvere.2007-04-17_11.29.52 is waiting for Client 
rakvere-fd to 
  connect to Storage storage-rakvere
7618 Fullpaide.2007-04-17_11.34.35 is waiting for Client paide-fd to 
  connect to Storage storage-paide
  =
  
  They've been hanging there for 4 hours now, so I wanted to just cancel 
them.
  
  In console cancel jobid=7617:
  =
  3904 Job rakvere.2007-04-17_11.29.52 not found.
  =
  
  cancel jobid=7618:
  =
  3904 Job paide.2007-04-17_11.34.35 not found.
  =
 
 Interesting... when I cancel a job like this, I always get TWO lines of 
 messages. One from the DIR, one from the SD or FD, I think.
 
  After a while they still got cancelled, so these error messages were a 
little 
  misleading.
  
  A bug?
 
 Or possible the rwason why the jobs were hanging around... like the DIR 
 still knew of them, but the SD or FD was restarted in between. This, at 
 least, is usually the reason when I get the not found messages. 
 Accompanied, to emphasize that, usually by a message that the job was 
 canceled.
 
 Arno

Hm, yes, maybe I did restart SD. But to my mind I did it before starting the 
first job. When the job had been hanging there for a while (waiting for SD), 
I just restarted SD again and hoped the job gets an error or smth. But it 
didn't. So I just started the other job from another client.

Today I see that both of these jobs got operation timed out for the SD 
(these messages lasted about 4,5 hours until the final error was returned), 
so I guess there's something misconfigured in SD's TLS or smth.

-- 
Silver

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Is HFS+ support working currently?

2007-04-18 Thread Adam Cécile
Hi,

I'm really interrested in having more infos about it.
I would know is there's anyway to backup fork ressources (like mac
aliases) from a Windows 2000 server NAS.

Regards, Adam.


Adam Compton a écrit :
 Hello,

 I am having issues with restoring Mac OS X resource forks stored on a 
 HFS+ filesystem. I noticed while researching the problem that a post to 
 bacula-devel[1] mentioned that HFS+ resource fork restoration was broken 
 as of early December last year. I'm curious to know if this is still the 
 case, or if I have a different problem. I was unable to find a bug 
 related to HFS+ support in the bug database, but that may very well be 
 because I am not familiar with its use.

 I have a Linux director[2] and storage daemon[3], and file daemons of 
 all shapes and colors (Linux, Mac OS X, and Windows). The Mac OS X file 
 daemon[4] is set to back up the system to a pool of file volumes on the 
 storage daemon (as are the other file daemons). I've included the 
 director configuration file for this client at [5]. When I try to 
 restore a file with a resource fork, I get the file (restored to 
 /tmp/bacula-restores by default), but no resource fork. The SplitForks 
 utility provided with the Developer Tools does not notice a resource 
 fork worth creating an AppleDouble file for, and doing a ls of the 
 resource fork (ls -l filename/rsrc) shows a size of zero. Also, the 
 console message for the successful restore command tells me that a total 
 of X bytes were restored, being exactly equal to the number of bytes in 
 the data fork of the file, instead of the size of the data fork and the 
 resource fork like I'd expect.

 If it is the case that HFS+ resource fork support is still broken, I'd 
 be more than happy to help test any fixes, although I don't know that 
 I'd be able to contribute much in the way of code. If it has been fixed, 
 is there any way for me to verify that resource forks are being backed 
 up properly, and are there any special procedures that I need to take in 
 order to restore them?

 Thanks in advance for your time.

 Adam Compton
 Network Administrator
 Sierra Canyon School

 [1] 
 http://article.gmane.org/gmane.comp.sysutils.backup.bacula.devel/7662/match=hfs
 [2] hercules-dir Version: 2.0.3 (06 March 2007) x86_64-pc-linux-gnu gentoo
 [3] hercules-sd Version: 2.0.3 (06 March 2007) x86_64-pc-linux-gnu gentoo
 [4] hestia-fd Version: 2.0.2 (28 January 2007)  
 powerpc-apple-darwin8.8.0 darwin 8.8.0
 [5] bacula-dir-hestia-fd.conf:

 #   Client Config   #
 Client {
   Name = hestia-fd
   Address = hestia
   FDPort = 9102
   Catalog = MyCatalog
   Password = redacted
   File Retention = 2 weeks
   Job Retention = 1 week
   AutoPrune = yes
 }

 #   Jobs Config   #
 Job {
   Name = Hestia OS
   JobDefs = Default OS Job
   Client = hestia-fd
   FileSet = Hestia OS FileSet
 }

 #   FileSet Config   #
 FileSet {
   Name = Hestia OS FileSet
   Include {
 Options {
   signature = MD5
   sparse = yes
   compression = GZIP
   hfsplussupport = yes
 }
 File = /
   }
   Exclude {
 # Be sure to put the excluded files from Carbon Copy Cloner in here too
 File = /StudentHomes
 File = /Shared Items

 snip

 File = /Volumes
 File = /.hotfiles.btree
   }
 }


 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
   


-- 
Adam CECILELinbox / FreeALter Soft
152 rue de Grigy   tél: +33 3 87 50 87 95
Technopôle Metz 2000   fax: +33 3 87 75 19 26   
57070 METZ - Francehttp://www.linbox.com


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Forcing a level upgrade for a scheduled job?

2007-04-18 Thread Hoffmann Ferdinand - ext. Berater Fa. HP
Hello,

Is it possible to upgrade the level of all jobs using the bacula console
(or via script)?
We use a script that handles the monthly tape cycle ('update slots scan'
command, moving tapes 
to the Scratch pool etc.). It's called by the operator after replacing
the tapes...
It would be very nice to schedule only diff./incr. jobs and upgrade them
to full after the tapes have been changed.

basicly the same as in:
http://thread.gmane.org/gmane.comp.sysutils.backup.bacula.general/17142


ferdinand hoffmann

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] el5 rpms ready

2007-04-18 Thread Felix Schwarz

The CentOS team released the RHEL 5 clone a few days ago. Therefore I created 
some some virtual machines for building bacula rpms and just uploaded rpms for 
i386 and x86_64 (see rpms-contrib-fschwarz package on the bacula sourceforge 
page).

Please note that these packages were built with the centos4 switch so there may 
be dependency problems (although I hope everything goes fine). Please report 
your results (success/failures) :-)

Have fun!
Felix


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Spaces in file names in FileSet directive.

2007-04-18 Thread David Michal
Hello,

When Bacula is trying to backup directories with spaces in their names
(only when defined in FileSet), I'm getting error message:

 

storage-fd:  Could not stat /root/vmware/Win2003: ERR=No such file
or directory

 

In bacula-dir I have:

FileSet {

  Name = linux_vmware_server

  Include {

Options {

  signature = MD5

  compression = GZIP

}

File = /etc

File = /home

File = /root/vmware/Win2003 VM

  }

}

 

I was trying to close the path to double quotes, but didn't help. Today
I'll try to have the path like: /root/vmware/Win2003\ VM ,  but I'm only
guesing how the syntax is.

 

Please anybody know how to define path with space in name?

 

Thanks,

David

 

 

 

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Spaces in file names in FileSet directive.

2007-04-18 Thread Johan Ehnberg

David Michal wrote:
 Hello,
 
 When Bacula is trying to backup directories with spaces in their names  
 (only when defined in FileSet), I’m getting error message:
 
  
 
 storage-fd:  Could not stat /root/vmware/Win2003: ERR=No such file 
 or directory
 
  
 
 In bacula-dir I have:
 
 FileSet {
 
   Name = linux_vmware_server
 
   Include {
 
 Options {
 
   signature = MD5
 
   compression = GZIP
 
 }
 
 File = /etc
 
 File = /home
 
 File = /root/vmware/Win2003 VM
 
   }
 
 }
 
  
 
 I was trying to close the path to double quotes, but didn’t help. Today 
 I’ll try to have the path like: /root/vmware/Win2003\ VM ,  but I’m only 
 guesing how the syntax is.
 
  
 
 Please anybody know how to define path with space in name?
 

Put quotes aroud it. That's the standard way in the unix world, which 
doesn't really (traditionally) like spaces in filenames.

  File = /root/vmware/Win2003 VM

Cheers,
Johan

-- 
Johan Ehnberg

Email: [EMAIL PROTECTED]
GSM:   +358503209688
WWW:   http://www.ehnberg.net/johan/

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Need suggestion for backup sol

2007-04-18 Thread nilesh vaghela
Dear All,

I have following requirement for backup purpose.

Presently handling the backup with script with rsync, smb and ssh with cygwin.

# Need to take backup of selected directory from window xp, windows 2000 and 98.
# The size of the network is 300 pc.
# maximum 2 gb per user.
# Need to support incremental and full backup.
# Schedule list.
# Mostly backup will be on HDD or Raid not on tape / dlt.
# Exclude and include file list.
# Find or search for the file and than backup the find or searched file.
# Open file backup if possible with windows xp.
# I do not want to share the windows xp drive.
# we do have few linux server need to backup.

Please suggest for BACULA

Thanx


-- 
Nil

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] hi-res bacula logo

2007-04-18 Thread Dan Langille
Do we have a hi res bacula logo, suitable for print?

I've been contacted by a magazine about to do an article.

-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php
PGCon - The PostgreSQL Conference - http://www.pgcon.org/



-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
Hi all,

I have instaled Bacula on Freebsd 6.2. When i try to run job i get an error

Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database

The owner of bacula.db is bacula user, and have write and read permission.

I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.

Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?

Thanks
-- 
Giancarlo Rubio

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Spaces in file names in FileSet directive.

2007-04-18 Thread David Michal
  I was trying to close the path to double quotes, but didn't help.
 Today
  I'll try to have the path like: /root/vmware/Win2003\ VM ,  but I'm
 only
  guesing how the syntax is.
 
 
 
  Please anybody know how to define path with space in name?
 
 
 Put quotes aroud it. That's the standard way in the unix world, which
 doesn't really (traditionally) like spaces in filenames.
 
   File = /root/vmware/Win2003 VM
 
 Cheers,
 Johan

Well, as I wrote, I did that already and it didn't work.
David


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] el5 rpms ready

2007-04-18 Thread Felix Schwarz
Hi Tim,

(I'm sending this mail to the public list as this may be of interest for 
others, 
too)

Tim Schoellhammer wrote:
 Gibt es einen Speziellen Grund das diese rpms nicht in die jeweiligen 
 repositories committed werden?

(English/short: Why aren't these RPMs not part of the {Fedora, RHEL} 
repositories?)

Obviously, Bacula was not important enough for Redhat to include it in their 
own 
repositories (RHEL, Fedora Core) that's why RHEL/CentOS do not ship them.

Fedora (Extras) is open for external contributors but I think there are some 
issues which prevent inclusion of the given RPM packages (such as Fedora SPEC 
file requirements, packaging concerns). The main obstacle is that nobody did 
care enough to make the required changes.

However, some months ago a new effort (with newly created rpms) was started by 
Andreas Thienemann and I think this will finally result in the inclusion of 
bacula to Fedora Extras and very likely Extra Packages for Enterprise Linux 
(EPEL). The bug report is: 
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=230344

fs

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] el5 rpms ready

2007-04-18 Thread Tim Schoellhammer
Thanks Felix,


ok so i will wait :)

Thanks for the RPMs.

Felix Schwarz schrieb:
 Hi Tim,
 
 (I'm sending this mail to the public list as this may be of interest for 
 others, too)
 
 Tim Schoellhammer wrote:
 Gibt es einen Speziellen Grund das diese rpms nicht in die jeweiligen 
 repositories committed werden?
 
 (English/short: Why aren't these RPMs not part of the {Fedora, RHEL} 
 repositories?)
 
 Obviously, Bacula was not important enough for Redhat to include it in 
 their own repositories (RHEL, Fedora Core) that's why RHEL/CentOS do not 
 ship them.
 
 Fedora (Extras) is open for external contributors but I think there are 
 some issues which prevent inclusion of the given RPM packages (such as 
 Fedora SPEC file requirements, packaging concerns). The main obstacle is 
 that nobody did care enough to make the required changes.
 
 However, some months ago a new effort (with newly created rpms) was 
 started by Andreas Thienemann and I think this will finally result in 
 the inclusion of bacula to Fedora Extras and very likely Extra Packages 
 for Enterprise Linux (EPEL). The bug report is: 
 https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=230344
 
 fs


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Spaces in file names in FileSet directive.

2007-04-18 Thread Thomas Glatthor
with bacula 2.0.3 and double quotes it works on linux.
i get no error for this path:

File = /home/thomas/thomas test


restore:
 Enter done to leave this mode.
 
 cwd is: /
 $ cd /home/thomas
 cwd is: /home/thomas/
 $ ls
 Desktop/
 thomas test/
 $ mark thomas test
 No files marked.
 $ mark thomas test
 2 files marked.
 $ lsmark
 *thomas test/
 *hallo
 $ unmark thomas test
 2 files unmarked.
 $ mark thomas\ test
 2 files marked.
 $ 


regards

thomas

David Michal schrieb:
 I was trying to close the path to double quotes, but didn't help.
 Today
 I'll try to have the path like: /root/vmware/Win2003\ VM ,  but I'm
 only
 guesing how the syntax is.



 Please anybody know how to define path with space in name?

 Put quotes aroud it. That's the standard way in the unix world, which
 doesn't really (traditionally) like spaces in filenames.

   File = /root/vmware/Win2003 VM

 Cheers,
 Johan
 
 Well, as I wrote, I did that already and it didn't work.
 David
 
 
 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
IC3S Information, Computer und Solartechnik AG
Bäckerbarg 6, 22889 Tangstedt, Germany

Telefon+49.4109.555.121
Telefax+49.4109.555.57
E-Mail  [EMAIL PROTECTED]
Webhttp://www.ic3s.de/

Vorstand: Jan Behrmann (Vorsitzender), Stefan Fehlauer
Aufsichtsrat: Sven Niklasson (Vorsitzender)
Dresdner Bank (200 800 00), Kto. 0123 9582 00
Commerzbank (200 400 00), Kto. 8540 288
Amtsgericht Kiel HRB 7590
UST.IdNr. DE184532766

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Problems with windows restore

2007-04-18 Thread Eduardo Jorge
Hi folks,

Now I'm starting to use bacula with my backup solution, and my scenario is:

Backup server: Debian Etch
Work Stations: Windows xp

I make a test Debian (backup server) to debian ( my workstation) and
backup and restore are occurred ok, but when I try to make this tests
with Debian (Backup server) to Windows (Workstations) the backup
ocurred with no problems but when I try to make a recover apparently
it occurred ok, but when I see in recover directory recovered archives
don't stay there.

In messages its appear

Bootstrap records written to /var/lib/bacula/s-158058-dir.2.restore.bsr

The job will require the following Volumes:

   bacula


2 files selected to be restored.

Automatically selected Job: RestoreFiles
Run Restore job
JobName:RestoreFiles
Bootstrap:  /var/lib/bacula/s-158058-dir.2.restore.bsr
Where:  /home/bacula/bacula-restores
Replace:always
FileSet:WinVM
Client: teste
Storage:File
When:   2007-04-18 10:19:32
Catalog:MyCatalog
Priority:   10
OK to run? (yes/mod/no): yes
Job started. JobId=74
*messages
18-Apr 10:19 s-158058-dir: Start Restore Job RestoreFiles.2007-04-18_10.19.33
18-Apr 10:19 s-158058-sd: Ready to read from volume bacula on device
FileStorage (/home/bacula).
18-Apr 10:19 s-158058-dir: Bacula 1.38.11 (28Jun06): 18-Apr-2007 10:19:40
  JobId:  74
  Job:RestoreFiles.2007-04-18_10.19.33
  Client: teste
  Start time: 18-Apr-2007 10:19:35
  End time:   18-Apr-2007 10:19:40
  Files Expected: 2
  Files Restored: 2
  Bytes Restored: 72,264
  Rate:   14.5 KB/s
  FD Errors:  0
  FD termination status:  OK
  SD termination status:  OK
  Termination:Restore OK

Anyone can help me?

-- 
Serrano Neves - a.k.a eth0 / www.eth0.eti.br
Realmente Seguro? http://secure.eth0.eti.br
Talk is cheap. Show me the code. - Linus Torvalds

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problems with windows restore

2007-04-18 Thread Eduardo Jorge
My problems are solved :)

Now I have another problem, Directorys with space style Documents and
Settings it not possible to recover because the cd command to
change to directory don't work, can anyone help me?

Tks

2007/4/18, Eduardo Jorge [EMAIL PROTECTED]:
 Hi folks,

 Now I'm starting to use bacula with my backup solution, and my scenario is:

 Backup server: Debian Etch
 Work Stations: Windows xp

 I make a test Debian (backup server) to debian ( my workstation) and
 backup and restore are occurred ok, but when I try to make this tests
 with Debian (Backup server) to Windows (Workstations) the backup
 ocurred with no problems but when I try to make a recover apparently
 it occurred ok, but when I see in recover directory recovered archives
 don't stay there.

 In messages its appear

 Bootstrap records written to /var/lib/bacula/s-158058-dir.2.restore.bsr

 The job will require the following Volumes:

bacula


 2 files selected to be restored.

 Automatically selected Job: RestoreFiles
 Run Restore job
 JobName:RestoreFiles
 Bootstrap:  /var/lib/bacula/s-158058-dir.2.restore.bsr
 Where:  /home/bacula/bacula-restores
 Replace:always
 FileSet:WinVM
 Client: teste
 Storage:File
 When:   2007-04-18 10:19:32
 Catalog:MyCatalog
 Priority:   10
 OK to run? (yes/mod/no): yes
 Job started. JobId=74
 *messages
 18-Apr 10:19 s-158058-dir: Start Restore Job RestoreFiles.2007-04-18_10.19.33
 18-Apr 10:19 s-158058-sd: Ready to read from volume bacula on device
 FileStorage (/home/bacula).
 18-Apr 10:19 s-158058-dir: Bacula 1.38.11 (28Jun06): 18-Apr-2007 10:19:40
   JobId:  74
   Job:RestoreFiles.2007-04-18_10.19.33
   Client: teste
   Start time: 18-Apr-2007 10:19:35
   End time:   18-Apr-2007 10:19:40
   Files Expected: 2
   Files Restored: 2
   Bytes Restored: 72,264
   Rate:   14.5 KB/s
   FD Errors:  0
   FD termination status:  OK
   SD termination status:  OK
   Termination:Restore OK

 Anyone can help me?

 --
 Serrano Neves - a.k.a eth0 / www.eth0.eti.br
 Realmente Seguro? http://secure.eth0.eti.br
 Talk is cheap. Show me the code. - Linus Torvalds



-- 
Serrano Neves - a.k.a eth0 / www.eth0.eti.br
Realmente Seguro? http://secure.eth0.eti.br
Talk is cheap. Show me the code. - Linus Torvalds

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread Michel Meyers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

John Steel wrote:
 Is this possible? There is a dedicated MySQL server on the LAN which 
 isn't the same as the one which will run bacula (with the tape in).
 I built and ran it fine on my home server and noticed it pulling in the 
 MySQL headers etc, but that server hosted everything (RH6).

It is certainly possible to have the MySQL base on a different server,
check out the manual:

http://www.bacula.org/rel-manual/FileSet_Resource.html#SECTION00159

You may also have to adapt the make_bacula_tables (and similar) scripts
before running them.

The fact that Bacula pulls in the MySQL headers when compiling is
normal, without them, it wouldn't be able to 'speak MySQL'.

Greetings,
Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFGJiES2Vs+MkscAyURAgshAJ9KQkmd/kzKpNAzZ+hjeGsTLZoeaACeMzoc
SfJtGL1HWj8lgDp7J3B+Blo=
=oj5+
-END PGP SIGNATURE-

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread John Steel
Is this possible? There is a dedicated MySQL server on the LAN which 
isn't the same as the one which will run bacula (with the tape in).
I built and ran it fine on my home server and noticed it pulling in the 
MySQL headers etc, but that server hosted everything (RH6).
Now I'm getting familiar with bacula I want to do the same in the 
office, which has the setup I described. Thanks.

-- 
--
http://www.phonewebcam.com
[EMAIL PROTECTED]


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Need suggestion for backup sol

2007-04-18 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Should work fine. Not 100% sure what you mean by open file backup if
possible with Windows XP. Does that mean the backup of open files, or
opening the backup files?

Either way, the former is possible, the latter is not.

=R

nilesh vaghela wrote:
 Dear All,
 
 I have following requirement for backup purpose.
 
 Presently handling the backup with script with rsync, smb and ssh with cygwin.
 
 # Need to take backup of selected directory from window xp, windows 2000 and 
 98.
 # The size of the network is 300 pc.
 # maximum 2 gb per user.
 # Need to support incremental and full backup.
 # Schedule list.
 # Mostly backup will be on HDD or Raid not on tape / dlt.
 # Exclude and include file list.
 # Find or search for the file and than backup the find or searched file.
 # Open file backup if possible with windows xp.
 # I do not want to share the windows xp drive.
 # we do have few linux server need to backup.
 
 Please suggest for BACULA
 
 Thanx
 
 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGJiZQmb+gadEcsb4RAoVbAJ4nBm6M7qQqfaNCavzMFdF46jlaDgCg4vR9
FD3naNAdcHD4JPfyYmjEw20=
=AzuY
-END PGP SIGNATURE-


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula windows director

2007-04-18 Thread Живко Нейчев
I have problem with starting of bacula director under windows XP. I installed 
bacula like server and after that, bacula storage servise started correct but 
director didn't.
The ERROR when I tried to start Director is something like this: The service 
can't start under local machine
Thanks in advance.

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
 Hi all,

 I have instaled Bacula on Freebsd 6.2. When i try to run job i get an error

 Job failed.
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
 sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed:
 attempt to write a readonly database
 18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000)
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
 sql_create.c:522 Create DB Client record INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
 readonly database

 The owner of bacula.db is bacula user, and have write and read permission.

 I found a similar user report about this problem
 (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
 solution at this moment.

 Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?

 Thanks

Almost certainly a user or permissions problem. How is bacula-director 
configured to run with regard to user  group? I'll bet it is not the same as 
the owner/group of bacula.db.

Cheers!

cmr
-- 
Debian 'Etch' - Registered Linux User #241964

More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

John Steel wrote:
 Is this possible? There is a dedicated MySQL server on the LAN which 
 isn't the same as the one which will run bacula (with the tape in).
 I built and ran it fine on my home server and noticed it pulling in the 
 MySQL headers etc, but that server hosted everything (RH6).
 Now I'm getting familiar with bacula I want to do the same in the 
 office, which has the setup I described. Thanks.

It is possible, just a bit more difficult. I haven't done it personally.
There may be information in the manual, but I'm not sure.

- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer III
 |$| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGJip8mb+gadEcsb4RAtBqAKCn3Hl1dD4x5pvLycigWshjmSMbsgCgvm/L
pkHEQqS31unagrC6oYdeMEk=
=TX46
-END PGP SIGNATURE-


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
See

# ps axu|grep bacula
bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01 grep bacula


# ls -l /var/db/bacula/bacula.db
-rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26 /var/db/bacula/bacula.db

2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
  Hi all,
 
  I have instaled Bacula on Freebsd 6.2. When i try to run job i get an error
 
  Job failed.
  18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
  sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000) failed:
  attempt to write a readonly database
  18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000)
  18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
  sql_create.c:522 Create DB Client record INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
  readonly database
 
  The owner of bacula.db is bacula user, and have write and read permission.
 
  I found a similar user report about this problem
  (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
  solution at this moment.
 
  Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
 
  Thanks

 Almost certainly a user or permissions problem. How is bacula-director
 configured to run with regard to user  group? I'll bet it is not the same as
 the owner/group of bacula.db.

 Cheers!

 cmr
 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users



-- 
Giancarlo Rubio
(041) 9192-5042

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
 See

 # ps axu|grep bacula
 bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
 root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
 /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
 bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
 /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
 root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01 grep
 bacula


 # ls -l /var/db/bacula/bacula.db
 -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26 /var/db/bacula/bacula.db

What are the permissions  ownership of the directories along the path to 
bacula.db (var, db, bacula)? 

cmr

 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
  On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
   Hi all,
  
   I have instaled Bacula on Freebsd 6.2. When i try to run job i get an
   error
  
   Job failed.
   18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
   sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
   (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
   ('gian-fd','',1,2592000,15552000) failed:
   attempt to write a readonly database
   18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
   (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
   ('gian-fd','',1,2592000,15552000)
   18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
   sql_create.c:522 Create DB Client record INSERT INTO Client
   (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
   ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
   readonly database
  
   The owner of bacula.db is bacula user, and have write and read
   permission.
  
   I found a similar user report about this problem
   (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
   solution at this moment.
  
   Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
  
   Thanks
 
  Almost certainly a user or permissions problem. How is bacula-director
  configured to run with regard to user  group? I'll bet it is not the
  same as the owner/group of bacula.db.
 
  Cheers!
 
  cmr
  --
  Debian 'Etch' - Registered Linux User #241964
  
  More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
 
  -
  This SF.net email is sponsored by DB2 Express
  Download DB2 Express C - the FREE version of DB2 express and take
  control of your XML. No limits. Just data. Click to get it now.
  http://sourceforge.net/powerbar/db2/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Debian 'Etch' - Registered Linux User #241964

More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula


2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
  See
 
  # ps axu|grep bacula
  bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
  /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
  root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
  /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
  bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
  /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
  root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01 grep
  bacula
 
 
  # ls -l /var/db/bacula/bacula.db
  -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26 /var/db/bacula/bacula.db

 What are the permissions  ownership of the directories along the path to
 bacula.db (var, db, bacula)?

 cmr

  2007/4/18, C M Reinehr [EMAIL PROTECTED]:
   On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
   
I have instaled Bacula on Freebsd 6.2. When i try to run job i get an
error
   
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
   
The owner of bacula.db is bacula user, and have write and read
permission.
   
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
   
Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
   
Thanks
  
   Almost certainly a user or permissions problem. How is bacula-director
   configured to run with regard to user  group? I'll bet it is not the
   same as the owner/group of bacula.db.
  
   Cheers!
  
   cmr
   --
   Debian 'Etch' - Registered Linux User #241964
   
   More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
  
   -
   This SF.net email is sponsored by DB2 Express
   Download DB2 Express C - the FREE version of DB2 express and take
   control of your XML. No limits. Just data. Click to get it now.
   http://sourceforge.net/powerbar/db2/
   ___
   Bacula-users mailing list
   Bacula-users@lists.sourceforge.net
   https://lists.sourceforge.net/lists/listinfo/bacula-users

 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users



-- 
Giancarlo Rubio
(041) 9192-5042

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Spaces in file names in FileSet directive.

2007-04-18 Thread Johan Ehnberg
Thomas Glatthor wrote:
 with bacula 2.0.3 and double quotes it works on linux.
 i get no error for this path:
 
   File = /home/thomas/thomas test
 
 
 restore:
 Enter done to leave this mode.

 cwd is: /
 $ cd /home/thomas
 cwd is: /home/thomas/
 $ ls
 Desktop/
 thomas test/
 $ mark thomas test
 No files marked.
 $ mark thomas test
 2 files marked.
 $ lsmark
 *thomas test/
 *hallo
 $ unmark thomas test
 2 files unmarked.
 $ mark thomas\ test
 2 files marked.
 $ 
 
 
 regards
 
 thomas
 
 David Michal schrieb:
 I was trying to close the path to double quotes, but didn't help.
 Today
 I'll try to have the path like: /root/vmware/Win2003\ VM ,  but I'm
 only
 guesing how the syntax is.



 Please anybody know how to define path with space in name?

 Put quotes aroud it. That's the standard way in the unix world, which
 doesn't really (traditionally) like spaces in filenames.

   File = /root/vmware/Win2003 VM

 Cheers,
 Johan
 Well, as I wrote, I did that already and it didn't work.
 David

Can you do other operations successfully with that path? Such as 'cd' or 
'cat'? Is there a space after it? What is the error message when you 
have the double quotes?

/johan

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
 # ls -ll /var/db/|grep bacula
 drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula

What are the permissions of /var/db and /var?

Also, just as an experiment, you might reconfigure bacula-director to run as 
root:root. If it works then you know it's a permissions/ownerwhip problem 
somewhere. If not, then we're on the wrong track and need to take a closer 
look at bacula.db.

HTH

cmr

 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
  On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
   See
  
   # ps axu|grep bacula
   bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
   /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
   root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
   /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
   bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
   /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
   root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01 grep
   bacula
  
  
   # ls -l /var/db/bacula/bacula.db
   -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
   /var/db/bacula/bacula.db
 
  What are the permissions  ownership of the directories along the path to
  bacula.db (var, db, bacula)?
 
  cmr
 
   2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
 Hi all,

 I have instaled Bacula on Freebsd 6.2. When i try to run job i get
 an error

 Job failed.
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
 error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed:
 attempt to write a readonly database
 18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000)
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
 sql_create.c:522 Create DB Client record INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
 readonly database

 The owner of bacula.db is bacula user, and have write and read
 permission.

 I found a similar user report about this problem
 (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
 solution at this moment.

 Is a FreeBSD problem on sqlite?? Have anyone running bacula on
 FreeBSD?

 Thanks
   
Almost certainly a user or permissions problem. How is
bacula-director configured to run with regard to user  group? I'll
bet it is not the same as the owner/group of bacula.db.
   
Cheers!
   
cmr
--
Debian 'Etch' - Registered Linux User #241964

More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
   
-
    This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
 
  --
  Debian 'Etch' - Registered Linux User #241964
  
  More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
 
  -
  This SF.net email is sponsored by DB2 Express
  Download DB2 Express C - the FREE version of DB2 express and take
  control of your XML. No limits. Just data. Click to get it now.
  http://sourceforge.net/powerbar/db2/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Debian 'Etch' - Registered Linux User #241964

More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
Running as root bacula works good.
It's a bug on bacula??

2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
  # ls -ll /var/db/|grep bacula
  drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula

 What are the permissions of /var/db and /var?

 Also, just as an experiment, you might reconfigure bacula-director to run as
 root:root. If it works then you know it's a permissions/ownerwhip problem
 somewhere. If not, then we're on the wrong track and need to take a closer
 look at bacula.db.

 HTH

 cmr

  2007/4/18, C M Reinehr [EMAIL PROTECTED]:
   On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
   
# ps axu|grep bacula
bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01 grep
bacula
   
   
# ls -l /var/db/bacula/bacula.db
-rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
/var/db/bacula/bacula.db
  
   What are the permissions  ownership of the directories along the path to
   bacula.db (var, db, bacula)?
  
   cmr
  
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
  Hi all,
 
  I have instaled Bacula on Freebsd 6.2. When i try to run job i get
  an error
 
  Job failed.
  18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
  error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000) failed:
  attempt to write a readonly database
  18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000)
  18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
  sql_create.c:522 Create DB Client record INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
  readonly database
 
  The owner of bacula.db is bacula user, and have write and read
  permission.
 
  I found a similar user report about this problem
  (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
  solution at this moment.
 
  Is a FreeBSD problem on sqlite?? Have anyone running bacula on
  FreeBSD?
 
  Thanks

 Almost certainly a user or permissions problem. How is
 bacula-director configured to run with regard to user  group? I'll
 bet it is not the same as the owner/group of bacula.db.

 Cheers!

 cmr
 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
  
   --
   Debian 'Etch' - Registered Linux User #241964
   
   More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
  
   -
   This SF.net email is sponsored by DB2 Express
   Download DB2 Express C - the FREE version of DB2 express and take
   control of your XML. No limits. Just data. Click to get it now.
   http://sourceforge.net/powerbar/db2/
   ___
   Bacula-users mailing list
   Bacula-users@lists.sourceforge.net
   https://lists.sourceforge.net/lists/listinfo/bacula-users

 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users



-- 
Giancarlo Rubio
(041) 9192-5042


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Giancarlo Rubio wrote:
 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
 # ls -ll /var/db/|grep bacula
 drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
 What are the permissions of /var/db and /var?

 Also, just as an experiment, you might reconfigure bacula-director to run as
 root:root. If it works then you know it's a permissions/ownerwhip problem
 somewhere. If not, then we're on the wrong track and need to take a closer
 look at bacula.db.

 Running as root bacula works good.
 It's a bug on bacula??

Things working as root and not working as other users can almost never
be bugs in Bacula. It's probably best not to suggest that it's a bug at
the drop of a hat, as it tends to piss off developers and others from
whom you might want help. :)

 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
 See

 # ps axu|grep bacula
 bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
 root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
 /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
 bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
 /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
 root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01 grep
 bacula


 # ls -l /var/db/bacula/bacula.db
 -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
 /var/db/bacula/bacula.db
 What are the permissions  ownership of the directories along the path to
 bacula.db (var, db, bacula)?

 cmr

 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
 Hi all,

 I have instaled Bacula on Freebsd 6.2. When i try to run job i get
 an error

 Job failed.
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
 error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed:
 attempt to write a readonly database
 18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000)
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
 sql_create.c:522 Create DB Client record INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
 readonly database

 The owner of bacula.db is bacula user, and have write and read
 permission.

 I found a similar user report about this problem
 (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
 solution at this moment.

 Is a FreeBSD problem on sqlite?? Have anyone running bacula on
 FreeBSD?

 Thanks
 Almost certainly a user or permissions problem. How is
 bacula-director configured to run with regard to user  group? I'll
 bet it is not the same as the owner/group of bacula.db.

 Cheers!

 cmr
 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
  This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

 
 

- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer III
 |$| |__| |  | |__/ | \| _| |[EMAIL 

Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread John Stoffel

John Is this possible? 

Yup, it's possible.  I have it setup just this way on my home
network.  Unfortunately, it's not supported right out of the box.

John There is a dedicated MySQL server on the LAN which isn't the
John same as the one which will run bacula (with the tape in).  I
John built and ran it fine on my home server and noticed it pulling
John in the MySQL headers etc, but that server hosted everything
John (RH6).  Now I'm getting familiar with bacula I want to do the
John same in the office, which has the setup I described. Thanks.

You need to make some tweaks to a couple of scripts and configuration
settings, so that you use the mysql '-h hostname' option.  

Let's see, I hacked the /etc/bacula/scripts/make_catalog_backup to
take a fourth parameter, which is the hostname of the system to
contact for mysql backups.

In the Catalog { ... } definition in the bacula-dir.conf I had to add
the line DB Address = hostname 

I think that was it really.

John

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
 Running as root bacula works good.
 It's a bug on bacula??

No, it means that user/group bacula:bacula can not 
access /var/db/bacula/bacula.db but user/group root:root can. So, as I said 
earlier, you have a permissions problem somewhere along the path.

cmr

 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
  On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
   # ls -ll /var/db/|grep bacula
   drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
 
  What are the permissions of /var/db and /var?
 
  Also, just as an experiment, you might reconfigure bacula-director to run
  as root:root. If it works then you know it's a permissions/ownerwhip
  problem somewhere. If not, then we're on the wrong track and need to take
  a closer look at bacula.db.
 
  HTH
 
  cmr
 
   2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
 See

 # ps axu|grep bacula
 bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
 root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
 /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
 bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
 /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
 root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01
 grep bacula


 # ls -l /var/db/bacula/bacula.db
 -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
 /var/db/bacula/bacula.db
   
What are the permissions  ownership of the directories along the
path to bacula.db (var, db, bacula)?
   
cmr
   
 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
  On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
   Hi all,
  
   I have instaled Bacula on Freebsd 6.2. When i try to run job i
   get an error
  
   Job failed.
   18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
   error: sql_create.c:520 sql_create.c:520 insert INSERT INTO
   Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
   ('gian-fd','',1,2592000,15552000) failed:
   attempt to write a readonly database
   18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
   Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
   ('gian-fd','',1,2592000,15552000)
   18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
   sql_create.c:522 Create DB Client record INSERT INTO Client
   (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
   ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write
   a readonly database
  
   The owner of bacula.db is bacula user, and have write and read
   permission.
  
   I found a similar user report about this problem
   (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but
   no solution at this moment.
  
   Is a FreeBSD problem on sqlite?? Have anyone running bacula on
   FreeBSD?
  
   Thanks
 
  Almost certainly a user or permissions problem. How is
  bacula-director configured to run with regard to user  group?
  I'll bet it is not the same as the owner/group of bacula.db.
 
  Cheers!
 
  cmr
  --
  Debian 'Etch' - Registered Linux User #241964
  
  More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
 
  -
   This SF.net email is sponsored by DB2 Express
  Download DB2 Express C - the FREE version of DB2 express and take
  control of your XML. No limits. Just data. Click to get it now.
  http://sourceforge.net/powerbar/db2/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
   
--
Debian 'Etch' - Registered Linux User #241964

More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
   
-
    This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
 
  --
  Debian 'Etch' - Registered Linux User #241964
  
  More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
 
  -
  This SF.net email is sponsored by DB2 Express
  Download DB2 Express C - the FREE version of DB2 express and take
  

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
It's not permission problem for the user bacula see

# su - bacula
$ echo teste  /var/db/bacula/bacula.test (user have write
permission on this folder)
$ sqlite3 /var/db/bacula/bacula.db
SQLite version 3.3.15
Enter .help for instructions
sqlite  INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18
09:11:42',1176898302);
sqlite select * from Job;
1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18
09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0
sqlite .quit

User have write permission on bacula.db

Giancarlo Rubio

2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
  Running as root bacula works good.
  It's a bug on bacula??

 No, it means that user/group bacula:bacula can not
 access /var/db/bacula/bacula.db but user/group root:root can. So, as I said
 earlier, you have a permissions problem somewhere along the path.

 cmr

  2007/4/18, C M Reinehr [EMAIL PROTECTED]:
   On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
  
   What are the permissions of /var/db and /var?
  
   Also, just as an experiment, you might reconfigure bacula-director to run
   as root:root. If it works then you know it's a permissions/ownerwhip
   problem somewhere. If not, then we're on the wrong track and need to take
   a closer look at bacula.db.
  
   HTH
  
   cmr
  
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
  See
 
  # ps axu|grep bacula
  bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM   0:00.03
  /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
  root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM   0:00.03
  /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
  bacula49009  0.0  0.9  4248  2048  ??  Ss   11:26AM   0:00.04
  /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
  root  49024  0.0  0.4  1592   900  p1  S+   11:27AM   0:00.01
  grep bacula
 
 
  # ls -l /var/db/bacula/bacula.db
  -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
  /var/db/bacula/bacula.db

 What are the permissions  ownership of the directories along the
 path to bacula.db (var, db, bacula)?

 cmr

  2007/4/18, C M Reinehr [EMAIL PROTECTED]:
   On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
   
I have instaled Bacula on Freebsd 6.2. When i try to run job i
get an error
   
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
error: sql_create.c:520 sql_create.c:520 insert INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write
a readonly database
   
The owner of bacula.db is bacula user, and have write and read
permission.
   
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but
no solution at this moment.
   
Is a FreeBSD problem on sqlite?? Have anyone running bacula on
FreeBSD?
   
Thanks
  
   Almost certainly a user or permissions problem. How is
   bacula-director configured to run with regard to user  group?
   I'll bet it is not the same as the owner/group of bacula.db.
  
   Cheers!
  
   cmr
   --
   Debian 'Etch' - Registered Linux User #241964
   
   More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
  
   -
    This SF.net email is sponsored by DB2 Express
   Download DB2 Express C - the FREE version of DB2 express and take
   control of your XML. No limits. Just data. Click to get it now.
   http://sourceforge.net/powerbar/db2/
   ___
   Bacula-users mailing list
   Bacula-users@lists.sourceforge.net
   https://lists.sourceforge.net/lists/listinfo/bacula-users

 --
 Debian 'Etch' - Registered Linux User #241964
 
 More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC

 

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 11:34, Giancarlo Rubio wrote:
 It's not permission problem for the user bacula see

 # su - bacula
 $ echo teste  /var/db/bacula/bacula.test (user have write
 permission on this folder)
 $ sqlite3 /var/db/bacula/bacula.db
 SQLite version 3.3.15
 Enter .help for instructions
 sqlite  INSERT INTO Job
 (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
 ('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18
 09:11:42',1176898302);
 sqlite select * from Job;
 1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18
 09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0
 sqlite .quit

 User have write permission on bacula.db

 Giancarlo Rubio

This makes a very good argument that it is _not_ a permission problem, but on 
the other hand, it is very unlikely to be a bug in bacula. (Since I am not 
running FreeBSD anything I say at this point is a guess.) This certainly 
looks similar to the problem report that you indicated at the beginning of 
this thread and could be some kind of weird problem owing to a combination of 
FreeBSD, Sqlite3  Bacula.

To the best of my knowledge there is no built-in database security in Sqlite. 
If you have write permission on the file you have write permission on the 
database.

Let's make one more test before we shout bug. Please set the permissions on 
bacula.db to 666 (read/write for all) and see what happens.

And, while we're at it. What version of Bacula and FreeBSD are you using? Is 
Bacula from a package or did you roll your own?

Cheers!

cmr

 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
  On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
   Running as root bacula works good.
   It's a bug on bacula??
 
  No, it means that user/group bacula:bacula can not
  access /var/db/bacula/bacula.db but user/group root:root can. So, as I
  said earlier, you have a permissions problem somewhere along the path.
 
  cmr
 
   2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
 # ls -ll /var/db/|grep bacula
 drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
   
What are the permissions of /var/db and /var?
   
Also, just as an experiment, you might reconfigure bacula-director to
run as root:root. If it works then you know it's a
permissions/ownerwhip problem somewhere. If not, then we're on the
wrong track and need to take a closer look at bacula.db.
   
HTH
   
cmr
   
 2007/4/18, C M Reinehr [EMAIL PROTECTED]:
  On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
   See
  
   # ps axu|grep bacula
   bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM  
   0:00.03 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c
   /usr/ root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM  
   0:00.03 /usr/local/sbin/bacula-fd -u root -g wheel -v -c
   /usr/loca bacula49009  0.0  0.9  4248  2048  ??  Ss  
   11:26AM   0:00.04 /usr/local/sbin/bacula-sd -u bacula -g bacula
   -v -c /usr/l root  49024  0.0  0.4  1592   900  p1  S+  
   11:27AM   0:00.01 grep bacula
  
  
   # ls -l /var/db/bacula/bacula.db
   -rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
   /var/db/bacula/bacula.db
 
  What are the permissions  ownership of the directories along the
  path to bacula.db (var, db, bacula)?
 
  cmr
 
   2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
 Hi all,

 I have instaled Bacula on Freebsd 6.2. When i try to run
 job i get an error

 Job failed.
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
 Fatal error: sql_create.c:520 sql_create.c:520 insert
 INSERT INTO Client
 (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
 ('gian-fd','',1,2592000,15552000) failed:
 attempt to write a readonly database
 18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
 Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
 VALUES ('gian-fd','',1,2592000,15552000)
 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
 Error: sql_create.c:522 Create DB Client record INSERT INTO
 Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
 VALUES ('gian-fd','',1,2592000,15552000) failed.
 ERR=attempt to write a readonly database

 The owner of bacula.db is bacula user, and have write and
 read permission.

 I found a similar user report about this problem
 (http://permalink.gmane.org/gmane.comp.bacula.user/15367) ,
 but no solution at this moment.

 Is a FreeBSD problem on sqlite?? Have anyone running bacula
 on FreeBSD?

 Thanks
   
Almost certainly a user or permissions problem. How is
bacula-director configured to 

Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread John Steel
John Stoffel wrote:
 In the Catalog { ... } definition in the bacula-dir.conf I had to add
 the line DB Address = hostname 

 I think that was it really.

 John

   
Thanks, and that will be great for running it. But I'm more concerned 
about the build. will ./configure --with-mysql work with no mysql-devel 
etc on the machine?
Do you have to temporarily do a full install of MySQL (  devel) ?

-- 
--
http://www.phonewebcam.com
[EMAIL PROTECTED]


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
its' a problem when creating tables
/usr/local/share/bacula/make_sqlite3_tables
When create table the permission are set to user root and group bacula
ls -ll
-rw-r-  1 rootbacula  49152 Apr 18 15:20 bacula.db

I have changed tto user bacula and group bacula and restarted bacula director.
I prepare to submit a bug report to this port to freebsd

Thank's all for atention

Giancarlo Rubio

2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 11:34, Giancarlo Rubio wrote:
  It's not permission problem for the user bacula see
 
  # su - bacula
  $ echo teste  /var/db/bacula/bacula.test (user have write
  permission on this folder)
  $ sqlite3 /var/db/bacula/bacula.db
  SQLite version 3.3.15
  Enter .help for instructions
  sqlite  INSERT INTO Job
  (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
  ('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18
  09:11:42',1176898302);
  sqlite select * from Job;
  1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18
  09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0
  sqlite .quit
 
  User have write permission on bacula.db
 
  Giancarlo Rubio

 This makes a very good argument that it is _not_ a permission problem, but on
 the other hand, it is very unlikely to be a bug in bacula. (Since I am not
 running FreeBSD anything I say at this point is a guess.) This certainly
 looks similar to the problem report that you indicated at the beginning of
 this thread and could be some kind of weird problem owing to a combination of
 FreeBSD, Sqlite3  Bacula.

 To the best of my knowledge there is no built-in database security in Sqlite.
 If you have write permission on the file you have write permission on the
 database.

 Let's make one more test before we shout bug. Please set the permissions on
 bacula.db to 666 (read/write for all) and see what happens.

 And, while we're at it. What version of Bacula and FreeBSD are you using? Is
 Bacula from a package or did you roll your own?

 Cheers!

 cmr

  2007/4/18, C M Reinehr [EMAIL PROTECTED]:
   On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
Running as root bacula works good.
It's a bug on bacula??
  
   No, it means that user/group bacula:bacula can not
   access /var/db/bacula/bacula.db but user/group root:root can. So, as I
   said earlier, you have a permissions problem somewhere along the path.
  
   cmr
  
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
  # ls -ll /var/db/|grep bacula
  drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula

 What are the permissions of /var/db and /var?

 Also, just as an experiment, you might reconfigure bacula-director to
 run as root:root. If it works then you know it's a
 permissions/ownerwhip problem somewhere. If not, then we're on the
 wrong track and need to take a closer look at bacula.db.

 HTH

 cmr

  2007/4/18, C M Reinehr [EMAIL PROTECTED]:
   On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
   
# ps axu|grep bacula
bacula48990  0.0  1.2  4732  2600  ??  Ss   11:26AM
0:00.03 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c
/usr/ root  48998  0.0  0.9  3952  1952  ??  Ss   11:26AM
0:00.03 /usr/local/sbin/bacula-fd -u root -g wheel -v -c
/usr/loca bacula49009  0.0  0.9  4248  2048  ??  Ss
11:26AM   0:00.04 /usr/local/sbin/bacula-sd -u bacula -g bacula
-v -c /usr/l root  49024  0.0  0.4  1592   900  p1  S+
11:27AM   0:00.01 grep bacula
   
   
# ls -l /var/db/bacula/bacula.db
-rw-r--r--  1 bacula  bacula  49152 Apr 18 11:26
/var/db/bacula/bacula.db
  
   What are the permissions  ownership of the directories along the
   path to bacula.db (var, db, bacula)?
  
   cmr
  
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
 On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
  Hi all,
 
  I have instaled Bacula on Freebsd 6.2. When i try to run
  job i get an error
 
  Job failed.
  18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
  Fatal error: sql_create.c:520 sql_create.c:520 insert
  INSERT INTO Client
  (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
  ('gian-fd','',1,2592000,15552000) failed:
  attempt to write a readonly database
  18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
  Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
  VALUES ('gian-fd','',1,2592000,15552000)
  18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
  Error: sql_create.c:522 Create DB Client record INSERT INTO
  Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
  VALUES ('gian-fd','',1,2592000,15552000) failed.
  ERR=attempt to write 

Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread Michel Meyers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

John Steel wrote:
 Thanks, and that will be great for running it. But I'm more concerned 
 about the build. will ./configure --with-mysql work with no mysql-devel 
 etc on the machine?

No, you will need mysql-devel to compile in MySQL support.

 Do you have to temporarily do a full install of MySQL (  devel) ?

You normally don't need MySQL to install the -dev packages (at least
that's not the case on my distro).

Greetings,
   Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFGJmua2Vs+MkscAyURAhIxAKC73iKjbJ9wx9tbpOiWannkWHMyewCgrwzP
wZQFWWS4lOHNT+Fvia5G8JI=
=OKp1
-END PGP SIGNATURE-

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Volume Files Mismatch (not the common case)

2007-04-18 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey all,

Got a quick question, Bacula 2.0.3 on all machines, director on Solaris 9.

We had a number of unscheduled power outages where the machine went down
relatively hard (we have a UPS but it does not currently communicate
with this machine).

I booted it back up and tried to run the next day's backup -- note the
drive was NOT in use when the downtime happened, and the worst case is
that the drive was mounted (in fact, it's very likely that it was). When
I attempt to backup, I get the volume files mismatched... only the
catalog contains 1 file and the volume contains 5. I'm not sure where to
go from here, as I've never really seen it be off by that much.

What would you do next if you were me? Scrap the tape and do new
backups? bscan?

Thanks for your help!
- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer III
 |$| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGJngkmb+gadEcsb4RAs/4AJ46loz2nRNZc3Rrlt24/4n55vBmJQCg0GTx
ImgTOoAeide4xW/ScHJ9e4M=
=FAsP
-END PGP SIGNATURE-


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Volume Files Mismatch (not the common case)

2007-04-18 Thread Arno Lehmann
Hi,

On 4/18/2007 9:57 PM, Ryan Novosielski wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Hey all,
 
 Got a quick question, Bacula 2.0.3 on all machines, director on Solaris 9.
 
 We had a number of unscheduled power outages where the machine went down
 relatively hard (we have a UPS but it does not currently communicate
 with this machine).

Relatively hard... interesting choice of word :-)

 I booted it back up and tried to run the next day's backup -- note the
 drive was NOT in use when the downtime happened, and the worst case is
 that the drive was mounted (in fact, it's very likely that it was). When
 I attempt to backup, I get the volume files mismatched... only the
 catalog contains 1 file and the volume contains 5. I'm not sure where to
 go from here, as I've never really seen it be off by that much.

Have you checked that the database is ok?

 What would you do next if you were me? Scrap the tape and do new
 backups? bscan?

Yup, bscan and compare with what the tape should hold according to the 
catalog.

 
 Thanks for your help!

Good luck... ok, if it's only one tape there is not much trouble :-)

Arno

 - --
   _  _ _  _ ___  _  _  _
  |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer III
  |$| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
  \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.5 (MingW32)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
 iD8DBQFGJngkmb+gadEcsb4RAs/4AJ46loz2nRNZc3Rrlt24/4n55vBmJQCg0GTx
 ImgTOoAeide4xW/ScHJ9e4M=
 =FAsP
 -END PGP SIGNATURE-
 
 
 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Using a hard drive library of 5 disks as a backup drive

2007-04-18 Thread David Lebel

Hello,

we currently use Bacula with a series of hard drive mounted into disk trays
that we swap and mount on the same mount point using a Media Type of File
and mounting the disk on /backup.  We labeled 6 of such disks to be used and
swapped when needed. This setup has been working great for the past year or
so.  Now, we need more space and bought a Sonnet Fusion 500P with a eSATA
controller and intend on putting 5 hard drive in the 5 slot library and use
those disks as if they were into an auto-changer.

As they say, hard drives are cheap now, so why now use them?  I've been
thinking on a few ways to do it, but I'm wondering if other did it too?

Let assume we have a directory structure like that:

/library/slot1
/library/slot2
/library/slot3
/library/slot4
/library/slot5

Each of those mount points would have a hard drive mounted on it. Let assume
we have a rotation of 10 hard drives.

Now, bacula-sd.conf would only have ONE device configured into it:

Device {
 Name = FileStorage
 Media Type = File
 Archive Device = /backup
 LabelMedia = yes;
 Random Access = Yes;
 AutomaticMount = yes;
 RemovableMedia = no;
 AlwaysOpen = yes;
}

And /backup would be defined on the OS level as a symlink to the current
slot, let assume for this example, to /drive
then, have the system just switch the /backup directory/symlink around the 5
drives, let say, /library/slot2 where a hard drive would be mounted.

Would that work?

PS: first language isn't English, so bear with me here :)

--
// david lebel [EMAIL PROTECTED]
// http://www.lebel.org/
// pgp: 3633 6999 D47E 73ED 099F  4341 08A4 8E48 EF56 61D1
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Volume Files Mismatch (not the common case)

2007-04-18 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Arno Lehmann wrote:
 Hi,
 
 On 4/18/2007 9:57 PM, Ryan Novosielski wrote:
 Hey all,
 
 Got a quick question, Bacula 2.0.3 on all machines, director on Solaris 9.
 
 We had a number of unscheduled power outages where the machine went down
 relatively hard (we have a UPS but it does not currently communicate
 with this machine).
 
 Relatively hard... interesting choice of word :-)

Was an interesting series of seemingly-hourly power failures. :)

 I booted it back up and tried to run the next day's backup -- note the
 drive was NOT in use when the downtime happened, and the worst case is
 that the drive was mounted (in fact, it's very likely that it was). When
 I attempt to backup, I get the volume files mismatched... only the
 catalog contains 1 file and the volume contains 5. I'm not sure where to
 go from here, as I've never really seen it be off by that much.
 
 Have you checked that the database is ok?

I just did a mysqlcheck -A -- another backup is currently running, and
the only thing I got is many warnings:

# ./mysqlcheck -A -u bacula -p
Enter password:
bacula.BaseFiles   OK
bacula.CDImagesOK
bacula.Client
warning  : 4 clients are using or haven't closed the table properly
status   : OK
bacula.CountersOK
bacula.Device  OK
bacula.File
warning  : 16 clients are using or haven't closed the table properly
status   : OK
bacula.FileSet
warning  : 5 clients are using or haven't closed the table properly
status   : OK
bacula.Filename
warning  : 15 clients are using or haven't closed the table properly
status   : OK
bacula.Job
warning  : 3 clients are using or haven't closed the table properly
status   : OK
bacula.JobMedia
warning  : 3 clients are using or haven't closed the table properly
status   : OK
bacula.LocationOK
bacula.LocationLog
warning  : 1 client is using or hasn't closed the table properly
status   : OK
bacula.Log
warning  : 3 clients are using or haven't closed the table properly
status   : OK
bacula.Media
warning  : 3 clients are using or haven't closed the table properly
status   : OK
bacula.MediaType
warning  : 1 client is using or hasn't closed the table properly
status   : OK
bacula.Path
warning  : 12 clients are using or haven't closed the table properly
status   : OK
bacula.Pool
warning  : 5 clients are using or haven't closed the table properly
status   : OK
bacula.Status
warning  : 1 client is using or hasn't closed the table properly
status   : OK
bacula.Storage
warning  : 1 client is using or hasn't closed the table properly
status   : OK
bacula.UnsavedFilesOK
bacula.Version
warning  : 1 client is using or hasn't closed the table properly
status   : OK

Only one backup is running right now, though, so would you expect this
is something to be concerned about? I could restore a catalog backup I
suppose -- one theoretically kicked off at the end of the last
successful backup. Unfortunately at this point, that would likely mean
redoing/bscanning the backup that's currently running (~25GB).

 What would you do next if you were me? Scrap the tape and do new
 backups? bscan?
 
 Yup, bscan and compare with what the tape should hold according to the 
 catalog.

The manual says (and I'm considering copying Kern on this, because this
ought to be corrected regardless of what the current state is):

- ---
Using bscan to Compare a Volume to an existing Catalog

If you wish to compare the contents of a Volume to an existing catalog
without changing the catalog, you can safely do so if and only if you do
not specify either the -m or the -s options. However, at this time
(Bacula version 1.26), the comparison routines are not as good or as
thorough as they should be, so we don't particularly recommend this mode
other than for testing.
- ---

Has this been improved any, or should I still not really consider this
an option?

 Thanks for your help!
 
 Good luck... ok, if it's only one tape there is not much trouble :-)

Not only just one tape, but furthermore only one night of backups (7
incremental backups in all). Not really worth the trouble, except I
really should get myself an education in what to do for this type of
circumstance should I ever really need to know. Thanks!

- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer III
 |$| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGJoF1mb+gadEcsb4RAgOKAJwIO1Z1qbk5ktyHrS2UWbLTuDxDagCglIo9
hufuW1XRWbiX5WDtnLqk2Ds=
=uEv8
-END PGP SIGNATURE-


-
This 

Re: [Bacula-users] [Bacula-devel] Feature Request: Per-Client priorities

2007-04-18 Thread Darien Hager

On Apr 14, 2007, at 11:50 AM, Kern Sibbald wrote:

 would you re-write the Feature Request using my terminology and  
 resubmit it?

Uhm, okay. I'll try, although I'm not sure what terminology I'm missing.


 As I see it, you are asking to implement a Client Priority = nn  
 directive in
 addition to the current Priority.

 The current Priority will be applied to jobs as it currently is,  
 then in
 addition if two Jobs from the same Client have the same Priority but
 different Client Priority, the job with the higher Client priority  
 (lower
 number) will run first.

Exactly right. And from that it follows that (unlike current  
priority), the ability of a higher-priority job to block the  
execution of other jobs is limited to jobs on the same client,  
increasing efficiency when using concurrent jobs.

 Also, please clarify the the first part of your example (current  
 system with one
 priority) by showing the priorities and fictive start and stop wall  
 clock
 times for each job, and add to the second part of your example by  
 showing the
 two priorities for each job and fictive wall clock times when each  
 job starts
 and stops under the proposed two priority system.

=
=

Item 1:   Allow per-client job priority ordering
Origin: Darien Hager [EMAIL PROTECTED]
Date:   April 18 2007
Status: Revised Request

What:

Provide a Client Priority = nn directive for Jobs, similar to the  
current Priority directive. Default value is 10. This directive is  
applied only upon jobs which are slated to run after applying the  
currently-implemented Priority directive. Additionally, this  
directive only serves to order jobs which have the same Client  
directive.

Why:Some jobs may require a specific ordering, but  
specifically in the context of a particular client rather than more  
generally across the whole system of clients. The current system can  
satisfy this, but is susceptible to significant possible bottlenecks  
where a single lengthy job may result in many jobs being delayed and  
concurrent job capability being wasted.

Notes: (See example situations at bottom of message for timing examples)
=
=

--Darien A. Hager
[EMAIL PROTECTED]





=
=

===Default Example set-up:
* One director, one Storage Daemon, and 2 client machines.
* In the example, we mainly consider two client machines called  
alpha and beta.
* Concurrent jobs are enabled, 2 jobs at a time.
* Assumption: We cannot ensure any ordering using solely scheduled  
start times, and must rely on the Priority directive. Perhaps the  
amount of data on each client is highly variable, or there are  
actually many clients (too many to write examples for), etc.
* There are two jobs defined for each client, named with the pattern:
$CLIENTNAME-Database, Scheduled 01:00
$CLIENTNAME-Files, Scheduled 01:30

* Sysadmin requirement: All *-Database jobs must run before *-Files  
jobs (for any particular machine). Perhaps because the *-Files jobs  
back up log-files generated from the *-Database jobs, so executing  
them in the opposite order is undesirable. Alternative example set- 
ups could use Backups and Verify jobs, run-script behaviors on a  
client machine, etc.
* The client are designated Alpha and Beta.
===Example of bottleneck:

* Jobs Alpha-Database and Beta-Database have Priority=20 set.
* Jobs Alpha-Files and Beta-Files have Priority=21 set.
* These priority settings satisfy the sysadmin requirement.
* In this case, all *-Database jobs must complete before any *-Files  
jobs start.
* Alpha and Beta have different usage patterns, so their jobs take  
different times.

Concurrent jobs can be run, 2 at a time.

Time needed for each job, assuming no SD bottleneck:
Alpha-Database: 30 minutes
Alpha-Files:10 minutes
Beta-Database:  10 minutes
Beta-Files: 30 minutes


01:37:  Beginning of example:

01:37:  The system begins to process Priority=20 jobs
01:37:  The system looks for jobs to run.
01:37:  Alpha-Database is started
01:37:  Beta-Database is started
01:47:  Beta-Database completes (10m)
01:47:  No other jobs to start in same priority
02:07:  Alpha-Database completes (30m)

02:07:  The system begins to process Priority=21 jobs
02:07:  The system looks for jobs to run.
02:07:  Alpha-Files is started
02:07:  Beta-Files is started
02:17:  Alpha-Files completes (10m)
02:17:  No other jobs to start in same priority
02:37:  Beta-Files completes (30m)

02:37:  End of example period: 60 minutes elapsed



===Example using new functionality:
* All jobs run at the same default Priority=20
* Alpha-Database and Beta-Database have Client Priority=10
* Alpha-Files and Beta-Files have Client Priority=11
* All jobs' elapsed times match those given in the previous example,  
assuming no bottleneck in the 

Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread John Stoffel

John Thanks, and that will be great for running it. But I'm more
John concerned about the build. will ./configure --with-mysql work
John with no mysql-devel etc on the machine?  Do you have to
John temporarily do a full install of MySQL (  devel) ?

I doubt it will work, since you need the mysqllibs (at least) so that
you can connect to the remote DB.  But I'm honestly not sure, I just
installed mysql on my main machine but don't have it configured to
start or anything.  

Hmm... looking at my system more closely, I'm using Debian, with the
provided bacula packages, I think if you just have the mysql-client
stuff installed, you should be all set.  And/or the
libmysqlclient15dev packages.  

Good luck!

John

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Using a hard drive library of 5 disks as a backupdrive

2007-04-18 Thread Darien Hager


On Apr 18, 2007, at 1:15 PM, David Lebel wrote:


And /backup would be defined on the OS level as a symlink to the  
current slot, let assume for this example, to /drive
then, have the system just switch the /backup directory/symlink  
around the 5 drives, let say, /library/slot2 where a hard drive  
would be mounted.


Would that work?


I think it's certainly do-able.

Perhaps you could use the autochanger functionality... the Changer  
Command directive could call a script which would, instead of  
sending commands like load this tape, do things like create  
symlinks to the appropriate mountpoint.


http://www.bacula.org/rel-manual/Autochanger_Support.html
http://www.bacula.org/rel-manual/ 
Storage_Daemon_Configuratio.html#AutochangerRes






--
--Darien A. Hager
[EMAIL PROTECTED]


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Volume Files Mismatch (not the common case)

2007-04-18 Thread Arno Lehmann
Hi,

On 4/18/2007 10:37 PM, Ryan Novosielski wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Arno Lehmann wrote:
 Hi,

 On 4/18/2007 9:57 PM, Ryan Novosielski wrote:
...
 Have you checked that the database is ok?
 
 I just did a mysqlcheck -A -- another backup is currently running, and
 the only thing I got is many warnings:

Well, I don't know much about the internals of MySQL, but I don't think 
these warnings are serious.

As long as the database is ok from MySQLs point of view, I think that 
should be ok. You might consider running dbcheck, but I really don't 
think this will find corrupt, but consistent volume records...

 # ./mysqlcheck -A -u bacula -p
...
 Only one backup is running right now, though, so would you expect this
 is something to be concerned about? I could restore a catalog backup I
 suppose -- one theoretically kicked off at the end of the last
 successful backup. Unfortunately at this point, that would likely mean
 redoing/bscanning the backup that's currently running (~25GB).

Hmm. So it's one bscan vs. one bscan... difficult choice.

 What would you do next if you were me? Scrap the tape and do new
 backups? bscan?

 Yup, bscan and compare with what the tape should hold according to the 
 catalog.
 
 The manual says (and I'm considering copying Kern on this, because this
 ought to be corrected regardless of what the current state is):
 
 - ---
 Using bscan to Compare a Volume to an existing Catalog

Ah, there is some misunderstanding... I would do that comparison 
manually, i.e. finding which jobs actually are on tape, and which should 
be, according to the catalog.

If the first job on tape is what the catalog says it should be, bscan 
the tape. If it isn't, scratch it. And see if the job is known to the 
catalog...

I wouldn't do a more detailed analysis - too much work for just seven 
backups :-)

 If you wish to compare the contents of a Volume to an existing catalog
 without changing the catalog, you can safely do so if and only if you do
 not specify either the -m or the -s options. However, at this time
 (Bacula version 1.26), the comparison routines are not as good or as
 thorough as they should be, so we don't particularly recommend this mode
 other than for testing.
 - ---
 
 Has this been improved any, or should I still not really consider this
 an option?
 
 Thanks for your help!

 Good luck... ok, if it's only one tape there is not much trouble :-)
 
 Not only just one tape, but furthermore only one night of backups (7
 incremental backups in all). Not really worth the trouble, except I
 really should get myself an education in what to do for this type of
 circumstance should I ever really need to know.

Isn't that the reason why we all spend so much time thinking about 
problems, how to solve them, where to store bsrs of the catalog backups, 
etc? - Just to prepare for a moment that (hopefully) never happens, and 
if it does, it holds surprises nobody ever expected?

 Thanks!
 
 - --
   _  _ _  _ ___  _  _  _
  |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer III
  |$| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
  \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.5 (MingW32)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
 iD8DBQFGJoF1mb+gadEcsb4RAgOKAJwIO1Z1qbk5ktyHrS2UWbLTuDxDagCglIo9
 hufuW1XRWbiX5WDtnLqk2Ds=
 =uEv8
 -END PGP SIGNATURE-
 
 
 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread Dan Langille
On 18 Apr 2007 at 16:59, John Stoffel wrote:

 
 John Thanks, and that will be great for running it. But I'm more
 John concerned about the build. will ./configure --with-mysql work
 John with no mysql-devel etc on the machine?  Do you have to John
 temporarily do a full install of MySQL (  devel) ?
 
 I doubt it will work, since you need the mysqllibs (at least) so that
 you can connect to the remote DB.  But I'm honestly not sure, I just
 installed mysql on my main machine but don't have it configured to
 start or anything.  
 
 Hmm... looking at my system more closely, I'm using Debian, with the
 provided bacula packages, I think if you just have the mysql-client
 stuff installed, you should be all set.  And/or the
 libmysqlclient15dev packages.  

FWIW, on FreeBSD, the port will install the MySQL client on that box. 
Not the MySQL Server.

HTH.

-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php
PGCon - The PostgreSQL Conference - http://www.pgcon.org/



-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server

2007-04-18 Thread John Stoffel
 Dan == Dan Langille [EMAIL PROTECTED] writes:

Dan FWIW, on FreeBSD, the port will install the MySQL client on that
Dan box.  Not the MySQL Server.

Hey, whaddaya know, on Debian Unstable (etch maybe?  Gotta check my
sources some day...) bacula depends on mysqlclient12, which depends on
mysql-common, which is version 4.0.24 of mysql.  Neat!

Thanks for making to bother to look Dan.  

John

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Need suggestion for backup sol

2007-04-18 Thread nilesh vaghela

Windows xp had shadow copy option, we can take backup of open files. Mainly
mail box from outlook or outlook express.

If any body have similar setup please share your views.
thanx.

On 4/18/07, Ryan Novosielski [EMAIL PROTECTED] wrote:


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Should work fine. Not 100% sure what you mean by open file backup if
possible with Windows XP. Does that mean the backup of open files, or
opening the backup files?

Either way, the former is possible, the latter is not.

=R

nilesh vaghela wrote:
 Dear All,

 I have following requirement for backup purpose.

 Presently handling the backup with script with rsync, smb and ssh with
cygwin.

 # Need to take backup of selected directory from window xp, windows 2000
and 98.
 # The size of the network is 300 pc.
 # maximum 2 gb per user.
 # Need to support incremental and full backup.
 # Schedule list.
 # Mostly backup will be on HDD or Raid not on tape / dlt.
 # Exclude and include file list.
 # Find or search for the file and than backup the find or searched file.
 # Open file backup if possible with windows xp.
 # I do not want to share the windows xp drive.
 # we do have few linux server need to backup.

 Please suggest for BACULA

 Thanx


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGJiZQmb+gadEcsb4RAoVbAJ4nBm6M7qQqfaNCavzMFdF46jlaDgCg4vR9
FD3naNAdcHD4JPfyYmjEw20=
=AzuY
-END PGP SIGNATURE-


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users





--
Nilesh Vaghela
ElectroMech
Redhat Channel Partner and Training Partner
74, Nalanda Complex, Satellite Rd, Ahmedabad
25, The Emperor, Fatehgunj, Baroda.
www.electromech.info
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Need suggestion for backup sol

2007-04-18 Thread Troy Daniels
Bacula supports VSS aka Volume Shadow Copy Service so this shouldn't be a 
problem.

In fact, as far as I can see, Bacula is capable of filling all your needs.

It runs under both Linux and Windows and doesn't require drives be shared using 
smb.

Troy Daniels
Systems Admin.
iTouch Australia

nilesh vaghela wrote:
 Windows xp had shadow copy option, we can take backup of open files. 
 Mainly mail box from outlook or outlook express.
 
 If any body have similar setup please share your views.
 thanx.
 
 On 4/18/07, *Ryan Novosielski* [EMAIL PROTECTED] 
 mailto:[EMAIL PROTECTED] wrote:
 
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Should work fine. Not 100% sure what you mean by open file backup if
 possible with Windows XP. Does that mean the backup of open files, or
 opening the backup files?
 
 Either way, the former is possible, the latter is not.
 
 =R
 
 nilesh vaghela wrote:
   Dear All,
  
   I have following requirement for backup purpose.
  
   Presently handling the backup with script with rsync, smb and ssh
 with cygwin.
  
   # Need to take backup of selected directory from window xp,
 windows 2000 and 98.
   # The size of the network is 300 pc.
   # maximum 2 gb per user.
   # Need to support incremental and full backup.
   # Schedule list.
   # Mostly backup will be on HDD or Raid not on tape / dlt.
   # Exclude and include file list.
   # Find or search for the file and than backup the find or
 searched file.
   # Open file backup if possible with windows xp.
   # I do not want to share the windows xp drive.
   # we do have few linux server need to backup.
  
   Please suggest for BACULA
  
   Thanx
  
  
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.5 (MingW32)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
 iD8DBQFGJiZQmb+gadEcsb4RAoVbAJ4nBm6M7qQqfaNCavzMFdF46jlaDgCg4vR9
 FD3naNAdcHD4JPfyYmjEw20=
 =AzuY
 -END PGP SIGNATURE-
 
 
 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 mailto:Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 
 
 
 -- 
 Nilesh Vaghela
 ElectroMech
 Redhat Channel Partner and Training Partner
 74, Nalanda Complex, Satellite Rd, Ahmedabad
 25, The Emperor, Fatehgunj, Baroda.
 www.electromech.info http://www.electromech.info
 
 
 
 
 -
 This SF.net email is sponsored by DB2 Express
 Download DB2 Express C - the FREE version of DB2 express and take
 control of your XML. No limits. Just data. Click to get it now.
 http://sourceforge.net/powerbar/db2/
 
 
 
 
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Need suggestion for backup sol

2007-04-18 Thread nilesh vaghela

Thanx.

Let me test and let you know.
--
Nilesh Vaghela
ElectroMech
Redhat Channel Partner and Training Partner
74, Nalanda Complex, Satellite Rd, Ahmedabad
25, The Emperor, Fatehgunj, Baroda.
www.electromech.info
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users