Bareos component version

bareos.com-bconsole-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (bconsole)
bareos.com-common-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (bconsole)
bareos.com-database-common-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (database-common)
bareos.com-database-postgresql-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (database-postgresql)
bareos.com-database-tools-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (database-tools)
bareos.com-director-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (director)
bareos.com-filedaemon-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (filedaemon)
bareos.com-storage-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (storage)
bareos.com-storage-dplcompat-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (storage-dplcompat)
bareos.com-tools-24.0.1.p10.a2.e4.f6.e Backup archiving recovery open sourced (tools)

Steps to reproduce

pdating 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.

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.

Looks like the FreeBSD packages are missing the postgresql.2230_2240.sql script.

Expected results

script postgresql.2230_2240.sql should be included in the FreeBSD builds

Actual results

script postgresql.2230_2240.sql is not included in the FreeBSD builds

Environment

- OS: 13.4-RELEASE-p2
- component:

Relevant log output

No response

Relevant traces output

No response

Anything else?

No response