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
I don't see a
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
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
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
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
Hi Thanks for your report,
I've now being able to reproduce it in the master and 23 branch, we will
certain get more information/fix from our beloved dev team soon.
Le vendredi 5 janvier 2024 à 12:39:50 UTC+1, jens.gr...@gmail.com a écrit :
> Hi Bruno,
>
> thanks for your reply.
>
> The
Hi Bruno,
thanks for your reply.
The db-scheme seems correct.
bareos@blabla:~$ psql -U bareos bareos
psql (15.5 (Debian 15.5-0+deb12u1))
Geben Sie »help« für Hilfe ein.
bareos=> \c
Sie sind jetzt verbunden mit der Datenbank »bareos« als Benutzer »bareos«.
bareos=> select * from version;
Hi Jen,
I guess you already verified that you didn't forget to update the database
schema and the privileges ?
either with dbconfig or manually by applying the manual script
update_bareos_tables and grant_bareos_privileges
```
Enter SQL query: select * from version;
+---+
| versionid |