[Bacula-users] full win32 version status

2006-06-07 Thread James Harper
What is the status of the 'full' (dir, fd, sd) win32 version?

I have a client using ntbackup and it sucks greatly.

Thanks

James


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Fwd: can't install properly on suse 9.0

2006-06-07 Thread veronica . hill
I thought I would try the Suse 9.1 RPM.  This did install!

Sorry to bother you all.

Ronny



> [EMAIL PROTECTED] wrote:
> 
> Sorry if you get this twice.  i thought I had completed joining the 
> mailing list but then found it was refused the 1st time..
> 
> Hi people!
>   
> I have one problem on Suse.  I have satisfied all the dependencies using 
> rpm's and am
> now trying to install using rpm's from the bacula sourceforge site.  But 
> this is what
> happens when I try to install the bacula-mysql-1.38.9-1.su92.i586.rpm
> 
> :~/RPM/bacula # rpm -Uvh --force bacula-mysql-1.38.9-1.su92.i586.rpm 
>
>  
> warning: bacula-mysql-1.38.9-1.su92.i586.rpm: V3 DSA signature: NOKEY, 
> key ID 10a792ad
> error: Failed dependencies:
> libmysqlclient_r.so.12 is needed by bacula-mysql-1.38.9-1
> 
> But I have already installed mysql-shared wich provides that lib:
> 
> :~/RPM/bacula # find / -name libmysqlclient_r.so.12
> find: /media/dvd: No medium found
> find: /media/floppy: No medium found
> /usr/lib64/libmysqlclient_r.so.12
> 
> 
> OS: Suse 9.0 x86_64 
> 
> 
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Fwd: can't install properly on suse 9.0

2006-06-07 Thread veronica . hill
Sorry if you get this twice.  i thought I had completed joining the mailing 
list but then found it was refused the 1st time..

Hi people!

I have one problem on Suse.  I have satisfied all the dependencies using rpm's 
and am
now trying to install using rpm's from the bacula sourceforge site.  But this 
is what
happens when I try to install the bacula-mysql-1.38.9-1.su92.i586.rpm

:~/RPM/bacula # rpm -Uvh --force bacula-mysql-1.38.9-1.su92.i586.rpm

 
warning: bacula-mysql-1.38.9-1.su92.i586.rpm: V3 DSA signature: NOKEY, key ID 
10a792ad
error: Failed dependencies:
libmysqlclient_r.so.12 is needed by bacula-mysql-1.38.9-1

But I have already installed mysql-shared wich provides that lib:

:~/RPM/bacula # find / -name libmysqlclient_r.so.12
find: /media/dvd: No medium found
find: /media/floppy: No medium found
/usr/lib64/libmysqlclient_r.so.12


OS: Suse 9.0 x86_64 


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Removing old clients from the database

2006-06-07 Thread [EMAIL PROTECTED]
Martin Simmons wrote:
>> On Tue, 06 Jun 2006 13:22:56 +0800, "[EMAIL PROTECTED]" <[EMAIL 
>> PROTECTED]> said:
>> 
>> Hi,
>>
>> I was wondering how you remove database entires for clients that are no 
>> longer being used. Currently I simply remove them from bacula-dir.conf 
>> but I suspect the database entries still exist.
>>
>> I'm getting a really bloated mysql bacula directory (currently nearly 
>> 1GB with 37 clients; used to be 42...) even after compacting.
>>
>> Any recommendations?
>>
>> Which tables can I drop in the database pertaining to the old clients as 
>> I'm looking to trim that database.
>> 
>
> Don't drop any tables -- they are all needed!
>
> You can use the "query" command option "List all backups for a Client" to find
> the jobids for jobs on the old clients and the use the "delete job" command to
> remove the information for each one.
>   
I ran dbchek (set to modify) but that did not reduce the size of the 
database. I'll try your suggestions. Thanks!
> __Martin
>
>   



___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Client Run Before Job script failing.

2006-06-07 Thread Georger Araujo
Possible solutions below.

1. Try sudo.
2. How do you connect to MySQL locally, TCP/IP or
socket? In that case, you might want to log into MySQL
as root and

SELECT User, Host, Password FROM mysql.user;

