Hi Leever
Change your Postgresql pg_hba.conf to the following,
# Allow any user on the local system to connect to any database with
# any database user name using Unix-domain sockets (the default for local
# connections).
#
# TYPE DATABASE USER ADDRESS METHOD
local all all trust
# The same using local loopback TCP/IP connections.
#
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 trust
# The same as the previous line, but using a separate netmask column
#
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
host all all 127.0.0.1 255.255.255.255
trust
# The same over IPv6.
#
# TYPE DATABASE USER ADDRESS METHOD
host all all ::1/128 trust
# The same using a host name (would typically cover both IPv4 and IPv6).
#
# TYPE DATABASE USER ADDRESS METHOD
host all all localhost trust
Execute Postgresql Reload to assume the new connection parameters, and
then execute BSCAN, it will be easier to "bscann" the volumes whiteout
asking for Postgresql Password.
Please, don't forget after terminating the Bscan to revert the Psql
Pg_hba.conf to the original state.
Best
Pedro
On 07/10/19 15:33, H.J. Leever via Bacula-users wrote:
Hello,i am having a LTO5 with several tapes, I lost the database and
could not restore the backed up catalog!
Now I am having several tapes with data but Bacula’s catalog don’t
know them!
I know whats on which tape with “sudo bls -V GKM169 /dev/nst0” this works.
Bacula-bat works ok I have several backups in my database which I can
see in Bacula console.
But when I use bscan to load the tape contence into the catalog bscan
says my Catalog is “NULL”
Can someone lease help me, is have searched all the documentation but
can not find how i can read the listing into de catalog !
hleever2@hleever2:~$ sudo bscan -s -m -n bacula -c bacula-sd.conf -v
-V GKM167 /dev/nst0
bscan: butil.c:292-0 Using device: "/dev/nst0" for reading.
07-okt 14:27 bscan JobId 0: Ready to read from volume "GKM167" on Tape
device "LTO-5" (/dev/nst0).
bscan: bscan.c:312-0 Could not open Catalog "NULL", database "bacula".
07-okt 14:28 bscan JobId 0: Fatal error: mysql.c:271 Unable to connect
to MySQL server.
Database=bacula User=bacula
MySQL connect failed either server not running or your authorization
is incorrect.
bscan: bscan.c:315-0 mysql.c:271 Unable to connect to MySQL server.
Database=bacula User=bacula
MySQL connect failed either server not running or your authorization
is incorrect.
*07-okt 14:28 bscan ERROR TERMINATION*
*Could not open Catalog "NULL", database "bacula".*
hleever2@hleever2:~$ sudo bscan -s -m -n bacula -C MyCatalog -c
bacula-sd.conf -v -V GKM167 /dev/nst0
bscan: ongeldige optie -- 'C'
Copyright (C) 2001-2017 Kern Sibbald.
Version: 9.0.6 (20 November 2017)
Usage: bscan [ options ] <bacula-archive>
-b bootstrap specify a bootstrap file
-c <file> specify configuration file
-d <nn> set debug level to <nn>
-dt print timestamp in debug output
-m update media info in database
-D <driver name> specify the driver database name (default NULL)
-n <name> specify the database name (default bacula)
-u <user> specify database user name (default bacula)
-P <password> specify database password (default none)
-h <host> specify database host (default NULL)
-t <port> specify database port (default 0)
-p proceed inspite of I/O errors
-r list records
-s synchronize or store in database
-S show scan progress periodically
-v verbose
-V <Volumes> specify Volume names (separated by |)
-w <dir> specify working directory (default from conf
file)
-? print this message
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
