Re: [Bacula-users] cannot prune/purge volumes

2006-11-05 Thread Frank Sweetser
be patient with it. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E3

Re: [Bacula-users] cannot prune/purge volumes

2006-11-04 Thread Frank Sweetser
unt.ind.wpi.edu/wiki/doku.php?id=faq#why_does_dbcheck_take_forever_to_run has some sample indexes that you might try adding. Check the mysql manpage for your version of mysql to get the correct commands to add them. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Ne

Re: [Bacula-users] Files table hit 4GB limit

2006-10-25 Thread Frank Sweetser
d in > bconsole but I think it locked up or hung after that. Check the output of top - the database might just be busy, especially if your tables have lots of rows in them. For getting past the table size limit, try http://dev.mysql.com/doc/refman/5.0/en/full-table.html -- Frank Sweets

Re: [Bacula-users] Capacity planning

2006-10-25 Thread Frank Sweetser
lated to bacula capacity here: http://paramount.ind.wpi.edu/wiki/doku.php?id=database_statistics -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E

Re: [Bacula-users] When to use /dev/nst0 versus /dev/st0?

2006-10-23 Thread Frank Sweetser
On Mon, Oct 23, 2006 at 04:04:21PM -0700, John Felczak wrote: > Thank you for the speedy reply, Frank! So I'm doing the right thing by > specifying the drive as /dev/nst0 and the autochanger as /dev/sg4 in the > configs then. Exactly =) -- Frank Sweetser fs at wpi.edu | For

Re: [Bacula-users] When to use /dev/nst0 versus /dev/st0?

2006-10-23 Thread Frank Sweetser
ape drive interface, while the sg* devices are used for sending other SCSI commands, such as tape library change commands or vendor specific diagnostics. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL M

Re: [Bacula-users] Restore whacks server

2006-10-11 Thread Frank Sweetser
7;ll second what someone else mentioned - those error messages were indicating that the hard drive wasn't responding to the kernel commands. You should probably assume that the hardware in that system will finish dying soon. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solut

Re: [Bacula-users] bacula clients and OpenVPN?

2006-10-06 Thread Frank Sweetser
e any outgoing connections. Needs to accept incoming on 9103 from file daemons and director. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG finger

Re: [Bacula-users] bacula clients and OpenVPN?

2006-10-06 Thread Frank Sweetser
a single OpenVPN client on the director server simultaneously connecting to mulitple OpenVPN servers on the bacula clients. I'd bet that if you try to shoehorn a VPN based solution around bacula, you'll end up with a lot more headaches, but not much more security. -- Frank Sweetser fs

Re: [Bacula-users] bacula clients and OpenVPN?

2006-10-05 Thread Frank Sweetser
the sd Given that bacula uses exactly the same TLS libraries to authenticate and encrypt its data that openvpn does, you're probably better off just allowing bacula through the firewall. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer

Re: [Bacula-users] bacula clients and OpenVPN?

2006-10-05 Thread Frank Sweetser
connect to the bacula server > via OpenVPN when it was time to do the backup and then disconnect after > the backup job was completed for that particular client. Well, my first question would be - what are you trying to accomplish that can't already be done via native TLS? -- Frank Swee

Re: [Bacula-users] mysql server has gone away

2006-09-22 Thread Frank Sweetser
ombs when it tries to use the db handle. http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#mysql_server_has_gone_away Rumor was that a patch taht went into 1.38.7 fixed this, but it appears that the glitch is still there in some cases. -- Frank Sweetser fs at wpi.edu | For every problem, the

Re: [Bacula-users] (no subject)

2006-09-22 Thread Frank Sweetser
tores results in a straightforward SQL database, which means that you should be able to generate any reports you like without too much trouble. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL M

Re: [Bacula-users] useful indexes (was Re: dbcheck needs very long time...)

2006-09-20 Thread Frank Sweetser
of running explain (mysql, I assume postgresql has an equivalent) on the queries used. This info is really useful to find hotspots that would benefit the most from adding an index or two. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer |

Re: [Bacula-users] Please help me getting TLS!