to see if your passwords are OK. My output is as
follows:

++-+-+
| User   | Host| Password|
++-+-+
| root   | localhost   | |
| root   | bacula.mydomain | |
|| bacula.mydomain | |
|| localhost   | |
| bacula | %   | put_pw_here |
| bacula | bacula.mydomain | |
| bacula | localhost   | |
++-+-+

Users 'root' and 'bacula' don't need to input a
password when logging on from my 'bacula.mydomain'
Bacula 1.38.9 server - I *think* it won't be broken
into (it's not connected to the Internet, I keep it
VERYut), and 'root' can't access MySQL from the
network. 'bacula' can, for the sole reason that my
Apache box running Bacula Web is a separate box, so it
must supply the 'put_pw_here' password in order to
read data from MySQL.
Could it be more secure? Sure. I tried to configure
the passwords so that 'root' and 'bacula' had to
authenticate when logging on from my Bacula server as
well, but for some weird reason the
/etc/bacula/make_catalog_backup script wouldn't parse
the password argument. But hey, even Oracle 10g allows
you to connect as SYSDBA without supplying a password
if you're part of the local dba group.

--- Will McDonald <[EMAIL PROTECTED]> escreveu:

> Hi all.
> 
> I have a problem with a Client Run Before Job script
> to backup MySQL
> databases which is only occurring when it's called
> by Bacula.
> 
> On the Director I have:
> 
> [EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm
> -qa | grep
> bacula; ps aux | grep [b]acula
> CentOS release 4.3 (Final)
> bacula-mysql-1.38.5-4
> bacula-mtx-1.38.5-4
> bacula   25352  0.0  0.4 39808 2168 ?Ssl 
> 09:20   0:00
> /usr/sbin/bacula-sd -u bacula -g disk -v -c
> /etc/bacula/bacula-sd.conf
> root 25357  0.0  0.3 18132 1848 ?Ssl 
> 09:20   0:00
> /usr/sbin/bacula-fd -u root -g bacula -v -c
> /etc/bacula/bacula-fd.conf
> bacula   25362  0.0  0.5 60420 2988 ?Ssl 
> 09:20   0:00
> /usr/sbin/bacula-dir -u bacula -g bacula -v -c
> /etc/bacula/bacula-dir.conf
> 
> And the clients are:
> 
> [EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm
> -qa | grep
> bacula; ps aux | grep [b]acula
> CentOS release 4.3 (Final)
> bacula-client-1.38.5-4
> root 14325  0.0  0.4 38976 2216 ?Ssl 
> Mar28  13:31
> /usr/sbin/bacula-fd -u root -g bacula -c
> /etc/bacula/bacula-fd.conf
> 
> The script runs mysqlshow to build a list of
> available databases then
> dumps them out to a standard location. It runs fine
> from the shell as
> root on the client hosts themselves, when called
> during a backup
> though I see the following:
> 
> 06-Jun 10:56 archive: Start Backup JobId 1045,
> Job=devmon1.2006-06-06_10.56.26
> *messages
> 06-Jun 10:56 devmon1: ClientRunBeforeJob:
> /usr/bin/mysqlshow: Access
> denied for user 'root'@'localhost' (using password:
> NO)
> 
> Again, running mysqlshow on a client from the shell
> as root works perfectly:
> 
> [EMAIL PROTECTED] ~]# mysqlshow
> +---+
> | Databases |
> +---+
> | cacti |
> | mysql |
> | wikidb|
> +---+
> 
> The mysql database is passworded and that's
> specifcied in
> ~root/.my.cnf  which has 600 permissions:
> 
> [EMAIL PROTECTED] ~]# cat ~/.my.cnf
> [client]
> password=correctpasswordhere
> 
> It appears mysqlshow checks the .my.cnf when run
> locally but when
> called by Bacula it isn't. If I append
> -pcorrectpasswordhere to the
> mysqlshow in the script then the backup works. I
> assume that the
> Bacula File Daemon runs clients scripts as root?
> 
> Can anyone suggest what's going on here?
> 
> Will.
> 
> 
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/bacula-users
> 


