[Bug]: MariaDB not starting

[gfriloux]

Current Behavior (bug)
Using examples for using MariaDB does not work for me.
The issue occurs when running mysql_install_db (from running devbox shell):

+ mysql_install_db --auth-root-authentication-method=normal --datadir=/home/kuri/test/conf/mysql/data --basedir=/home/kuri/test/.devbox/virtenv --pid-file=/home/kuri/test/conf/mysql/mysql.pid

FATAL ERROR: Could not find errmsg.sys

The following directories were searched:

Expected Behavior (fix)
MariaDB should start without issue

Additional context

I use:

• fish 3.6.1
• devbox 0.4.5
• Example MariaDB from : https://github.com/jetpack-io/devbox/tree/main/examples/databases/mariadb

If i change conf/mysql/mysql.sh to replace --basedir=$MYSQL_BASEDIR with --basedir=/nix/store/faz61mkdds3q613qr6fpyj9i82qb20k0-mariadb-server-10.6.11 (which is where nix stores mariadb files), then everything works.

Of course, this path is not "normal" → not a correct fix.

I saw that MYSQL_BASEDIR is defined depending on the result of which mariadb.
In my case, this resolves to /home/kuri/test/.devbox/virtenv/bin/mariadb.
While this path is correct to find binaries, it won't have MariaDB's share files