2006-09-18 Thread Frank Sweetser
ling bacula to connect to. You'll probably have a much easier time setting up the certs with tinyCA instead of raw openssl commands. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken

Re: [Bacula-users] Tape compression and encryption

2006-09-17 Thread Frank Sweetser
en more FD cpu cycles), but tape compression probably won't buy you much of anything in either case. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129

Re: [Bacula-users] dbcheck needs very long time...

2006-09-07 Thread Frank Sweetser
o find that is in the documentation for your database. That way you can make sure you're getting accurate information, as opposed to something for a previous version or the like. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is

Re: [Bacula-users] dbcheck needs very long time...

2006-09-06 Thread Frank Sweetser
, yes, that is not inconceivable, but it is fixable. http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#why_does_dbcheck_take_forever_to_run -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken

Re: [Bacula-users] TLS attempts crashes FD

2006-09-05 Thread Frank Sweetser
On Tue, Sep 05, 2006 at 08:21:25PM -0400, Dan Langille wrote: > lists-fd: bsys.c:517 Could not open state file. sfd=-1 size=188: > ERR=No such file or directory Are you sure that the TLS errors aren't a red herring? -- Frank Sweetser fs at wpi.edu | For every problem, there is

Re: [Bacula-users] MySQL Server has gone away

2006-08-17 Thread Frank Sweetser
On Thu, Aug 17, 2006 at 11:31:12AM +0200, Warwick Bruce Chapman wrote: > Hi All > > Any ideas why I am getting this? http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#mysql_server_has_gone_away -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network

Re: [Bacula-users] Bacula backup error!

2006-08-14 Thread Frank Sweetser
g > definitive. I have plenty of space on my hardrives. You can use the perror command to translate mysql error codes: tty/1 1011 erwin 11:45:48 $ perror 28 OS error code 28: No space left on device -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Networ

Re: [Bacula-users] Oracle RMAN and Bacula

2006-08-07 Thread Frank Sweetser
On Mon, Aug 07, 2006 at 11:39:13AM -0300, Georger Araujo wrote: > OK, it's up at > http://paramount.ind.wpi.edu/wiki/doku.php?do=show&id=application_specific_backups#oracle_10g_release_2 Excellent writeup - thanks! -- Frank Sweetser fs at wpi.edu | For every problem, there is

Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for file:

2006-08-07 Thread Frank Sweetser
Try using the dbcheck utility to verify this and clean out any duplicate or stale records. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8

Re: [Bacula-users] Oracle RMAN and Bacula

2006-08-07 Thread Frank Sweetser
hare those scripts, a great place to do so is on the bacula wiki: http://paramount.ind.wpi.edu/wiki/ -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D2

Re: [Bacula-users] Bacula and xdelta ?

2006-08-05 Thread Frank Sweetser
ntire new file. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3

Re: [Bacula-users] Self Signed certificate

2006-07-31 Thread Frank Sweetser
ow if you're connected to a legitimate server or a malicious man in the middle attacker. I'd reccomend using TinyCA to set up your own mini CA instead. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is

Re: [Bacula-users] Terrible performance for backing up bacula server

2006-07-14 Thread Frank Sweetser
nly a few dozen k of throughput data post compression. The easiest way to test this would be just to disable software compression and try another set of backup runs for comparison. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simp

Re: [Bacula-users] bacula TLS

2006-07-06 Thread Frank Sweetser
CA certificate store is required > when using "TLS Verify Peer". You need to start by fixing this error first. You need to point the bacula daemons at the CA certificate that signed the server certificates you're using with a "TLS CA Certificate File = " directive for e

Re: [Bacula-users] RESOLVED: Re: UTF-8 file names support in Bacula ( OS X client)

2006-06-30 Thread Frank Sweetser
he manual > lacks all mention of Unicode/UTF-8, so I will add this to my todo so it does > not get lost. I've thrown a note in the wiki about adding this in. I'll make sure to try and write something up when I get back in a few weeks. -- Frank Sweetser fs at wpi.edu | For

Re: [Bacula-users] The Table "file" is full!?

