If this is the upgrade to version 23, I had a similar issue. I needed to
run /usr/lib/bareos/script/update_bareos_tables to update the tables in
bareos. Then I had to reboot the server. I tried to just reboot the
postgresql but that did not work.
best of luck.
On Friday, May 5, 2023 at 4:39:51 AM UTC-4 DUCARROZ Birgit wrote:
> Hi,
>
> Please can anyone help me with this issue?
> ----------------------------------------------------------
> sudo -u bareos -s
>
> bareos@xxxx:/home/superuser$ psql
>
> *psql: error: connection to server on socket
> "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "bareos" does
> not exist*
>
>
>
> LOG- AND CONFIGURATION FILES:
> ----------------------------------------------------------
> netstat -nlp | grep 5432
> tcp 0 0 127.0.0.1:5432 0.0.0.0:*
> LISTEN 1218/postgres
> unix 2 [ ACC ] STREAM LISTENING 59051 1218/postgres
> /var/run/postgresql/.s.PGSQL.5432
> ----------------------------------------------------------
> ps axf | grep postgres
> 8021 pts/1 S+ 0:00 \_ grep
> --color=auto postgres
> 1218 ? Ss 0:01 /usr/lib/postgresql/15/bin/postgres -D
> /var/lib/postgresql/15/main -c
> config_file=/etc/postgresql/15/main/postgresql.conf
> 1246 ? Ss 0:00 \_ postgres: 15/main: checkpointer
> 1247 ? Ss 0:00 \_ postgres: 15/main: background writer
> 1322 ? Ss 0:00 \_ postgres: 15/main: walwriter
> 1323 ? Ss 0:00 \_ postgres: 15/main: autovacuum launcher
> 1324 ? Ss 0:00 \_ postgres: 15/main: logical replication
> launcher
> ----------------------------------------------------------
> /usr/sbin/bareos-dir -t
> bareos-dir: dird/check_catalog.cc:64-0 Could not open Catalog
> "MyCatalog", database "bareos".
> bareos-dir: dird/check_catalog.cc:71-0 cats/postgresql.cc:230 Unable to
> connect to PostgreSQL server. Database=bareos User=bareos
> Possible causes: SQL server not running; password incorrect;
> max_connections exceeded.
> (connection to server at "localhost" (127.0.0.1), port 5432 failed:
> FATAL: password authentication failed for user "bareos"
> connection to server at "localhost" (127.0.0.1), port 5432 failed:
> FATAL: password authentication failed for user "bareos"
> )
> bareos-dir ERROR TERMINATION
>
> ----------------------------------------------------------
>
> /usr/sbin/bareos-dir --xc Catalog MyCatalog
> Catalog {
> Name = "MyCatalog"
> DbAddress = "localhost"
> DbPort = 5432
> DbPassword = "test"
> DbUser = "bareos"
> DbName = "bareos"
> }
> ----------------------------------------------------------
> cat /etc/bareos/bareos-dir.d/catalog/MyCatalog.conf
> Catalog {
> Name = MyCatalog
> dbname = bareos
> dbaddress = 127.0.0.1
> #dbaddress = localhost
> dbport = 5432
> dbuser = bareos
> dbpassword = test
>
> }
> ----------------------------------------------------------
> cat /etc/dbconfig-common/bareos-database-common.conf
> # automatically generated by the maintainer scripts of
> bareos-database-common
> # any changes you make will be preserved, though your comments
> # will be lost! to change your settings you should edit this
> # file and then run "dpkg-reconfigure bareos-database-common"
>
> # dbc_install: configure database with dbconfig-common?
> # set to anything but "true" to opt out of assistance
> dbc_install='true'
>
> # dbc_upgrade: upgrade database with dbconfig-common?
> # set to anything but "true" to opt out of assistance
> dbc_upgrade='true'
>
> # dbc_remove: deconfigure database with dbconfig-common?
> # set to anything but "true" to opt out of assistance
> dbc_remove='true'
>
> # dbc_dbtype: type of underlying database to use
> # this exists primarily to let dbconfig-common know what database
> # type to use when a package supports multiple database types.
> # don't change this value unless you know for certain that this
> # package supports multiple database types
> dbc_dbtype='pgsql'
>
> # dbc_dbuser: database user
> # the name of the user who we will use to connect to the database.
> dbc_dbuser='bareos'
>
> # dbc_dbpass: database user password
> # the password to use with the above username when connecting
> # to a database, if one is required
> dbc_dbpass='test'
>
> # dbc_dballow: allowed host to connect from
> # only for database types that support specifying the host from
> # which the database user is allowed to connect from
> # this string defines for which host the dbc_dbuser is allowed
> # to connect
> # this value is only really used again when you reconfigure the
> # package
> dbc_dballow='localhost'
>
> # dbc_dbserver: database host.
> # leave unset to use localhost (or a more efficient local method
> # if it exists).
> dbc_dbserver='localhost'
>
> # dbc_dbport: remote database port
> # leave unset to use the default. only applicable if you are
> # using a remote database.
> dbc_dbport='5432'
>
> # dbc_dbname: name of database
> # this is the name of your application's database.
> dbc_dbname='bareos'
>
> # dbc_dbadmin: name of the administrative user
> # this is the administrative user that is used to create all of the above
> # The exception is the MySQL/MariaDB localhost case, where this value is
> # ignored and instead is determined from /etc/mysql/debian.cnf.
> dbc_dbadmin='postgres'
>
> # dbc_basepath: base directory to hold database files
> # leave unset to use the default. only applicable if you are
> # using a local (filesystem based) database.
> dbc_basepath=''
>
> ##
> ## postgresql specific settings. if you don't use postgresql,
> ## you can safely ignore all of these
> ##
>
> # dbc_ssl: should we require ssl?
> # set to "true" to require that connections use ssl
> dbc_ssl=''
>
> # dbc_authmethod_admin: authentication method for admin
> # dbc_authmethod_user: authentication method for dbuser
> # see the section titled "AUTHENTICATION METHODS" in
> # /usr/share/doc/dbconfig-common/README.pgsql for more info
> dbc_authmethod_admin='ident'
> dbc_authmethod_user='password'
>
> ##
> ## end postgresql specific settings
> ##
>
>
> ----------------------------------------------------------
>
> /usr/sbin/bareos-dir -t -f -d 500
> bareos-dir (10): lib/parse_conf.h:440-0 ConfigResourcesContainer: new
> configuration_resources_ 55e8b2aa27d0
> bareos-dir (100): lib/parse_conf.cc:174-0 config file =
> /etc/bareos/bareos-dir.d/*/*.conf
> bareos-dir (100): lib/lex.cc:316-0 glob
> /etc/bareos/bareos-dir.d/*/*.conf: 25 files
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/catalog/MyCatalog.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/client/bareos-fd.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/console/admin.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/console/bareos-mon.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/director/bareos-dir.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/Catalog.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/LinuxAll.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/SelfTest.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/Windows All Drives.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/job/backup-bareos-fd.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/job/BackupCatalog.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/jobdefs/DefaultJob.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/job/RestoreFiles.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/messages/Daemon.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/messages/Standard.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Differential.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Full.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Incremental.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Scratch.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/profile/operator.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/profile/webui-admin.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/profile/webui-readonly.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/schedule/WeeklyCycleAfterBackup.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/schedule/WeeklyCycle.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/storage/File.conf
> bareos-dir (9): dird/inc_conf.cc:548-0 set wildfile 55e8b2aa9420 size=1
> [A-Z]:/hiberfil.sys
> bareos-dir (9): dird/inc_conf.cc:548-0 set wildfile 55e8b2aa9420 size=2
> [A-Z]:/pagefile.sys
> bareos-dir (9): dird/inc_conf.cc:548-0 set wildfile 55e8b2aa9420 size=3
> [A-Z]:/swapfile.sys
> bareos-dir (9): dird/inc_conf.cc:548-0 set wilddir 55e8b2aa9420 size=1
> [A-Z]:/RECYCLER
> bareos-dir (9): dird/inc_conf.cc:548-0 set wilddir 55e8b2aa9420 size=2
> [A-Z]:/$RECYCLE.BIN
> bareos-dir (9): dird/inc_conf.cc:548-0 set wilddir 55e8b2aa9420 size=3
> [A-Z]:/System Volume Information
> bareos-dir (100): lib/lex.cc:316-0 glob
> /etc/bareos/bareos-dir.d/*/*.conf: 25 files
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/catalog/MyCatalog.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/client/bareos-fd.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/console/admin.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/console/bareos-mon.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/director/bareos-dir.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/Catalog.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/LinuxAll.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/SelfTest.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/fileset/Windows All Drives.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/job/backup-bareos-fd.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/job/BackupCatalog.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/jobdefs/DefaultJob.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/job/RestoreFiles.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/messages/Daemon.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/messages/Standard.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Differential.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Full.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Incremental.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/pool/Scratch.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/profile/operator.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/profile/webui-admin.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/profile/webui-readonly.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/schedule/WeeklyCycleAfterBackup.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/schedule/WeeklyCycle.conf
> bareos-dir (100): lib/lex.cc:213-0 open config file:
> /etc/bareos/bareos-dir.d/storage/File.conf
> bareos-dir (200): dird/dird_conf.cc:2313-0 job RestoreFiles RunScript
> inherited: 1 1
> bareos-dir (200): dird/dird_conf.cc:2313-0 job DefaultJob RunScript
> inherited: 1 1
> bareos-dir (500): dird/dird_conf.cc:2905-0 runscript: creating new
> RunScript object
> bareos-dir (500): lib/runscript.cc:210-0 runscript: setting command =
> /usr/lib/bareos/scripts/make_catalog_backup MyCatalog
> bareos-dir (500): lib/runscript.cc:220-0 runscript: setting target = *None*
> bareos-dir (200): lib/runscript.cc:297-0 runscript: debug
> bareos-dir (200): lib/runscript.cc:298-0 --> RunScript
> bareos-dir (200): lib/runscript.cc:299-0 -->
> Command=/usr/lib/bareos/scripts/make_catalog_backup MyCatalog
> bareos-dir (200): lib/runscript.cc:300-0 --> Target=*None*
> bareos-dir (200): lib/runscript.cc:301-0 --> RunOnSuccess=1
> bareos-dir (200): lib/runscript.cc:302-0 --> RunOnFailure=0
> bareos-dir (200): lib/runscript.cc:303-0 --> FailJobOnError=1
> bareos-dir (200): lib/runscript.cc:304-0 --> RunWhen=2
> bareos-dir (500): dird/dird_conf.cc:2905-0 runscript: creating new
> RunScript object
> bareos-dir (500): lib/runscript.cc:210-0 runscript: setting command =
> /usr/lib/bareos/scripts/delete_catalog_backup MyCatalog
> bareos-dir (500): lib/runscript.cc:220-0 runscript: setting target = *None*
> bareos-dir (200): lib/runscript.cc:297-0 runscript: debug
> bareos-dir (200): lib/runscript.cc:298-0 --> RunScript
> bareos-dir (200): lib/runscript.cc:299-0 -->
> Command=/usr/lib/bareos/scripts/delete_catalog_backup MyCatalog
> bareos-dir (200): lib/runscript.cc:300-0 --> Target=*None*
> bareos-dir (200): lib/runscript.cc:301-0 --> RunOnSuccess=1
> bareos-dir (200): lib/runscript.cc:302-0 --> RunOnFailure=0
> bareos-dir (200): lib/runscript.cc:303-0 --> FailJobOnError=0
> bareos-dir (200): lib/runscript.cc:304-0 --> RunWhen=1
> bareos-dir (200): dird/dird_conf.cc:2313-0 job BackupCatalog RunScript
> inherited: 1 1
> bareos-dir (200): dird/dird_conf.cc:2313-0 job backup-bareos-fd
> RunScript inherited: 1 1
> bareos-dir (250): lib/message.cc:244-0 Copied message resource 55e8b2aaada0
> bareos-dir (100): dird/dird.cc:320-0 backend path: /usr/lib/bareos/backends
> bareos-dir (150): dird/dir_plugins.cc:273-0 Load dir plugins
> bareos-dir (150): dird/dir_plugins.cc:275-0 No dir plugin dir!
> bareos-dir (100): cats/cats_backends.cc:71-0 db_init_database: Trying to
> find mapping of given interfacename postgresql to mapping interfacename
> dbi, partly_compare = true
> bareos-dir (100): cats/cats_backends.cc:71-0 db_init_database: Trying to
> find mapping of given interfacename postgresql to mapping interfacename
> mysql, partly_compare = false
> bareos-dir (100): cats/cats_backends.cc:71-0 db_init_database: Trying to
> find mapping of given interfacename postgresql to mapping interfacename
> postgresql, partly_compare = false
> bareos-dir (100): cats/cats_backends.cc:219-0 db_init_database: checking
> backend /usr/lib/bareos/backends/libbareoscats-postgresql.so
> bareos-dir (100): cats/cats_backends.cc:245-0 db_init_database: loaded
> backend /usr/lib/bareos/backends/libbareoscats-postgresql.so
> bareos-dir (100): cats/postgresql.cc:956-0 db_init_database first time
> bareos-dir (50): cats/postgresql.cc:224-0 pg_real_connect failed
> bareos-dir (50): cats/postgresql.cc:226-0 db_user=bareos db_name=bareos
> db_password=test
> bareos-dir: dird/check_catalog.cc:64-0 Could not open Catalog
> "MyCatalog", database "bareos".
> bareos-dir: dird/check_catalog.cc:71-0 cats/postgresql.cc:230 Unable to
> connect to PostgreSQL server. Database=bareos User=bareos
> Possible causes: SQL server not running; password incorrect;
> max_connections exceeded.
> (connection to server at "localhost" (127.0.0.1), port 5432 failed:
> FATAL: password authentication failed for user "bareos"
> connection to server at "localhost" (127.0.0.1), port 5432 failed:
> FATAL: password authentication failed for user "bareos"
> )
> bareos-dir ERROR TERMINATION
> Please correct the configuration in /etc/bareos/bareos-dir.d/*/*.conf
>
>
> Thank you so much for any hint!
> Regards,
> Birgit
>
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/bareos-users/9378ecfe-b5b7-4adc-acce-8259d0eabc60n%40googlegroups.com.
