Problemas em conectar o bacula

chpmicha
(usa CentOS)

Enviado em 05/08/2016 - 17:34h

Boa tarde Pessoal, instalei o bacula seguindo o tuturial: https://www.vivaolinux.com.br/dica/Bacula-7x-no-CentOS-7x-Instalacao-e-configuracao

Show de bola o tutorial e as colaborações dos comentários, consegui instalar sem erros o bacula.

Contudo preciso de um help, na hora de conectar agora ao bconsole, não conecta:

[root@localhost ~]# bconsole

Connecting to Director 127.0.0.1:9101

[root@localhost ~]# 

olhei nos Logs e parece ser problema com usuario do banco de dados, já tentei fazer varios procedimentos para adequar, mas sem sucesso!

abaixo os logs:

/opt/bacula/log/bacula.log:

05-Ago 17:05 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".

05-Ago 17:05 bacula-dir JobId 0: Fatal error: mysql.c:265 Unable to connect to MySQL server.

Database=bacula User=bacula

MySQL connect failed either server not running or your authorization is incorrect.

05-Ago 17:05 bacula-dir ERROR TERMINATION

Please correct configuration file: /etc/bacula/bacula-dir.conf 

/var/log/mariadb/mariadb.log:

Version: '5.5.47-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

160805 16:50:39 [Warning] Found invalid password for user: 'bacula@localhost'; Ignoring user

160805 16:57:01 [Warning] Found invalid password for user: 'bacula@%'; Ignoring user

160805 16:57:01 [Warning] Found invalid password for user: 'bacula@localhost'; Ignoring user

160805 16:57:01 [Warning] Found invalid password for user: 'bacula@bacula'; Ignoring user

160805 16:59:01 [Warning] Found invalid password for user: 'bacula@%'; Ignoring user

160805 16:59:01 [Warning] Found invalid password for user: 'bacula@localhost'; Ignoring user

160805 16:59:01 [Warning] Found invalid password for user: 'bacula@bacula'; Ignoring user

160805 17:04:19 [Warning] Found invalid password for user: 'bacula@%'; Ignoring user

160805 17:04:19 [Warning] Found invalid password for user: 'bacula@localhost'; Ignoring user

160805 17:04:19 [Warning] Found invalid password for user: 'bacula@bacula'; Ignoring user

160805 17:04:41 [Warning] Found invalid password for user: 'bacula@%'; Ignoring user

160805 17:04:41 [Warning] Found invalid password for user: 'bacula@localhost'; Ignoring user

160805 17:04:41 [Warning] Found invalid password for user: 'bacula@bacula'; Ignoring user 

Aqui a abaixo o dito /etc/bacula/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 7.4.3 (18 June 2016) -- redhat (Core)

#

#  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.

#

# Copyright (C) 2000-2015 Kern Sibbald

# License: BSD 2-Clause; see file LICENSE-FOSS

#



Director {                            # define myself

  Name = localhost.localdomain-dir

  DIRport = 9101                # where we listen for UA connections

  QueryFile = "/etc/bacula/query.sql"

  WorkingDirectory = "/opt/bacula/working"

  PidDirectory = "/var/run"

  Maximum Concurrent Jobs = 20

  Password = "centos"         # Console password

  Messages = Daemon

}



JobDefs {

  Name = "DefaultJob"

  Type = Backup

  Level = Incremental

  Client = localhost.localdomain-fd

  FileSet = "Full Set"

  Schedule = "WeeklyCycle"

  Storage = File1

  Messages = Standard

  Pool = File

  SpoolAttributes = yes

  Priority = 10

  Write Bootstrap = "/opt/bacula/working/%c.bsr"

}





#

# Define the main nightly save backup job

#   By default, this job will back up to disk in /tmp

Job {

  Name = "BackupClient1"

  JobDefs = "DefaultJob"

}



#Job {

#  Name = "BackupClient2"

#  Client = localhost.localdomain2-fd

#  JobDefs = "DefaultJob"

#}



#Job {

#  Name = "BackupClient1-to-Tape"