2006-06-26 Thread Frank Sweetser
a 1.38.3. Any Idea? Yep. http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#why_does_mysql_say_my_file_table_is_full -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D

Re: [Bacula-users] bacula-dir crashes while building the dir tree on a restore job

2006-06-22 Thread Frank Sweetser
there are entire books written on the subject of tuning MySQL and b) the "best practices" for it changer over time with new releases, I'd say the best thing to do is probably just point users to http://dev.mysql.com/doc/refman/5.0/en/optimization.html -- Frank Sweetser fs at wpi.edu

Re: [Bacula-users] Poor quality of reported problems.

2006-06-22 Thread Frank Sweetser
uldn't help with the problem description, but would make it more likely the report would include basic configuration (config files minus passwords, operating system, database, etc). -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | i

Re: [Bacula-users] No errors - No backup

2006-06-20 Thread Frank Sweetser
et; ending with no errors. Is /home a mountpoint for a seperate filesystem? -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 12

Re: [Bacula-users] 3 running processes of fd daemon.

2006-06-18 Thread Frank Sweetser
. Check the man pages for ps to see if you can get it to show you the difference more accuratelly. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21

Re: [Bacula-users] I love my bacula, but my boss says throughput is too slow.... :-( What can I do to optimize?

2006-06-18 Thread Frank Sweetser
obably will want to add the skip-networking option to the [mysqld] section of your /etc/my.cnf config file. This option will completely disable all network support, and mysqld won't even open a network socket at all. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution

Re: [Bacula-users] Bacula is using too much hard drive storage

2006-06-09 Thread Frank Sweetser
am currenlty > backing up about 160 GB compressed data on tape backup. > > > I tried running vacuum full verberos on the database and prune some of the > files from Bacula ,but the data directory remains the same size. You may also want to consider reducing your retention periods

Re: [Bacula-users] Backup Sql Server

2006-05-23 Thread Frank Sweetser
iki/doku.php?id=application_specific_backups#microsoft_sql_server and/or the bacula-users mailing list archive for a little more info on how you might do this. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken

Re: [Bacula-users] Doubt about tape space management

2006-05-19 Thread Frank Sweetser
b? No, it will not. Bacula will not reuse that space until it decides to recycle that volume. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4

Re: [Bacula-users] Restoring from old tapes

2006-05-18 Thread Frank Sweetser
atalog. This will allow you to restore from the volume without having it immediately purged. When you have restored and backed up the data, you can reset the VolStatus to Used and the Volume will be purged from the catalog. -- Frank Sweetser fs at wpi.edu | For every problem, there is a so

Re: [Bacula-users] backup fails when scheduled, works when run by hand

2006-05-16 Thread Frank Sweetser
ons at http://dev.mysql.com/doc/refman/4.1/en/gone-away.html -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29

Re: [Bacula-users] backing up snapshots?

2006-05-16 Thread Frank Sweetser
/wiki/doku.php?id=application_specific_backups#linux_lvm_snapshots One minor disadvantage, is that bacula will store the paths of the snapshot mount point (ie, '/snapshot/data/' rather than '/data/'). -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI N

Re: [Bacula-users] backup fails when scheduled, works when run by hand

2006-05-16 Thread Frank Sweetser
,'2006-05-12 10:30:00',1147426200) failed: > Lost connection to MySQL server during query What version of bacula and what version of mysql are you running? -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, eleg

Re: [Bacula-users] Examples on the website

2006-05-11 Thread Frank Sweetser
honest it wasn't an 'unofficial' > version I was after. Kern is certainly aware of it, and approves of its existence. I believe he was planning on linking to it from the bacula main page, but I'd imagine it's pretty low on his priority list at this point. -- Frank S

Re: [Bacula-users] Examples on the website

2006-05-11 Thread Frank Sweetser
t; What do people think? Would they find this beneficial. As it just so happens, there is a page set aside on the wiki for just this purpose: http://paramount.ind.wpi.edu/wiki/doku.php?id=sample_configs -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network

Re: [Bacula-users] Refreshing the configuration

