I got some error messages below and am told the Bacula database may be
corrupt. How can I tell for sure? Can someone tell me what I should do
if it is? I'm not as worried about preserving old data as I am about
being able to begin running back-ups again as soon as possible, so if I
have to do something crazy like delete and rebuild this database, that's
OK. Details on my setup with config files are at the bottom of this
message. Thanks again for your attention and any assistance!
Mike
Clip from my previous message to the list:
=> Thanks, Mark! Your suggestion got rid of the Permission denied bit but
Glad that helped.
=> I still get the below message, which is still preventing me from
=> backing stuff up.
=>
=> 09-May 14:56 bmm-s1-dir: Client1.2007-05-09_14.56.02 Fatal error:
=> catreq.c:346 Attribute create error. sql_create.c:685 Create db
=> Filename record INSERT INTO Filename (Name) VALUES ('') failed. ERR=no
=> such table: Filename
Sounds like the database is corrupt and missing the "Filename" table.
=> 09-May 14:56 bmm-s1-dir: Client1.2007-05-09_14.56.02 Error: Bacula
=> 1.36.3 (22Apr05): 09-May-2007 14:56:18
=>
=> Know what I can do to get rid of that?
Some suggestions:
report the problem to the bacula mailing list
upgrade to a more current version (1.36.3 is ancient)
My System:
OS: Ubuntu Linux 6.06
Bacula version: 1.36.3
Tape changer: Quantum Superloader 3, LTO Ultrium 3
Changer passes btape autochanger test.
Config files:
************Bacula-dir.conf***************
[EMAIL PROTECTED]:/etc/bacula# cat bacula-dir.conf
#
# Default Bacula Director Configuration file
#
# The only thing that MUST be changed is to add one or more
# file or directory names in the Include directive of the
# FileSet resource.
#
# For Bacula release 1.36.3 (22 April 2005) -- debian testing/unstable
#
# You might also want to change the default email address
# from root to your address. See the "mail" and "operator"
# directives in the Messages resource.
#
Director { # define myself
Name = bmm-s1-dir
DIRport = 9101 # where we listen for UA connections
QueryFile = "/etc/bacula/scripts/query.sql"
WorkingDirectory = "/var/lib/bacula"
PidDirectory = "/var/run/bacula"
Maximum Concurrent Jobs = 1
Password = "" # Console password
Messages = Daemon
}
JobDefs {
Name = "DefaultJob"
Type = Backup
Level = Full
Client = bmm-s1-fd
FileSet = "Full Set"
Schedule = "WeeklyCycle"
Storage = LTO-3
Messages = Standard
Pool = Default
Priority = 10
}
#
# Define the main nightly save backup job
# By default, this job will back up to disk in /tmp
Job {
Name = "Client1"
JobDefs = "DefaultJob"
Write Bootstrap = "/var/lib/bacula/Client1.bsr"
}
# Backup the catalog database (after the nightly save)
Job {
Name = "BackupCatalog"
JobDefs = "DefaultJob"
Level = Full
FileSet="Catalog"
Schedule = "WeeklyCycleAfterBackup"
# This creates an ASCII copy of the catalog
RunBeforeJob = "/etc/bacula/scripts/make_catalog_backup -u<user>
-p<password>"
# This deletes the copy of the catalog
RunAfterJob = "/etc/bacula/scripts/delete_catalog_backup"
Write Bootstrap = "/var/lib/bacula/BackupCatalog.bsr"
Priority = 11 # run after main backup
}
# Standard Restore template, to be changed by Console program
Job {
Name = "RestoreFiles"
Type = Restore
Client=bmm-s1-fd
FileSet="Full Set"
Storage = LTO-3
Pool = Default
Messages = Standard
Where = /tmp/bacula-restores
}
# List of files to be backed up
FileSet {
Name = "Full Set"
Include {
File = /home/mike
Options { compression=GZIP
signature = MD5 }
}
#
# Put your list of files here, preceded by 'File =', one per line
# or include an external list with:
#
# File = <file-name
#
# Note: / backs up everything on the root partition.
# if you have other partitons such as /usr or /home
# you will probably want to add them too.
#
# By default this is defined to point to the Bacula build
# directory to give a reasonable FileSet to backup to
# disk storage during initial testing.
#
# File = /build/buildd/bacula-1.36.3
# }
#
# If you backup the root directory, the following two excluded
# files can be useful
#
Exclude {
File = /proc
File = /tmp
File = /.journal
File = /.fsck
}
}
#
# When to do the backups, full backup on first sunday of the month,
# differential (i.e. incremental since full) every other sunday,
# and incremental backups other days
Schedule {
Name = "WeeklyCycle"
Run = Full 1st sun at 1:05
Run = Differential 2nd-5th sun at 1:05
Run = Full mon-sat at 1:05
}
# This schedule does the catalog. It starts after the WeeklyCycle
Schedule {
Name = "WeeklyCycleAfterBackup"
Run = Full sun-sat at 1:10
}
# This is the backup of the catalog
FileSet {
Name = "Catalog"
Include {
Options {
signature = MD5
}
File = /var/lib/bacula/bacula.sql
}
}
# Client (File Services) to backup
Client {
Name = bmm-s1-fd
Address = bmm-s1
FDPort = 9102
Catalog = MyCatalog
Password = "" # password for FileDaemon
File Retention = 30 days # 30 days
Job Retention = 6 months # six months
AutoPrune = yes # Prune expired Jobs/Files
}
# Definiton of file storage device
Storage {
Name = LTO-3 # Do not use "localhost" here
Address = bmm-s1.bmmad.internal # N.B. Use a fully qualified name here
SDPort = 9103
Password = ""
Device = LTO-3
Media Type = LTO-3
}
# Generic catalog service
Catalog {
Name = MyCatalog
dbname = bacula; password = "@db_pswd@"
}
# Reasonable message delivery -- send most everything to email address
# and to the console
Messages {
Name = Standard
#
# NOTE! If you send to two email or more email addresses, you will need
# to replace the %r in the from field (-f part) with a single valid
# email address in both the mailcommand and the operatorcommand.
#
mailcommand = "/usr/lib/bacula/bsmtp -h localhost -f \"\(Bacula\)
%r\" -s \"Bacula: %t %e of %c %l\" %r"
operatorcommand = "/usr/lib/bacula/bsmtp -h localhost -f
\"\(Bacula\) %r\" -s \"Bacula: Intervention needed for %j\" %r"
mail = [EMAIL PROTECTED] = all, !skipped
operator = [EMAIL PROTECTED] = mount
console = all, !skipped, !saved
#
# WARNING! the following will create a file that you must cycle from
# time to time as it will grow indefinitely. However, it will
# also keep all your messages if they scroll off the console.
#
append = "/var/lib/bacula/log" = all, !skipped
}
#
# Message delivery for daemon messages (no job).
Messages {
Name = Daemon
mailcommand = "/usr/lib/bacula/bsmtp -h localhost -f \"\(Bacula\)
%r\" -s \"Bacula daemon message\" %r"
mail = [EMAIL PROTECTED] = all, !skipped
console = all, !skipped, !saved
append = "/var/lib/bacula/log" = all, !skipped
}
# Default pool definition
Pool {
Name = Default
Pool Type = Backup
Recycle = yes # Bacula can automatically
recycle Volumes
AutoPrune = yes # Prune expired volumes
Volume Retention = 365 days # one year
Accept Any Volume = yes # write on any volume in the pool
}
#
# Restricted console used by tray-monitor to get the status of the
director
#
Console {
Name = bmm-s1-mon
Password = ""
CommandACL = status, .status
}
###################### fileserver Client #####################
Job {
Name = "lasbmms1w03"
Type = Backup
Level = Full
Client = lasbmms1w03-fd
FileSet = "fileserver"
Schedule = "WeeklyCycle"
Storage = LTO-3
Messages = Standard
Pool = Default
Write Bootstrap = "/var/lib/bacula/lasbmms1w03.bsr"
}
# Client (File Services) to backup
Client {
Name = lasbmms1w03-fd
Address = lasbmms1w03.bmmad.internal
FDPort = 9102
Catalog = MyCatalog
Password = "" # password for
File Retention = 30d # 30 days
Job Retention = 180d # six months
AutoPrune = yes # Prune expired Jobs/Files
}
# List of files to be backed up
FileSet {
Name = "fileserver"
Include {
File = d:/home/departments/bmmna_transfer
Options { compression=GZIP
signature = MD5 }
}
}
# Standard Restore template, to be changed by Console program
Job {
Name = "fileserverrestore"
Type = Restore
Client=lasbmms1w03-fd
FileSet="fileserver"
Storage = LTO-3
Pool = Default
Messages = Standard
Where = /tmp/bacula-restores
}
###################### Test Client #####################
#Job {
# Name = "bmm-dsalour"
# Type = Backup
# Client = bmm-dsalour-fd
# FileSet = "test1"
# Schedule = "WeeklyCycle"
# Storage = File
# Messages = Standard
# Pool = Default
# Write Bootstrap = "/var/lib/bacula/bmm-dsalour.bsr"
#}
## Client (File Services) to backup
#Client {
# Name = bmm-dsalour-fd
# Address = 10.0.3.26
# FDPort = 9102
# Catalog = MyCatalog
# Password = "" # password for
# File Retention = 30d # 30 days
# Job Retention = 180d # six months
# AutoPrune = yes # Prune expired Jobs/Files
#}
## List of files to be backed up
#FileSet {
# Name = "test1"
# Include {
# File = d:/home/departments/bmmna_transfer
# Options { compression=GZIP
# signature = MD5 }
# }
#}
***********bacula-sd.conf*********************
[EMAIL PROTECTED]:/etc/bacula# cat bacula-sd.conf
#
# Default Bacula Storage Daemon Configuration file
#
# For Bacula release 1.36.3 (22 April 2005) -- debian testing/unstable
#
# You may need to change the name of your tape drive
# on the "Archive Device" directive in the Device
# resource. If you change the Name and/or the
# "Media Type" in the Device resource, please ensure
# that dird.conf has corresponding changes.
#
Storage { # definition of myself
Name = bmm-s1-sd
SDPort = 9103 # Director's port
WorkingDirectory = "/var/lib/bacula"
Pid Directory = "/var/run/bacula"
Maximum Concurrent Jobs = 20
}
#
# List Directors who are permitted to contact Storage daemon
#
Director {
Name = bmm-s1-dir
Password = ""
}
#
# Restricted Director, used by tray-monitor to get the
# status of the storage daemon
#
Director {
Name = bmm-s1-mon
Password = ""
Monitor = yes
}
#
# Devices supported by this Storage daemon
# To connect, the Director's bacula-dir.conf must have the
# same Name and MediaType.
#
#Device {
# Name = FileStorage
# Media Type = File
# Archive Device = /tmp
# LabelMedia = yes; # lets Bacula label unlabeled media
# Random Access = Yes;
# AutomaticMount = yes; # when device opened, read it
# RemovableMedia = no;
# AlwaysOpen = no;
#}
#
# A Linux or Solaris tape drive
#
Device {
Name = LTO-3 #
Media Type = LTO-3
Archive Device = /dev/nst0
AutomaticMount = yes; # when device opened, read it
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
Changer Command = "/etc/bacula/scripts/mtx-changer %c %o %S %a %d"
Changer Device = /dev/sg2
AutoChanger = yes
Alert Command = "sh -c 'tapeinfo -f %c |grep TapeAlert|cat'"
}
#
# Send all messages to the Director,
# mount messages also are sent to the email address
#
Messages {
Name = Standard
director = bmm-s1-dir = all
}
*************bacula-fd.conf*******************
[EMAIL PROTECTED]:/etc/bacula# cat bacula-fd.conf
#
# Default Bacula File Daemon Configuration file
#
# For Bacula release 1.36.3 (22 April 2005) -- debian testing/unstable
#
# There is not much to change here except perhaps the
# File daemon Name to
#
#
# List Directors who are permitted to contact this File daemon
#
Director {
Name = bmm-s1-dir
Password = ""
}
#
# Restricted Director, used by tray-monitor to get the
# status of the file daemon
#
Director {
Name = bmm-s1-mon
Password = ""
Monitor = yes
}
#
# "Global" File daemon configuration specifications
FileDaemon { # this is me
Name = lasbmms1w03-fd
FDport = 9102 # where we listen for the director
WorkingDirectory = /var/lib/bacula
Pid Directory = /var/run/bacula
Maximum Concurrent Jobs = 20
}
# Send all messages except skipped files back to Director
Messages {
Name = Standard
director = bmm-s1-dir = all, !skipped
}
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
