[@bacula01 ~]$ rpm -qa|grep -i bacula
bacula-storage-9.0.6-6.el8.x86_64
bacula-libs-9.0.6-6.el8.x86_64
bacula-director-9.0.6-6.el8.x86_64
bacula-client-9.0.6-6.el8.x86_64
bacula-common-9.0.6-6.el8.x86_64
bacula-libs-sql-9.0.6-6.el8.x86_64
bacula-console-9.0.6-6.el8.x86_64
[@bacula01 ~]$
On Wednesday, April 5, 2023 at 12:39:05 PM CDT, Phil Stracchino
<ph...@caerllewys.net> wrote:
On 4/5/23 11:10, Andrew Meyer via Bacula-users wrote:
> I'm trying to set up bacula on AlmaLinux 8.7 w/ MariaDB 10.11 and
> getting the following error:
>
> $ sudo /usr/libexec/bacula/make_mysql_tables -u bacula -p
> Enter password:
> ERROR 1005 (HY000) at line 112: Can't create table `bacula`.`Job`
> (errno: 150 "Foreign key constraint is incorrectly formed")
> ERROR 1005 (HY000) at line 286: Can't create table `bacula`.`Pool`
> (errno: 150 "Foreign key constraint is incorrectly formed")
> Creation of Bacula MySQL tables succeeded.
>
> The error was much worse when I tried to run this as mysql root user.
>
> Can someone point me in the right direction to resolve this?
Andrew, which version of Bacula? If you are seeing foreign key
constraint failures, I suspect the general answer is "an old one",
because no table in current Bacula releases contains foreign key
constraints. They were removed a LONG time ago.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
