Hi. When I try to run backups, I get an error like this:
08-May 11:22 bmm-s1-sd: Alert: cannot open SCSI device '/dev/sg2' -
Permission denied
08-May 11:22 bmm-s1-dir: Client1.2007-05-08_11.19.52 Error: Bacula
1.36.3 (22Apr05):
What I've tried:
Restarting all bacula services.
Combing through my config files.
Google -- I couldn't find anyone with the same problem.
Creating new volumes for tapes.
Staring blankly at the screen.
Cursing.
Sobbing.
Services seem to be running fine, media is mounted and labeled in
bconsole.
Everything was running beautifully for a couple months now. We had to
shut the backup server down because of work on our building and after
bringing the server back up and changing tapes, I have not been able
to do any back-ups successfully. :(
Can anyone give me a shove in the right direction on what I've got
wrong here?
Thank you!
Mike
All the standard details are below.
OS: Ubuntu Linux 6.06
Bacula version: 1.36.3
Tape changer: Quantum Superloader 3, LTO Ultrium 3
Changer passes btape autochanger test.
Bacula messages output:
08-May 11:22 bmm-s1-dir: Client1.2007-05-08_11.19.52 Fatal error:
sql_create.c:685 Create db Filename record INSERT INTO Filename (Name)
VALUES ('') failed. ERR=no such table: Filename
08-May 11:22 bmm-s1-dir: Client1.2007-05-08_11.19.52 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
08-May 11:22 bmm-s1-sd: Alert: cannot open SCSI device '/dev/sg2' -
Permission denied
08-May 11:22 bmm-s1-dir: Client1.2007-05-08_11.19.52 Error: Bacula
1.36.3 (22Apr05): 08-May-2007 11:22:14
JobId: 263
Job: Client1.2007-05-08_11.19.52
Backup Level: Full
Client: bmm-s1-fd
FileSet: "Full Set" 2007-03-08 06:51:47
Pool: "Default"
Storage: "LTO-3"
Start time: 08-May-2007 11:19:54
End time: 08-May-2007 11:22:14
FD Files Written: 99
SD Files Written: 99
FD Bytes Written: 343,419
SD Bytes Written: 355,286
Rate: 2.5 KB/s
Software Compression: 73.1 %
Volume name(s): may2007
Volume Session Id: 1
Volume Session Time: 1178647662
Last Volume Bytes: 144,131,685,547
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: *** Backup Error ***
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
