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 '[EMAIL PROTECTED]', 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 = [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 = "/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 = [EMAIL PROTECTED] = all, !skipped console = all, !skipped, !saved append = "/home/bacula/working/log" = all, !skipped } Messages { Name = Standard operator = [EMAIL PROTECTED] = 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users