#  JobDefs = "DefaultJob"

#  Storage = LTO-4

#  Spool Data = yes    # Avoid shoe-shine

#  Pool = Default

#}



#}



# 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/make_catalog_backup.pl MyCatalog"

  # This deletes the copy of the catalog

  RunAfterJob  = "/etc/bacula/delete_catalog_backup"

  Write Bootstrap = "/opt/bacula/working/%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=localhost.localdomain-fd

  FileSet="Full Set"

  Storage = File1

  Pool = File

  Messages = Standard

  Where = /tmp/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 = /sbin

  }



#

# If you backup the root directory, the following two excluded

#   files can be useful

#

  Exclude {

    File = /opt/bacula/working

    File = /tmp

    File = /proc

    File = /tmp

    File = /sys

    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 = "/opt/bacula/working/bacula.sql"

  }

}



# Client (File Services) to backup

Client {

  Name = localhost.localdomain-fd

  Address = 127.0.0.1

  FDPort = 9102

  Catalog = MyCatalog

  Password = "centos"          # password for FileDaemon

  File Retention = 60 days            # 60 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 = localhost.localdomain2-fd

#  Address = localhost2

#  FDPort = 9102

#  Catalog = MyCatalog

#  Password = "centos2"        # password for FileDaemon 2

#  File Retention = 60 days           # 60 days

#  Job Retention = 6 months           # six months

#  AutoPrune = yes                    # Prune expired Jobs/Files

#}





# Definition of file Virtual Autochanger device

Storage {

  Name = File1

# Do not use "localhost" here

  Address = 127.0.0.1                # N.B. Use a fully qualified name here

  SDPort = 9103

  Password = "centos"

  Device = FileChgr1

  Media Type = File1

  Maximum Concurrent Jobs = 10        # run up to 10 jobs a the same time

}



# Definition of a second file Virtual Autochanger device

#   Possibly pointing to a different disk drive

Storage {

  Name = File2

# Do not use "localhost" here

  Address = localhost                # N.B. Use a fully qualified name here

  SDPort = 9103

  Password = "centos"

  Device = FileChgr2

  Media Type = File2

  Maximum Concurrent Jobs = 10        # run up to 10 jobs a the same time

}



# Definition of LTO-4 tape Autochanger device

#Storage {

#  Name = LTO-4

#  Do not use "localhost" here

#  Address = localhost               # N.B. Use a fully qualified name here

#  SDPort = 9103

#  Password = "centos"         # password for Storage daemon

#  Device = LTO-4                     # must be same as Device in Storage daemon

#  Media Type = LTO-4                 # must be same as MediaType in Storage daemon

#  Maximum Concurrent Jobs = 10

#}



# Generic catalog service

Catalog {

  Name = MyCatalog

  dbname = "bacula"; dbuser = "bacula"; dbpassword = "centos"

}



# 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@mydomain.com', is better since that tends to

#  tell (most) people that its coming from an automated source.



#

  mailcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula: %t %e of %c %l\" %r"

  operatorcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula: Intervention needed for %j\" %r"

  mail = meu@email = all, !skipped

  operator = meu@email = 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 = "/opt/bacula/log/bacula.log" = all, !skipped

  catalog = all

}





#

# Message delivery for daemon messages (no job).

Messages {

  Name = Daemon

  mailcommand = "/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula daemon message\" %r"

  mail = meu@email = all, !skipped

  console = all, !skipped, !saved

  append = "/opt/bacula/log/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

  Maximum Volume Bytes = 50G          # Limit Volume size to something reasonable

  Maximum Volumes = 100               # Limit number of Volumes in Pool

}



# 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

  Label Format = "Vol-"               # Auto label

}





# Scratch pool definition

Pool {

  Name = Scratch

  Pool Type = Backup

}



#

# Restricted console used by tray-monitor to get the status of the director

#

Console {

  Name = localhost.localdomain-mon

  Password = "centos"

  CommandACL = status, .status

}

 

Alguem consegue me dar uma luz?


Obrigado!