Re: [Bacula-users] backing up cisco switches config

2008-10-21 Thread Patrick Okui
Adrian Moisey wrote:
> I was thinking that I'll write a python script that will telnet into 
> each switch and get a copy of "show run"
> 
> Has anybody done this ?

Rancid hasn't been updated for a while but could do nicely.

http://www.shrubbery.net/rancid/

patrick

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backing up cisco switches config

2008-10-21 Thread James Harper
> Hi
> 
> I've been thinking about backing up cisco switches config files.
> 
> I was thinking that I'll write a python script that will telnet into
> each switch and get a copy of "show run"
> 
> Has anybody done this ?
> 

They certainly have - http://www.shrubbery.net/rancid/

rancid will connect to Cisco switches (and a few other branches) at
whatever interval you want, grab the config, and commit to a local SVN
tree, so you get a complete change history too.

Once it's in SVN, backing it up is easy.

James

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] backing up cisco switches config

2008-10-21 Thread Adrian Moisey
Hi

I've been thinking about backing up cisco switches config files.

I was thinking that I'll write a python script that will telnet into 
each switch and get a copy of "show run"

Has anybody done this ?

-- 
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: [EMAIL PROTECTED]
Phone: +27 21 818 8621 | Mobile: +27 82 858 7830 | Fax: +27 21 818 8855

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Windows / TLS / errors

2008-10-21 Thread Bruno Friedmann
Did you double quotes the path certificate file ?
Openssl is sensible ...

And in what you get as error message it talk to the crl ( certificate 
revocation list )
which have to exist and be genereated after you issue new certificate ( or 
revoque some other ).

You could check in openssl manual for crl

openssl ca -verbose -config $CACONF -gencrl -out $CADIR/crl/ca.pem.crl


Exim List wrote:
> I have a client who would like data backed up on a remote Windows machine.
> 
> I have the bacula-fd.conf set up and working well by itself on the 
> Windows 2003 server connecting to a Linux Director.
> 
> When I try to use TLS, I get errors.
> 
> Per suggestions, I created the .key, .csr and .crt files on a Unix 
> machine to alleviate the hassle of using Openssl on Windows.
> 
> I copied these files to:
> 
> c:\documents and settings\all users\application data\bacula
> 
> as server.key, server.crt and the original ca.crt used on the issuing 
> server.
> 
> I get this error when running 'bacula-fd -d100' from the command line:
> 
> 
> Error: ../../lib/openssl.c:86 Error loading certification verification 
> stores:  ERR=error:02001002:system library:fopen:No such file or directory
> 
> The next error is the same except it changes to 2006D080:BIO 
> routines:BIO_new_file:no such file
> 
> Third error is 0B084002:x509 certificate 
> routines:X509_load_cert_crl_file:system lib
> 
> Fourth error is Fatal Error at ../../filed/filed.c:323 because: Failed 
> to initialize TLS context for File daemon "server" in bacula-fd.conf.
> 
> 
> I've tried copying the crt files to c:\program files\bacula and changing 
> the bacula-fd.conf to match.  That didn't help either.
> 
> I've scoured the web for about an hour and can't find anything pertinent 
> to help.
> 
> Does anyone have any ideas?
> 
> Thanks.
> 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


-- 

 Bruno Friedmann

Ioda-Net Sàrl
  2830 Vellerat - Switzerland

  Tél : ++41 32 435 7171
  Fax : ++41 32 435 7172
  gsm : ++41 78 802 6760
  www.ioda-net.ch

 Centre de Formation et de Coaching En Ligne
 www.cfcel.com


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] REPLACE BSMTP with other mail program

2008-10-21 Thread Mark V
On Tue, Oct 21, 2008 at 4:21 PM, Peter Herrington
<[EMAIL PROTECTED]> wrote:
> Hello
>
> I am having the continual situation where the bsmtp cant send me emails
> because of various reasons,
> First it was invalid recipient.As Soon as I put in a valid email addr, it
> then says invalid sender.
> Now I just saw in the mail queue that my ISP email server refused the
> connection.
>
> My Clarkconnect server's email server component,postfix is configured to
> OUTBOUND RELAY to my ISP mail server
> Because that was the only way I could get my emails from my LAN to the
> intended recipients on the internet.
>
> My thinking goes if I can only put another email program in the email
> settings, one that authorise on smtp,
> My problem will be solved, unless of course bsmtp can do that.
>
> Any pointers will be great

I had a slightly different use case.  The simplest solution I found was ssmtp.
Further details here:

http://linux.derkeiler.com/Mailing-Lists/SuSE/2008-07/msg01593.html

HTH?
Mark

> Rgds/Pete
>
>
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Reducing the size of the database.

2008-10-21 Thread John Drescher
> You have to run:
>
> echo "16" |dbcheck -b -f -c /path/to/bacula-dir.conf -C dbname workingdir
> vacuumdb -q -d dbname -z -f
> reindexdb -q dbname
>
> After running these commands my database size was reduced from 10 GB to 8.0 
> GB.
>
Just did this on my postgresql database. It went from 22.5 GB to 27 GB
(during the process) and then to 17 GB so the reindexing did help.

Thanks,
John

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Removing Volumes from Catalog

2008-10-21 Thread Mark
hai, i r noob

RTFM for the win.