__
Fale com seus amigos  de graça com o novo Yahoo! Messenger 
http://br.messenger.yahoo.com/ 


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Using Multiple Disks

2006-06-07 Thread Scott Ruckh

-- 

This is what you said Doug Penny
> I am new to bacula, but have been very impressed with the flexibility
> it provides.  I currently have bacula backing up 9 different servers
> to disk.  However everything is going to one disk.  Is there anyway to
> have all of my full backups go to one disk and all differentials go to
> another disk?  I know I can specify which pool different backup levels
> use, but I can't figure out how (if possible) to specify which disk a
> certain pool will use.  Thank you for your help.
>
> Sincerely,
> Doug Penny

I just created multiple entries in the storage director configuration:

Device {
  Name = SD_FULL
  Media Type = File
  Archive Device = /BACKUPS/Full
  LabelMedia = yes;   # lets Bacula label unlabeled media
  Random Access = Yes;
  AutomaticMount = yes;   # when device opened, read it
  RemovableMedia = no;
  AlwaysOpen = no;
}

Device {
  Name = SD_INCR
  Media Type = File
  Archive Device = /BACKUPS/Incremental
  LabelMedia = yes;   # lets Bacula label unlabeled media
  Random Access = Yes;
  AutomaticMount = yes;   # when device opened, read it
  RemovableMedia = no;
  AlwaysOpen = no;
}

each of those mount points can be on different disks.

I of course have my Storage{} and Pool{} options configured in the
director configuration to utilize the Device {} created in the storage
director.

Scott


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Drive SDX-550V using tape TAIT2-80C

2006-06-07 Thread Danilo Pinheiro Rodrigues
I have a Drive SDX-550V with a tape TAIT2-80C 186M  / AIT2-TURBO remote 64k, somebody would know to say me if the Bacula have support for this tape and if it have which would be the correct configuration for the type of media in the file 
bacula-sd.conf.Thank you-- Danilo Pinheiro
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Client Run Before Job script failing.

2006-06-07 Thread Scott Ruckh

-- 

> The Bacula Director and Storage daemons are running as bacula on the
> backup server. The Bacula File Daemon running on the clients is
> running as use root, group bacula. As the script's running on the
> client I'd have thought it'd execute as root, and it is.
>
>> I am using,
>> http://worldcommunity.com/opensource/utilities/mysql_backup.html, to
>> backup my databases from Bacula Director (ClientRunBeforeJob).
>>
>> ClientRunBeforeJob= "/usr/local/bin/mysqlbackup/mysqlbackup.pl"
>>
>> This appears to work good for me.
>
> Do you have passworded MySQL root user access? i.e. to you need to
> supply "-p somepass" when connecting using the CLI?
>
> Will.

Yes, I have configured root to require a password when logging in.  The
username and password configured for doing the backups is included in the
script's configuration ($user and $password).

Scott


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Client Run Before Job script failing.

2006-06-07 Thread Will McDonald
On 07/06/06, Scott Ruckh <[EMAIL PROTECTED]> wrote:
> This is what you said Will McDonald
> > Hi all. Tried to send this mail yesterday and it appeared to bounce.
> > Apologies if this is a duplicate.
> >
> > I have a problem with a Client Run Before Job script to backup MySQL
> > databases which is only occurring when it's called by Bacula.
> >
> > On the Director I have:
> >
> > bacula   25352  0.0  0.4 39808 2168 ?Ssl  09:20   0:00
> > /usr/sbin/bacula-sd -u bacula -g disk -v -c /etc/bacula/bacula-sd.conf
> > root 25357  0.0  0.3 18132 1848 ?Ssl  09:20   0:00
> > /usr/sbin/bacula-fd -u root -g bacula -v -c /etc/bacula/bacula-fd.conf
> > bacula   25362  0.0  0.5 60420 2988 ?Ssl  09:20   0:00
> > /usr/sbin/bacula-dir -u bacula -g bacula -v -c
> > /etc/bacula/bacula-dir.conf
> >
> > And the clients are:
> > root 14325  0.0  0.4 38976 2216 ?Ssl  Mar28  13:31
> > /usr/sbin/bacula-fd -u root -g bacula -c /etc/bacula/bacula-fd.conf
> >
> > The script runs mysqlshow to build a list of available databases then
> > dumps them out to a standard location. It runs fine from the shell as
> > root on the client hosts themselves, when called during a backup
> > though I see the following:
> >
> > 06-Jun 10:56 archive: Start Backup JobId 1045,
> > Job=devmon1.2006-06-06_10.56.26
> > *messages
> > 06-Jun 10:56 devmon1: ClientRunBeforeJob: /usr/bin/mysqlshow: Access
> > denied for user 'root'@'localhost' (using password: NO)
> >
> > Again, running mysqlshow on a client from the shell as root works
> > perfectly:
>
> Looks like your are running the bacula program as the user bacula.  When
> you run your script as root and use root's home directory for your my.cnf
> file that will be different then your bacula user.  Plus some shells do
> not respect some of your dot files in a non-interactive shell, but I am
> not sure this is your problem.

