ch.vorburger.exec.ManagedProcessException: An error occurred while installing the database

[giandrea77]

Hello,

I am trying to run a Java integration test with MariaDB under MacOS Sonoma 14.0 but, I get this error:

ch.vorburger.exec.ManagedProcessException: Program [/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysql_install_db, --datadir=/private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/data/6603, --basedir=/private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base, --no-defaults, --force, --skip-name-resolve] (in working directory /var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base) failed, exitValue=1, last 100 lines of console:
dyld[46028]: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
  Referenced from: <807EF787-5964-392D-94E0-E301374CE806> /private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/my_print_defaults
  Reason: tried: '/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (no such file), '/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (no such file), '/usr/local/lib/libssl.1.0.0.dylib' (no such file), '/usr/lib/libssl.1.0.0.dylib' (no such file, not in dyld cache)
Installing MariaDB/MySQL system tables in '/private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/data/6603' ...
dyld[46052]: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
  Referenced from: <46DF14A9-48CB-3FF1-83B5-0E8E9446546C> /private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysqld
  Reason: tried: '/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (no such file), '/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (no such file), '/usr/local/lib/libssl.1.0.0.dylib' (no such file), '/usr/lib/libssl.1.0.0.dylib' (no such file, not in dyld cache)
/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysql_install_db: line 454: 46052 Abort trap: 6           "$mysqld_bootstrap" $defaults "$mysqld_opt" --bootstrap $silent_startup "--basedir=$basedir" "--datadir=$ldata" --log-warnings=0 --enforce-storage-engine="" $args --max_allowed_packet=8M --net_buffer_length=16K

Installation of system tables failed!  Examine the logs in
/private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/data/6603 for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysql_install_db --defaults-file=~/.my.cnf


You can also try to start the mysqld daemon with:

    shell> /private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysqld --skip-grant --general-log &

and use the command line tool /private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/base/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in /private/var/folders/xx/l5qkx1y52xn1583vczlj63t80000gn/T/MariaDB4j/data/6603 that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

I tried to installa Openssl@1.0 but it not supported:

``brew install rbenv/tap/openssl@1.0 not working anymore https://github.com/rbenv/homebrew-tap/issues/1

Is there any way to solve this issue? I am using ch-vorburger-mariaDB4j.version 3.0.1 on Java 17. I tried also to .addArg("--skip-ssl") but withous success.

This is the code we use to start the embedded MariaDB.

DBConfigurationBuilder config = DBConfigurationBuilder.newBuilder()
.setPort(6603)
.setSecurityDisabled(true)
.addArg("--skip-ssl")
.addArg("--character-set-server=utf8mb4")
.addArg("--collation-server=utf8mb4_general_ci")
.addArg("--connect-timeout=10")
.addArg("--net-read-timeout=30")
.addArg("--net-write-timeout=60")
.addArg("--wait-timeout=28800")
.addArg("--max-connect-errors=100")
.addArg("--max-connections=151")
.addArg("--net-retry-count=10")
.addArg("--sql-mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION");

Thanks!
Andrea