I was looking for the remove command.

Sorry to spam the list, gents.

Mark


> Hiya list,
> 
> I added a bunch of volumes with the add command but both the volume 
> sequence numbers and slot locations came out wrong. I then discovered 
> the label barcode command which started to add the volumes in correctly 
> and would have if I hadn't canceled it part of the way though.
> 
> So my question is how do I remove volumes from the catalog?
> 
> Mark




-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Removing Volumes from Catalog

2008-10-21 Thread Mark
Hiya list,

I added a bunch of volumes with the add command but both the volume 
sequence numbers and slot locations came out wrong. I then discovered 
the label barcode command which started to add the volumes in correctly 
and would have if I hadn't canceled it part of the way though.

So my question is how do I remove volumes from the catalog?

Mark

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread Hemant Shah



--- On Tue, 10/21/08, ebollengier <[EMAIL PROTECTED]> wrote:

> From: ebollengier <[EMAIL PROTECTED]>
> Subject: Re: [Bacula-users] Re ducing the size of the database.
> To: bacula-users@lists.sourceforge.net
> Date: Tuesday, October 21, 2008, 2:25 AM
> If it's 40,000 rows of the filename or path table, each
> rows are something
> like 10 or 15 bytes long
> 
> If you want to reduce the size of your database, you need
> to review your
> retention periode or to prune jobs (ie, remove backup
> content information
> from the catalog).
> 
> See the manual for more information (Automatic Volume
> Recycling chapter)
> 

  My retention periods are fine, I have it configured like I want it. My 
problem was I did not understand how PostgreSQL handles the disk space for the 
deleted rows. I figured out how to reclaim disks pace.
 
> 
> shahhe wrote:
> > 
> > This is probably a question for a PostgreSQL group,
> but I though users
> > using bacula may have come across this problem.
> > 
> > I am using PostgreSQL for the database, last week when
> I checked, my
> > database size was 10GB. I removed one month worth of
> volumes from the
> > bacula database and ran dbcheck command. It deleted
> about 40,000 rows from
> > the database, but the database size was still 10GB.
> Next, I ran postgresql
> > vacuumdb (vacuumdb -q -d bacula -z -f)command to
> reclaim the space used by
> > deleted rows, but the database size is still 10GB. How
> do I reduce the
> > size of the database?
> > 
> > I also backup the catalog every night using pgdump
> command. Before I
> > deleted the 40,000 rows the backup file size was
> 800MB, after deleting
> > 40,000 rows the backup file size is still 800MB.
> > 
> > 
> > # df -h /baculaDB
> > FilesystemSize  Used Avail Use% Mounted on
> > /dev/mapper/VolGroup01-baculaDB
> >   99G   11G   83G  12% /baculaDB
> > 
> > 
> > bacula=# select pg_database.datname,
> > pg_size_pretty(pg_database_size(pg_database.datname))
> as size from
> > pg_database;
> >  datname  |  size   
> > ---+-
> > template1 | 4272 kB
> > template0 | 4272 kB
> > postgres  | 4272 kB
> > bacula| 10 GB
> > (4 rows)
> > 
> > 
> > Hemant Shah
> > 
> 
> -- 
> View this message in context:
> http://www.nabble.com/Reducing-the-size-of-the-database.-tp20073848p20084840.html
> Sent from the Bacula - Users mailing list archive at
> Nabble.com.
> 
> 
> -
> This SF.Net email is sponsored by the Moblin Your Move
> Developer's challenge
> Build the coolest Linux based applications with Moblin SDK
> & win great prizes
> Grand prize is a trip for two to an Open Source event
> anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users



Hemant Shah
E-mail: [EMAIL PROTECTED]


  

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread Hemant Shah

--- On Tue, 10/21/08, John Huttley <[EMAIL PROTECTED]> wrote:

> From: John Huttley <[EMAIL PROTECTED]>
> Subject: Re: [Bacula-users] Re ducing the size of the database.
> To: "ebollengier" <[EMAIL PROTECTED]>
> Cc: bacula-users@lists.sourceforge.net
> Date: Tuesday, October 21, 2008, 3:53 AM
> Run 'vacuum full'
> 
> but this will lock the database as it needs exclusive use
> of the tables.
> 
> After that, perform a reindex.

  This was my problem. I needed to run reindexdb.

  Thanks.