2006-04-26 Thread Frank Sweetser
On Wed, Apr 26, 2006 at 09:47:20PM +0300, Silver Salonen wrote: > Yup, bacula-dir and bacula-sd run under bacula, but all the config-files > belonged to root and were 660. > > Now Bacula reloads nicely, thanks :) No problem =) Now to go add that to the faq... -- Frank Sweetser f

Re: [Bacula-users] Refreshing the configuration

2006-04-26 Thread Frank Sweetser
user, but one or more of the required config and/or certificate files are readable only by root. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4

Re: [Bacula-users] Restore error!

2006-04-24 Thread Frank Sweetser
e the necessary changes. Is that the problem? Nope - this is not a bacula problem at all. The problem is that your MySQL server ran out of disk space, either for it's primary table storage or temporary table storage. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solut

Re: [Bacula-users] Restore error!

2006-04-24 Thread Frank Sweetser
t.FileSet: ERR=Got > error 28 from storage engine MySQL error 28 translates to no space left on device. Most likely, either the partition holding your msyql database is full, or the partition where mysql is creating temporary tables is full. -- Frank Sweetser fs at wpi.edu | For every problem, the

Re: [Bacula-users] Jobstatus values?

2006-04-17 Thread Frank Sweetser
iki/doku.php?id=faq#what_do_all_those_job_status_codes_mean -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3

Re: [Bacula-users] Re: Director crashing: same results with one processor

2006-04-08 Thread Frank Sweetser
bject file: No such file or directory -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3

Re: [Bacula-users] Preventing "mysql server has gone away" problem.

2006-04-07 Thread Frank Sweetser
On Fri, Apr 07, 2006 at 11:59:34PM +0200, Erik P. Olsen wrote: > Sorry, but could you spell out where I can find this FAQ? http://paramount.ind.wpi.edu/wiki/doku.php?id=faq -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is sim

Re: [Bacula-users] Preventing "mysql server has gone away" problem.

2006-04-07 Thread Frank Sweetser
It would probably be better if I actually attached the patch, huh? -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC

Re: [Bacula-users] Preventing "mysql server has gone away" problem.

2006-04-07 Thread Frank Sweetser
MYSQL_OPT_RECONNECT is if the internal structure changes at some point, and the reconnect flag is no longer directly accessible. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL M

Re: [Bacula-users] Preventing "mysql server has gone away" problem.

2006-04-06 Thread Frank Sweetser
a were to ever support database level transactions, it's worth noting that using the reconnect flag will break transactions. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerp

Re: [Bacula-users] Preventing "mysql server has gone away" problem.

2006-04-06 Thread Frank Sweetser
mysqld] section. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC

Re: [Bacula-users] Re: Bacula codes

2006-03-30 Thread Frank Sweetser
m I blind? ehehe ) > >Can anyone tell me where can I find them please? > > See the Bacula wiki, address should be somewhere in the list archive... > I remember that someone announced that the codes are in there. Yup - http://paramount.ind.wpi.edu/wiki/ -- Frank Sweetser fs at wpi

Re: [Bacula-users] Windows Bare Metal Recovery

2006-03-24 Thread Frank Sweetser
re it out again?! http://paramount.ind.wpi.edu/wiki/doku.php?id=windows_bare_metal_recovery Note that it's complicated, and utterly untested. If you have any luck with it, or find anything wrong with those directions, feel free to update them to reflect reality more closely. -- Frank Sweetser

Re: [Bacula-users] Database Corrupt?

2006-03-20 Thread Frank Sweetser
red the tables? > FROM Pool WHERE Pool.Name='apollodesignfull' failed: > Got error 127 from table handler Error 127 means that there is still corruption in the database table files. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network

Re: [Bacula-users] Database Corrupt?

2006-03-17 Thread Frank Sweetser
e for table: 'Filename'. Try to repair it > Is it possible that my database can be corrupt? Almost certain, given that the database server asked you to run a repair on the tables. Assuming you're running MySQL, you can get directions on how to do so at http://dev.mysql.com/doc/re

