Database schema fails

Installation RPM Installation
1

During the installation of version 4.2.1.10 I run into the following error in the database step, where some columns cant be initialized. The mariadb step during the installation is also not working so I tried it here with a fresh installation of mine. I tried for the baseline version 0.0.0.0, blanked (which defaults to 2.3.0.0). Same error every time

I am working on centos9-stream

Also I am courios if its possible to continue the installation script from a specific step as it doesnt work when I start it again.

Please validate information below
---------------------------------
FLYWAY_BASELINE_VERSION=2.3.0.0
FLYWAY_OPENIAM_DATABASE_NAME=openiam
FLYWAY_ACTIVITI_DATABASE_NAME=activiti
FLYWAY_OPENIAM_HOST=localhost
FLYWAY_OPENIAM_PORT=3306
FLYWAY_ACTIVITI_HOST=localhost
FLYWAY_ACTIVITI_PORT=3306
FLYWAY_DATABASE_TYPE=mysql
Database will be initialized=Y
Root (Db admin) user name=root
Root (Db admin) user password=root
---------------------------------
Please validate your input above, if your are OK with that enter 'y'. To repeat an information collecting procedure enter 'n' :y
Mysql. Try to initialize automatically
/usr/local/openiam/conf/schema/mysql/openiam/
A new version of Flyway is available
Upgrade Flyway: Command-line - Redgate Flyway - Product Documentation
Flyway Community Edition 9.5.1 by Redgate
See what's new here: Release Notes for Flyway Engine - Redgate Flyway - Product Documentation

Database: jdbc:mysql://localhost:3306/openiam (MariaDB 10.5)
Creating Schema History table `openiam`.`flyway_schema_history` with baseline ...
Successfully baselined schema with version: 2.3.0.0
Successfully validated 1201 migrations (execution time 00:00.731s)
Current version of schema `openiam`: 2.3.0.0
Migrating schema `openiam` to version "2.3.0.0.001 - mysql schema common"
Migrating schema `openiam` to version "2.3.0.0.002 - mysql schema security"
Migrating schema `openiam` to version "2.3.0.0.003 - mysql idm data"
Migrating schema `openiam` to version "3.0.0.0.001 - alter table attribute map"
Migrating schema `openiam` to version "3.0.0.0.002 - create resource many to many mapping"
Migrating schema `openiam` to version "3.0.0.0.003 - create group many to many mapping"
Migrating schema `openiam` to version "3.0.0.0.004 - migrate role id"
Migrating schema `openiam` to version "3.0.0.0.005 - migrate resource role mappings"
Migrating schema `openiam` to version "3.0.0.0.006 - create role many to many mapping"
Migrating schema `openiam` to version "3.0.0.0.007 - create group and role name constraints"
Migrating schema `openiam` to version "3.0.0.0.008 - add authorization data to resources"
Migrating schema `openiam` to version "3.0.0.0.009 - migrate menus to resources"
Migrating schema `openiam` to version "3.0.0.0.010 - fix resource name and type"
Migrating schema `openiam` to version "3.0.0.0.011 - add url protector column to res"
Migrating schema `openiam` to version "3.0.0.0.012 - fix group name"
Migrating schema `openiam` to version "3.0.0.0.013 - add fk to users"
Migrating schema `openiam` to version "3.0.0.0.014 - remove obsolete res and role fields"
Migrating schema `openiam` to version "3.0.0.0.015 - fix role name"
Migrating schema `openiam` to version "3.0.0.0.016 - update menu urls"
Migrating schema `openiam` to version "3.0.0.0.017 - role menus"
Migrating schema `openiam` to version "3.0.0.0.018 - fix group name"
Migrating schema `openiam` to version "3.0.0.0.019 - drop deprecated group columns"
Migrating schema `openiam` to version "3.0.0.0.020 - group menus"
Migrating schema `openiam` to version "3.0.0.0.021 - create group categories"
Migrating schema `openiam` to version "3.0.0.0.022 - fix id lenght metadata category"
ERROR: Migration of schema `openiam` to version "3.0.0.0.022 - fix id lenght metadata category" failed! Please restore backups and roll back database and code!
ERROR: Migration V3.0.0.0.022__fix_id_lenght_metadata_category.sql failed
------------------------------------------------------------------
SQL State : HY000
Error Code : 1833
Message : (conn=6) Cannot change column 'TYPE_ID': used in a foreign key constraint 'openiam/FK_CATEGORY_METADATA_TYPE' of table 'openiam/CATEGORY_TYPE'
Location : /usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql (/usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql)
Line : 2
Statement : ALTER TABLE METADATA_TYPE MODIFY TYPE_ID varchar(32) not null

