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 5432tcp 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 postgres8021 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 launcher1324 ? Ss 0:00 \_ postgres: 15/main: logical replication launcher
---------------------------------------------------------- /usr/sbin/bareos-dir -tbareos-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 500bareos-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 --> RunScriptbareos-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=2bareos-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 --> RunScriptbareos-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=1bareos-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 failedbareos-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/f48d6e2f-44c4-499d-3bd6-5ea13a591b6c%40unifr.ch.
OpenPGP_0xD86E168D606536D7.asc
Description: OpenPGP public key
OpenPGP_signature
Description: OpenPGP digital signature