The Bacula Director and Storage daemons are running as bacula on the
backup server. The Bacula File Daemon running on the clients is
running as use root, group bacula. As the script's running on the
client I'd have thought it'd execute as root, and it is.

> I am using,
> http://worldcommunity.com/opensource/utilities/mysql_backup.html, to
> backup my databases from Bacula Director (ClientRunBeforeJob).
>
> ClientRunBeforeJob= "/usr/local/bin/mysqlbackup/mysqlbackup.pl"
>
> This appears to work good for me.

Do you have passworded MySQL root user access? i.e. to you need to
supply "-p somepass" when connecting using the CLI?

Will.


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Using Multiple Disks

2006-06-07 Thread Doug Penny
I am new to bacula, but have been very impressed with the flexibility
it provides.  I currently have bacula backing up 9 different servers
to disk.  However everything is going to one disk.  Is there anyway to
have all of my full backups go to one disk and all differentials go to
another disk?  I know I can specify which pool different backup levels
use, but I can't figure out how (if possible) to specify which disk a
certain pool will use.  Thank you for your help.

Sincerely,
Doug Penny


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Client Run Before Job script failing.

2006-06-07 Thread Will McDonald
Hi all.

I have a problem with a Client Run Before Job script to backup MySQL
databases which is only occurring when it's called by Bacula.

On the Director I have:

[EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm -qa | grep
bacula; ps aux | grep [b]acula
CentOS release 4.3 (Final)
bacula-mysql-1.38.5-4
bacula-mtx-1.38.5-4
bacula   25352  0.0  0.4 39808 2168 ?Ssl  09:20   0:00
/usr/sbin/bacula-sd -u bacula -g disk -v -c /etc/bacula/bacula-sd.conf
root 25357  0.0  0.3 18132 1848 ?Ssl  09:20   0:00
/usr/sbin/bacula-fd -u root -g bacula -v -c /etc/bacula/bacula-fd.conf
bacula   25362  0.0  0.5 60420 2988 ?Ssl  09:20   0:00
/usr/sbin/bacula-dir -u bacula -g bacula -v -c
/etc/bacula/bacula-dir.conf

And the clients are:

[EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm -qa | grep
bacula; ps aux | grep [b]acula
CentOS release 4.3 (Final)
bacula-client-1.38.5-4
root 14325  0.0  0.4 38976 2216 ?Ssl  Mar28  13:31
/usr/sbin/bacula-fd -u root -g bacula -c /etc/bacula/bacula-fd.conf

The script runs mysqlshow to build a list of available databases then
dumps them out to a standard location. It runs fine from the shell as
root on the client hosts themselves, when called during a backup
though I see the following:

06-Jun 10:56 archive: Start Backup JobId 1045, Job=devmon1.2006-06-06_10.56.26
*messages
06-Jun 10:56 devmon1: ClientRunBeforeJob: /usr/bin/mysqlshow: Access
denied for user 'root'@'localhost' (using password: NO)

Again, running mysqlshow on a client from the shell as root works perfectly:

[EMAIL PROTECTED] ~]# mysqlshow
+---+
| Databases |
+---+
| cacti |
| mysql |
| wikidb|
+---+

The mysql database is passworded and that's specifcied in
~root/.my.cnf  which has 600 permissions:

[EMAIL PROTECTED] ~]# cat ~/.my.cnf
[client]
password=correctpasswordhere

