Hi Bruno,
I had the same issue as Bruce had. I'm working on a Debian 11.8 system and
the reboot was the only way to get bareos up and running again.
Greetings, Jens
Bruno Friedmann (bruno-at-bareos) schrieb am Montag, 27. November 2023 um
10:30:32 UTC+1:
> Hi Bruce, It look really weird to me, to have to reboot a server due to
> Bareos update or upgrade.
> Mostly update just need to restart services which all can be done in one
> go with `systemctl restart bareos-dir bareos-sd bareos-fd`
>
> For upgrade, it has always been a good idea (beside reading the
> documentation and changelog) to run the
> /usr/lib/bareos/script/update_bareos_tables
> /usr/lib/bareos/script/grant_bareos_privileges
> Which update the database schema, and associated right
> Then restart the service.
>
> I would always in my case check each daemon before restart to handle
> configuration warning deprecation etc.
> `
> bareos-dir -t -u bareos -g bareos
> bareos-sd -t u bareos -g bareos
> bareos-fd -t -u root -g bareos
> `
>
> If you still have to reboot, would be interesting to know which platform
> requires that.
> Le dimanche 26 novembre 2023 à 17:17:01 UTC+1, Bruce Eckstein a écrit :
>
>> 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/041c2c86-1d7a-40b5-a359-20d38a849496n%40googlegroups.com.