> 
> --John
> 
> 
> ebollengier wrote:
> > If it's 40,000 rows of the filename or path table,
> each rows are something
> > like 10 or 15 bytes long
> >
> > If you want to reduce the size of your database, you
> need to review your
> > retention periode or to prune jobs (ie, remove backup
> content information
> > from the catalog).
> >
> > See the manual for more information (Automatic Volume
> Recycling chapter)
> >
> >
> > shahhe wrote:
> >   
> >> This is probably a question for a PostgreSQL
> group, but I though users
> >> using bacula may have come across this problem.
> >>
> >> I am using PostgreSQL for the database, last week
> when I checked, my
> >> database size was 10GB. I removed one month worth
> of volumes from the
> >> bacula database and ran dbcheck command. It
> deleted about 40,000 rows from
> >> the database, but the database size was still
> 10GB. Next, I ran postgresql
> >> vacuumdb (vacuumdb -q -d bacula -z -f)command to
> reclaim the space used by
> >> deleted rows, but the database size is still 10GB.
> How do I reduce the
> >> size of the database?
> >>
> >> I also backup the catalog every night using pgdump
> command. Before I
> >> deleted the 40,000 rows the backup file size was
> 800MB, after deleting
> >> 40,000 rows the backup file size is still 800MB.
> >>
> >>
> >> # df -h /baculaDB
> >> FilesystemSize  Used Avail Use%
> Mounted on
> >> /dev/mapper/VolGroup01-baculaDB
> >>   99G   11G   83G  12%
> /baculaDB
> >>
> >>
> >> bacula=# select pg_database.datname,
> >>
> pg_size_pretty(pg_database_size(pg_database.datname)) as
> size from
> >> pg_database;
> >>  datname  |  size   
> >> ---+-
> >> template1 | 4272 kB
> >> template0 | 4272 kB
> >> postgres  | 4272 kB
> >> bacula| 10 GB
> >> (4 rows)
> >>
> >>
> >> Hemant Shah
> >>
> >> 
> >
> >   
> -
> This SF.Net email is sponsored by the Moblin Your Move
> Developer's challenge
> Build the coolest Linux based applications with Moblin SDK
> & win great prizes
> Grand prize is a trip for two to an Open Source event
> anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users



Hemant Shah
E-mail: [EMAIL PROTECTED]



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Reducing the size of the database.

2008-10-21 Thread Hemant Shah



--- On Tue, 10/21/08, SystemManagement <[EMAIL PROTECTED]> wrote:

> From: SystemManagement <[EMAIL PROTECTED]>
> Subject: Re: [Bacula-users] Reducing the size of the database.
> To: [EMAIL PROTECTED]
> Cc: "baculausers" 
> Date: Tuesday, October 21, 2008, 1:34 AM
> Hi,
> 
> by experience I found that the command
> echo "16" | dbcheck -f workingdir  bacula-db
> bacula-user bacula-password
> will reduce the database.
> The vacuum will be done automatically in PostGreSQL or you
> have to call 
> it manually.
> 
> Regards,
> Reiner

  dbcheck will delete the rows, but PostgreSQL does not release the diskspace. 
I found out that vacuumdb will release the diskspace, but it builds new nodes 
in index but does not remove the entries fo deleted rows. You have to run 
reindexdb command to reclaim that space.

You have to run:

echo "16" |dbcheck -b -f -c /path/to/bacula-dir.conf -C dbname workingdir
vacuumdb -q -d dbname -z -f
reindexdb -q dbname

After running these commands my database size was reduced from 10 GB to 8.0 GB.

dbcheck does not have "-q" option so that it would not print the "Checking for 
" messages. I think it should be added so that when you run it from cron 
you do not get e-mails with the messages.

> 
> Hemant Shah schrieb:
> > This is probably a question for a PostgreSQL group,
> but I though users using bacula may have come across this
> problem.
> >
> > I am using PostgreSQL for the database, last week when
> I checked, my database size was 10GB. I removed one month
> worth of volumes from the bacula database and ran dbcheck
> command. It deleted about 40,000 rows from the database, but
> the database size was still 10GB. Next, I ran postgresql
> vacuumdb (vacuumdb -q -d bacula -z -f)command to reclaim the
> space used by deleted rows, but the database size is still
> 10GB. How do I reduce the size of the database?
> >
> > I also backup the catalog every night using pgdump
> command. Before I deleted the 40,000 rows the backup file
> size was 800MB, after deleting 40,000 rows the backup file
> size is still 800MB.
> >
> >
> > # df -h /baculaDB
> > FilesystemSize  Used Avail Use% Mounted on
> > /dev/mapper/VolGroup01-baculaDB
> >   99G   11G   83G  12% /baculaDB
> >
> >
> > bacula=# select pg_database.datname,
> pg_size_pretty(pg_database_size(pg_database.datname)) as
> size from pg_database;
> >  datname  |  size   
> > ---+-
> > template1 | 4272 kB
> > template0 | 4272 kB
> > postgres  | 4272 kB
> > bacula| 10 GB
> > (4 rows)
> >
> >
> > Hemant Shah
> > E-mail: [EMAIL PROTECTED]
> >
> > __
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> > http://mail.yahoo.com 
> >
> >
> -
> > This SF.Net email is sponsored by the Moblin Your Move
> Developer's challenge
> > Build the coolest Linux based applications with Moblin
> SDK & win great prizes
> > Grand prize is a trip for two to an Open Source event
> anywhere in the world
> >
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > ___
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> >
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> >
> >
> >



Hemant Shah
E-mail: [EMAIL PROTECTED]


  

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tape is marked as error after restore

2008-10-21 Thread Alan Brown
On Mon, 20 Oct 2008, Dan Langille wrote:

> >> I believe this was a known bug in earlier versions of Bacula.
> >
> > It still happens.
>
> You have seen this in what version of Bacula?

Sorry, not on restore.

I'm getting tapes marked in error fairly regaulrly on an apparently random
basis. Right now I'm trying to eliminate hardware faults.



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] REPLACE BSMTP with other mail program