Caused by: Migration V3.0.0.0.022__fix_id_lenght_metadata_category.sql failed
------------------------------------------------------------------
SQL State : HY000
Error Code : 1833
Message : (conn=6) Cannot change column 'TYPE_ID': used in a foreign key constraint 'openiam/FK_CATEGORY_METADATA_TYPE' of table 'openiam/CATEGORY_TYPE'
Location : /usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql (/usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql)
Line : 2
Statement : ALTER TABLE METADATA_TYPE MODIFY TYPE_ID varchar(32) not null

Caused by: java.sql.SQLTransientConnectionException: (conn=6) Cannot change column 'TYPE_ID': used in a foreign key constraint 'openiam/FK_CATEGORY_METADATA_TYPE' of table 'openiam/CATEGORY_TYPE'
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Cannot change column 'TYPE_ID': used in a foreign key constraint 'openiam/FK_CATEGORY_METADATA_TYPE' of table 'openiam/CATEGORY_TYPE'
Caused by: java.sql.SQLException: Cannot change column 'TYPE_ID': used in a foreign key constraint 'openiam/FK_CATEGORY_METADATA_TYPE' of table 'openiam/CATEGORY_TYPE'

2

Hello @iam,

Sorry for the trouble you’ve experienced during installation. I believe you wrote that you are using v4.2.1.10 – could you please install the current release of the Community Edition which is 4.2.1.14? We have documentation for doing so at this link: https://docs.openiam.com/docs-4.2.1.14/installation/1-rpm-installation/1-singlenode

Please let me know if you run into any issues.

Thanks,

Ameet

3

Hello, I tried the 4.2.1.14 version but I run into the same error. Everything works fine until setting up the database.

Kind regards

5

Could you please share the RPM installation log during the step where the Maria DB installation fails?

Thanks.

6

The installation log file can be found at /usr/local/openiam/init.log

7

Would you like to install MariaDB RDBMS locally? [y/n]:y
OpenIAM-Base-Local 53 MB/s | 444 kB 00:00
Fehler:
Problem 1: Problem mit installiertem Paket perl-overloading-0.02-483.el9.noarch
- package perl-overloading-0.02-483.el9.noarch from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-overloading-0.02-479.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-overloading-0.02-480.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-overloading-0.02-481.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-overloading-0.02-483.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- widersprüchliche Anforderungen
Problem 2: Problem mit installiertem Paket python3-perf-5.14.0-615.el9.x86_64
- package python3-perf-5.14.0-615.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package python3-perf-5.14.0-604.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package python3-perf-5.14.0-605.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package python3-perf-5.14.0-611.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package python3-perf-5.14.0-612.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package python3-perf-5.14.0-615.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- widersprüchliche Anforderungen
Problem 3: package perl-POSIX-1.94-479.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-479.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-480.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-481.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-URI-1.73-3.el8.noarch from @commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- Problem mit installiertem Paket perl-POSIX-1.94-483.el9.x86_64
- package perl-POSIX-1.94-480.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-483.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- widersprüchliche Anforderungen
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- package perl-POSIX-1.94-481.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
Problem 4: package foomatic-4.0.13-19.el9.x86_64 from appstream requires perl(POSIX), but none of the providers can be installed
- package perl-B-1.80-479.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-B-1.80-479.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- Problem mit installiertem Paket perl-B-1.80-483.el9.x86_64
- package perl-B-1.80-480.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-B-1.80-480.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- Problem mit installiertem Paket foomatic-4.0.13-19.el9.x86_64
- package foomatic-4.0.13-19.el9.x86_64 from @System requires perl(POSIX), but none of the providers can be installed
- package perl-POSIX-1.94-479.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-479.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-480.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-481.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Unicode-Normalize-1.25-396.el8.x86_64 from @commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed
- package perl-Unicode-Normalize-1.25-396.el8.x86_64 from @commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-483.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- widersprüchliche Anforderungen
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- package perl-POSIX-1.94-480.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-481.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-B-1.80-481.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-B-1.80-481.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-B-1.80-483.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-B-1.80-483.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-B-1.80-483.el9.x86_64 from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-B-1.80-483.el9.x86_64 from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
Problem 5: package mariadb-server-utils-3:10.3.39-1.module+el8.8.0+19673+72b0d35f.x86_64 from @commandline requires perl(POSIX), but none of the providers can be installed
- package perl-Class-Struct-0.66-479.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Class-Struct-0.66-479.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- Problem mit installiertem Paket perl-Class-Struct-0.66-483.el9.noarch
- package perl-Class-Struct-0.66-480.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Class-Struct-0.66-480.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-POSIX-1.94-479.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-479.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-480.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-481.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Time-Local-1:1.280-1.el8.noarch from @commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-483.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- widersprüchliche Anforderungen
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- package perl-POSIX-1.94-480.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-481.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-Class-Struct-0.66-481.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Class-Struct-0.66-481.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-Class-Struct-0.66-483.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Class-Struct-0.66-483.el9.noarch from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-Class-Struct-0.66-483.el9.noarch from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Class-Struct-0.66-483.el9.noarch from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
Problem 6: package perl-podlators-4.11-1.el8.noarch from @commandline requires perl(POSIX), but none of the providers can be installed
- package perl-Fcntl-1.13-479.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Fcntl-1.13-479.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- Problem mit installiertem Paket perl-Fcntl-1.13-483.el9.x86_64
- package perl-Fcntl-1.13-480.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Fcntl-1.13-480.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-POSIX-1.94-479.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-479.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-480.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.32.1-481.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-threads-shared-1.58-2.el8.x86_64 from @commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed
- package perl-threads-shared-1.58-2.el8.x86_64 from @commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-483.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- widersprüchliche Anforderungen
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- package perl-POSIX-1.94-480.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-481.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-POSIX-1.94-483.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-Fcntl-1.13-481.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Fcntl-1.13-481.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-Fcntl-1.13-483.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Fcntl-1.13-483.el9.x86_64 from appstream conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
- package perl-Fcntl-1.13-483.el9.x86_64 from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from openiam-local
- package perl-Fcntl-1.13-483.el9.x86_64 from @System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from @commandline
Problem 7: Problem mit installiertem Paket perl-mro-1.23-483.el9.x86_64
- package perl-mro-1.23-483.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-mro-1.23-481.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-mro-1.23-480.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-mro-1.23-479.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-mro-1.23-483.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-threads-1:2.21-2.el8.x86_64 from @commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed
- package perl-threads-1:2.21-2.el8.x86_64 from @commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-479.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- widersprüchliche Anforderungen
- cannot install both perl-libs-4:5.32.1-480.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-481.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-483.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System
Problem 8: Problem mit installiertem Paket perl-DBD-SQLite-1.66-5.el9.x86_64
- package perl-DBD-SQLite-1.66-5.el9.x86_64 from @System requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-DBD-SQLite-1.66-5.el9.x86_64 from appstream requires libperl.so.5.32()(64bit), but none of the providers can be installed
- package perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch from @commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed
- cannot install both perl-libs-4:5.32.1-479.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-479.el9.x86_64 from appstream
- widersprüchliche Anforderungen
- cannot install both perl-libs-4:5.32.1-480.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-480.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-481.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-481.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.32.1-483.el9.x86_64 from appstream and perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from appstream
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-483.el9.x86_64 from @System
- cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from @commandline and perl-libs-4:5.32.1-483.el9.x86_64 from @System

