bareos 23 to 24 upgrade - FreeBSD

[Alexander Frankenhauser]

Hello,

I'm updating bareos from version 23.1 to version 24 on FreeBSD 13.4.

The update goes well until I need to run the database update script:

/usr/local/lib/bareos/scripts/update_bareos_tables

su postgres -c /usr/local/lib/bareos/scripts/update_bareos_tables
Info: Updating bareos tables
[: bee: bad number
Error: Don't know how to upgrade from version 2230 to 2240

I had a similar error when upgrading from a previous version (22 to 23) the issue was that the SQL upgrade script did not make it into the port.

Anybody running into the same issue?

[Alexander Frankenhauser]

Ok I downloaded the DB update script  from:

bareos/core/src/cats/ddl/updates/postgresql.2230_2240.sql at master · bareos/bareos · GitHub

uploaded it to:

/usr/local/lib/bareos/scripts/ddl/updates

and rerun: 

su postgres -c /usr/local/lib/bareos/scripts/update_bareos_tables

su postgres -c /usr/local/lib/bareos/scripts/grant_bareos_privileges

everything is working now.

[Bruno Friedmann (bruno-at-bareos)]

Oh that's bad if it is missing in terms of packaging, would you mind to create an issue on github ?