Hi,
On 5/10/2007 1:10 AM, Mike Toscano wrote:
> I got some error messages below and am told the Bacula database may be
> corrupt. How can I tell for sure?
Use the mainenance program belonging to your database... unfortunately
you don't write which one you use.
dbcheck might also reveal something, thoug, if a table is missing, that
won't help you much.
> 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.
In that case, simply save the od database and create a new one.
Arno
> 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
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------------------------
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
