Bacula-users

Re: [Bacula-users] Can't find your catalog (MyCatalog)

2010-06-22 14:21:25
Subject: Re: [Bacula-users] Can't find your catalog (MyCatalog)
From: Dave Buchanan <alegriatechdfw AT gmail DOT com>
To: John Drescher <drescherjm AT gmail DOT com>
Date: Tue, 22 Jun 2010 12:23:40 -0500


On Tue, Jun 22, 2010 at 11:54 AM, John Drescher <drescherjm AT gmail DOT com> wrote:
On Tue, Jun 22, 2010 at 12:47 PM, Dave Buchanan
<alegriatechdfw AT gmail DOT com> wrote:
> Hi John -
>
> yes it does bring up the schema using the bacula account
>

Can you post your bacula-dir.conf. It appears the problem is not
database connectivity but something wrong with your configuration
file.

John

Here ya go !

#
# 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 5.0.1 (24 February 2010) -- ubuntu 10.04
#
#  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 = dfw_backup-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 = 15
  Password = "password_for_Dir"         # Console password
  Messages = Daemon
  DirAddress = 10.0.2.16
}

JobDefs {
  Name = "DefaultJob"
  Type = Backup
  Level = Incremental
  Client = dfw_backup-fd
  FileSet = "Full Set"
  Schedule = "WeeklyCycle"
  Storage = File
  Messages = Standard
  Pool = File
  Priority = 10
  Write Bootstrap = "/var/lib/bacula/%c.bsr"
  Prefer Mounted Volumes = no
}


#
# Define the main nightly save backup job

Job {
  Name = "BackupClient1"
  JobDefs = "DefaultJob"
}

#Job {
#  Name = "BackupClient2"
#  Client = dfw_backup2-fd
#  JobDefs = "DefaultJob"
#}

# 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
  # Arguments to make_catalog_backup.pl are:
  #  make_catalog_backup.pl <catalog-name>
  RunBeforeJob = "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog"
  # This deletes the copy of the catalog
  RunAfterJob  = "/etc/bacula/scripts/delete_catalog_backup"
  Write Bootstrap = "/var/lib/bacula/%n.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=dfw_backup-fd                
  FileSet="Full Set"                 
  Storage = File                     
  Pool = Default
  Messages = Standard
  Where = /backup/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 partitions such as /usr or /home
#    you will probably want to add them too.
#
#  By default this is defined to point to the Bacula binary
#    directory to give a reasonable FileSet to backup to
#    disk storage during initial testing.
#
    File = /usr/sbin
  }

#
# If you backup the root directory, the following two excluded
#   files can be useful
#
  Exclude {
    File = /var/lib/bacula
    File = /backup
    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 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 = "/var/lib/bacula/bacula.sql"
  }
}

# Client (File Services) to backup
Client {
  Name = dfw_backup-fd
  Address = 10.0.2.16
  FDPort = 9102
  Catalog = MyCatalog
  Password = "password_for_Dir"          # password for FileDaemon
  File Retention = 30 days            # 30 days
  Job Retention = 6 months            # six months
  AutoPrune = yes                     # Prune expired Jobs/Files
  Maximum Concurrent Jobs = 10

}


# Definition of file storage device
Storage {
  Name = File
# Do not use "localhost" here   
  Address = dfw_backup.dfw.sirific.com                # N.B. Use a fully qualified name here
  SDPort = 9103
  Password = "password_for_Dir"
  Device = FileStorage
  Media Type = File
}

Storage {
  Name = Autochanger
  Password = "password_for_Dir"
  Address = dfw_backup.domain
  SDPort = 9103
  Device = Autochanger
  Media Type = LTO-3
  Maximum concurrent jobs = 10
  }

 Storage {
  Name = Drive-0
  Password = "password_for_Dir"
  Address = dfw_backup.domain
  SDPort = 9103
  Device = Drive-0
  Media Type = LTO-3
  }

 Storage {
  Name = Drive-1
  Password = "password_for_Dir"
  Address = dfw_backup.domain
  SDPort = 9103
  Device = Drive-1
  Media Type = LTO-3
 }




# Definition of DVD storage device
#Storage {
#  Name = "DVD"
#  Do not use "localhost" here
#  Address = localhost                # N.B. Use a fully qualified name here
#  SDPort = 9103
#  Password = "CnkqG2R4DvoC37ue03jiS_YmqJ30faJqF"
#  Device = "DVD Writer"
#  MediaType = "DVD"
#}


# Generic catalog service
Catalog {
  Name = MyCatalog
    dbname = bacula; dbuser = "bacula"; dbpassword = "sql-pass";DB Address = 127.0.0.1

}

# 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 = "/usr/lib/bacula/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula-client: %t %e of %c %l\" %r"
  operatorcommand = "/usr/lib/bacula/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula-client: 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 = "/var/lib/bacula/log" = all, !skipped
  catalog = all
}


#
# 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 = root@localhost = 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
}

# File Pool definition
Pool {
  Name = File
  Pool Type = Backup
  Recycle = yes                       # Bacula can automatically recycle Volumes
  AutoPrune = yes                     # Prune expired volumes
  Volume Retention = 365 days         # one year
  Maximum Volume Bytes = 50G          # Limit Volume size to something reasonable
  Maximum Volumes = 100               # Limit number of Volumes in Pool
}


# Scratch pool definition
Pool {
  Name = Scratch
  Pool Type = Backup
}

#
# Restricted console used by tray-monitor to get the status of the director
#
Console {
  Name = dfw_backup-mon
  Password = "password_for_Dir"
  CommandACL = status, .status
}
FileSet {
  Name = "users "
  Include {
    File = /home
    Options {
      signature = MD5
    }
  }
}
FileSet {
  Name = eng
  Include {
    File = /eng
    Options {
      signature = MD5
    }
  }
}
Pool {
  Name = forever_archive
  Pool Type = *Archive
  Volume Retention = 360 days
  Recycle = yes
  AutoPrune = yes
}
Pool {
  Name = daily
  Pool Type = Backup
  Volume Retention = 45 days
  Recycle = yes
  AutoPrune = yes
  LabelFormat = daily-
}
Schedule {
  Name = monthly
  Run = Level=Full Pool=forever_archive at 01:00
}
Schedule {
  Name = Daily_rotation
  Run = Level=Full Pool=daily Pool=daily sun at 07:00
  Run = Level=Incremental Pool=daily at 19:00
}
Job {
  Name = user_backup
  Type = Backup
  Level = Incremental
  Client = dfw_backup-fd
  FileSet = "users "
  Schedule = Daily_rotation
  Storage = Autochanger
  Pool = daily
  Messages = Daemon
  Prefer Mounted Volumes = no
}
Job {
  Name = Eng
  Type = Backup
  Level = Incremental
  Client = dfw_backup-fd
  FileSet = eng
  Schedule = Daily_rotation
  Storage = Autochanger
  Pool = daily
  Messages = Daemon
 Prefer Mounted Volumes = no
}
 

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>