Bacula-dir não inicia. desesperado
1,270 views
Skip to first unread message
gabriel leme de souza
Jan 20, 2017, 9:15:09 AM1/20/17
to Bacula Backup-Pt-Br
Boa tarde meu bacula estava funcionando
normalmente quando eu reiniciei o servidor de backup aparece o seguinte erro: Obs: Já dei um Drop no postgresql e conferi as senhas.
bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "bacula".
bacula-dir: dird.c:1020-0 postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
20-Jan 12:05 bacula-dir ERROR TERMINATION
Please correct configuration file: bacula-dir.conf
bacula-dir: dird.c:1020-0 postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
20-Jan 12:05 bacula-dir ERROR TERMINATION
Please correct configuration file: bacula-dir.conf
rodei o comando bacula-dir -d100 -c /etc/bacula/bacula-dir.conf
bacula-dir -d100 -c /etc/bacula/bacula-dir.conf
bacula-dir: dird.c:223-0 Debug level = 100
bacula-dir: jcr.c:140-0 read_last_jobs seek to 192
bacula-dir: jcr.c:147-0 Read num_items=10
bacula-dir: dir_plugins.c:160-0 Load dir plugins
bacula-dir: dir_plugins.c:162-0 No dir plugin dir!
bacula-dir: postgresql.c:1126-0 db_init_database first time
[root@152-249-244-141 bacula]# bacula-dir: postgresql.c:241-0 pg_real_connect done
bacula-dir: postgresql.c:243-0 db_user=bacula db_name=bacula db_password=528978528978
bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "bacula".
bacula-dir: dird.c:1020-0 postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
20-Jan 12:03 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf
bacula-dir: dird.c:223-0 Debug level = 100
bacula-dir: jcr.c:140-0 read_last_jobs seek to 192
bacula-dir: jcr.c:147-0 Read num_items=10
bacula-dir: dir_plugins.c:160-0 Load dir plugins
bacula-dir: dir_plugins.c:162-0 No dir plugin dir!
bacula-dir: postgresql.c:1126-0 db_init_database first time
[root@152-249-244-141 bacula]# bacula-dir: postgresql.c:241-0 pg_real_connect done
bacula-dir: postgresql.c:243-0 db_user=bacula db_name=bacula db_password=528978528978
bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "bacula".
bacula-dir: dird.c:1020-0 postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
20-Jan 12:03 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf
Segue abaixo a configuração do 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 5.2.13 (19 February 2013) -- 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.
#
# 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.2.13 (19 February 2013) -- 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.
#
Director { # define myself
Name = bacula-dir
DIRport = 9101 # where we listen for UA connections
QueryFile = "/etc/bacula/query.sql"
WorkingDirectory = "/var/spool/bacula"
PidDirectory = "/var/run"
Maximum Concurrent Jobs = 1
Password = "34235" # Console password
Messages = Daemon
}
Name = bacula-dir
DIRport = 9101 # where we listen for UA connections
QueryFile = "/etc/bacula/query.sql"
WorkingDirectory = "/var/spool/bacula"
PidDirectory = "/var/run"
Maximum Concurrent Jobs = 1
Password = "34235" # Console password
Messages = Daemon
}
JobDefs {
Name = "DefaultJob"
Type = Backup
Level = Incremental
Client = bacula-fd
FileSet = "bacula_arquivos_set"
Schedule = "WeeklyCycle"
Storage = File
Messages = Standard
Pool = baculamensal
Priority = 10
Write Bootstrap = "/var/spool/bacula/%c.bsr"
}
Name = "DefaultJob"
Type = Backup
Level = Incremental
Client = bacula-fd
FileSet = "bacula_arquivos_set"
Schedule = "WeeklyCycle"
Storage = File
Messages = Standard
Pool = baculamensal
Priority = 10
Write Bootstrap = "/var/spool/bacula/%c.bsr"
}
#
# Define the main nightly save backup job
# By default, this job will back up to disk in /tmp
Job {
Name = "BackupBacula"
JobDefs = "DefaultJob"
}
Job {
Name = "Backup_server_Debian"
Type = Backup
Client = server-debian-fd
FileSet = "server_debian_Departamental"
Schedule = "Agenda_gfs"
Storage = File
Messages = Standard
Pool = Diaria
Priority = 10
}
Name = "Backup_server_Debian"
Type = Backup
Client = server-debian-fd
FileSet = "server_debian_Departamental"
Schedule = "Agenda_gfs"
Storage = File
Messages = Standard
Pool = Diaria
Priority = 10
}
# Backup the catalog database (after the nightly save)
Job {
Name = "BackupCatalog"
JobDefs = "DefaultJob"
Level = Full
FileSet="Catalog"
# This creates an ASCII copy of the catalog
# Arguments to make_catalog_backup.pl are:
# make_catalog_backup.pl <catalog-name>
RunBeforeJob = "/usr/libexec/bacula/make_catalog_backup.pl MyCatalog"
# This deletes the copy of the catalog
RunAfterJob = "/usr/libexec/bacula/delete_catalog_backup"
Write Bootstrap = "/var/spool/bacula/%n.bsr"
Priority = 11 # run after main backup
}
Job {
Name = "BackupCatalog"
JobDefs = "DefaultJob"
Level = Full
FileSet="Catalog"
# This creates an ASCII copy of the catalog
# Arguments to make_catalog_backup.pl are:
# make_catalog_backup.pl <catalog-name>
RunBeforeJob = "/usr/libexec/bacula/make_catalog_backup.pl MyCatalog"
# This deletes the copy of the catalog
RunAfterJob = "/usr/libexec/bacula/delete_catalog_backup"
Write Bootstrap = "/var/spool/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=bacula-fd
FileSet = "bacula_arquivos_set"
Storage = File
Pool = Default
Messages = Standard
Where = /tmp/bacula-restores
}
# 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=bacula-fd
FileSet = "bacula_arquivos_set"
Storage = File
Pool = Default
Messages = Standard
Where = /tmp/bacula-restores
}
# List of files to be backed up
FileSet {
Name = "bacula_arquivos_set"
Enable VSS = yes
Include {
Options {
signature = MD5
compression = GZIP2
}
File = /etc
File = /var
File = /opt
}
Exclude {
File = /var/spool/bacula
File = /var/lib/pgsql
}
}
FileSet {
Name = "server_debian_Departamental"
Enable VSS = yes
Include {
Options {
signature = MD5
compression = GZIP2
}
File = /home/Departamental
}
Exclude {
}
}
#
# 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 Pool = baculamensal 1st saturday at 21:00
}
Name = "server_debian_Departamental"
Enable VSS = yes
Include {
Options {
signature = MD5
compression = GZIP2
}
File = /home/Departamental
}
Exclude {
}
}
#
# 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 Pool = baculamensal 1st saturday at 21:00
}
Schedule {
Name = "Agenda_gfs"
Run = Differential Pool = Diaria Monday-Thursday at 19:00
Run = Full Pool = Mensal 1st 2nd 3rd 4th 5th Friday at 19:00
}
Name = "Agenda_gfs"
Run = Differential Pool = Diaria Monday-Thursday at 19:00
Run = Full Pool = Mensal 1st 2nd 3rd 4th 5th Friday at 19:00
}
# This is the backup of the catalog
FileSet {
Name = "Catalog"
Include {
Options {
signature = MD5
}
File = "/var/spool/bacula/bacula.sql"
}
}
FileSet {
Name = "Catalog"
Include {
Options {
signature = MD5
}
File = "/var/spool/bacula/bacula.sql"
}
}
# Client (File Services) to backup
Client {
Name = bacula-fd
Address = localhost
FDPort = 9102
Catalog = MyCatalog
Password = "49834" # password for FileDaemon
File Retention = 30 days # 30 days
Job Retention = 6 months # six months
AutoPrune = yes # Prune expired Jobs/Files
}
Client {
Name = bacula-fd
Address = localhost
FDPort = 9102
Catalog = MyCatalog
Password = "49834" # password for FileDaemon
File Retention = 30 days # 30 days
Job Retention = 6 months # six months
AutoPrune = yes # Prune expired Jobs/Files
}
Client {
Name = server-debian-fd
Address = 192.168.0.2
FDPort = 9102
Catalog = MyCatalog
Password = "43792473" # password for FileDaemon
File Retention = 30 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 = bacula2-fd
# Address = localhost2
# FDPort = 9102
# Catalog = MyCatalog
# Password = "@@FD_PASSWORD@@2" # password for FileDaemon 2
# File Retention = 30 days # 30 days
# Job Retention = 6 months # six months
# AutoPrune = yes # Prune expired Jobs/Files
#}
Name = server-debian-fd
Address = 192.168.0.2
FDPort = 9102
Catalog = MyCatalog
Password = "43792473" # password for FileDaemon
File Retention = 30 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 = bacula2-fd
# Address = localhost2
# FDPort = 9102
# Catalog = MyCatalog
# Password = "@@FD_PASSWORD@@2" # 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 = 127.0.0.1 # N.B. Use a fully qualified name here
SDPort = 9103
Password = "45674"
Device = FileStorage
Media Type = File
}
# Generic catalog service
Catalog {
Name = MyCatalog
# Uncomment the following line if you want the dbi driver
# dbdriver = "dbi:postgresql"; dbaddress = 127.0.0.1; dbport =
dbname = "bacula"; dbuser = "bacula"; dbpassword = "528978528978"
}
# 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-r...@mydomain.com', is better since that tends to
# tell (most) people that its coming from an automated source.
# 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-r...@mydomain.com', is better since that tends to
# tell (most) people that its coming from an automated source.
#
mailcommand = "/usr/sbin/mail -s \"Bacula: %t %e of %c %l\" %r"
operatorcommand = "/usr/sbin/mail -s \"Bacula: Intervention needed for %j\" %r"
mail = edu...@tiffel.com.br = all, !skipped
operator = gab...@tiffel.com.br = 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/log/bacula/bacula.log" = all, !skipped
catalog = all
}
mailcommand = "/usr/sbin/mail -s \"Bacula: %t %e of %c %l\" %r"
operatorcommand = "/usr/sbin/mail -s \"Bacula: Intervention needed for %j\" %r"
mail = edu...@tiffel.com.br = all, !skipped
operator = gab...@tiffel.com.br = 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/log/bacula/bacula.log" = all, !skipped
catalog = all
}
#
# Message delivery for daemon messages (no job).
Messages {
Name = Daemon
mailcommand = "/usr/sbin/mail -s \"Bacula daemon message\""
mail = edu...@tiffel.com.br = all, !skipped
console = all, !skipped, !saved
append = "/var/log/bacula/bacula.log" = all, !skipped
}
# File 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
}
Pool {
Name = baculamensal
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes
Volume Use Duration = 20 hours # Prune expired volumes
Volume Retention = 20 days # one year
Label Format = "baculamensal-${NumVols}"
Maximum Volume Bytes = 3G # Limit Volume size to something reasonable
Maximum Volumes = 12 # Limit number of Volumes in Pool
}
Name = baculamensal
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes
Volume Use Duration = 20 hours # Prune expired volumes
Volume Retention = 20 days # one year
Label Format = "baculamensal-${NumVols}"
Maximum Volume Bytes = 3G # Limit Volume size to something reasonable
Maximum Volumes = 12 # Limit number of Volumes in Pool
}
Pool {
Name = Mensal
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes
Volume Use Duration = 2 days # Prune expired volumes
Volume Retention = 4 days # one year
Label Format = "Mensal-${NumVols}"
Maximum Volume Bytes = 100GB # Limit Volume size to something reasonable
Maximum Volumes = 16 # Limit number of Volumes in Pool
}
Name = Mensal
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes
Volume Use Duration = 2 days # Prune expired volumes
Volume Retention = 4 days # one year
Label Format = "Mensal-${NumVols}"
Maximum Volume Bytes = 100GB # Limit Volume size to something reasonable
Maximum Volumes = 16 # Limit number of Volumes in Pool
}
Pool {
Name = Diaria
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes
Volume Use Duration = 3 days # Prune expired volumes
Volume Retention = 7 days # one year
Label Format = "Diaria-${NumVols}"
Maximum Volume Bytes = 5GB # Limit Volume size to something reasonable
Maximum Volumes = 20 # 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 = bacula-mon
Password = "342442"
CommandACL = status, .status
}
Name = Diaria
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes
Volume Use Duration = 3 days # Prune expired volumes
Volume Retention = 7 days # one year
Label Format = "Diaria-${NumVols}"
Maximum Volume Bytes = 5GB # Limit Volume size to something reasonable
Maximum Volumes = 20 # 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 = bacula-mon
Password = "342442"
CommandACL = status, .status
}
Alessandro Fazenda
Jan 20, 2017, 9:53:31 AM1/20/17
to bacula-ba...@googlegroups.com
o banco de dados tá rodando?
consegue conectar por console no banco?
--
Você recebeu essa mensagem porque está inscrito no grupo "Bacula Backup-Pt-Br" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para bacula-backup-pt-br+unsub...@googlegroups.com.
Para postar nesse grupo, envie um e-mail para bacula-backup-pt-br@googlegroups.com.
Acesse esse grupo em https://groups.google.com/group/bacula-backup-pt-br.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/bacula-backup-pt-br/46d11226-1162-469a-86b9-4489158dad9a%40googlegroups.com.
Para mais opções, acesse https://groups.google.com/d/optout.
gabriel leme de souza
Jan 20, 2017, 9:56:11 AM1/20/17
to Bacula Backup-Pt-Br
Boa tarde.
Eu consigo sim
[root@152-249-244-141 bacula]# su postgres
bash-4.2$ psql bacula
psql (9.2.15)
Digite "help" para ajuda.
bash-4.2$ psql bacula
psql (9.2.15)
Digite "help" para ajuda.
bacula=# \d
Lista de relações
Esquema | Nome | Tipo | Dono
---------+-----------------------------------+-----------+----------
public | basefiles | tabela | postgres
public | basefiles_baseid_seq | sequência | postgres
public | cdimages | tabela | postgres
public | client | tabela | postgres
public | client_clientid_seq | sequência | postgres
public | counters | tabela | postgres
public | device | tabela | postgres
public | device_deviceid_seq | sequência | postgres
public | file | tabela | postgres
public | file_fileid_seq | sequência | postgres
public | filename | tabela | postgres
public | filename_filenameid_seq | sequência | postgres
public | fileset | tabela | postgres
public | fileset_filesetid_seq | sequência | postgres
public | job | tabela | postgres
public | job_jobid_seq | sequência | postgres
public | jobhisto | tabela | postgres
public | jobmedia | tabela | postgres
public | jobmedia_jobmediaid_seq | sequência | postgres
public | location | tabela | postgres
public | location_locationid_seq | sequência | postgres
public | locationlog | tabela | postgres
public | locationlog_loclogid_seq | sequência | postgres
public | log | tabela | postgres
public | log_logid_seq | sequência | postgres
public | media | tabela | postgres
public | media_mediaid_seq | sequência | postgres
public | mediatype | tabela | postgres
public | mediatype_mediatypeid_seq | sequência | postgres
public | path | tabela | postgres
public | path_pathid_seq | sequência | postgres
public | pathhierarchy | tabela | postgres
public | pathvisibility | tabela | postgres
public | pool | tabela | postgres
public | pool_poolid_seq | sequência | postgres
public | restoreobject | tabela | postgres
public | restoreobject_restoreobjectid_seq | sequência | postgres
public | status | tabela | postgres
public | storage | tabela | postgres
public | storage_storageid_seq | sequência | postgres
public | unsavedfiles | tabela | postgres
public | version | tabela | postgres
(42 registros)
Lista de relações
Esquema | Nome | Tipo | Dono
---------+-----------------------------------+-----------+----------
public | basefiles | tabela | postgres
public | basefiles_baseid_seq | sequência | postgres
public | cdimages | tabela | postgres
public | client | tabela | postgres
public | client_clientid_seq | sequência | postgres
public | counters | tabela | postgres
public | device | tabela | postgres
public | device_deviceid_seq | sequência | postgres
public | file | tabela | postgres
public | file_fileid_seq | sequência | postgres
public | filename | tabela | postgres
public | filename_filenameid_seq | sequência | postgres
public | fileset | tabela | postgres
public | fileset_filesetid_seq | sequência | postgres
public | job | tabela | postgres
public | job_jobid_seq | sequência | postgres
public | jobhisto | tabela | postgres
public | jobmedia | tabela | postgres
public | jobmedia_jobmediaid_seq | sequência | postgres
public | location | tabela | postgres
public | location_locationid_seq | sequência | postgres
public | locationlog | tabela | postgres
public | locationlog_loclogid_seq | sequência | postgres
public | log | tabela | postgres
public | log_logid_seq | sequência | postgres
public | media | tabela | postgres
public | media_mediaid_seq | sequência | postgres
public | mediatype | tabela | postgres
public | mediatype_mediatypeid_seq | sequência | postgres
public | path | tabela | postgres
public | path_pathid_seq | sequência | postgres
public | pathhierarchy | tabela | postgres
public | pathvisibility | tabela | postgres
public | pool | tabela | postgres
public | pool_poolid_seq | sequência | postgres
public | restoreobject | tabela | postgres
public | restoreobject_restoreobjectid_seq | sequência | postgres
public | status | tabela | postgres
public | storage | tabela | postgres
public | storage_storageid_seq | sequência | postgres
public | unsavedfiles | tabela | postgres
public | version | tabela | postgres
(42 registros)
bacula=#
Para postar nesse grupo, envie um e-mail para bacula-ba...@googlegroups.com.
Heitor Faria
Jan 20, 2017, 10:06:35 AM1/20/17
to bacula-ba...@googlegroups.com
Boa tarde meu bacula estava funcionandonormalmente quando eu reiniciei o servidor de backup aparece o seguinte erro: Obs: Já dei um Drop no postgresql e conferi as senhas.
Olá, Gabriel: já verificou como está o pg_hba.conf?
Lá é definido o método de autenticação que ele aceita.
Outra coisa: o log do Postgresql vai te dizer exatamente o que está errado.
bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "bacula".
bacula-dir: dird.c:1020-0 postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
20-Jan 12:05 bacula-dir ERROR TERMINATION
Please correct configuration file: bacula-dir.confrodei o comando bacula-dir -d100 -c /etc/bacula/bacula-dir.confbacula-dir -d100 -c /etc/bacula/bacula-dir.conf
bacula-dir: dird.c:223-0 Debug level = 100
bacula-dir: jcr.c:140-0 read_last_jobs seek to 192
bacula-dir: jcr.c:147-0 Read num_items=10
bacula-dir: dir_plugins.c:160-0 Load dir plugins
bacula-dir: dir_plugins.c:162-0 No dir plugin dir!
bacula-dir: postgresql.c:1126-0 db_init_database first time
[root@152-249-244-141 bacula]# bacula-dir: postgresql.c:241-0 pg_real_connect done
bacula-dir: postgresql.c:243-0 db_user=bacula db_name=bacula db_password=528978528978
bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "bacula".
bacula-dir: dird.c:1020-0 postgresql.c:248 Unable to connect to PostgreSQL server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
20-Jan 12:03 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf
--
===========================================================================
Heitor Medrado de Faria | Bacula do Brasil
Heitor Medrado de Faria | Bacula do Brasil
• Não seja tarifado pelo tamanho dos seus backups, conheça o Bacula Enterprise: http://www.bacula.com.br/enterprise/
• Ministro treinamento e implementação in-company do Bacula Community: http://www.bacula.com.br/in-company/
(61) 98268-4220 | www.bacula.com.br
============================================================================
Indicamos também as capacitações complementares:
• Shell básico e Programação em Shell com Julio Neves.
• Zabbix com Adail Host.
• Zabbix com Adail Host.
============================================================================
gabriel leme de souza
Jan 20, 2017, 10:42:30 AM1/20/17
to Bacula Backup-Pt-Br
Olhei os arquivo de configuração aprece o seguinte:
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
tem que deixar como md5?
Wanderlei Huttel
Jan 20, 2017, 10:47:31 AM1/20/17
to bacula-ba...@googlegroups.com
Olá Gabriel
Execute esses comandos para parar o Bacula
/etc/init.d/bacula-dir stop
/etc/init.d/bacula-sd stop
/etc/init.d/bacula-fd stop
pkill bacula
Poste o resultado dos comandos abaixo:
* netstat -na | grep 910[123]
* ps -aux | grep bacula
* bacula-dir -t
Mude ali no postgreSQL para "trust" par ver se conecta e reinicie o postgresql
# IPv4 local connections:
--
Você recebeu essa mensagem porque está inscrito no grupo "Bacula Backup-Pt-Br" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para bacula-backup-pt-br+unsub...@googlegroups.com.
Para postar nesse grupo, envie um e-mail para bacula-backup-pt-br@googlegroups.com.
Acesse esse grupo em https://groups.google.com/group/bacula-backup-pt-br.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/bacula-backup-pt-br/0c6936e1-751c-4376-9c1e-fb8543cdc889%40googlegroups.com.
gabriel leme de souza
Jan 20, 2017, 10:48:04 AM1/20/17
to Bacula Backup-Pt-Br
Aparece isso no log.
[root@152-249-244-141 pg_log]# tail -f postgresql-Fri.log
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
LOG: nome de usuário fornecido (bacula) e nome de usuário autenticado (root) não correspondem
FATAL: autenticação do tipo peer falhou para usuário "bacula"
Wanderlei Huttel
Jan 20, 2017, 10:55:54 AM1/20/17
to bacula-ba...@googlegroups.com
Usuário e senha do bacula no postgresql est]ao diferente do bacula-dir.conf no Catalog { ... }
--
Você recebeu essa mensagem porque está inscrito no grupo "Bacula Backup-Pt-Br" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para bacula-backup-pt-br+unsub...@googlegroups.com.
Para postar nesse grupo, envie um e-mail para bacula-backup-pt-br@googlegroups.com.
Acesse esse grupo em https://groups.google.com/group/bacula-backup-pt-br.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/bacula-backup-pt-br/6b4983bb-a3ed-4718-8487-219d76082119%40googlegroups.com.
gabriel leme de souza
Jan 20, 2017, 10:57:11 AM1/20/17
to Bacula Backup-Pt-Br
Rodei os comandos so uma observação meu sistema operacional é o Centos 7
[root@152-249-244-141 data]# netstat -na | grep 9101
[root@152-249-244-141 data]# netstat -na | grep 9102
[root@152-249-244-141 data]# netstat -na | grep 9103
[root@152-249-244-141 data]# ps aux | grep bacula
root 21795 0.0 0.0 112668 964 pts/2 S+ 13:55 0:00 grep --color=auto bacula
[root@152-249-244-141 data]# bacula-dir -t
[root@152-249-244-141 data]# netstat -na
[root@152-249-244-141 data]# netstat -na | grep 9102
[root@152-249-244-141 data]# netstat -na | grep 9103
[root@152-249-244-141 data]# ps aux | grep bacula
root 21795 0.0 0.0 112668 964 pts/2 S+ 13:55 0:00 grep --color=auto bacula
[root@152-249-244-141 data]# bacula-dir -t
[root@152-249-244-141 data]# netstat -na
gabriel leme de souza
Jan 20, 2017, 11:07:12 AM1/20/17
to Bacula Backup-Pt-Br
consegui subir ele no modo debug.
As senhas ja estavam corretas.
[root@152-249-244-141 data]# ps aux | grep bacula
root 23438 0.0 0.1 510960 3484 ? Ssl 14:02 0:00 bacula-dir -d100 -c /etc/bacula/bacula-dir.conf
root 23472 0.0 0.0 107936 620 pts/3 S+ 14:03 0:00 tail -f /var/log/bacula/bacula.log
root 23509 0.0 0.2 335380 4340 ? Ssl 14:03 0:00 /usr/sbin/bacula-fd -f -c /etc/bacula/bacula-fd.conf -u root -g root
bacula 23619 0.0 0.2 403008 4736 ? Ssl 14:03 0:00 /usr/sbin/bacula-sd -f -c /etc/bacula/bacula-sd.conf -u bacula -g tape
root 23820 0.0 0.0 112668 964 pts/2 S+ 14:05 0:00 grep --color=auto bacula
root 23472 0.0 0.0 107936 620 pts/3 S+ 14:03 0:00 tail -f /var/log/bacula/bacula.log
root 23509 0.0 0.2 335380 4340 ? Ssl 14:03 0:00 /usr/sbin/bacula-fd -f -c /etc/bacula/bacula-fd.conf -u root -g root
bacula 23619 0.0 0.2 403008 4736 ? Ssl 14:03 0:00 /usr/sbin/bacula-sd -f -c /etc/bacula/bacula-sd.conf -u bacula -g tape
root 23820 0.0 0.0 112668 964 pts/2 S+ 14:05 0:00 grep --color=auto bacula
Heitor Faria
Jan 20, 2017, 11:17:39 AM1/20/17
to gabriel leme de souza, Bacula Backup-Pt-Br
Gabriel: metodo peer não considera senha. Tem de ser md5, password ou text (não lembro ao certo as duas últimas).
Nos comentários do pg_hba.conf são descritos os metódos.
Depois de mudar reinicie o pgsql.
Abraços,
===========================================================================
Heitor Medrado de Faria | Bacula do Brasil
• Não seja tarifado pelo tamanho dos seus backups, conheça o Bacula Enterprise: http://www.bacula.com.br/enterprise/
• Ministro treinamento e implementação in-company do Bacula Community: http://www.bacula.com.br/in-company/
============================================================================
Indicamos também as capacitações complementares:
• Shell básico e Programação em Shell com Julio Neves.
• Zabbix com Adail Host.
• Zabbix com Adail Host.
============================================================================
------ Mensagem original------
De: gabriel leme de souza
Data: sex, 20 de jan de 2017 2:07 PM
Para: Bacula Backup-Pt-Br;
Cc:
Assunto:Re: [bacula-brasil] Bacula-dir não inicia. desesperado
--
Você recebeu essa mensagem porque está inscrito no grupo "Bacula Backup-Pt-Br" dos Grupos do Google.
Você recebeu essa mensagem porque está inscrito no grupo "Bacula Backup-Pt-Br" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para bacula-backup-p...@googlegroups.com.
Para postar nesse grupo, envie um e-mail para bacula-ba...@googlegroups.com.
Para postar nesse grupo, envie um e-mail para bacula-ba...@googlegroups.com.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/bacula-backup-pt-br/305885f4-5bf4-44c4-acc6-0a886d81d04f%40googlegroups.com.
Heitor Faria
Jan 20, 2017, 11:25:09 AM1/20/17
to bacula-ba...@googlegroups.com, gabriel leme de souza
Gabriel: metodo peer não considera senha. Tem de ser md5, password ou text (não lembro ao certo as duas últimas).
Nos comentários do pg_hba.conf são descritos os metódos.Depois de mudar reinicie o pgsql.
Em tempo: ou usa trust para conexões locais, que eu considero até mais seguro que uma senha legível e que acaba muitas vezes se tornando padrão na empresa.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/bacula-backup-pt-br/assp.0193883eb6.13bfq35nvfe4d03ub67qgr67.1484929065325%40email.lge.com.
Para mais opções, acesse https://groups.google.com/d/optout.
--
gabriel leme de souza
Jan 20, 2017, 11:28:31 AM1/20/17
to Bacula Backup-Pt-Br, gabri...@gmail.com
OK muito obrigado vou verificar aqui ja respondo.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para bacula-backup-pt-br+unsub...@googlegroups.com.
gabriel leme de souza
Jan 20, 2017, 11:41:01 AM1/20/17
to Bacula Backup-Pt-Br, gabri...@gmail.com
Boa tarde muito obrigado problema solucionado pois esta acessando e não aparece erro mas quando eu rodo o
service bacula-dir start ele não inicia mas se eu rodar o /usr/sbin/bacula-dir -f -c /etc/bacula/bacula-dir.conf -u root -g root
Desculpa se eu estar vacilando muito mas não tem logica não funcionar.
gabriel leme de souza
Jan 20, 2017, 11:48:43 AM1/20/17
to Bacula Backup-Pt-Br, gabri...@gmail.com
Consegui rodando o comando /bin/systemctl start bacula-dir.service
gabriel leme de souza
Jan 20, 2017, 11:51:05 AM1/20/17
to Bacula Backup-Pt-Br, gabri...@gmail.com
Muito obrigado pela atenção hoje a noite vou ver se o backup full vai rodar de boa.
Obrigado Heitor e Wanderlei.
gabriel leme de souza
Mar 30, 2017, 4:18:51 PM3/30/17
to Bacula Backup-Pt-Br, gabri...@gmail.com
Backup Funcionando perfeitamente.
Reply all
Reply to author
Forward
0 new messages