8

There are more errors which are similar but exceed charakter limit here. The errors are also the same no matter which version I try to install

9

Hello, I would like to know if you have found a solution to this issue, cause i have been running into it for two days and it’s blocking me

The OS distribution i am using is Rocky Linux 9.6, and the installer version is openIAM 4.2.1.14

Thank you in advance

10

Hello @iam and @obmium,

I’ve shared the log with my team, and it seems the error stems from using the OpenIAM RHEL8 package on a CentOS Stream 9 (RHEL9-based) system. The logs show EL8-era Perl dependencies (e.g., perl-interpreter-5.26.3) conflicting with native EL9 Perl 5.32 packages.

This is causing the error during MariaDB install. To move past this we will want to use the EL9 build as outlined at this link: Installation without Internet Access via RPM on Linux

You’ll want to download the EL9 files as shown below:

curl https://download.openiam.com/release/enterprise/4.2.1.14/rpm/mod_openiam-4.2.1.14.el9.x86_64.rpm  --output mod_openiam-4.2.1.14.el9.x86_64.rpm
curl https://download.openiam.com/release/enterprise/4.2.1.14/dependencies/el9/openiamrepo.tar.gz  --output openiamrepo.tar.gz
curl https://download.openiam.com/release/enterprise/4.2.1.14/binaries/backend.tar.gz  --output backend.tar.gz
curl https://download.openiam.com/release/enterprise/4.2.1.14/binaries/frontend.tar.gz  --output frontend.tar.gz
curl https://download.openiam.com/release/enterprise/infra/httpd-libs.tar.gz  --output httpd-libs.tar.gz

From there, you will want to continue from step #2 as outlined in the document linked above.

This should help you move past the error. Please let me know if you have any questions or continue to run into issues.

11

Hello @ameet_shah

Thank you for your help, I tried the solution you suggested using the EL9 packages and following the steps outlined in the document. Unfortunately, I am still encountering the same migration errors during the installation.

Thank you for your support.

NOTE: the OS is Rocky Linux 9.5

12

Hello ameet_shah, iam

Does this box have Internet access ? \[y/n\]:

Reconfigure env.conf

openiamrepo.tar.gz exists. Continue…

backend.tar.gz exists. Continue…

frontend.tar.gz exists. Continue…

openiamrepo/

openiamrepo/mariadb/

openiamrepo/mariadb/perl-MIME-Base64-3.15-396.el8.x86_64.rpm

openiamrepo/mariadb/perl-Math-BigInt-1.9998.11-7.el8.noarch.rpm