Re: [Bacula-users] Client Run After Spool?

2006-03-10 Thread Frank Sweetser
ve is to have the RunBefore script stop the database, copy it to a staging area, restart the database, and then let the staging area get backed up. The RunAfter script would then clean up the staging area. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Netw

Re: [Bacula-users] Followup: Problems with winbacula-1.38.4

2006-03-02 Thread Frank Sweetser
I should also point out I had it working with stunnel running natively. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3

Re: [Bacula-users] Followup: Problems with winbacula-1.38.4

2006-03-02 Thread Frank Sweetser
with a destination ethernet address of a Windows box and a destination IP address in the 127 range. In quite a few configurations, the Windows box will actualy process the packet! -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is

Re: [Bacula-users] Followup: Problems with winbacula-1.38.4

2006-03-02 Thread Frank Sweetser
t > hostname due to firwalling issues): The error is: The Windows loopback interface is implemented poorly at best. I had luck using this kind of tunneling in Windows by explicitly specifying 127.0.0.1 instead of localhost. -- Frank Sweetser fs at wpi.edu | For every problem, there is a sol

Re: [Bacula-users] How do we specify compatible media?

2006-02-24 Thread Frank Sweetser
; will use the changer when a tape fills... This sounds like a pretty usefull setup. If you have a few extra minutes, would you mind posting the relevant bits of your config into sample configs section of the wiki? http://paramount.ind.wpi.edu/wiki/doku.php?id=sample_configs -- Frank Sweetse

Re: [Bacula-users] RunBeforeJob and su command

2006-02-24 Thread Frank Sweetser
On Fri, Feb 24, 2006 at 06:41:20PM +0100, Torsten Uhlmann wrote: > How can I execute commands from Bacula that must run as root and do "su", > tar and other things? Check out the 'sudo' command. With it, you can grant certain users the right to run certain commands as

Re: [Bacula-users] Bacula & dell PowerVault 110T LTO2 drive

2006-02-13 Thread Frank Sweetser
132T dual LTO2 works quite happily under FC4. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4

Re: [Bacula-users] Bare-metal recovery Windows 2003 Server (PDC)

2006-02-08 Thread Frank Sweetser
so it would be great if you or anyone else out there who is could check it over to make sure I didn't munge any of the technical details, or to add in or clarify anything else. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer |

Re: [Bacula-users] Autochanger with multiple drives

2006-02-03 Thread Frank Sweetser
> device /dev/nst0. > > Do you have any ideas how to force Bacula to use all available drives? Check the Prefer Mounted Volumes option in the manual at http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000143000 -- Frank Sweetser fs at wpi.edu | For every proble

Re: [Bacula-users] include all dot-files from $HOME

2006-02-02 Thread Frank Sweetser
R a second literal . followed by ANY character > >) (end of the EITHER-OR part) > >.* followed by ANY ZERO OR MORE additional characters > >$ and then ends. > > Great. And now, put that into the manual :-) Or perhaps the wiki? http://paramount.ind.wpi.edu/wiki -

Re: [Bacula-users] Re: The table 'File' is full

2006-02-01 Thread Frank Sweetser
to do... -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC --

Re: [Bacula-users] The table 'File' is full

2006-02-01 Thread Frank Sweetser
976,'Bc sHVV IGk B Yc Y CwOuQ WvE BAA C4 BD0Kbs > BD0Kbs BD2MTW A A C','0') failed: > The table 'File' is full If you start up the mysql client, what does the query select count(*) from File; return? -- Frank Sweetser fs at wpi.edu | For every proble

Re: [Bacula-users] Autochange support

2006-01-31 Thread Frank Sweetser
has numbers they'd like to throw into the fray here, I'd love to get some hard numbers back. The script to do so, and any results as I get them, are at http://paramount.ind.wpi.edu/wiki/doku.php?id=database_statistics -- Frank Sweetser fs at wpi.edu | For every problem, there is a solu

Re: [Bacula-users] Wanted: a better mousetrap (Bscan)

