Digging a bit more into the packages, it looks like the postgresql.2210_2230.sql file wasn't included sometime in the 22.1.x release release cycle. In my FreeBSD jail as root:
cp postgresql.2210_2230.sql /usr/local/lib/bareos/scripts/ddl/updates/ su - postgres psql bareos </usr/local/lib/bareos/scripts/ddl/updates/postgresql.2210_2230.sql Once the database was upgraded to the correct version, my installation seems to be working again. I don't know if the original lua error is anything to be concerned about but I'm in the process of testing various workflows and will update this if I find any issues. On Friday, January 5, 2024 at 1:29:25 PM UTC-8 Peter Kropf wrote: > I don't see a update_bareos_tables script on my system. I suspect that the > Lua script that's throwing errors is preventing the database update to run. > Unfortunately I'm not sure how to debug this. > > > > > On Friday, January 5, 2024 at 11:33:59 AM UTC-8 aeron...@gmail.com wrote: > >> On my ubuntu system I had to run >> >> /usr/bareos/lib/scripts/update_bareos_tables >> >> Hope that helps >> On 1/5/24 2:18 PM, Peter Kropf wrote: >> >> In /var/log/bareos/bareos.log: >> >> >> 05-Jan 11:05 bareos-dir JobId 0: Fatal error: Version error for database >> "bareos". Wanted 2230, got 2210 >> 05-Jan 11:05 bareos-dir JobId 0: Fatal error: Could not open Catalog >> "MyCatalog", database "bareos". >> 05-Jan 11:05 bareos-dir JobId 0: Fatal error: Version error for database >> "bareos". Wanted 2230, got 2210 >> 05-Jan 11:05 bareos-dir ERROR TERMINATION >> Please correct the configuration in >> /usr/local/etc/bareos/bareos-dir.d/*/*.conf >> >> >> Seems the upgrade of bareos-dir failed as it was expecting the database >> to be version 2230 but it's at 2210. >> >> Anyone know how to upgrade the database to 2230? >> >> >> On Friday, January 5, 2024 at 10:58:35 AM UTC-8 Peter Kropf wrote: >> >>> I'm trying to upgrade my Bareos installation on a FreeBSD server from >>> version 22 to 23. After updating the repository via >>> add_bareos_repositories.sh from my subscription, I ran pkg upgrade. That >>> resulted in >>> >>> [bare2] [9/9] Extracting bareos.com-director-23.0.0: 100% >>> pkg: Failed to execute lua script: [string "-- args: >>> "etc/bareos/bareos-dir.d/fileset/Win..."]:3: ')' expected near 'etc' >>> pkg: lua script failed >>> pkg: Failed to execute lua script: [string "-- args: >>> "etc/bareos/bareos-dir.d/fileset/Win..."]:3: ')' expected near 'etc' >>> pkg: lua script failed >>> >>> Anyone successfully upgraded from 22 to 23? Any insights into what needs >>> to happen to fix this? >>> >>> Full output of upgrade is attached. >>> >>> - Peter >>> >>> -- >> 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...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/bareos-users/6f62229b-53cd-4c2b-8d38-75fd1459bb2bn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/bareos-users/6f62229b-53cd-4c2b-8d38-75fd1459bb2bn%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 bareos-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/4efc91f8-2b43-4e61-986b-9783c6965056n%40googlegroups.com.
