[pkg-bacula-devel] Bug#975970: bacula-director-mysql broken SQL schema for mariadb-server-10.5

[Radoslav Bodó]

> Yes, I can confirm the problem. Getting this solved may prove
> interesting, as upstream does not officially support MariaDB.

thank you for very quick response



> 2) After disabling those checks, there is still a different error in
> bacula.Job and bacula.Pool:
>
> ,----
> | Error in foreign key constraint of table `bacula`.`Pool`:
> | Create table `bacula`.`Pool` with foreign key (ScratchPoolId)
> constraint
> | failed. There is only prefix index in the referenced table where the
> | referenced columns appear as the first columns.
> `----
>
> I have not yet found any explanation about that specific error on the
> net anywhere.

I have elaborated a bit on your progress and come up with following
patch (attachment) which processes fine on current Bullseye.

I don't really have an exact explanation but at least the schema seem to
be created ...


bodik
-------------- next part --------------
A non-text attachment was scrubbed...
Name: debian-bacula-mysql-install-schema.patch
Type: text/x-patch
Size: 2975 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-bacula-devel/attachments/20201127/2440f84c/attachment.bin>