openiamrepo/mariadb/perl-Pod-Usage-1.69-395.el8.noarch.rpm

openiamrepo/mariadb/mariadb-backup-10.3.39-1.module+el8.8.0+19673+72b0d35f.x86_64.rpm

openiamrepo/mariadb/perl-Net-SSLeay-1.88-2.module+el8.6.0+13392+f0897f98.x86_64.rpm

openiamrepo/mariadb/perl-IO-1.38-422.el8.x86_64.rpm

openiamrepo/mariadb/perl-DBD-MySQL-4.046-3.module+el8.1.0+2938+301254e2.x86_64.rpm

openiamrepo/mariadb/mariadb-errmsg-10.3.39-1.module+el8.8.0+19673+72b0d35f.x86_64.rpm

openiamrepo/mariadb/perl-interpreter-5.26.3-422.el8.x86_64.rpm

openiamrepo/mariadb/perl-Term-ANSIColor-4.06-396.el8.noarch.rpm

openiamrepo/mariadb/perl-Time-Local-1.280-1.el8.noarch.rpm

openiamrepo/mariadb/perl-Unicode-Normalize-1.25-396.el8.x86_64.rpm

openiamrepo/mariadb/perl-Scalar-List-Utils-1.49-2.el8.x86_64.rpm

openiamrepo/mariadb/perl-Mozilla-CA-20160104-7.module+el8.3.0+6498+9eecfe51.noarch.rpm

openiamrepo/mariadb/compat-openssl11-1.1.1k-4.el9.x86_64.rpm

openiamrepo/mariadb/mariadb-connector-c-3.1.11-2.el8_3.x86_64.rpm

openiamrepo/mariadb/perl-podlators-4.11-1.el8.noarch.rpm

openiamrepo/mariadb/perl-Exporter-5.72-396.el8.noarch.rpm

openiamrepo/mariadb/mariadb-server-utils-10.3.39-1.module+el8.8.0+19673+72b0d35f.x86_64.rpm

openiamrepo/mariadb/perl-Math-Complex-1.59-422.el8.noarch.rpm

openiamrepo/mariadb/perl-Text-ParseWords-3.30-395.el8.noarch.rpm

openiamrepo/mariadb/perl-Digest-MD5-2.55-396.el8.x86_64.rpm

openiamrepo/mariadb/libaio-0.3.112-1.el8.x86_64.rpm

openiamrepo/mariadb/perl-File-Path-2.15-2.el8.noarch.rpm

openiamrepo/mariadb/mariadb-server-10.3.39-1.module+el8.8.0+19673+72b0d35f.x86_64.rpm

openiamrepo/mariadb/perl-PathTools-3.74-1.el8.x86_64.rpm

openiamrepo/mariadb/perl-Pod-Escapes-1.07-395.el8.noarch.rpm

openiamrepo/mariadb/perl-libs-5.26.3-422.el8.x86_64.rpm

…

Would you like to install MariaDB RDBMS locally? \[y/n\]:Last metadata expiration check: 0:00:56 ago on Wed 15 Oct 2025 03:56:04 PM +01.

Error:

Problem 1: package perl-B-1.80-481.1.el9_6.x86_64 from System conflicts with perl-interpreter < 4:5.30.1-451 provided by perl-interpreter-4:5.26.3-422.el8.x86_64 from commandlinecommandlinecommandlinecommandline

* conflicting requests

* problem with installed package perl-B-1.80-481.1.el9_6.x86_64

Problem 2: cannot install both perl-libs-4:5.26.3-422.el8.xcommandlinecommandline6_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package foomatic-4.0.13-19.el9.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package foomatic-4.0.13-19.el9.x86_64

Problem 3: package perl-URI-1commandlinecommandline73-3.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-lcommandlinecommandlinebs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-AutoLoader-5.74-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-AutoLoader-5.74-481.1.el9_6.noarch

Problem 4: package perlcommandlinecommandlineUnicode-Normalize-1.25-396.el8.x86_64 from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* pcommandlinecommandlineckage perl-Unicode-Normalize-1.25-396.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 frocommandlinecommandline System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-Class-Struct-0.66-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-Class-Struct-0.66-481commandlinecommandline1.el9_6.noarch

Problem 5: package perl-Time-Local-1:1.280-1.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

commandline81.1.el9_6.x86_64

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-lcommandlinecal and perl-libs-4:5.32.1-commandline81.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-DBD-SQLite-1.66-5.el9.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-DBD-SQLite-1.66-5.el9.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be installed

* conflicting requests

* commandlineroblem with installed packacommandlinee perl-DBD-SQLite-1.66-5.el9.x86_64

Problem 6: package perl-threads-shared-1.58-2.el8.x86_64 from commandlicommandlinee requires perl(:MODULE_COMcommandlineAT_5.26.2), but none of the providers can be installed

* package perl-threads-shared-1.58-2.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed

* cannot install both perl-libs-4:5.2commandline.3-422.el8.x86_64 from opencommandlineam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-DynaLoader-1.47-481.1.el9_6.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be instalcommandlinecommandlineed

* conflicting requestscommandline

* problem with installed package perl-DynaLoader-1.47-481.1.el9_6.x86_64

Problem 7: packagecommandlineperl-threads-1:2.21-2.el8.x86_64 from commandlinecommandline requires perl(:MODULE_COMPAT_5.26.2), but none of commandlinehe providers can be installed

* package perl-threads-1:2.21-2.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers commandlinean be installed

* cannot install both perl-libs-commandline:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-Fcntl-1.13-481.1.el9_6.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-Fcntl-1.13-481.1.el9_6.x86_64 from System requires libperl.so.5.32(commandline(64bit), but none of the providers can be installcommandlined

* conflicting requests

* problem with installed package perl-Fcntl-1.13-481.1.el9_6.x86_64

Problem 8: package perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but commandlineone of the providers can be installed

* cannot icommandlinestall both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-File-Basename-2.85-481.1.el9_6.noarch from System requires pcommandlinerl(:MODULE_COMPAT_5.32.1), but none of the providcommandliners can be installed

* conflicting requests

* problem with installed package perl-File-Basename-2.85-481.1.el9_6.noarch

Problem 9: package perl-Text-ParseWords-3.30-395.el8.noarch from commandline requires perl(:MODULcommandline_COMPAT_5.26.2), but none of the providers can becommandlineinstalled

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-File-Find-1.37-481.commandline.el9_6.noarch from System requires perl(:MODULE_COMPATcommandline5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-File-Find-1.37-481.1.el9_6.noarch

Problem 10: package perl-Term-Cap-1.17-395.el8.noarch from commandlincommandline requires perl(:MODULE_COMPAT_5.26.2), but none ocommandline the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-Filcommandline-stat-1.09-481.1.el9_6.noarch from System requires percommandline(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-File-stat-1.09-481.1.el9_6.noarch

Problem 11: package perl-Term-ANSIColor-4.06-396.el8.ncommandlinearch from commandline requires perl(:MODULE_COMPcommandlineT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* pcommandlineckage perl-FileHandle-2.03-481.1.el9_6commandlinenoarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers ccomman be installed

* conflicting requests

* problemcommandlinewith installed package perl-FileHandle-2.03-481.1.el9_6.noarch

Problem 12: package perl-Storable-1:3.11-3.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed

* package pcommandlinerl-Storable-1:3.11-3.el8.x86_64 from commacommandlinedline requires perl(:MODULE_COMPAT_5.26.3), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481commandline1.el9_6.x86_64 from System

* packagcommandline perl-Getopt-Std-1.12-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none ocommandline the providers can be installedcommandline

* conflicting requests

* problem with installed package perl-Getopt-Std-1.12-481.1.el9_6.noarch

Problem 13: package perl-Socket-4:2.027-3.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the provicommandlineers can be installed

* package pecommandline.x86_64l-Socketcommandline4:2.027-3.el8.x86_64 from commandline requires perl(:MODULE_COMPAT_5.26.3), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 commandlinerom commandline and perl-libs-4:5.32.1-481.1.el9\_commandline.x86_64 from System

* package perl-IPC-Open3-1.21-481.1.el9_6.noarch from System requires perl(:MODcommandlineLE_COMPAT_5.32.1), but none of the providers can bcommandline installed

* conflicting requests

* problem with installed package perl-IPC-Open3-1.21-481.1.el9_6.noarch

Problem 14: package perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 from commandline requires perl(:commandlineODULE_COMPAT_5.26.2), but none of the providers can be instalcommandlineed

* package perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-NDBM_File-1.1commandline-481.1.el9_6.x86_64 from System requires perl(:MODULE_CcommandlineMPAT_5.32.1), but none of the providers can be installed

* package perl-NDBM_File-1.15-481.1.el9_6.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be installed

* conflicting commandlineequests

* problem with installed package perl-NDBM_File-1.15commandline481.1.el9_6.x86_64

Problem 15: package perl-Pod-Usage-4:1.69-395.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 frocommandline System

* package perl-POSIX-1.94-481.1.el9_6.x86_64 fcommandlineom System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-POSIX-1.94-481.1.el9_6.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be installed

* commandline

conflicting requests

* problem with installed pacommandlinekage perl-POSIX-1.94-481.1.el9_6.x86_64

Problem 16: package perl-Pod-Simple-1:3.35-395.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none commandlineithf the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libscommandline4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-lcommandlinebs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-SelectSaver-1.commandlinerom2-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1),commandlinebut none of the providers can be installed

* conflicting requests

* problem commandlineith installed package perl-SelectSaver-1.02-481.1.el9_6.noarch

Problem 17: package perl-Pod-Perldoc-3.28-396.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26commandline3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 commandlinerom System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-Symbol-1.08-481.1.el9_6.noarch from System requircommandlines perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* ccommandlinenflicting requests

* problem with installed package perl-Symbol-1.08-481.1.el9_6.noarch

Problem 18: package perl-podlators-4.11-1.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install bcommandlineth perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1commandline481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-base-2.27-481.1.el9_6.nocommandlinerch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers cancommandlinebe installed

* conflicting requests

* problem with installed package perl-base-2.27-481.1.el9_6.noarch

Problem 19: package perl-Pod-Escapes-1:1.07-395.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cancommandlineot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-locacommandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* commandlinecannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and pecommandlinel-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-if-0.60.800-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* confliccommandlineing requests

* problem with installed package perl-if-0.60.800-481.1.el9_6.nocommandlinerch

Problem 20: package perl-PathTools-3.74-1.el8.x86_64 from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* package perl-PathTools-3.74-1.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but ncommandlinene of the providers can be installed

* cannot install both perl-libs-4:5.26.3commandline422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9commandline6.x86_64 from System

* package perl-locale-1.09-481.1.el9_6.noarch from System requirescommandlineperl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-locale-1.09-481.1.el9_6.noarch

Problem 21: package perl-parent-1:0.237-1.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-48commandline.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-42commandline.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 fromcommandline System

* package perl-mro-1.23-481.1.el9_6.x86_64 from System requires perl(:MODULE_COMcommandlineAT_5.32.1), but none of the providers can be installed

* package perl-mro-1.23-481.1.el9_6.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be installed

* concommandlinelicting requests

* problem with installed package perl-mro-1.23-481.1.el9_6.xcommandline6_64

Problem 22: package perl-Net-SSLeay-1.88-2.module+el8.6.0+13392+f0897f98.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed

* package perl-Net-SSLeay-1.88-2.module+el8.6.0+13392+f0897f98.x86_64 from commandline requires perl(:MODULE\_commandlineOMPAT_5.26.3), but none of the providers can be installed

* cannot install bocommandlineh perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1commandline481.1.el9_6.x86_64 from System

* package perl-overload-1.31-481.1.el9_6commandlinenoarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-overload-1.31-481.1.el9_6.noarch

Problem 23: package perl-Mozilla-CA-20160104-7.module+el8.3.0+6498+9eecfe51.noarch from comcommandlineandline requires perl(:MODULE_COMPAT_5.26.3), but none of the provicommandlineers can be installed

* cannot install both perl-libs-4:commandline.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86commandline64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-overloading-0.02-481.1.el9_6.noarch fcommandlineom System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be incommandlinetalled

* conflicting requests

* problem with installed package perl-overloading-0.02-481.1.el9_6.noarch

Problem 24: package perl-MIME-Base64-3.15-396.el8.x86_64 from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installcommandd

* package perl-MIME-Base64-3.15-396.el8.x86_64 from commandline requires lcommandlinebperl.so.5.26()(64bit), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot inscommandlineall both perl-libs-4:5.26.3-422.el8.x86_64 from commandline ancommandline perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-subs-1.03-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-subs-1.03-481.1.el9_6.noarch

Problemcommandline25: package perl-Math-Complex-1.59-422.el8.noarch from commandcommandlineine requires perl(:MODULE_COMPAT_5.26.3), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 frcommandlinem System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 frcommandlinem commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-vars-1.05-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* conflicting requests

* problem with installed package perl-vars-1.05-481.commandline.el9_6.noarch

Problem 26: package perl-Math-BigInt-1:1.9998.11-7.el8.noarccommandline from commandline requires perl(:MODULE_COMPAT_5.26.3), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.commandline2.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-42commandline.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package python3-perf-5.14.0-570.49.1.el9_6.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be installed

* conflicting requests

* problem with installed package python3-perf-5.14.0-570.49.1.el9_6.x86_64

Problem 27: package perl-macros-4:5.26commandline3-422.el8.x86_64 from commandline requires perl(:MODULE_COMPAT_5.26.3), bcommandlinet none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot installcommandlineboth perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1commandlineel9_6.x86_64 from System

* package foomatic-4.0.13-19.el9.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package pnm2ppa-1:1.04-52.el9.x86_64 from System requires foomatic, but none of the providers can be installed

* conflicting requests

* problem with installed package pnm2ppa-1:1.04-52.el9.x86_64

Problem 28: package perl-libnet-3.11-3.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* package perl-DBD-SQLite-1.66-5.el9.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-DBD-SQLite-1.66-5.el9.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be installed

* package rasdaemon-0.6.7-18.el9.x86_64 from System requires perl-DBD-SQLite, but none of the providers can be installed

* conflicting requests

* problem with installed package commandlineasdaemon-0.6.7-18.el9.x86_64

Problem 29: problem with installed package pecommandlinel-Sys-Hostname-1.23-481.1.el9_6.x86_64

* package perl-Sys-Hostname-1.23-481.1.el9_6.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package percommandline-Sys-Hostname-1.23-481.1.el9_6.x86_64 from System requires libperl.so.5.32()(64commandlineit), but none of the providers can be installed

* package perl-Sys-Hostname-1.23-481.el9.x86_64 from openiam-local requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-Sys-Hostname-1.23-481.el9.x86_64 from openiam-local requires libperl.so.5.32()(64bit), but none of the providers can be installed

* package perl-IO-Socket-SSL-2.066-4.module+el8.3.0+6446+594cad75.noarch fcommandlineom commandline requires perl(:MODULE_COMPAT_5.26.3), but none of the procommandlineiders can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5commandline26.3-422.el8.x86_64 from cocommandline.el9_6.x86_64mandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 fromcommandline System

* conflicting requests

Problem 30: probcommandline4em with installed package perl-File-Copy-2.34-481.1.el9_6.noarch

* package perl-File-Copy-2.34-481.1.el9_6.noarch from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-File-Copy-2.34-481.el9.noarch from openiam-local requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-IO-Socket-IP-0.39-5.el8.noarch from commandline requires perl(:MODULE_COMPAT_5.26.2), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* commandlinecannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.commandline.el9_6.x86_6commandline from System

* conflicting requests

Problem 31: problem with installed package perl-DBD-MariaDB-1.21-16.el9_0.x86\_commandline4

* package perl-DBD-MariaDB-1.21-16.el9_0.x86_64 from System requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* packacommandlinee perl-DBD-MariaDB-1.21-16.el9_0.x86_64 from System requires libperl.so.5.32()(64bit), but none of the providers can be instalcommandlineed

* package perl-DBD-MariaDB-1.21-16.el9_0.x86_64 from openiam-local requires perl(:MODULE_COMPAT_5.32.1), but none of the providers can be installed

* package perl-DBD-MariaDB-1.21-16.el9_0.x86_64 from openiam-local requires libperl.so.5.32()(64bit), but none of the providers can be installed

* package perl-IO-1.38-422.el8.x86_64 from commandline requires libperl.so.5.26()(64bit), but none of the providers can be installed

* package perl-IO-1.38-422.el8.x86_64 from commandline requires perl(:MODULE_COMPAT_5.26.3), but none of the providers can be installed

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from openiam-local and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* cannot install both perl-libs-4:5.26.3-422.el8.x86_64 from commandline and perl-libs-4:5.32.1-481.1.el9_6.x86_64 from System

* conflicting requests

(try to add ‘–allowerasing’ to command line to replace conflicting packages or ‘–skip-broken’ to skip uninstallable packages or ‘–nobest’ to use not only best candidate packages)

…

Database: jdbc:mysql://localhost:3306/openiam?autoReconnect=true&useUnicode=true&characterEncoding=utf8&connectionCollation=utf8_general_ci&serverTimezone=UTC (MariaDB 10.5)

Creating Schema History table `openiam`.`flyway_schema_history` with baseline …

Successfully baselined schema with version: 2.3.0.0

Successfully validated 1227 migrations (execution time 00:00.652s)

Current version of schema `openiam`: 2.3.0.0

Migrating schema `openiam` to version “2.3.0.0.001 - mysql schema common”

Migrating schema `openiam` to version “2.3.0.0.002 - mysql schema security”

Migrating schema `openiam` to version “2.3.0.0.003 - mysql idm data”

Migrating schema `openiam` to version “3.0.0.0.001 - alter table attribute map”

Migrating schema `openiam` to version “3.0.0.0.002 - create resource many to many mapping”

Migrating schema `openiam` to version “3.0.0.0.003 - create group many to many mapping”

Migrating schema `openiam` to version “3.0.0.0.004 - migrate role id”

Migrating schema `openiam` to version “3.0.0.0.005 - migrate resource role mappings”

Migrating schema `openiam` to version “3.0.0.0.006 - create role many to many mapping”

Migrating schema `openiam` to version “3.0.0.0.007 - create group and role name constraints”

Migrating schema `openiam` to version “3.0.0.0.008 - add authorization data to resources”

Migrating schema `openiam` to version “3.0.0.0.009 - migrate menus to resources”

Migrating schema `openiam` to version “3.0.0.0.010 - fix resource name and type”

Migrating schema `openiam` to version “3.0.0.0.011 - add url protector column to res”

Migrating schema `openiam` to version “3.0.0.0.012 - fix group name”

Migrating schema `openiam` to version “3.0.0.0.013 - add fk to users”

Migrating schema `openiam` to version “3.0.0.0.014 - remove obsolete res and role fields”

Migrating schema `openiam` to version “3.0.0.0.015 - fix role name”

Migrating schema `openiam` to version “3.0.0.0.016 - update menu urls”

Migrating schema `openiam` to version “3.0.0.0.017 - role menus”

Migrating schema `openiam` to version “3.0.0.0.018 - fix group name”

Migrating schema `openiam` to version “3.0.0.0.019 - drop deprecated group columns”

Migrating schema `openiam` to version “3.0.0.0.020 - group menus”

Migrating schema `openiam` to version “3.0.0.0.021 - create group categories”

Migrating schema `openiam` to version “3.0.0.0.022 - fix id lenght metadata category”

ERROR: Migration of schema `openiam` to version “3.0.0.0.022 - fix id lenght metadata category” failed! Please restore backups and roll back database and code!

ERROR: Script V3.0.0.0.022__fix_id_lenght_metadata_category.sql failed

SQL State : HY000

Error Code : 1833

Message : (conn=12) Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’

Location : /usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql (/usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql)

Line : 2

Statement : Run Flyway with -X option to see the actual statement causing the problem

## Caused by: Script V3.0.0.0.022__fix_id_lenght_metadata_category.sql failed

SQL State : HY000

Error Code : 1833

Message : (conn=12) Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’

Location : /usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql (/usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql)

Line : 2

Statement : Run Flyway with -X option to see the actual statement causing the problem

Caused by: java.sql.SQLTransientConnectionException: (conn=12) Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’

Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’

Caused by: java.sql.SQLException: Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’

This is the init log. I would be very grateful if you could find a way to resolve this. This is the no internet installation

13

Hello @obmium,

Was the artifact below downloaded?

curl https://download.openiam.com/release/enterprise/4.2.1.14/dependencies/el9/openiamrepo.tar.gz --output openiamrepo.tar.gz

Before running the command openiam-cli init to avoid conflicts with existing in the system packages, try to disable the broken dependencies in the file /usr/local/openiam/utils/init.sh. Find and update the command:

yum --nogpgcheck localinstall /usr/local/openiam/openiamrepo/mariadb/*.rpm

to

yum --nogpgcheck localinstall /usr/local/openiam/openiamrepo/mariadb/*.rpm --skip-broken -y

Please let me know if you run into any obstacles.

14

Hello @ameet_shah

Thank you so much for your help.

I’ve tried all the suggestions you mentioned, but unfortunately, I’m still facing the same issue.

ERROR: Script V3.0.0.0.022__fix_id_lenght_metadata_category.sql failed

SQL State : HY000
Error Code : 1833
Message : (conn=12) Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’
Location : /usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql (/usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql)
Line : 2
Statement : Run Flyway with -X option to see the actual statement causing the problem

Caused by: Script V3.0.0.0.022__fix_id_lenght_metadata_category.sql failed

SQL State : HY000
Error Code : 1833
Message : (conn=12) Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’
Location : /usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql (/usr/local/openiam/conf/schema/mysql/openiam/3.0.0.0/V3.0.0.0.022__fix_id_lenght_metadata_category.sql)
Line : 2
Statement : Run Flyway with -X option to see the actual statement causing the problem

Caused by: java.sql.SQLTransientConnectionException: (conn=12) Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’
Caused by: java.sql.SQLException: Cannot change column ‘TYPE_ID’: used in a foreign key constraint ‘openiam/FK_CATEGORY_METADATA_TYPE’ of table ‘openiam/CATEGORY_TYPE’

The same issue always in this migration.
Thank you

15

hello @obmium

Please tell us which database version was installed on this box finally?

yum info mariadb

16

Hello @sergey.m

Thank you for your reply.

[root@localhost ~]# dnf info mariadb
Last metadata expiration check: 2:30:21 ago on Tue 21 Oct 2025 07:18:45 AM +01.
Installed Packages
Name : mariadb
Epoch : 3
Version : 10.5.27
Release : 1.el9_5.0.2
Architecture : x86_64
Size : 18 M
Source : mariadb-10.5.27-1.el9_5.0.2.src.rpm
Repository : @System
From repo : appstream
Summary : A very fast and robust SQL database server
URL : http://mariadb.org
License : GPLv2 and LGPLv2
Description : MariaDB is a community developed fork from MySQL - a multi-user, multi-threaded SQL database server. It is a client/server implementation consisting of a server daemon (mariadbd) and many different client programs and libraries. The base package contains the standard MariaDB/MySQL client programs and utilities.

17

hello @obmium

That is not expected db version for 4.2.1.14

The version you shared was installed from rockylinux appstream repo.
If you look at the script /usr/local/openiam/utils/init.sh
we do the db installation from the openiam repo (/usr/local/openiam/openiamrepo/mariadb) which contains the mariadb 10.3.39 (ls -la /usr/local/openiam/openiamrepo/mariadb | grep maria
)
You should do:
/usr/local/openiam/utils/uninstall.sh

remove the current db from the system (yum/dnf remove mariadb)

make sure the db was removed from the system

repeat openiam installation (dont forget to add –skip-broken to the init script before running openiam-cli init like you did above)

Regards,

Sergey