2008-10-21 Thread Allan Black
John Lockard wrote:
> If your problem is authentication or encryption then I would
> suggest you check out msmtp (http://msmtp.sourceforge.net/).

It may turn out to be a simpler solution than that (hopefully!)

> On Tue, Oct 21, 2008 at 07:21:07AM +0200, Peter Herrington wrote:
>> My Clarkconnect server's email server component,postfix is configured to
>> OUTBOUND RELAY to my ISP mail server
>> Because that was the only way I could get my emails from my LAN to the
>> intended recipients on the internet.

 because very few mail servers will accept email from the IP ranges
allocated to ISPs as dynamic addresses (an anti-SPAM measure). I had to
configure sendmail in a similar way to get outgoing email to work.

Try making the same change to sendmail as you did to postfix. Add your
ISP's mail server as the sendmail "Smart" relay host, by appending it to
the DS line (no spaces) in sendmail.cf

In order to make the ISP's relay accept the outgoing email I had to ensure
that the message was "From" a email address which was registered with the
ISP, i.e. my primary email account name, or one of the additional accounts
which some ISPs let you create.

Allan

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Multiple jobs simultaneously with multiple storage daemons

2008-10-21 Thread John Drescher
On Tue, Oct 21, 2008 at 10:41 AM, Tonton Dede <[EMAIL PROTECTED]> wrote:
> Hello,
>
> we have 1 director and 2 storage daemons installed on 2 servers, each
> one with 1 tape drive.
>
> Both SD are configure and known by the director. In the director, le
> Maximum Concurrent jobs has been set to 2
>
You need to set Maximum Concurrent jobs in bacula-dir.conf more than 1
time. Once for the director. Once for each client that you want
concurrency. Possibly on each storage resource ( Do you want to run
more than 1 job at a time on each tape drive?)

>
> - is what we want to do possible (that is backup on several sd with 1
> director at the same time
> - how can this be achieved ?
>
See above. You may also have some problems if the jobs go to the same
pool and media type but to 2 different tape drives. And what I mean
about problems is bacula wanting the tape from one drive to be in the
other causing bacula to block.

John

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] REPLACE BSMTP with other mail program

2008-10-21 Thread John Lockard
If your problem is authentication or encryption then I would
suggest you check out msmtp (http://msmtp.sourceforge.net/).

This smtp client will use SSL/TLS for encrypted transport and
GSSAPI, Digest-MD5 and many more for authentication.

-John

On Tue, Oct 21, 2008 at 07:21:07AM +0200, Peter Herrington wrote:
> Hello
> 
> I am having the continual situation where the bsmtp cant send me emails
> because of various reasons,
> First it was invalid recipient.As Soon as I put in a valid email addr, it
> then says invalid sender.
> Now I just saw in the mail queue that my ISP email server refused the
> connection.
> 
> My Clarkconnect server's email server component,postfix is configured to
> OUTBOUND RELAY to my ISP mail server
> Because that was the only way I could get my emails from my LAN to the
> intended recipients on the internet.
> 
> My thinking goes if I can only put another email program in the email
> settings, one that authorise on smtp,
> My problem will be solved, unless of course bsmtp can do that.
> 
> Any pointers will be great
> 
> Rgds/Pete

-- 
"Maybe, just once, someone will call me 'sir' without
 adding, 'you're making a scene.'" - Homer Simpson
---
 John M. Lockard |  U of Michigan - School of Information
 Unix and Security Admin |  1214 SI Norsth - 1075 Beal Ave.
  [EMAIL PROTECTED] |Ann Arbor, MI  48109-2112
 www.umich.edu/~jlockard | 734-615-8776 | 734-647-8045 FAX
---

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Multiple jobs simultaneously with multiple storage daemons

2008-10-21 Thread Tonton Dede
Hello,

we have 1 director and 2 storage daemons installed on 2 servers, each
one with 1 tape drive.

Both SD are configure and known by the director. In the director, le
Maximum Concurrent jobs has been set to 2

- is what we want to do possible (that is backup on several sd with 1
director at the same time
- how can this be achieved ?

Kind regards and many thanks in advance
TD

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Fatal error: "backup.c:892 Network send error to SD"

2008-10-21 Thread Josh Fisher

Miguel Angel wrote:
> Hi list,
>
> I need your help, when launch a backup for a client ("nous-fd", OS: 
> WinXP), these work too slow, Bacula show me this error:
>
> 20-oct 23:18 bacula-sd JobId 39748: Job write elapsed time = 05:20:29, 
> Transfer rate = 41.78 K bytes/second
> 20-oct 23:18 nous-fd JobId 39748: Fatal error: 
> ../../filed/backup.c:892 Network send error to SD. ERR=No error
>
> I have no idea about what should be. May someone help me?
>

First, make sure Windows Firewall is not blocking incoming connections 
to TCP port 9102 or outgoing to TCP port 9103.

Otherwise, I have seen this behavior with Lenovo T61 laptops with Vista 
Business 32-bit. I got one to work by updating the driver for its Intel 
82566MM ethernet controler and disabling power saving features of the 
82566MM.  I believe the ethernet driver was (incorrectly) turning off 
the ethernet PHY to save power, even though there was still an open TCP 
connection.. If the ethernet driver, firewall, etc. drops the connection 
that the Bacula client makes to the Bacula storage daemon due to 
entering power saving mode, etc., then the Bacula client sees an I/O 
error when it tries to send more data to the SD.

>
> My configuration:
>
> Bacula version: bacula-dir Version: 2.4.2 (26 July 2008)
> SO: CentOS 5.0
> MySQL version: 14.12 Distrib 5.0.22
>
>
> Thanks, any help would be greatly appreciated.
>
>
>
>
> -- 
> Atentamente,
>
>
> Miguel Angel Moreno Bolaños
>
> Usuario Linux registrado No. 391784
> http://counter.li.org
>
> "El amor es un dolor entre pecho y espalda,
> que sabe a papas fritas sin salsa de tomate!"
>
> Att: Nous
> 
>
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 
>
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>   

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Windows / TLS / errors

2008-10-21 Thread Exim List
I have a client who would like data backed up on a remote Windows machine.

I have the bacula-fd.conf set up and working well by itself on the 
Windows 2003 server connecting to a Linux Director.

When I try to use TLS, I get errors.

Per suggestions, I created the .key, .csr and .crt files on a Unix 
machine to alleviate the hassle of using Openssl on Windows.

I copied these files to:

c:\documents and settings\all users\application data\bacula

as server.key, server.crt and the original ca.crt used on the issuing 
server.

I get this error when running 'bacula-fd -d100' from the command line:


Error: ../../lib/openssl.c:86 Error loading certification verification 
stores:  ERR=error:02001002:system library:fopen:No such file or directory

The next error is the same except it changes to 2006D080:BIO 
routines:BIO_new_file:no such file

Third error is 0B084002:x509 certificate 
routines:X509_load_cert_crl_file:system lib

Fourth error is Fatal Error at ../../filed/filed.c:323 because: Failed 
to initialize TLS context for File daemon "server" in bacula-fd.conf.


I've tried copying the crt files to c:\program files\bacula and changing 
the bacula-fd.conf to match.  That didn't help either.

I've scoured the web for about an hour and can't find anything pertinent 
to help.

Does anyone have any ideas?

Thanks.

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tape is marked as error after restore

2008-10-21 Thread Martijn de Munnik


On Oct 21, 2008, at 9:25 AM, bacula-users- 
[EMAIL PROTECTED] wrote:



Message: 19
Date: Mon, 20 Oct 2008 13:53:39 -0400
From: Dan Langille <[EMAIL PROTECTED]>
Subject: Re: [Bacula-users] Tape is marked as error after restore
To: Alan Brown <[EMAIL PROTECTED]>
Cc: "Erik P. Olsen" <[EMAIL PROTECTED]>,
bacula-users@lists.sourceforge.net
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=US-ASCII; format=flowed


On Oct 20, 2008, at 7:24 AM, Alan Brown wrote:


On Fri, 17 Oct 2008, Dan Langille wrote:

It has sometimes happened to me also. Maybe it's because the tape  
is

positioned
different from where Bacula believes it is. Try to change the error
flag to
append and see if it will be accepted by Bacula. I have several
times been able
to cure the problem this way.


I believe this was a known bug in earlier versions of Bacula.


It still happens.



You have seen this in what version of Bacula?

I'm using the blastwave package which is currently 2.2.8




--
Dan Langille
http://langille.org/


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Restore Bug?

2008-10-21 Thread Thomas
with 2.4.3 it is the same problem:


cwd is: /
$ cd etc
cwd is: /etc/
$ mark services
1 file marked.
$ done
Bootstrap records written to /var/lib/bacula/backup-dir.restore.1.bsr

The job will require the following
   Volume(s) Storage(s)SD Device(s)
===

   FUL142JBBB  JBBB


Enter SQL query: select slot,inchanger from media where volumename = 'FUL142';
+--+---+
| slot | inchanger |
+--+---+
|   25 | 0 |
+--+---+


21-Okt 11:58 backup-dir JobId 54512: Start Restore Job 
RestoreFiles.2008-10-21_11.58.06
21-Okt 11:58 backup-dir JobId 54512: Using Device "JBBB-1"
21-Okt 11:58 backup-sd-bb JobId 54512: Invalid slot=0 defined in catalog for 
Volume "FUL142" on "JBBB-1" (/dev/nst0). Manual load may be required.
21-Okt 11:58 backup-sd-bb JobId 54512: 3307 Issuing autochanger "unload slot 
18, drive 0" command.
21-Okt 11:59 backup-sd-bb JobId 54512: Warning: acquire.c:260 Wrong Volume 
mounted on device "JBBB-1" (/dev/nst0): Wanted FUL142 have INC033
21-Okt 11:59 backup-sd-bb JobId 54512: 3301 Issuing autochanger "loaded? drive 
0" command.
21-Okt 11:59 backup-sd-bb JobId 54512: 3302 Autochanger "loaded? drive 0", 
result: nothing loaded.
21-Okt 11:59 backup-sd-bb JobId 54512: 3304 Issuing autochanger "load slot 25, 
drive 0" command.
21-Okt 11:59 backup-sd-bb JobId 54512: 3305 Autochanger "load slot 25, drive 
0", status is OK.
21-Okt 11:59 backup-sd-bb JobId 54512: 3307 Issuing autochanger "unload slot 
25, drive 0" command.
21-Okt 12:00 backup-sd-bb JobId 54512: Warning: acquire.c:260 Wrong Volume 
mounted on device "JBBB-1" (/dev/nst0): Wanted FUL142 have FUL147
21-Okt 12:00 backup-sd-bb JobId 54512: Please mount Volume "FUL142" for:
Job:  RestoreFiles.2008-10-21_11.58.06
Storage:  "JBBB-1" (/dev/nst0)
Pool: FUL
Media type:   SDLT-320


next we put the tape into the changer:

*update slots
3306 Issuing autochanger "list" command.
Catalog record for Volume "FUL142" updated to reference slot 1.
Catalog record for Volume "INC008" is up to date.
Catalog record for Volume "INC009" is up to date.


*mount
The defined Storage resources are:
 1: JBGS
 2: JBBB
Select Storage resource (1-4): 2
Enter autochanger drive[0]:
Enter autochanger slot: 1
3001 OK mount. Device="JBBB-1" (/dev/nst0)
You have messages.
*m
21-Okt 12:09 backup-sd-bb JobId 54512: 3301 Issuing autochanger "loaded? drive 
0" command.
21-Okt 12:09 backup-sd-bb JobId 54512: 3302 Autochanger "loaded? drive 0", 
result: nothing loaded.
21-Okt 12:09 backup-sd-bb JobId 54512: 3304 Issuing autochanger "load slot 25, 
drive 0" command.
1-Okt 12:10 backup-sd-bb JobId 54512: 3305 Autochanger "load slot 25, drive 0", 
status is OK.
21-Okt 12:10 backup-sd-bb JobId 54512: 3307 Issuing autochanger "unload slot 
25, drive 0" command.
21-Okt 12:10 backup-sd-bb JobId 54512: Warning: acquire.c:260 Wrong Volume 
mounted on device "JBBB-1" (/dev/nst0): Wanted FUL142 have FUL147
21-Okt 12:10 backup-sd-bb JobId 54512: 3301 Issuing autochanger "loaded? drive 
0" command.
21-Okt 12:10 backup-sd-bb JobId 54512: 3302 Autochanger "loaded? drive 0", 
result: nothing loaded.
21-Okt 12:10 backup-sd-bb JobId 54512: 3304 Issuing autochanger "load slot 25, 
drive 0" command.
21-Okt 12:11 backup-sd-bb JobId 54512: 3305 Autochanger "load slot 25, drive 
0", status is OK.
21-Okt 12:11 backup-sd-bb JobId 54512: 3307 Issuing autochanger "unload slot 
25, drive 0" command.
21-Okt 12:11 backup-sd-bb JobId 54512: Warning: acquire.c:260 Wrong Volume 
mounted on device "JBBB-1" (/dev/nst0): Wanted FUL142 have FUL147
21-Okt 12:11 backup-sd-bb JobId 54512: Please mount Volume "FUL142" for:
Job:  RestoreFiles.2008-10-21_11.58.06
Storage:  "JBBB-1" (/dev/nst0)
Pool: FUL
Media type:   SDLT-320



grmpf.



Thomas schrieb:
> last month i had the problem described below,
> i will verify if it happens again with 2.4.3.
> 
> 
> starting a restore without the needed tape in the jukebox:
> (FUL138 is the needed tape)
> 
> 2008-09-18 14:54:41   Start Restore Job RestoreFiles.2008-09-18_14.54.04
> 2008-09-18 14:54:41   Using Device "JBBB-1"
> 2008-09-18 14:54:42   Invalid slot=0 defined in catalog for Volume "FUL138" 
> on "JBBB-1" (/dev/nst0). Manual load may be required.
> 2008-09-18 14:54:42   3301 Issuing autochanger "loaded? drive 0" command.
> 2008-09-18 14:54:42   3302 Autochanger "loaded? drive 0", result: nothing 
> loaded.
> 2008-09-18 14:54:42   Warning: acquire.c:221 Read open device "JBBB-1" 
> (/dev/nst0) Volume "FUL138" failed: ERR=dev.c:432 Unable to open device 
> "JBBB-1" (/dev/nst0): ERR=No medium found
> 2008-09-18 14:54:42   3301 Issuing autochanger "loaded? drive 0" command.
> 2008-09-18 14:54:42   3302 Autochanger "loaded? drive 0", result: nothing 
> loaded.
> 2008-09-18 14:54:42   3304 Issuing autochanger "load slot 22, 

Re: [Bacula-users] Restore Bug?

2008-10-21 Thread Thomas

last month i had the problem described below,
i will verify if it happens again with 2.4.3.


starting a restore without the needed tape in the jukebox:
(FUL138 is the needed tape)

2008-09-18 14:54:41 Start Restore Job RestoreFiles.2008-09-18_14.54.04
2008-09-18 14:54:41 Using Device "JBBB-1"
2008-09-18 14:54:42 Invalid slot=0 defined in catalog for Volume "FUL138" 
on "JBBB-1" (/dev/nst0). Manual load may be required.
2008-09-18 14:54:42 3301 Issuing autochanger "loaded? drive 0" command.
2008-09-18 14:54:42 3302 Autochanger "loaded? drive 0", result: nothing 
loaded.
2008-09-18 14:54:42 Warning: acquire.c:221 Read open device "JBBB-1" 
(/dev/nst0) Volume "FUL138" failed: ERR=dev.c:432 Unable to open device 
"JBBB-1" (/dev/nst0): ERR=No medium found
2008-09-18 14:54:42 3301 Issuing autochanger "loaded? drive 0" command.
2008-09-18 14:54:42 3302 Autochanger "loaded? drive 0", result: nothing 
loaded.
2008-09-18 14:54:42 3304 Issuing autochanger "load slot 22, drive 0" 
command.
2008-09-18 14:55:23 3305 Autochanger "load slot 22, drive 0", status is OK.
2008-09-18 14:55:35 3307 Issuing autochanger "unload slot 22, drive 0" 
command.
2008-09-18 14:56:02 Warning: acquire.c:260 Wrong Volume mounted on device 
"JBBB-1" (/dev/nst0): Wanted FUL138 have FUL140
2008-09-18 14:56:02 Please mount Volume "FUL138" for:
Job: RestoreFiles.2008-09-18_14.54.04
Storage: "JBBB-1" (/dev/nst0)
Pool: FUL
Media type: SDLT-320


bacula noticed that an invalid slot is defined
(=> the tape is not in the changer)
and then it loads the current tape from the slot
where the correct volume was last seen.
(the slot in the mediatable points to 22 for volume FUL138
but the inchanger-flag is set to 0)

next we put the tape FUL138 into the changer at a random slot (21).

run update slots:

Device "JBBB" has 26 slots.
Connecting to Storage daemon JBBB at backup-sd-bb.ic3s.de:9103 ...
3306 Issuing autochanger "list" command.

Catalog record for Volume "FUL138" updated to reference slot 21.
Catalog record for Volume "FUL140" updated to reference slot 22.

*

and then we mount slot 21:

*mount
The defined Storage resources are:
 1: JBGS
 2: JBBB
 3: FileStorageBB
 4: USBStorageBB1
Select Storage resource (1-4): 2
Enter autochanger drive[0]:
Enter autochanger slot: 21
3001 OK mount. Device="JBBB-1" (/dev/nst0)
You have messages.
*m
18-Sep 15:09 backup-sd-bb JobId 52022: 3301 Issuing autochanger "loaded? drive 
0" command.
18-Sep 15:09 backup-sd-bb JobId 52022: 3302 Autochanger "loaded? drive 0", 
result: nothing loaded.
18-Sep 15:09 backup-sd-bb JobId 52022: 3304 Issuing autochanger "load slot 22, 
drive 0" command.
18-Sep 15:10 backup-sd-bb JobId 52022: 3305 Autochanger "load slot 22, drive 
0", status is OK.
18-Sep 15:10 backup-sd-bb JobId 52022: 3307 Issuing autochanger "unload slot 
22, drive 0" command.
18-Sep 15:11 backup-sd-bb JobId 52022: Warning: acquire.c:260 Wrong Volume 
mounted on device "JBBB-1" (/dev/nst0): Wanted FUL138 have FUL140
18-Sep 15:11 backup-sd-bb JobId 52022: 3301 Issuing autochanger "loaded? drive 
0" command.
18-Sep 15:11 backup-sd-bb JobId 52022: 3302 Autochanger "loaded? drive 0", 
result: nothing loaded.
18-Sep 15:11 backup-sd-bb JobId 52022: 3304 Issuing autochanger "load slot 22, 
drive 0" command.
18-Sep 15:11 backup-sd-bb JobId 52022: 3305 Autochanger "load slot 22, drive 
0", status is OK.
18-Sep 15:11 backup-sd-bb JobId 52022: 3307 Issuing autochanger "unload slot 
22, drive 0" command.
18-Sep 15:12 backup-sd-bb JobId 52022: Warning: acquire.c:260 Wrong Volume 
mounted on device "JBBB-1" (/dev/nst0): Wanted FUL138 have FUL140
18-Sep 15:12 backup-sd-bb JobId 52022: Please mount Volume "FUL138" for:
Job:  RestoreFiles.2008-09-18_14.54.04
Storage:  "JBBB-1" (/dev/nst0)
Pool: FUL
Media type:   SDLT-320


bacula still mounts slot 22 instead of the one we entered on the mount command.
very strange  :(
we tried it a few times but the only way to go on with the restore
was to put the tape FUL138 into slot 22!




Alan Brown schrieb:
> 2.4.2-1 (Scott Barninger's RPM, but that shouldn't make any difference)
> 
> Using an autochanger.
> 
> Restores which only use a single tape are fine.
> 
> For multiple tape restores, even thought he tapes are in various slots,
> Bacula is insisting on loading all the tapes it wants from the first slot
> it uses.
> 
> IE: tape A,B,C,D are in slot 1,2,3,4
> 
> Bacula loads Tape C from slot 3.
> 
> Bacula then wants Tape A, but tries to load it from slot 3 and complains.
> 
> If Tape A is manually loaded, Bacula unloads it, loads slot 3 and then
> complains.
> 
> If Tape A is put in Slot 3 bacula loads it happily.
> 
> Repeat for Tapes B and D.
> 
> Can anyone else verify?
> 
> 
> AB
> 
> 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based app

Re: [Bacula-users] Windows fileset - regexdir

2008-10-21 Thread Thomas

i can confirm that the quantifier is not working with windows-fd's (Bacula 
2.4.3).
but an equal fileset works fine with a linux-client.

Best Regards

Thomas

bjoern_busch schrieb:
> Ok, It seams like the quantifier isn't working.
> 
> This works:
> 
> RegexDir = "D:/Project/External/[0-9][0-9][0-9][0-9][0-9]_.*"
> 
> Any idea why?
> 
> 
> 
> bjoern_busch wrote:
>> Hi,
>>
>> I've browsed the list now for a while, but I can't really find a solution,
>> so please excuse me, if there is already an answer and I missed it.
>>
>> Bacula is running on an Ubuntu machine, one client is a Windows 2003
>> Server. Everything works fine, but the one part of the FileSet doesn't get
>> interpreted as I thought it would be.
>>
>> The folders that I want to backup look like this:
>>
>> D:\Project\External\12345_Something
>> D:\Project\External\12346_Something2
>> D:\Project\External\12347_Something3
>> D:\Project\External\12348_Something4
>>
>> The folders that I want to exclude are the following:
>>
>> D:\Project\External\1234_Something
>> D:\Project\External\1233_Something
>> D:\Project\External\123456_Something
>>
>> So, assuming that I understood regular expressions and everything
>> correctly, the include for that should look like this:
>>
>> Include {
>>   Options {
>> signature = MD5
>> IgnoreCase = yes
>> Exclude = no
>> RegexDir = "[0-9]{5}_.*"
>>   }
>>   Options {
>> RegexDir = ".*"
>> Exclude = yes
>>   }
>>   File = "D:/Project/External/"
>> }
>>
>> But if I specify it like this, nothing gets backed up. I've tried several
>> other combinations, like:
>>
>> RegexDir = "D:/Project/External/[0-9]{4}_.*"
>> RegexDir = "^[0-9]{4}_.*"
>>
>> Please help me, I'm really clueless right now. To verify the correct
>> behavior, I use the estimate command. 
>>
>> Thanks in advance!
>>
> 

-- 
[:O]###[O:]

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread John Huttley

Run 'vacuum full'

but this will lock the database as it needs exclusive use of the tables.

After that, perform a reindex.

--John


ebollengier wrote:

If it's 40,000 rows of the filename or path table, each rows are something
like 10 or 15 bytes long

If you want to reduce the size of your database, you need to review your
retention periode or to prune jobs (ie, remove backup content information
from the catalog).

See the manual for more information (Automatic Volume Recycling chapter)


shahhe wrote:
  

This is probably a question for a PostgreSQL group, but I though users
using bacula may have come across this problem.

I am using PostgreSQL for the database, last week when I checked, my
database size was 10GB. I removed one month worth of volumes from the
bacula database and ran dbcheck command. It deleted about 40,000 rows from
the database, but the database size was still 10GB. Next, I ran postgresql
vacuumdb (vacuumdb -q -d bacula -z -f)command to reclaim the space used by
deleted rows, but the database size is still 10GB. How do I reduce the
size of the database?

I also backup the catalog every night using pgdump command. Before I
deleted the 40,000 rows the backup file size was 800MB, after deleting
40,000 rows the backup file size is still 800MB.


# df -h /baculaDB
FilesystemSize  Used Avail Use% Mounted on
/dev/mapper/VolGroup01-baculaDB
  99G   11G   83G  12% /baculaDB


bacula=# select pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) as size from
pg_database;
 datname  |  size   
---+-

template1 | 4272 kB
template0 | 4272 kB
postgres  | 4272 kB
bacula| 10 GB
(4 rows)


Hemant Shah




  
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread ebollengier

If it's 40,000 rows of the filename or path table, each rows are something
like 10 or 15 bytes long

If you want to reduce the size of your database, you need to review your
retention periode or to prune jobs (ie, remove backup content information
from the catalog).

See the manual for more information (Automatic Volume Recycling chapter)


shahhe wrote:
> 
> This is probably a question for a PostgreSQL group, but I though users
> using bacula may have come across this problem.
> 
> I am using PostgreSQL for the database, last week when I checked, my
> database size was 10GB. I removed one month worth of volumes from the
> bacula database and ran dbcheck command. It deleted about 40,000 rows from
> the database, but the database size was still 10GB. Next, I ran postgresql
> vacuumdb (vacuumdb -q -d bacula -z -f)command to reclaim the space used by
> deleted rows, but the database size is still 10GB. How do I reduce the
> size of the database?
> 
> I also backup the catalog every night using pgdump command. Before I
> deleted the 40,000 rows the backup file size was 800MB, after deleting
> 40,000 rows the backup file size is still 800MB.
> 
> 
> # df -h /baculaDB
> FilesystemSize  Used Avail Use% Mounted on
> /dev/mapper/VolGroup01-baculaDB
>   99G   11G   83G  12% /baculaDB
> 
> 
> bacula=# select pg_database.datname,
> pg_size_pretty(pg_database_size(pg_database.datname)) as size from
> pg_database;
>  datname  |  size   
> ---+-
> template1 | 4272 kB
> template0 | 4272 kB
> postgres  | 4272 kB
> bacula| 10 GB
> (4 rows)
> 
> 
> Hemant Shah
> 

-- 
View this message in context: 
http://www.nabble.com/Reducing-the-size-of-the-database.-tp20073848p20084840.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users