It appears mysqlshow checks the .my.cnf when run locally but when
called by Bacula it isn't. If I append -pcorrectpasswordhere to the
mysqlshow in the script then the backup works. I assume that the
Bacula File Daemon runs clients scripts as root?

Can anyone suggest what's going on here?

Will.


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Client Run Before Job script failing.

2006-06-07 Thread Scott Ruckh

-- 

This is what you said Will McDonald
> Hi all. Tried to send this mail yesterday and it appeared to bounce.
> Apologies if this is a duplicate.
>
> I have a problem with a Client Run Before Job script to backup MySQL
> databases which is only occurring when it's called by Bacula.
>
> On the Director I have:
>
> [EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm -qa | grep
> bacula; ps aux | grep [b]acula
> CentOS release 4.3 (Final)
> bacula-mysql-1.38.5-4
> bacula-mtx-1.38.5-4
> bacula   25352  0.0  0.4 39808 2168 ?Ssl  09:20   0:00
> /usr/sbin/bacula-sd -u bacula -g disk -v -c /etc/bacula/bacula-sd.conf
> root 25357  0.0  0.3 18132 1848 ?Ssl  09:20   0:00
> /usr/sbin/bacula-fd -u root -g bacula -v -c /etc/bacula/bacula-fd.conf
> bacula   25362  0.0  0.5 60420 2988 ?Ssl  09:20   0:00
> /usr/sbin/bacula-dir -u bacula -g bacula -v -c
> /etc/bacula/bacula-dir.conf
>
> And the clients are:
>
> [EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm -qa | grep
> bacula; ps aux | grep [b]acula
> CentOS release 4.3 (Final)
> bacula-client-1.38.5-4
> root 14325  0.0  0.4 38976 2216 ?Ssl  Mar28  13:31
> /usr/sbin/bacula-fd -u root -g bacula -c /etc/bacula/bacula-fd.conf
>
> The script runs mysqlshow to build a list of available databases then
> dumps them out to a standard location. It runs fine from the shell as
> root on the client hosts themselves, when called during a backup
> though I see the following:
>
> 06-Jun 10:56 archive: Start Backup JobId 1045,
> Job=devmon1.2006-06-06_10.56.26
> *messages
> 06-Jun 10:56 devmon1: ClientRunBeforeJob: /usr/bin/mysqlshow: Access
> denied for user 'root'@'localhost' (using password: NO)
>
> Again, running mysqlshow on a client from the shell as root works
> perfectly:

Looks like your are running the bacula program as the user bacula.  When
you run your script as root and use root's home directory for your my.cnf
file that will be different then your bacula user.  Plus some shells do
not respect some of your dot files in a non-interactive shell, but I am
not sure this is your problem.

I am using,
http://worldcommunity.com/opensource/utilities/mysql_backup.html, to
backup my databases from Bacula Director (ClientRunBeforeJob).

ClientRunBeforeJob= "/usr/local/bin/mysqlbackup/mysqlbackup.pl"

This appears to work good for me.


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Client Run Before Job script failing.

2006-06-07 Thread Will McDonald
Hi all. Tried to send this mail yesterday and it appeared to bounce.
Apologies if this is a duplicate.

I have a problem with a Client Run Before Job script to backup MySQL
databases which is only occurring when it's called by Bacula.

On the Director I have:

[EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm -qa | grep
bacula; ps aux | grep [b]acula
CentOS release 4.3 (Final)
bacula-mysql-1.38.5-4
bacula-mtx-1.38.5-4
bacula   25352  0.0  0.4 39808 2168 ?Ssl  09:20   0:00
/usr/sbin/bacula-sd -u bacula -g disk -v -c /etc/bacula/bacula-sd.conf
root 25357  0.0  0.3 18132 1848 ?Ssl  09:20   0:00
/usr/sbin/bacula-fd -u root -g bacula -v -c /etc/bacula/bacula-fd.conf
bacula   25362  0.0  0.5 60420 2988 ?Ssl  09:20   0:00
/usr/sbin/bacula-dir -u bacula -g bacula -v -c
/etc/bacula/bacula-dir.conf

And the clients are:

[EMAIL PROTECTED] scripts]# cat /etc/redhat-release; rpm -qa | grep
bacula; ps aux | grep [b]acula
CentOS release 4.3 (Final)
bacula-client-1.38.5-4
root 14325  0.0  0.4 38976 2216 ?Ssl  Mar28  13:31
/usr/sbin/bacula-fd -u root -g bacula -c /etc/bacula/bacula-fd.conf

The script runs mysqlshow to build a list of available databases then
dumps them out to a standard location. It runs fine from the shell as
root on the client hosts themselves, when called during a backup
though I see the following:

06-Jun 10:56 archive: Start Backup JobId 1045, Job=devmon1.2006-06-06_10.56.26
*messages
06-Jun 10:56 devmon1: ClientRunBeforeJob: /usr/bin/mysqlshow: Access
denied for user 'root'@'localhost' (using password: NO)

Again, running mysqlshow on a client from the shell as root works perfectly:

[EMAIL PROTECTED] ~]# mysqlshow
+---+
| Databases |
+---+
| cacti |
| mysql |
| wikidb|
+---+

The mysql database is passworded and that's specifcied in
~root/.my.cnf  which has 600 permissions:

[EMAIL PROTECTED] ~]# cat ~/.my.cnf
[client]
password=correctpasswordhere