2006-01-31 Thread Frank Sweetser
p a few staging tables, dump the results from each tape into them, and then aggregate the results together into the normal operational tables with a few INSERT ... SELECT statements. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer |

Re: [Bacula-users] monthy full backup -> archive

2006-01-30 Thread Frank Sweetser
me from the backup tapes which > are presumed more easily accessible than archive tapes which might be > taken offsite. Very slick! Any chance I could convince you to do a slightly more detailed writeup on the wiki? =) http://paramount.ind.wpi.edu/wiki/doku.php?id=sample_configs -- Frank

Re: [Bacula-users] Restore job where multiple storage directives exist

2006-01-30 Thread Frank Sweetser
etc, and you should be all set. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3

Re: [Bacula-users] Bacula size/statistics

2006-01-30 Thread Frank Sweetser
nd uploaded it to the wiki. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC bacula-dbstats.gz Description: GNU Zip compressed data

Re: [Bacula-users] Bacula size/statistics

2006-01-30 Thread Frank Sweetser
version work for you and produce the same results? select sum(J1.JobFiles) from Job as J1 where J1.JobId = ( select J2.JobId from Job as J2 where J2.Name = J1.Name and J2.Type = 'B' and J2.Level = 'F' and J2.JobStatus = 'T' order by J2.SchedTime desc lim

[Bacula-users] Bacula size/statistics

2006-01-29 Thread Frank Sweetser
is, I hacked up a perl script that extracts a few basic statistics out of the catalog. You can find the script at http://paramount.ind.wpi.edu/wiki/doku.php?id=database_statistics Once some data starts coming in, I'll put together another site with the results. -- Frank Sweetser fs at w

Re: [Bacula-users] Large Bacula databases and bacula's dbcheck

2006-01-28 Thread Frank Sweetser
you have in these two tables? select count(*) from File; select count(*) from Job; -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3

Re: [Bacula-users] sd question

2006-01-26 Thread Frank Sweetser
an i just > make a sort of "redirection" instead of installing something?, what do > you recommend? http://bacula.org/rel-manual/What_is_Bacula.html#104 All of the components of bacula - director, storage, file daemon, catalog server, and console - can run on seperate systems. -- Fr

Re: [Bacula-users] Problem with chroot from bare metal rescue disk

2006-01-23 Thread Frank Sweetser
t in your path, so it's not searching ./bacula after you chroot. Try it with the full absolute path to bacula-fd after chrooting, /bacula/bin/bacula-fd -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and

Re: [Bacula-users] TLS : can't get started

2006-01-22 Thread Frank Sweetser
ssword from it. You can do so with the openssl command: openssl rsa -in password.key -out nopassword.key -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129

Re: [Bacula-users] Re: [Bacula-devel] Fwd: Time for a Bacula book?

2006-01-13 Thread Frank Sweetser
d is a separate documentation mailing list to gather > together the interested parties and then to draw up a strategy for the > documentation as a sub-project. I'll second that. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer

Re: [Bacula-users] Fwd: Time for a Bacula book?

2006-01-11 Thread Frank Sweetser
s.com/cp/info/sell/books.aspx In addition to the full book, it might be useful to make available a smaller "Oh Sh*t!" pocket reference version for when things go really wrong - basically, a quick quide to bare metal recovery, rebuilding the catalouge, etc. -- Frank Sweetser fs at wpi

Re: [Bacula-users] Backup xattrs (SELinux)?

2006-01-04 Thread Frank Sweetser
backing up selinux attributes was on my todo list anyway =) -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3

Re: [Bacula-users] Backup xattrs (SELinux)?

