Hi,
I am currently testing bacula in order to replace our current backup
solution.
I have been using bweb, since I like how things are displayed.
My current issue is the fact that bweb cannot display any of the details
of a jobs runned and it displays this : Can't get log for jobid 18.
here is what tail of /var/log/httpd/error_log outputs when I try to see
the details :
Mon Oct 06 06:20:37 2008] [error] [client 192.168.4.201] DBD::Pg::db
selectrow_hashref failed: ERROR: function group_concat(text) does not
exist, referer:
http://192.168.4.236/cgi-bin/bweb/bweb.pl?action=job_zoom;jobid=18
[Mon Oct 06 06:20:37 2008] [error] [client 192.168.4.201] HINT: No
function matches the given name and argument types. You may need to add
explicit type casts. at /usr/lib/perl5/site_perl/5.8.8/Bweb.pm line
1396., referer:
http://192.168.4.236/cgi-bin/bweb/bweb.pl?action=job_zoom;jobid=18
here is my bacula-dir.conf configuration:
#
# 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 2.4.2 (26 July 2008) -- redhat
#
# 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 = dhcpclt-236-dir
DIRport = 9101 # where we listen for UA connections
QueryFile = "/home/bacula/conf/query.sql"
WorkingDirectory = "/home/bacula/working"
PidDirectory = "/home/bacula/bin/working"
Maximum Concurrent Jobs = 1
Password = "cPAShD32jEb9i1+abtA8zTJdKdnONY347/yADyK9Aw7j" #
Console password
Messages = Daemon
}
JobDefs {
Name = "DefaultJob"
Type = Backup
Level = Incremental
Client = pisa.lan.lexum.pri
FileSet = "Full Set"
Schedule = "WeeklyCycle"
Storage = File
Messages = Standard
Pool = Default
Priority = 10
}
#
# Define the main nightly save backup job
# By default, this job will back up to disk in /home/bacula/vtapes
Job {
Name = "PISA"
Client = pisa.lan.lexum.pri
JobDefs = "DefaultJob"
Write Bootstrap = "/home/bacula/working/pisa.bsr"
}
#Job {
# Name = "Client2"
# Client = dhcpclt-2362-fd
# JobDefs = "DefaultJob"
# Write Bootstrap = "/home/bacula/working/Client2.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
# WARNING!!! Passing the password via the command line is insecure.
# see comments in make_catalog_backup for details.
# Arguments to make_catalog_backup are:
# make_catalog_backup <database-name> <user-name> <password> <host>
RunBeforeJob = "/home/bacula/conf/make_catalog_backup bacula bacula"
# This deletes the copy of the catalog
RunAfterJob = "/home/bacula/conf/delete_catalog_backup"
Write Bootstrap = "/home/bacula/working/BackupCatalog.bsr"
Priority = 11 # run after main backup
}
#
# Standard Restore template, to be changed by Console program
# Only one such job is needed for all Jobs/Clients/Storage ...
#
Job {
Name = "RestoreFiles"
Type = Restore
Client=pisa.lan.lexum.pri
FileSet="Full Set"
Storage = File
Pool = Default
Messages = Standard
Where = /home/bacula/vtapes/bacula-restores
}
# List of files to be backed up
FileSet {
Name = "Full Set"
Include {
Options {
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 = /var/lib/pgsql/backups
}
#
# If you backup the root directory, the following two excluded
# files can be useful
#
Exclude {
File = /proc
File = /tmp
File = /.journal
File = /.fsck
File = /dev
File = /sys
File = /boot
File = /misc
File = /var/lib/nfs/rpc_pipefs
File = /selinux
File = /home/bacula/vtapes
File = /net
}
}
#
# 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 23:05
Run = Differential 2nd-5th sun at 23:05
Run = Incremental mon-sat at 23:05
}
# This schedule does the catalog. It starts after the WeeklyCycle
Schedule {
Name = "WeeklyCycleAfterBackup"
Run = Full sun-sat at 23:10
}
# This is the backup of the catalog
FileSet {
Name = "Catalog"
Include {
Options {
signature = MD5
}
File = /home/bacula/working/bacula.sql
}
}
# Client (File Services) to backup
Client {
Name = pisa.lan.lexum.pri
Address = pisa.lan.lexum.pri
FDPort = 9102
Catalog = MyCatalog
Password = "wUEBQOI/mFylkHj81PFXHSIRdrqqFOy8ebwytUzmQpGF" #
password for FileDaemon
File Retention = 1 days # 30 days
Job Retention = 6 months # six months
AutoPrune = yes # Prune expired Jobs/Files
}
#
# Second Client (File Services) to backup
# You should change Name, Address, and Password before using
#
#Client {
# Name = dhcpclt-2362-fd
# Address = dhcpclt-2362
# FDPort = 9102
# Catalog = MyCatalog
# Password = "wUEBQOI/mFylkHj81PFXHSIRdrqqFOy8ebwytUzmQpGF2" #
password for FileDaemon 2
# File Retention = 30 days # 30 days
# Job Retention = 6 months # six months
# AutoPrune = yes # Prune expired Jobs/Files
#}
# Definition of file storage device
Storage {
Name = File
# Do not use "localhost" here
Address = dhcpclt-236 # N.B. Use a fully qualified
name here
SDPort = 9103
Password = "vEqgPFw/iL3//3rrOYr2/wFJRNHHxgsUsOdiZKFUVm1W"
Device = FileStorage
Media Type = File
}
# Definition of DDS tape storage device
#Storage {
# Name = DDS-4
# Do not use "localhost" here
# Address = dhcpclt-236 # N.B. Use a fully qualified
name here
# SDPort = 9103
# Password = "vEqgPFw/iL3//3rrOYr2/wFJRNHHxgsUsOdiZKFUVm1W" #
password for Storage daemon
# Device = DDS-4 # must be same as Device in
Storage daemon
# Media Type = DDS-4 # must be same as MediaType in
Storage daemon
# Autochanger = yes # enable for autochanger device
#}
# Definition of 8mm tape storage device
#Storage {
# Name = "8mmDrive"
# Do not use "localhost" here
# Address = dhcpclt-236 # N.B. Use a fully qualified
name here
# SDPort = 9103
# Password = "vEqgPFw/iL3//3rrOYr2/wFJRNHHxgsUsOdiZKFUVm1W"
# Device = "Exabyte 8mm"
# MediaType = "8mm"
#}
# Definition of DVD storage device
#Storage {
# Name = "DVD"
# Do not use "localhost" here
# Address = dhcpclt-236 # N.B. Use a fully qualified
name here
# SDPort = 9103
# Password = "vEqgPFw/iL3//3rrOYr2/wFJRNHHxgsUsOdiZKFUVm1W"
# Device = "DVD Writer"
# MediaType = "DVD"
#}
# Generic catalog service
Catalog {
Name = MyCatalog
dbname = "bacula"; dbuser = "bacula"; dbpassword = "secret"
}
# 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.
# What this does is, it sets the email address that emails would display
# in the FROM field, which is by default the same email as they're being
# sent to. However, if you send email to more than one address, then
# you'll have to set the FROM address manually, to a single address.
# for example, a 'no-reply AT mydomain DOT com', is better since that tends to
# tell (most) people that its coming from an automated source.
#
# mailcommand = "/home/bacula/bin/bsmtp -h localhost -f \"\(Bacula\)
\<%r\>\" -s \"Bacula: %t %e of %c %l\" %r"
# operatorcommand = "/home/bacula/bin/bsmtp -h localhost -f
\"\(Bacula\) \<%r\>\" -s \"Bacula: Intervention needed for %j\" %r"
# mail = root@localhost = all, !skipped
# operator = root@localhost = 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 = "/home/bacula/working/log" = all, !skipped
#}
#
# Message delivery for daemon messages (no job).
Messages {
Name = Daemon
mailcommand = "/home/bacula/bin/bsmtp -h localhost -f \"\(Bacula\)
\<%r\>\" -s \"Bacula daemon message\" %r"
mail = root@localhost = all, !skipped
console = all, !skipped, !saved
append = "/home/bacula/working/log" = all, !skipped
}
Messages {
Name = Standard
operator = root@localhost = mount
console = all, !skipped, !saved
append = "/home/bacula/working/log" = all, !skipped
catalog = all, !skipped, !saved
}
# 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
}
# Scratch pool definition
Pool {
Name = Scratch
Pool Type = Backup
}
#
# Restricted console used by tray-monitor to get the status of the director
#
Console {
Name = dhcpclt-236-mon
Password = "FsRAcJDfYSJvIkaezobRAZEIfnRZIr4GCGVbmoy0f7Sr"
CommandACL = status, .status
}
-------------------------------------------------------------------------
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|