It appears mysqlshow checks the .my.cnf when run locally but when
called by Bacula it isn't. If I append -pcorrectpasswordhere to the
mysqlshow in the script then the backup works. I assume that the
Bacula File Daemon runs clients scripts as root?

Can anyone suggest what's going on here?

Will.


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula-web on debianhelp

2006-06-07 Thread Joshua J. Kugler
http://www.debianhelp.co.uk/baculaweb.htm

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Spooling parallel, Despooling sequential

2006-06-07 Thread Arno Lehmann
Hi,

sorry that it took some time...

On 6/2/2006 5:05 PM, Baptiste Malguy wrote:
> Hello,
> 
> I wish I could get more precise details for my case. Let's consider
> backup are only made on some disks.
> 
> In bacula-dir.conf, in Job resources, we may set Spool Data attribute to
> yes. From the online doc, you can read: "This option should not be used
> if you are writing to a disk file".
> 
> I definitly understand this advice. Why spool on disk, while the final
> storage is on a disk.
> 
> However, I still want to run multiple Jobs in parallel AND avoid
> interleaved backup data.

As long as you've got enough disk space, you can and should use 
spooling. In my opinion, of course.

> Furthermore, when I had to restore some small (< 100kb) files from a
> disk volume > 50GB, I had to wait for more than 20 minutes. I don't
> understand why it was so long.
> 
> Here are my questions:
> 
> 1 - Is it just the OS that takes so long to set its index to the content
> of the disk volume (file) or is it Bacula that treats a disk volume as a
> cartridge, with sequential access instead of random access ?

That's a problem in Bacula which exists for a while. For reasons unknown 
to me, Kern foundd that file positioning doesn't work reliably for 
Bacula, so he disabled that code. Thus, as far as I know, Bacula treats 
file volumes even worse than tape ones - when searching, it reads each 
byte while tapes can usually be positioned faster than being read.

> 2 - Based on the fact Bacula does not use random access to disk volumes,
> what's the best deal between spooling data to avoid interleaved backups
> data and havin interleaved backups data on disk volumes ?

Use spooling, and limit the size of your volume files to something 
reasonable. Depending on how fast and often you have to run restores I'd 
recommend something between few GB to something like 50 GB. (Keep in 
mind that, depending on your filesystem, it can be necessary or helpful 
to create the file system Bacula uses with an inode density that closely 
fits to what Bacula will need.)

> 3 - By the way, what do you think of havin a single ~ 60GB disk volume
> or several smaller 5-10GB volumes ? Does anyone has some background
> about it ?

Yup, see above - several smaller ones are usually more efficient.

> I'm not sure I've made myself clear. Do not hesitate to ask me to
> reformulate.

Not necessary, I think I understood your points ;-)