2006-01-04 Thread Frank Sweetser
har *name, ... int fsetxattr (int filedes, const char *name, ... -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E

Re: [Bacula-users] Backup xattrs (SELinux)?

2006-01-04 Thread Frank Sweetser
ing leading '/' from absolute path names # file: bin/ls security.selinux="system_u:object_r:ls_exec_t\000" This is how selinux encodes that /bin/ls has an selinux context of system_u:object_r:ls_exec_t on disk. Make sense? -- Frank Sweetser fs at wpi.edu | For every probl

Re: [Bacula-users] Backup xattrs (SELinux)?

2006-01-04 Thread Frank Sweetser
, and you would have to work a way to reapply those contexts on restore manually, but at least the data would be there. That said, I don't suppose there happen to be any plans to backup xattrs? I'd be more than happy to volunteer to test out any code to do so. -- Frank Sweetser fs at wpi

Re: [Bacula-users] DELL PV132LTO1 or PV132LTO2 compatible with Bacula

2006-01-03 Thread Frank Sweetser
ically, but we're using one flawlessly under Linux. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8

Re: [Bacula-users] autochanger question

2005-12-20 Thread Frank Sweetser
ackups can easily be transfered to offsite storage. To facilitate this, I'd like to be able to have all of a given run of full backups end up on a single tape set. Will using both drives like this interfere with doing so? -- Frank Sweetser fs at wpi.edu | For every problem, there

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Frank Sweetser
v.mysql.com/doc/refman/4.1/en/optimize-table.html -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E

Re: [Bacula-users] Re: error with mysql and suse 9.3

2005-12-12 Thread Frank Sweetser
ql -L/usr/lib/mysql -lmysqlclient_r -lz -lfind -lbac -lm -lpthread > /usr/lib/gcc-lib/i586-suse-linux/3.3.5/../../../../i586-suse-linux/bin/ld: > cannot find -lz Looks like it's asking for the devel version of the zlib package. Install that and try again. -- Frank Sweetser fs at

Re: [Bacula-users] Prepending meta-data to volumes?

2005-12-09 Thread Frank Sweetser
destroyed, how can you recover? The volumes do indeed have enough metadata to recover the catalog if lost. You can find the details on it in the bacula manual. http://bacula.org/rel-manual/Volume_Utility_Tools.html#SECTION0003672000000 -- Frank Sweetser fs at wpi.edu | For every proble

Re: [Bacula-users] RHEL 4 and Bacula 1.38.2

2005-12-09 Thread Frank Sweetser
ot;build_rhel4 1" --define > "build_mysql4 1" You need to specify --define "build_mysql" in addition to build_mysql4. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL

Re: [Bacula-users] File daemon/director spinning at 100% cpu?

2005-12-07 Thread Frank Sweetser
On Mon, Dec 05, 2005 at 12:42:02PM +0100, Kern Sibbald wrote: > Are you using comm encryption? Yes. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 1

Re: [Bacula-users] File daemon/director spinning at 100% cpu?

2005-12-06 Thread Frank Sweetser
thanks! -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC diff -u -r bacula-1.38.2-select/src/lib/bnet.c bacul

Re: [Bacula-users] File daemon/director spinning at 100% cpu?

2005-12-05 Thread Frank Sweetser
look into > before the 1.38.0 release ... Ah, I see, I didn't realize you meant this was expected. Any chance this will change in a future rev? -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wr

Re: [Bacula-users] File daemon/director spinning at 100% cpu?

2005-12-05 Thread Frank Sweetser
On Mon, Dec 05, 2005 at 08:26:55PM +, Martin Simmons wrote: > attach $pid > thread apply all bt Attached. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint

Re: [Bacula-users] File daemon/director spinning at 100% cpu?

2005-12-05 Thread Frank Sweetser
On Mon, Dec 05, 2005 at 08:07:30PM +, Martin Simmons wrote: > I think you'll have to attach gdb to it to see where this thread looping. I'm only vaguely familiar with gdb; got any pointers on how I should start? -- Frank Sweetser fs at wpi.edu | For every problem, there is a

Re: [Bacula-users] File daemon/director spinning at 100% cpu?

2005-12-05 Thread Frank Sweetser
3 read(5, 0x8cf3038, 5) = -1 EAGAIN (Resource temporarily unavailable) 2103 select(6, [5], NULL, [5], {0, 0}) = 0 (Timeout) 2103 read(5, 0x8cf3038, 5) = -1 EAGAIN (Resource temporarily unavailable) -- Frank Sweetser fs at wpi.edu | For every problem, there is a solu

<    1   2   3   4   >