Try running /usr/lib/bareos/scripts/update_bareos_tables as user postgres .
Kindest regards, Peter. On Mon, Feb 17, 2020 at 8:55 PM 'Pablo J Rebollo-Sosa' via bareos-users < [email protected]> wrote: > Stefan, > > You need to update the DB schema. The following link has more information. > > > https://docs.bareos.org/master/IntroductionAndTutorial/UpdatingBareos.html#updating-the-database-scheme > > > For CentOS installation using MySQL you can use the following. > > mysql -u root -p bareos < > /usr/lib/bareos/scripts/ddl/updates/mysql.2171_2192.sql > > > > Best regards, > > Pablo J. Rebollo-Sosa > > On Feb 17, 2020, at 3:37 PM, Stefan Harbich < > [email protected]> wrote: > > Hello my dears, > > after the update to Bareos 19.2.6-2 my directory no longer starts. I get > the following error message: > root@dsme01:~# /usr/sbin/bareos-dir -t -f -d 500 > bareos-dir (10): dird/dird.cc:253-0 Debug level = 500 > bareos-dir (100): lib/parse_conf.cc:208-0 config file = > /etc/bareos/bareos-dir.d/*/*.conf > bareos-dir (100): lib/lex.cc:333-0 glob > /etc/bareos/bareos-dir.d/*/*.conf: 40 files > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/catalog/MyCatalog.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/bareos-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/dsme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/nmanwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/nmanwwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/console/admin.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/console/bareos-mon.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/director/bareos-dir.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/Catalog.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/LinuxAll.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/plugin-ldap.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/plugin-mysql.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/SelfTest.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/Windows All Drives.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-bareos-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/BackupCatalog.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-dsme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-ldap.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-mysql.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-nmanwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-nmanwwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/backup-dsme01.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/backup-nmanwme01.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/backup-nmanwwme01.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/DefaultJob.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/RestoreFiles.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/messages/Daemon.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/messages/Standard.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Differential.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Full.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Incremental.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Scratch.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/bareosfs-all.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/operator.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/webui-admin.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/webui-readonly.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/schedule/EmptyCycle.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/schedule/WeeklyCycleAfterBackup.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/schedule/WeeklyCycle.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/storage/File.conf > bareos-dir (9): dird/inc_conf.cc:573-0 set wildfile 55959ea36b70 size=1 > [A-Z]:/swapfile.sys > bareos-dir (9): dird/inc_conf.cc:573-0 set wildfile 55959ea36b70 size=2 > [A-Z]:/pagefile.sys > bareos-dir (9): dird/inc_conf.cc:573-0 set wildfile 55959ea36b70 size=3 > [A-Z]:/hiberfil.sys > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=1 > [A-Z]:/RECYCLER > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=2 > [A-Z]:/$RECYCLE.BIN > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=3 > [A-Z]:/System Volume Information > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=4 A:/ > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=5 B:/ > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=6 D:/ > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=7 E:/ > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=8 M:/ > bareos-dir (9): dird/inc_conf.cc:573-0 set wilddir 55959ea36b70 size=9 S:/ > bareos-dir (100): lib/lex.cc:333-0 glob > /etc/bareos/bareos-dir.d/*/*.conf: 40 files > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/catalog/MyCatalog.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/bareos-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/dsme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/nmanwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/client/nmanwwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/console/admin.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/console/bareos-mon.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/director/bareos-dir.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/Catalog.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/LinuxAll.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/plugin-ldap.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/plugin-mysql.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/SelfTest.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/fileset/Windows All Drives.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-bareos-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/BackupCatalog.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-dsme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-ldap.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-mysql.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-nmanwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/backup-nmanwwme01-fd.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/backup-dsme01.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/backup-nmanwme01.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/backup-nmanwwme01.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/jobdefs/DefaultJob.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/job/RestoreFiles.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/messages/Daemon.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/messages/Standard.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Differential.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Full.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Incremental.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/pool/Scratch.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/bareosfs-all.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/operator.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/webui-admin.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/profile/webui-readonly.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/schedule/EmptyCycle.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/schedule/WeeklyCycleAfterBackup.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/schedule/WeeklyCycle.conf > bareos-dir (100): lib/lex.cc:226-0 open config file: > /etc/bareos/bareos-dir.d/storage/File.conf > bareos-dir (500): dird/dird_conf.cc:3140-0 runscript: creating new > RunScript object > bareos-dir (500): lib/runscript.cc:211-0 runscript: setting command = > /usr/lib/bareos/scripts/make_catalog_backup.pl MyCatalog > bareos-dir (500): lib/runscript.cc:221-0 runscript: setting target = > *None* > bareos-dir (200): lib/runscript.cc:298-0 runscript: debug > bareos-dir (200): lib/runscript.cc:299-0 --> RunScript > bareos-dir (200): lib/runscript.cc:300-0 --> > Command=/usr/lib/bareos/scripts/make_catalog_backup.pl MyCatalog > bareos-dir (200): lib/runscript.cc:301-0 --> Target=*None* > bareos-dir (200): lib/runscript.cc:302-0 --> RunOnSuccess=1 > bareos-dir (200): lib/runscript.cc:303-0 --> RunOnFailure=0 > bareos-dir (200): lib/runscript.cc:304-0 --> FailJobOnError=1 > bareos-dir (200): lib/runscript.cc:305-0 --> RunWhen=2 > bareos-dir (500): dird/dird_conf.cc:3140-0 runscript: creating new > RunScript object > bareos-dir (500): lib/runscript.cc:211-0 runscript: setting command = > /usr/lib/bareos/scripts/delete_catalog_backup > bareos-dir (500): lib/runscript.cc:221-0 runscript: setting target = > *None* > bareos-dir (200): lib/runscript.cc:298-0 runscript: debug > bareos-dir (200): lib/runscript.cc:299-0 --> RunScript > bareos-dir (200): lib/runscript.cc:300-0 --> > Command=/usr/lib/bareos/scripts/delete_catalog_backup > bareos-dir (200): lib/runscript.cc:301-0 --> Target=*None* > bareos-dir (200): lib/runscript.cc:302-0 --> RunOnSuccess=1 > bareos-dir (200): lib/runscript.cc:303-0 --> RunOnFailure=0 > bareos-dir (200): lib/runscript.cc:304-0 --> FailJobOnError=0 > bareos-dir (200): lib/runscript.cc:305-0 --> RunWhen=1 > bareos-dir (250): lib/message.cc:253-0 Copied message resource > 55959ea3d5a0 > bareos-dir (100): dird/dird.cc:379-0 backend path: > /usr/lib/bareos/backends > bareos-dir (150): dird/dir_plugins.cc:289-0 Load dir plugins > bareos-dir (50): lib/plugins.cc:220-0 LoadPlugins > bareos-dir (150): dird/dir_plugins.cc:302-0 No plugins loaded > bareos-dir (100): cats/cats_backends.cc:83-0 db_init_database: Trying to > find mapping of given interfacename mysql to mapping interfacename dbi, > partly_compare = true > bareos-dir (100): cats/cats_backends.cc:83-0 db_init_database: Trying to > find mapping of given interfacename mysql to mapping interfacename mysql, > partly_compare = false > bareos-dir (100): cats/cats_backends.cc:178-0 db_init_database: testing > backend /usr/lib/bareos/backends/libbareoscats-mysql.so > bareos-dir (100): cats/cats_backends.cc:264-0 db_init_database: loaded > backend /usr/lib/bareos/backends/libbareoscats-mysql.so > bareos-dir (100): cats/mysql.cc:853-0 db_init_database first time > bareos-dir (50): cats/mysql.cc:178-0 mysql_init done > bareos-dir (50): cats/mysql.cc:201-0 mysql_real_connect done > bareos-dir (50): cats/mysql.cc:203-0 db_user=bareos db_name=bareos > db_password=bareos > bareos-dir (500): cats/mysql.cc:414-0 SqlQueryWithHandler starts with > SELECT VersionId FROM Version > bareos-dir (500): cats/mysql.cc:465-0 SqlQueryWithHandler succeeded. > checking handler > bareos-dir (500): cats/mysql.cc:487-0 SqlQueryWithHandler finished > bareos-dir: dird/check_catalog.cc:65-0 Could not open Catalog > "MyCatalog", database "bareos". > bareos-dir: dird/check_catalog.cc:71-0 Version error for database > "bareos". Wanted 2192, got 2171 > bareos-dir (100): cats/mysql.cc:247-0 closedb ref=0 connected=1 > db=55959ea86bd8 > bareos-dir (100): cats/mysql.cc:252-0 close db=55959ea86bd8 > bareos-dir ERROR TERMINATION > Please correct the configuration in /etc/bareos/bareos-dir.d/*/*.conf > > Do you have an idea where I have to look for the error? > > Greetings from Stefan Harbich > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bareos-users/40fa244d-badf-477e-96af-c6528624002b%40googlegroups.com > <https://groups.google.com/d/msgid/bareos-users/40fa244d-badf-477e-96af-c6528624002b%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bareos-users/27DF85EA-1D64-40AE-82AA-ACBD7F8F05AA%40upr.edu > <https://groups.google.com/d/msgid/bareos-users/27DF85EA-1D64-40AE-82AA-ACBD7F8F05AA%40upr.edu?utm_medium=email&utm_source=footer> > . > -- Peter Van Biesen Systems Administrator IT-Team/exploitatie&beheer VLAAMS AGENTSCHAP VOOR PERSONEN MET EEN HANDICAP *T* +32 2 249 33 47 <+32+2+249+33+47> [email protected] Zenithgebouw, Koning Albert II-laan 37, 1030 Brussel www.vaph.be //////////////////////////////////////////////////////////////////////////////////////////////////// -- <https://mijn.vaph.be> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/CAHGw5uUzOW1Mv-u1nDksQRj2UsGCH3btBWFBxighYVpa-UTeWA%40mail.gmail.com.