Arno

> 
> Arno Lehmann wrote:
> 
>>Hi,
>>
>>On 6/2/2006 9:00 AM, Christoph Litauer wrote:
>>
>>>Dear bacula users,
>>>
>>>I currently backup about 15 linux/windows servers to a LTO streamer. For
>>>increased restore speed I want no parallel (interleaving) backups on the
>>>tapes. So I set "Maximum Concurrent Jobs" of the tape storage to 1.
>>>
>>>On the other hand, collecting data should happen in parallel on all
>>>clients. So I set "SpoolData = yes" and "Maximum Concurrent Jobs" in the
>>>sections "Director", "FileDaemon" (in clients bacula-fd.conf) and
>>>"Storage" (bacula-sd.conf) to 20.
>>>
>>>I expected the clients to spool in parallel but despooling sequential.
>>>But the clients wait for each other doing the backups on after another.
>>>Did I miss something?
>>
>>Not exactly, but there's another solution to your needs.
>>
>>Activate spooling and allow multiple concurrent jobs. In this case, the 
>>data for one job will be written to tape consecutively (at least the 
>>amount that is spooled). Despooling happens per job, so during 
>>despooling there's only data from one job at a time going to tape.
> 
> 
> 
>>If your spool space is smaller than what you'd need for all jobs you 
>>might end up with multiple chunks of data for a job, but these can be 
>>restored rather fast because Bacula can forward the tape between these 
>>chunks.
>>
>>This is the sort of setup I prefer because it gives me the right 
>>compromise between overall backup speed and restore speed.
>>
>>Arno
>>
>>
> 
> 
> 

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


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] How to start from a clean slate.

2006-06-07 Thread John Boris
We have been running bacula for over a month and I now found I had
things a bit misconfigured. I want to start over so I purged and deleted
the contents of the catalog through the console. So the catalog showed
no volumes. When my scheduled job kicked off I get an error that says:

06-Jun 23:10 jerome-dir: Start Backup JobId 120,
Job=BackupCatalog.2006-06-06_23.10.00
06-Jun 23:10 jerome-dir: Created new Volume "Volume_0001" in catalog.
06-Jun 23:10 jerome-sd: 3301 Issuing autochanger "loaded drive 0"
command.
06-Jun 23:10 jerome-sd: 3302 Autochanger "loaded drive 0", result is
Slot 1.
06-Jun 23:10 jerome-sd: BackupCatalog.2006-06-06_23.10.00 Warning:
Director wanted Volume "Volume_0001".
Current Volume "000101L2" not acceptable because:
1997 Volume "000101L2" not in catalog.
06-Jun 23:10 jerome-sd: Please mount Volume "Volume_0001" on Storage
Device "Drive-0" (/dev/nst1) for Job BackupCatalog.2006-06-06_23.10.00
06-Jun 23:17 jerome-dir: BackupCatalog.2006-06-06_23.10.00 Fatal error:
Network error with FD during Backup: ERR=No data available
06-Jun 23:17 jerome-dir: BackupCatalog.2006-06-06_23.10.00 Fatal error:
No Job status returned from FD.
06-Jun 23:17 jerome-dir: BackupCatalog.2006-06-06_23.10.00 Error:
Bacula 1.38.5 (18Jan06): 06-Jun-2006 23:17:22

I also got this error when the catalog tried to write:

06-Jun 23:10 jerome-sd: Please mount Volume "Volume_0001" on Storage
Device "Drive-0" (/dev/nst1) for Job BackupCatalog.2006-06-06_23.10.00

Is this a label issue? Is this covered in the Manual? I just want to
start over.

TIA

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

"Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!"




___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Removing old clients from the database

2006-06-07 Thread Martin Simmons
> On Tue, 06 Jun 2006 13:22:56 +0800, "[EMAIL PROTECTED]" <[EMAIL 
> PROTECTED]> said:
> 
> Hi,
> 
> I was wondering how you remove database entires for clients that are no 
> longer being used. Currently I simply remove them from bacula-dir.conf 
> but I suspect the database entries still exist.
> 
> I'm getting a really bloated mysql bacula directory (currently nearly 
> 1GB with 37 clients; used to be 42...) even after compacting.
> 
> Any recommendations?
> 
> Which tables can I drop in the database pertaining to the old clients as 
> I'm looking to trim that database.

Don't drop any tables -- they are all needed!

You can use the "query" command option "List all backups for a Client" to find
the jobids for jobs on the old clients and the use the "delete job" command to
remove the information for each one.

__Martin


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Only the second "update slots" works

2006-06-07 Thread Thomas Sturm
Linux bacula 2.4.25_pre7-gss-r3 #8 Mo Mär 7 09:53:29 CET 2005 i686 Intel(R)
Pentium(R) 4 CPU 1.80GHz GenuineIntel GNU/Linux
1000 OK: bacula-dir Version: 1.38.9 (02 May 2006)

Hello list,
my problem is that the first "*update slots=8 scan storage=Autoloader" does 
not work (the second always does!)

*update slots=8 scan storage=Autoloader

07-Jun 09:30 bacula-dir: RunBefore: Connecting to Director 
backup.intra.melle.de:9101
07-Jun 09:30 bacula-dir: RunBefore: 1000 OK: bacula-dir Version: 1.38.9 (02 
May 2006)
07-Jun 09:30 bacula-dir: RunBefore: Enter a period to cancel a command.
07-Jun 09:30 bacula-dir: RunBefore: update slots=8 scan storage=Autoloader
07-Jun 09:30 bacula-dir: RunBefore: Using default Catalog name=MyCatalog 
DB=bacula
07-Jun 09:30 bacula-dir: RunBefore: Connecting to Storage daemon Autoloader at 
backup.intra.melle.de:9103 ...
07-Jun 09:30 bacula-dir: RunBefore: 3306 Issuing autochanger "slots" command.
07-Jun 09:30 bacula-dir: RunBefore: Device "VS160" has 0 slots.
07-Jun 09:30 bacula-dir: RunBefore: No slots in changer to scan.

*update slots=8 scan storage=Autoloader

07-Jun 09:30 bacula-dir: RunBefore: update slots=8 scan storage=Autoloader
07-Jun 09:30 bacula-dir: RunBefore: Connecting to Storage daemon Autoloader at 
backup.intra.melle.de:9103 ...
07-Jun 09:30 bacula-dir: RunBefore: 3306 Issuing autochanger "slots" command.
07-Jun 09:30 bacula-dir: RunBefore: Device "VS160" has 8 slots.
07-Jun 09:30 bacula-dir: RunBefore: Connecting to Storage daemon Autoloader at 
backup.intra.melle.de:9103 ...
07-Jun 09:30 bacula-dir: RunBefore: 3301 Issuing autochanger "loaded drive 0" 
command.
07-Jun 09:30 bacula-dir: RunBefore: 3302 Autochanger "loaded drive 0", result: 
nothing loaded.
07-Jun 09:30 bacula-dir: RunBefore: 3306 Issuing autochanger "list" command.
07-Jun 09:30 bacula-dir: RunBefore: Connecting to Storage daemon Autoloader at 
backup.intra.melle.de:9103 ...
07-Jun 09:30 bacula-dir: RunBefore: 3301 Issuing autochanger "loaded drive 0" 
command.
07-Jun 09:30 bacula-dir: RunBefore: 3302 Autochanger "loaded drive 0", result: 
nothing loaded.
07-Jun 09:30 bacula-dir: RunBefore: 3304 Issuing autochanger "load slot 8, 
drive 0" command.
07-Jun 09:31 bacula-dir: RunBefore: 3305 Autochanger "load slot 8, drive 0", 
status is OK.
07-Jun 09:31 bacula-dir: RunBefore: 3301 Issuing autochanger "loaded drive 0" 
command.
07-Jun 09:31 bacula-dir: RunBefore: 3302 Autochanger "loaded drive 0", result 
is Slot 8.
07-Jun 09:31 bacula-dir: RunBefore: 3001 Volume=Mi_1-s8 Slot=8
07-Jun 09:31 bacula-dir: RunBefore: Catalog record for Volume "Mi_1-s8" 
updated to reference slot 8.

Best regards
Thomas

---


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users